Howto Backing Up and Restoring Your MySQL Database

Damn, selalu aj lupa yg satu ini. Mending gw tulis aj deh..

Backup
mysqldump -u [username] -p [password] [databasename] > [backupfile.sql]

sample : mysqldump -u sadmin -p pass21 Customers > custback.sql

Restore
mysql -u USER -p DBNAME < dump.sql