Skip to content

Instantly share code, notes, and snippets.

@kany
Created Sep 5, 2012
Embed
What would you like to do?
Importing Large MySQL Databases - Mac OS
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