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
redwards@stripped
http://www.linkedin.com/in/rolandoedwards
-----Original Message-----
From: James Corteciano [mailto:james@stripped]
Sent: Thursday, September 02, 2010 1:19 AM
To: mysql@stripped
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
