Upload sql database to remote server using Terminal on Mac?

Question

I have a large local SQL database. When I try to upload the file to the remote database I get a message saying the file is too large.

My hosting provider told me I need to upload the SQL database to remote server using Terminal on Mac.

I need to know the Terminal commands to connect and upload the file.

phpMyAdmin 2.9.0. I tried: mysql -u user -p database. But I get the message "-bash: mysql: command not found"

red · Answer 1 · 2011-06-27 10:42:30Z

up vote 1 down vote accepted

First install the mysql client for Mac, I don't know the specifics on how that is done, sorry.

Then if the mysql client works the same way as on linux, the dump command would be something like:

mysqldump -u user -p databasename > dump.sql

Then using SCP or a graphical sftp software, transfer the file to the remote server:

scp dump.sql user@remotehost.ip:

Then use the mysql client there to import the dump.sql with:

mysql -u user -p databasename < dump.sql

You might need to create an empty database with the desired name before you import the dump.

answered Jun 27 '11 at 10:42

red
1465

	I now know that the problem is that I have not installed mysql in local. But I do have installed MAMP and it include mysql. Don't know if I have to install mysql in other way than trough MAMP ??¿¿ – chefnelone Jun 27 '11 at 10:47
	MAMP MySQL via Command line: aschroder.com/2009/03/… – red Jun 27 '11 at 10:48
	I saw the page you linked me but it show how to run commands on local machine. Once I am in mysql> can I connect to a remote database. How? – chefnelone Jun 27 '11 at 16:34
	You must SSH into the remote server to run the mysql import command I listed there. As my answer says, first you run the two local commands, and then SSH into the remote machine to run the last command. – red Jun 28 '11 at 11:09
	ok I see, I'll try that. – chefnelone Jun 30 '11 at 6:59

feedback

migrated from stackoverflow.com Jun 27 '11 at 10:38