Solved

how to ALTER all TABLEs  ENGINE to myisam

Posted on 2008-06-16
3
1,352 Views
Last Modified: 2010-04-21
hi,
how to alter all tables ENGINE to myisam?


regards,
0
Comment
Question by:uk1900
  • 2
3 Comments
 
LVL 4

Expert Comment

by:davidsperling
ID: 21791857
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
 
LVL 4

Accepted Solution

by:
davidsperling earned 500 total points
ID: 21791878
0
 

Author Closing Comment

by:uk1900
ID: 31467517
thank you for your help
0

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction In this installment of my SQL tidbits, I will be looking at parsing Extensible Markup Language (XML) directly passed as string parameters to MySQL 5.1.5 or higher. These would be instances where LOAD_FILE (http://dev.mysql.com/doc/refm…
Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, just open a new email message. In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…

813 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now