Link to home
Create AccountLog 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
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
See answer
Avatar of uk1900

ASKER

thank you for your help