Link to home
Start Free TrialLog in
Avatar of uk1900
uk1900

asked on

how to ALTER all TABLEs ENGINE to myisam

hi,
how to alter all tables ENGINE to myisam?


regards,
Avatar of davidsperling
davidsperling

Using Mysql Administrator:
I'd try to start the action manually on on table, copy the proposed SQL statment to notedpad and then cancel.

Then create such a statment for all table names (ctrl-v, ctrl-c) and run it as a script.
ASKER CERTIFIED SOLUTION
Avatar of davidsperling
davidsperling

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of uk1900

ASKER

thank you for your help