Where my .sql file should be located?

Posted August 6, 2018 8.3k views
MySQLUbuntu 16.04

Hello there,

I have created a new raw Droplet (raw one), then using my command line I installed LAMP (installed MySQL server & PHP).

I brought my Drupal (databse.sql & public_html folder as Zip) from other hosting service by (wget).

I was able to unzip my public_html .. and that works just fine.

But I am unable to import my database.sql to MySQL server (I don’t prefer to install and use PhpMyAdmin), I am new to this, and here are some questions:

1- Where should I put my database.sql file before importing?
2- Should I run mysql> command OR I just use my terminal shell and run “mysql -u -p database < database.sql.. etc”?
3- how can I test that MySQL server is working good? how to test that my database.sql file has tables on it?

I need to ask this question because I want to have a good idea toward this action, you can say, I need your any knowledge regrading to that.

Any help is much appreciated !


These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Submit an Answer
2 answers

Hello friend!

You are thinking in the right direction here. The location of the .sql file will not matter as you are going to import it into a database, which will then live in /var/lib/mysql (not using the .sql format). Check out the “Import” section of this article from a while back:

Kind Regards,

by Etel Sverdlov
MySQL is a powerful database management system used for organizing and retrieving data. This tutorial explains how to import and export MySQL databases and how to reset a root MySQL password

Thank you Jarland for your help.. At the moment, I am on /var/www/html directory, and when I run the command:
I got nothing..

I run
mysql > SHOW TABLES;

I find empty values !

Any idea?