RE: table backup

2003-11-27 Thread Bob Loeffler
EMAIL PROTECTED] Sent: Thursday, November 27, 2003 12:26 PM To: Victoria Reznichenko Cc: MySQL List Subject: Re: table backup The problem is that I wnt to use this remotely on another server. Is there a SQL command for doing this (exporting the table with data into a SQL script)? --- Victoria Reznic

Re: table backup

2003-11-27 Thread Victoria Reznichenko
Zenzo <[EMAIL PROTECTED]> wrote: > The problem is that I wnt to use this remotely on > another server. You can use --host option of mysqldump. > Is there a SQL command for doing this > (exporting the table with data into a SQL script)? No. > > > --- Victoria Reznichenko > <[EMAIL PROTECTED]>

Re: table backup

2003-11-27 Thread Zenzo
The problem is that I wnt to use this remotely on another server. Is there a SQL command for doing this (exporting the table with data into a SQL script)? --- Victoria Reznichenko <[EMAIL PROTECTED]> wrote: > Zenzo <[EMAIL PROTECTED]> wrote: > > how can I backup the table but not with BACKUP > TA

Re: table backup

2003-11-27 Thread Victoria Reznichenko
Zenzo <[EMAIL PROTECTED]> wrote: > how can I backup the table but not with BACKUP TABLE > because it Backups the .frm and another files. I want > that it backups in SQL with data. How can i do it? > Take a look at mysqldump program: http://www.mysql.com/doc/en/mysqldump.html -- For tec