Posts Tagged backup
MySQL Backup & Restore
I did this on an install of MySQL 5 Community Server running on Windows 2008 Server Web Edition- From the command line- backup:
mysqldump -u [username] -p[password] [database name] > FILE.sql
restore;
mysql -u [username] -p[password] [database name] < FILE.sql
Remember; if you have restored your core mysql database, which contains all the info on users and privileges, you will need to do a
FLUSH PRIVILEGES;
before you will be able to login using those user accounts!