MySQL Database Backup and Restore

By Bhavesh Jain
February 24, 2014 | 610 Views

Latest Industry insights to keep you updated on the latest happenings.

Database Backup 

mysqldump -u [Username] -p [databasename] > [backupfile.sql]     then enter

then enter the password of mysql.

 

Database Restore

1) With mysqldump command

mysqldump -u [Username] -p [databasename] <  [backupfile.sql]     then enter

then enter the password of mysql.

2) With Source command

-> mysql -u username -p 

 then enter the password of mysql.

-> use database name

-> source <file name>

Monthly industry insights to keep you updated on latest happenings

Follow us on Twitter
Follow us on Facebook
Follow us on Linkedin