Export database from a remote server into a specific folder on my computer

Question

I'm having trouble with a database export that is too big for phpmyadmin to handle.

I'm curious what the syntax would be for exporting a mysql database from a remote server and getting the export file into a specific folder on my own computer, all using the command line.

Say the database name is: mydb Say the remote server's ip is: 123.456.789.101 Say my username is: tic Say my password is: toc Say the folder i want the mysql dump transferred into is my downloads folder, and say I am on a windows 7 pc.

unix/linux command solutions are welcome. Bonus points for solutions that work on microsoft.

Answer 1

You can run

mysqldump -h yourhostname -u youruser -p yourdatabasename > C:\your\file\path.sql

-h connects you to the remote servers IP so you can dump the data locally, as long as your user has the correct privileges and you can connect remotely to your database server.

However, you may need to ssh into your server first. If you are running windows, Download putty and connect to your host from this tool.

Once on remote server execute: >mysqldump -u youruser -p yourdbname > /your/file/path.sql

After that, download a ftp client tool like winscp or filezilla and transfer (copy) the .sql file from your remote host onto your local host.

You can read more here and here.