Thanks for this input. I seem to have stumbled across this exact problem of needing to import a database over 2M.
Does this just overwrite an existing database, or does it append or combine anything?
In trying to do a mysqldump, I had an error indicating I had a duplicate entry for a primary key value at line 76. How do I find what line 76 the command prompt is talking about? I checked every table and there are no duplicate entries for any key value.
I once saw a line of code to take one database from one xampp install and transfer it to another in just one line of code, but I can't find it again. Do you know how to do that? This might allow synchronization between a laptop/desktop installation and a portable on a thumb drive.
Found it under:
Posted by Keith Jolley:
"""""you can also do this is one step:
local_server% mysqldump -u mysqluser --password=mysqlpasswd --databases db1 | ssh remote_server /usr/local/bin/mysql -u mysqluser -p
note that on a multi-user system you will NOT want to put in the passwords as shown because anyone on the system will be able to see them. in that case you can use the following, less convenient command. it will ask you for your password twice, once for the local server and once for the remote server:
local_server% mysqldump -u mysqluser --password=mysqlpasswd --databases db1 | ssh remote_server /usr/local/bin/mysql -u mysqluser -p"""""