There was a problem loading the comments.

How do I restore a mysqldump file

Support Portal  »  Knowledgebase  »  Viewing Article


1) Access to mysql cli

cPanel: mysql

Directadmin: search for mysql root password in Directadmin server /usr/local/directadmin/scripts/setup.txt then run command below

mysql -u root -p

2) Once you access to mysql cli, you need see something below:

mysql >

3) Now select which database you want to use

mysql> use db_name;

4) Now restore the database from mysqlexample.sql. Please make sure before you went into mysql cli, you are that the path that contain that mysqlexample.sql

mysql> source mysqlexample.sql;

5) Then exit.

mysql > exit;

Share via
Did you find this article useful?  

Related Articles

© ServerFreak Technologies Sdn Bhd