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

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

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

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