Thursday, March 28, 2013

MYSQLDUMP and RESTORE Command

you can test MySQL command on localhost
exam: go to cmd dos

mysqldump -u root -p etc > etc.sql

or  dump table only

mysqldump -u root -p khonkaensoft -tables my_table_name > etc.sql



How to restore
exam: this one you need create database before.

#mysql -u root -p khonkaensoft < etc.sql