How to import large sql file in phpmyadmin

by

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}

More Related Contents:

  1. If two columns are 1 then make new column
  2. MySQL: How to reset or change the MySQL root password?
  3. MySQL Server has gone away when importing large sql file
  4. #1071 – Specified key was too long; max key length is 1000 bytes
  5. MySQL : isn’t in GROUP BY
  6. MySQL: Can’t create table (errno: 150)
  7. Why is the estimated rows count very different in phpmyadmin results?
  8. phpMyAdmin on MySQL 8.0 [duplicate]
  9. Setting up foreign keys in phpMyAdmin?
  10. How to access remote server with local phpMyAdmin client?
  11. Regaining access to lost MySQL password for PHPMyAdmin on WAMP
  12. Bug? #1146 – Table ‘xxx.xxxxx’ doesn’t exist
  13. Creating functions in phpMyAdmin – Error: access denied you need the super privilege for this operation
  14. #1273 – Unknown collation: ‘utf8mb4_unicode_ci’ cPanel
  15. Error Dropping Database (Can’t rmdir ‘.test\’, errno: 17)
  16. phpMyAdmin is throwing a #2002 cannot log in to the mysql server phpmyadmin
  17. How to Import Multiple csv files into a MySQL Database
  18. Composite key as foreign key (sql)
  19. phpMyAdmin – can’t connect – invalid setings – ever since I added a root password – locked out
  20. how to delete duplicate rows from a table in mysql
  21. Can’t import database through phpmyadmin file size too large
  22. #1045 – Access denied for user ‘root’@’localhost’ (using password: YES)
  23. SQL: deleting tables with prefix
  24. #1292 – Incorrect date value: ‘0000-00-00’ [duplicate]
  25. #1130 – Host ‘localhost’ is not allowed to connect to this MySQL server
  26. How do I write an SP in phpMyAdmin (MySQL)?
  27. Import CSV to Update rows in table
  28. How to get back Lost phpMyAdmin Password, XAMPP
  29. UTF8 problem with MySQL 5
  30. mySQL query to search all tables within a database for a string?

Leave a Comment