phpmyadmin import large sql file code example

Example 1: import big data to mysql

mysql -u root -D DATA_BASE_NAME < PATH_OF_DATABASE_FILE

Example 2: import big sql file phpmyadmin

Try to import it from mysql console as per the taste of your OS.

mysql -u {DB-USER-NAME} -p {DB-NAME} < {db.file.sql path}
or if it's on a remote server use the -h flag to specify the host.

mysql -u {DB-USER-NAME} -h {MySQL-SERVER-HOST-NAME} -p {DB-NAME} < {db.file.sql path}

Tags:

Sql Example

Related