Skip to content

Instantly share code, notes, and snippets.

Created Sep 5, 2012
What would you like to do?
Importing Large MySQL Databases - Mac OS
1) Install Keka
2) (optional) split your import file(
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