Install the mysql client on the web server and run the same mysqldump command from within the web server.
Give it a try !!! Rolando A. Edwards MySQL DBA (CMDBA) 155 Avenue of the Americas, Fifth Floor New York, NY 10013 212-625-5307 (Work) 201-660-3221 (Cell) AIM & Skype : RolandoLogicWorx redwa...@logicworks.net http://www.linkedin.com/in/rolandoedwards -----Original Message----- From: James Corteciano [mailto:ja...@linux-source.org] Sent: Thursday, September 02, 2010 1:19 AM To: mysql@lists.mysql.com Subject: How to dump MySQL data on remote server using mysqldump Hi, I have mysql server separated from web server. My problem is, when I dump the data from database using the command "mysqldump -uuser -p -h mysql_server -t -T /tmp/dbname database_name" on web server, all data were dumped to the /tmp/dbname of mysql server and not inside of web server. [web]$ mysqldump -uuser -p -h mysql_server -t -T /tmp/dbname database_name [web]$ ll /tmp/dbname total 0 [mysql]$ ll /tmp/dbname total 2 -rw-rw-rw- 1 mysql mysql table_name.txt How could I put the dump data on web server and not the local disk on mysql server? Thanks. Regards, James -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
