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
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
Post a Comment for "Howto Backing Up and Restoring Your MySQL Database"