php - How to import 5 GB MySQL Dump file in phpmyadmin -


i want import sql file of approx 5 gb. causing problem while loading. there way upload without splitting sql file ?

i have tried import terminal also many errors.

please me on this.

most won't able import 5gb database on phpmyadmin. try bigdump. can download here. step mentioned below.

download , unzip bigdump.zip on pc.  open bigdump.php in text editor, adjust database configuration , dump file encoding.  drop old tables on target database if dump doesn’t contain “drop table” (use phpmyadmin).  create working directory (e.g. dump) on web server  upload bigdump.php , dump files (*.sql or *.gz) via ftp working directory (take care of text mode upload bigdump.php , dump.sql binary mode dump.gz if uploading ms windows).  run bigdump.php web browser via url http://www.yourdomain.com/dump/bigdump.php.  can select file imported listing of working directory. click “start import” start.  bigdump start every next import session automatically if javascript enabled in browser.  relax , wait script finish. not close browser window! important: remove bigdump.php , dump files web server. 

else try command line

mysql -u user_name -p database_name < path/to/the/file.sql 

Comments

Popular posts from this blog

c++ - Difference between pre and post decrement in recursive function argument -

php - Nothing but 'run(); ' when browsing to my local project, how do I fix this? -

php - How can I echo out this array? -