How to import a large files with MySQL?

The following steps allow the import of a large database with MySQL.

1. The first step is to connect to the MySQL interface (-u for username, -p for password):

mysql -u [USERNAME] -p

2. If necessary, create the database that will receive the imported file

CREATE DATABASE [DATABASE] CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

3. You must then specify the database into which the data will be imported:

use [DATABASE]

4. To avoid any problem during the import, it may be necessary to disable foreign keys checking:

SET foreign_key_checks = 0;

5. You can now import data from file:

source [FILENAME]

6. Once the import is complete, you can check the foreign keys.

SET foreign_key_checks = 1;

The following steps import a large database with MySQL.

1. The first step is to connect to the MySQL interface (-u for username, -p for password):

mysql -u [USERNAME] -p

2. If necessary, create the database that will receive the imported file

CREATE DATABASE [DATABASE] CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

3. You must then specify the database into which the data will be imported:

use [DATABASE]

4. To avoid any problem during the import, it may be necessary to disable foreign keys checking:

SET foreign_key_checks = 0;

5. You can now import data from file:

source [FILENAME]

6. Once the import is complete, you can check the foreign keys.

SET foreign_key_checks = 1;