Question on MySQL database structure: Why 3 MyISAM tables?

AngryChris
Bear Rating Master
Bear Rating Master
Posts: 135
Joined: 08 Apr 2013, 02:42

Re: Question on MySQL database structure: Why 3 MyISAM table

Postby AngryChris » 10 Sep 2013, 12:12

I would guess if the table is already InnoDB and you do the ALTER TABLE on it to set InnoDB, it will just pop an error. I can't imagine it would break anything.

User avatar
fox
^ me reading your posts ^
Posts: 6318
Joined: 27 Aug 2005, 22:53
Location: Saint-Petersburg, Russia
Contact:

Re: Question on MySQL database structure: Why 3 MyISAM table

Postby fox » 10 Sep 2013, 12:21

Error in db update script would cause an update failure though.

User avatar
sleeper_service
Bear Rating Overlord
Bear Rating Overlord
Posts: 884
Joined: 30 Mar 2013, 23:50
Location: Dallas, Texas

Re: Question on MySQL database structure: Why 3 MyISAM table

Postby sleeper_service » 10 Sep 2013, 14:55

can you test for the db type before that update step? or just ignore an error at that stage?

User avatar
fox
^ me reading your posts ^
Posts: 6318
Joined: 27 Aug 2005, 22:53
Location: Saint-Petersburg, Russia
Contact:

Re: Question on MySQL database structure: Why 3 MyISAM table

Postby fox » 10 Sep 2013, 15:08

That would need a special update kinda thing, generic updater checks for every query result and aborts with whining if something goes wrong (and rollbacks the transaction but in mysql case this might matter little).

User avatar
dxbi
Bear Rating Disaster
Bear Rating Disaster
Posts: 62
Joined: 16 Mar 2013, 13:44

Re: Question on MySQL database structure: Why 3 MyISAM table

Postby dxbi » 10 Sep 2013, 15:57


User avatar
sleeper_service
Bear Rating Overlord
Bear Rating Overlord
Posts: 884
Joined: 30 Mar 2013, 23:50
Location: Dallas, Texas

Re: Question on MySQL database structure: Why 3 MyISAM table

Postby sleeper_service » 10 Sep 2013, 16:11


User avatar
fox
^ me reading your posts ^
Posts: 6318
Joined: 27 Aug 2005, 22:53
Location: Saint-Petersburg, Russia
Contact:

Re: Question on MySQL database structure: Why 3 MyISAM table

Postby fox » 10 Sep 2013, 16:59

Ah that's cool; I guess I can make an update script then.


Return to “Everything else”

Who is online

Users browsing this forum: No registered users and 1 guest