Question

How do you import a large database in MySQL?

Answer 1

You can do this from 1) the command line, 2)for smaller from PHPMYadmin or 3) from Workbench, e.t.c.

How import MySQL database from the command line?

1. Open the MySQL command line.
2. Type the path of your MySQL bin directory and press Enter.
3. Paste your SQL file inside the bin folder of the MySQL server.
4. Create a database in MySQL.
5. Use that particular database where you want to import the SQL file.
6. Type source databasefilename.sql and Enter.
7. Your SQL file upload successfully.