Can’t import database through phpmyadmin file size too large

by

For Upload large size data in using phpmyadmin
Do following steps.

  1. Open php.ini file from C:\wamp\bin\apache\Apache2.4.4\bin Update
    following lines 

    max_execution_time = 259200
max_input_time = 259200
memory_limit = 1000M
upload_max_filesize = 750M
post_max_size = 750M

    than after restart wamp server or restart all services Now Upload
    data using import function in phymyadmin. Apply second step if
    till not upload data.

  2. open config.default.php file in
    c:\wamp\apps\phpmyadmin4.0.4\libraries (Open this file accoring
    to phpmyadmin version)
    Find $cfg['ExecTimeLimit'] = 300;Replace to $cfg['ExecTimeLimit'] = 0;
    Now you can upload data.

You can also upload large size database using MySQL Console as below.

  1. Click on WampServer Icon -> MySQL -> MySQL Consol
  2. Enter your database password like root in popup
  3. Select database name for insert data by writing command USE DATABASENAME
  4. Then load source sql file as SOURCE C:\FOLDER\database.sql
  5. Press enter for insert data.

Note: You can’t load a compressed database file e.g. database.sql.zip or database.sql.gz, you have to extract it first. Otherwise the console will just crash.

More Related Contents:

  1. #1130 – Host ‘localhost’ is not allowed to connect to this MySQL server
  2. How to get back Lost phpMyAdmin Password, XAMPP
  3. Error Code: 2013. Lost connection to MySQL server during query
  4. Throw an error preventing a table update in a MySQL trigger
  5. MySQL: How to reset or change the MySQL root password?
  6. Do different databases use different name quote?
  7. Binary Data in MySQL [closed]
  8. Using an Alias in SQL Calculations
  9. Can a table field contain a hyphen?
  10. Adding a leading zero to some values in column in MySQL
  11. Auto Generate Database Diagram MySQL [closed]
  12. How to access remote server with local phpMyAdmin client?
  13. View’s SELECT contains a subquery in the FROM clause
  14. MySQL : Multiple row as comma separated single row
  15. Regaining access to lost MySQL password for PHPMyAdmin on WAMP
  16. How to re-sync the Mysql DB if Master and slave have different database incase of Mysql replication?
  17. Case statement in MySQL
  18. Export a MySQL Database to SQLite Database
  19. How to find out the MySQL root password
  20. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  21. phpmyadmin automatic logout time
  22. How to display open transactions in MySQL
  23. MySQL query, MAX() + GROUP BY
  24. Easiest way to copy a table from one database to another?
  25. What is the best way to store media files on a database?
  26. Native JSON support in MYSQL 5.7 : what are the pros and cons of JSON data type in MYSQL?
  27. Foreign key constraints: When to use ON UPDATE and ON DELETE
  28. SQL: deleting tables with prefix
  29. How to use a user variables in MySQL LIKE clause?
  30. remove all numeric characters from column mysql

Leave a Comment