Import large database in MySql

To import the large database in MySql, Below are the changes required in MySql my.ini (Configuration file):

Step 1: Stop the MySQL server from your control panel.

Step 2: Open the file C:\xampp\mysql\bin\my.ini

Search and Change the below lines (setting):

Step 3: Start the MySQL server from your control panel.

Step 4: Open the command prompt and run the import command

mysql -h localhost -u root -p < e:/mydb.sql

Note: In place of “e:/mydb.sql” put your database path.

So now you can import large database in MySQL.