Aquia Desktop - How to import a MySql database that is too big I am using Aquia Dev Desktop. I have a MySql database dump that is too big to upload into Aquia Dev Desktop. What are my options? I am using a Mac, so would appreciate Mac based options

Steps I have tried:

I think the problem is the cache table. If I could empty (not delete) this table, I should be able to upload it into Acquia Dev Desktop.

1) Downloading MySQLWork Bench to delete the cache table.
MySQl Work Bench has a Data Import option. However, it requires the password of the Acquia Dev Desktop, which I don't have.

2) Downloading Sequel-Pro to delete the cache table
Again this requires the username/password of the database.
configure Mysql my.ini


change the value of myisam_sort_buffer_size from 8M to whatever your sql size is.

I will say if your file size is 100 change the value to myisam_sort_buffer_size = 156M.


Restart your mysql.
using terminal navigate to mysql bin directory
run the command: mysql -u username -p yourdatabasename &lt;yourmysqldatabasefile


enter the password for the user, if there is no password the user than just press enter.