MySQL Dump to Directory

Question

I'm currently trying to make a copy of a site to run locally, and i'm having some difficulty in downloading a dump of the mySQL database using PhpMyAdmin. (In that it doesn't work). I was wondering (and I suspect) if there is an sql command I can execute that would dump out the database to a location that I can download it via FTP.

I've found the following:

 mysqldump --opt --user=root --password password > /home/backup/db.sql

but the page says that this will only run via shell, and I don't have shel access to the server. Can anyone help?

Answer 1

mysqldump -u root -p -T/path/ database

Answer 2

PERFORM MySQL DATABASE DUMP:

1. Having registered mysql.exe in the Paths of Environment Variables (On Windows Os)
2. Open windows console

3. Type the following Query:

   mysqldump [Your database Name] -u root -p > C:/[Your Destination Directory ]/[ new Backup Database Name.sql ]

4. You will be prompted for a database user password
5. Enter Password:*******
6. when the dump is over...the directory will go back to the current user session in Windows console

For this to work well, replace all parameters in square braces "[ ]" with your own values without the square braces