[root@server-mysql bin]# mysql_convert_table_format --help Conversion of a MySQL tables to other storage engines Usage: /usr/bin/mysql_convert_table_format database [table[ table ...]]
1.If no tables has been specifed, all tables in the database will be converted.
2.You can also use wildcards, ie "my%" The following options are available: -f, --force
Continue even if there is some error. -?, --help
Shows this help -e, --engine=ENGINE
Converts tables to the given storage engine (Default: MYISAM) -h, --host=HOST
Host name where the database server is located. (Default: localhost) -p, --password=PASSWORD
Password for the current user. -P, --port=PORT
TCP/IP port to connect to if host is not "localhost". -S, --socket=SOCKET
Socket to connect with. -u, --user=USER
User name to log into the SQL server. -v, --verbose
This is a test specific option that is only used when debugging a test.
Print more information about what is going on. -V, --version
Shows the version of this program.
convert.sh
#!/bin/bash
/usr/local/mysql56/bin
echo 'Enter Host Name:'
read HOSTNAME
echo 'Enter User Name:'
read USERNAME
echo 'Enter Password:'
read PASSWD
echo 'Enter Socket Path:'
read SOCKETPATH
echo 'Enter Database Name:'
read DBNAME
echo 'Enter Table Name:'
read TBNAME
echo 'Enter Table Engine:'
read TBTYPE /usr/local/mysql56/bin/mysql_convert_table_format --host=$HOSTNAME --user=$USERNAME --password=$PASSWD --socket=$SOCKETPATH --type=$TBTYPE $DBNAME $TBNAME --verbose
mysql> select concat(table_schema,'.',table_name) as table_name ,engine from information_schema.tables where table_schema = 'test';
+------------+--------+
| table_name | engine |
+------------+--------+
| test.t | InnoDB |
| test.t1 | InnoDB |
| test.t3 | InnoDB |
| test.t4 | InnoDB |
| test.t5 | InnoDB |
+------------+--------+
5 rows in set (0.01 sec)
[root@server-mysql ~]# ./convert.sh
./convert.sh: line 3: /usr/local/mysql56/bin: is a directory
Enter Host Name:
localhost
Enter User Name:
root
Enter Password:
Aa@12345
Enter Socket Path:
/tmp/mysql.sock5
Enter Database Name:
test
Enter Table Name: Enter Table Engine:
MYISAM
Warning: /usr/local/mysql56/bin/mysql_convert_table_format is deprecated and will be removed in a future version.
Converting tables:
converting t
converting t1
converting t3
converting t4
converting t5
mysql> select concat(table_schema,'.',table_name) as table_name ,engine from information_schema.tables where table_schema = 'test';
+------------+--------+
| table_name | engine |
+------------+--------+
| test.t | MyISAM |
| test.t1 | MyISAM |
| test.t3 | MyISAM |
| test.t4 | MyISAM |
| test.t5 | MyISAM |
+------------+--------+
5 rows in set (0.01 sec)