How to Import 1GB sql file to WAMP phpmyadmin

Question

I want to import over 1GB size sql file to MySQL database in localhost WAMP phpmyadmin  But phpmyadmin UI doesn t allow to import such big file   What are the possible ways to do that such as any SQL query to import  sql file    Thanks

User · Answer

Go to c  wamp apps phpadmin3 5 2 Make a new subfolder called    upload    Edit config inc php to find and update this line   cfg    UploadDir          upload    Now when you import a database  you will give a drop-down list in web server upload directory with all the files in this directory   Chose the file you want and you are done

User · Answer

A phpMyAdmin feature called UploadDir permits to upload your file via another mechanism  then importing it from the server s file system  See http   docs phpmyadmin net en latest faq html i-cannot-upload-big-dump-files-memory-http-or-timeout-problems

User · Answer

I suggest you d definitely use mysql command prompt that would be faster option  because there are limitation in phpmyadmin UI and browsers itself for process request  following are steps to use mysql command line   doesnt matter if you user xampp wamp mamp  find mysql directory in xampp wamp mamp in your system directory   search for bin folder path is system dir  xampp wamp  mysql bin  now open command prompt i ll refer to windows  please change directory in command line and point to path to mysql bin   then user following command   mysql-u root -p -h localhost  press enter system will ask for password press enter again  finally you re in  please use command  use Database name  to point to specific database and you re good to go  if you want to upload database in to for ex  temp table  then follow these steps  use temp  source path to sql file where db is store in your system sql    this will upload sql file database in temp db  if you didnt get any part from this then please pm me i ll definitely help you out   Mitesh

User · Answer

If you will try to load such a large file through phpmyadmin then you would need to change upload file size in php ini to your requirements and then after uploading you will have to revert it back  What will happen  If you would like to load a 3GB file  You will have to change those parameters in php ini again   The best solution to solve this issue to open command prompt in windows   Find path of wamp mysql directory   Usually  it is C  wamp64 bin mysql mysqlversion bin mysql exe  Execute mysql -u root  You will be in mysql command prompt  Switch database with use command   mysql gt  use database name mysql gt  source  file path    In case of Windows  here is the example   mysql gt  source C  sqls sql1GB sql   That s it  If you will have a database over 10GB or 1000GB  This method will still work for you

User · Answer

I suspect you will be able to import 1 GB file through phpmyadmin But you can try by increasing the following value in php ini and restart the wamp  post max size 1280M upload max filesize 1280M max execution time   300   increase time as per your server requirement    You can also try below command from command prompt  your path may be different as per your MySQL installation  C  wamp bin mysql mysql5 5 24 bin mysql exe -u root -p db name  lt  C  some path your sql file sql  You should increase the max allowed packet of mysql in my ini to avoid MySQL server gone away error  something like this max allowed packet   100M

User · Answer

I ve tried with the SQLyog and It has done the work

User · Answer

Step 1   Find the config inc php file located in the phpmyadmin directory  In my case it is located here    C  wamp apps phpmyadmin3 4 5 config inc php    Note   phymyadmin3 4 5 folder name is different in different version of wamp  Step 2   Find the line with  cfg  UploadDir   on it and update it to    cfg  UploadDir      upload     Step 3   Create a directory called    upload    within the phpmyadmin directory   C  wamp apps phpmyadmin3 2 0 1 upload    Step 4   Copy and paste the large sql file into upload directory which you want importing to phymyadmin  Step 5   Select sql file from drop down list from phymyadmin to import

User · Answer

Make sure to check the phpMyAdmin config file as well  On newer WAMP applications it is set to 128Mb by default  Even if you update php ini to desired values you still need to update the phpmyadmin conf   Sample path  C  wamp64 alias phpmyadmin conf  Or edit through your WAMP icon by  - Apache -  Alias directories -  phpMyAdmin

User · Answer

I also face the same problem and strangely changing the values in php ini did not worked for me  So I found out one more solution which worked for me    Click your Wamp server icon -  MySql -  MySql console Once mysql console is open  Enter your mysql password  and give these commands    use user database name source c  your sql path filename sql    If you still have problems watch this video

User · Answer

The values indicated by Ram Sharma might need to be changed in Wamp alias configuration files instead   In  lt wamp dir gt  alias phpmyadmin conf  in the  lt Directory gt   section     php admin value upload max filesize 1280M   php admin value post max size 1280M   php admin value max execution time 1800

User · Answer

Before importing just make sure you have max allowed pack value set some thing large else you will get an error  Error 2006 MySQL server gone away    Then try the command  mysql -u root -p database name  lt  file sql

User · Answer

You can do it in following ways    You can go to control panel cpanel and add host    It means now the database server can be accessed from your local machine  Now you can install and use MySQL Administrator or Navicat to import and export database with out using PHP-Myadmin  I used it several times to upload 200 MB to 500 MB of data with no issues Use gzip  bzip2 compressions for exporting and importing  I am using PEA ZIP software  free  in Windows  Try to avoid Winrar and Winzip Use MySQL Splitter that splits up the sql file into several parts  In my personal suggestion  Not recommended Using PHP INI setting  dynamically change the max upload and max execution time  as already mentioned by other friends is fruitful but not always

User · Answer

What are the possible ways to do that such as any SQL query to import  sql file     Try this   mysql -u lt user gt  -p lt password gt   lt database name gt   lt   path to dump sql   assuming dump sql is your 1 GB dump file

[mysql] How to Import 1GB .sql file to WAMP/phpmyadmin

Examples related to mysql

Examples related to sql

Examples related to phpmyadmin

Examples related to wamp