How to dump MySQL data on remote server using mysqldump

--0016e6d99b5fcfe551048f3ff34b
Content-Type: text/plain; charset=ISO-8859-1

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

--0016e6d99b5fcfe551048f3ff34b--

RE: How to dump MySQL data on remote server using mysqldump

Install the mysql client on the web server and run the same mysqldump comma=
nd 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@logicworks.net
http://www.linkedin.com/in/rolandoedwards

-----Original Message-----
From: James Corteciano [mailto:james@linux-source.org]=20
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=3Dgcdmg-mysql-2@m.gmane.o rg

Re: How to dump MySQL data on remote server using mysqldump

--002215048f630368c8048f439a49
Content-Type: text/plain; charset=ISO-8859-1

From the mysqldump manpage, on the -T option:

Note
> This option should be used only when mysqldump is run on the same machine
> as the mysqld server. You must have the FILE privilege, and the server must
> have permission to write files in the directory that you specify.
>

In other words, you've probably found a loophole that allows you do do
serverside dumps remotely using mysqldump :-)

Given that this is not what you intended, I suggest you either remove the -T
and get SQL-format dumps; or go through the documentation again and find
another way to do what you want :-)



--
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel

--002215048f630368c8048f439a49--

Re: How to dump MySQL data on remote server using mysqldump

On 02/09/2010 7:19 a, James Corteciano wrote:
> How could I put the dump data on web server and not the local disk on mysql
> server?
Log into the web server and do it from there? or copy the file onto the
web server?
--
Jangita | +256 76 91 8383 | Y! & MSN: jangita@yahoo.com
Skype: jangita | GTalk: jangita.nyagudi@gmail.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org