List:General Discussion« Previous MessageNext Message »
From:Rolando Edwards Date:September 2 2010 6:04am
Subject:RE: How to dump MySQL data on remote server using mysqldump
View as plain text  
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
Thread
How to dump MySQL data on remote server using mysqldumpJames Corteciano2 Sep
  • RE: How to dump MySQL data on remote server using mysqldumpRolando Edwards2 Sep
  • Re: How to dump MySQL data on remote server using mysqldumpJohan De Meersman2 Sep
  • Re: How to dump MySQL data on remote server using mysqldumpJangita2 Sep