MYSQL Database and Table Alterations

MySQL information.
Post Reply
dzcadii
Posts: 94
Joined: Sun Mar 01, 2015 4:36 am

MYSQL Database and Table Alterations

Post by dzcadii » Sun Mar 01, 2015 11:14 pm

Here is a quick list of SQL lines for editing/altering your tables and database:

**Note**
"table_name" would be the name of your table in the database.


I do caution you to shutdown access to the database server if it is supporting a production site or has allot of traffic.
My opinion about the two types:
MyISAM = Speed
InnoDB = Data integrity/reliability
You can search and read many articles on this subject. I said the above because of experience.


Change table type to MyISAM
ALTER TABLE table_name ENGINE = MyISam;

Change table type to InnoDB
ALTER TABLE table_name ENGINE = InnoDB

Free up some space in a table/optimize
OPTIMIZE TABLE table_name;

for a complete list of MYSQL Database Administration Statements:
http://dev.mysql.com/doc/refman/5.1/en/ ... ation.html

Post Reply