Monday 4 January 2021

How to Create MySQL database backup and restore it

 



Process to Create MySQL database backup and restore.



1. Open Command Prompt using admin.


2. Move to 


C:\Program Files\MySQL\MySQL Server 8.0\bin>


3. For Backup


mysqldump -uroot -proot databasename > backupfilename.sql


4. Open MySql


5. Drop database and create again


6. For Restore Database from backup file


In Command Prompt write


mysql -uroot -proot databasename < backupfilename.sql


7. Check in MySql all tables will restore

No comments:

Post a Comment