Restoring mysql database backup command line

Restoring MySQL database backup

restoring mysql database

In this tutorial, I will show you how to restore Mysql Database. If you want to learn how backup MySQL database please  go to the following link:

How to backup MySQL database command line

Now, If you want to restore the dump of MySQL databases you need to run the following command:

mysql -u username -p databasename < backup.sql

In the above command database name is the database you want to restore and

backup.sql is the name of backup to restore.

That is How to backup and restore MySQL databases.

Read Also: How to create Mysql database from command line

If you get some issues using this tutorial please feel free to comment below.

Leave a Reply

Your email address will not be published.


The reCAPTCHA verification period has expired. Please reload the page.

48-Hour Flash Sale! Courses from just $10.99