Join 1M+ other developers and:
- Get help and share knowledge in Q&A
- Subscribe to topics of interest
- Get courses & tools that help you grow as a developer or small business owner
Where my .sql file should be located?
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.×