Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

lvm raid0, apache reverse proxy to iis ntlm, m.p. pasing list download, useradd default password, rajxxxxxcom.., Thor Johnson Beefy Uncut Ginger Adult Entertainer, how do you pronounce myisam, jwbznx, udp send thread safe, wwwB xxx

Links

Issociate
Impressum

#1: How to dump MySQL data on remote server using mysqldump

Posted on 2010-09-02 07:19:02 by James Corteciano

--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--

Report this message

Mr Ad

Google

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

Posted on 2010-09-02 08:04:58 by Rolando Edwards

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

Report this message

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

Posted on 2010-09-02 11:40:16 by Johan De Meersman

--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--

Report this message

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

Posted on 2010-09-02 13:00:28 by Jangita

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

Report this message