Skip to content

Instantly share code, notes, and snippets.

@kany

kany/gist:3640501

Created September 5, 2012 17:25
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save kany/3640501 to your computer and use it in GitHub Desktop.
Save kany/3640501 to your computer and use it in GitHub Desktop.
Download ZIP
Importing Large MySQL Databases - Mac OS
Raw
gistfile1.txt
1) Install Keka
http://www.kekaosx.com/en/
2) (optional) split your import file(http://www.webmaster-source.com/2011/09/26/how-to-import-a-very-large-sql-dump-with-phpmyadmin/)
3) Compress your sql dump file(s) into a 7z file using Keka.
4) From the terminal, run:
7z x -so backup_some_app_data.sql.7z | mysql -u root some_app_db
5) Read some blogs and wait
6) Use 'show tables' to see how many tables have imported
7) Use 'show table status from some_app_db like 'some_table_name' \G' to see rows being added to the db.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment