• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1359
  • Last Modified:

how to ALTER all TABLEs ENGINE to myisam

hi,
how to alter all tables ENGINE to myisam?


regards,
0
uk1900
Asked:
uk1900
  • 2
1 Solution
 
davidsperlingCommented:
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.
0
 
davidsperlingCommented:
0
 
uk1900Author Commented:
thank you for your help
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now