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

2010-09-02 Thread Rolando Edwards
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

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

2010-09-02 Thread Johan De Meersman
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

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

2010-09-02 Thread 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: jang...@yahoo.com Skype: jangita |

How to dump MySQL data on remote server using mysqldump

2010-09-01 Thread James Corteciano
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]$