Importing DB from computer

Your way is ok but sometimes it may not work...

Another way that always work is:

Create a database from command line or from phpmyadmin as it is easier...

Then go to your mysql bin folder path and upload there your database.sql

This example path is for Wamp software:

Code:

cd C:\wamp\bin\mysql\mysql5.7.24\bin
mysql.exe -u root -p databasename < database.sql

Then enter the mysql root password and it should work....

 

Yes but if mysql is not in the "path" on Windows my example will not work.

What i recommend you is something that i did a few days ago

You can try it and see if it works for you...

You don' need any third-party software for that...

 

As you are trying to import a database.sql file you should use Mysql.

So an installation of it is needed.

Usually most users use something like Wamp or Xampp software that will install Mysql, php and Nginx or Apache...

If yes then find that path of mysql as my example for Wamp and follow my instructions...

If you did something else to install Mysql then maybe you need some other instructions to do it...

Provide some info on how you install Mysql as it may help.. Locate where s the
mysql.exe file and let us know the path..

A command like this should work also:

Code:

C:\path\to\mysql\mysql.exe -u root -p databasename < C:\Users\BlahBlah\DB.sql

 

Yes you need it... As know it is like trying to open a photoshop .psd file on your computer and you don't have the photoshop Software to handle it ....

You can do it without Xampp or Wamp. It is just easier if you use that kind of software...