Posts

Showing posts from March, 2013

MYSQLDUMP and RESTORE Command

Image
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