Skip to content

Instantly share code, notes, and snippets.

@deepak-rajpal

deepak-rajpal/mysql-import.html

Last active September 18, 2015 14:26
Show Gist options
  • Save deepak-rajpal/5279ecfcd72266535c43 to your computer and use it in GitHub Desktop.
Save deepak-rajpal/5279ecfcd72266535c43 to your computer and use it in GitHub Desktop.
Download ZIP
Importing Big/Large database file into mysql db
Raw
mysql-import.html
1) Use phpmyadmin > (use compressed file) > check partial import and go
2) Using cmd
C:\wamp\bin\mysql\mysql5.0.51b\bin>mysql -u root -p YourDatabaseName < YourFileName.sql
http://stackoverflow.com/questions/14846879/import-sql-file-by-command-line-in-windows-7
3) Best - using BigDumb script
http://www.ozerov.de/bigdump/usage/ (Tested 118 mb data (.sql file import) in 5-10 sec)
4)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment