I think mysqldump does that. It creates a script that contains SQL statements to create the table and then the data to populate the table. Mysqldump has command line parameters, but I don't know which ones you would need to use.
Bob -----Original Message----- From: Zenzo [mailto:[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 Reznichenko <[EMAIL PROTECTED]> wrote: > 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 technical support contracts, goto > https://order.mysql.com/?ref=ensita > This email is sponsored by Ensita.net > http://www.ensita.net/ > __ ___ ___ ____ __ > / |/ /_ __/ __/ __ \/ / Victoria Reznichenko > / /|_/ / // /\ \/ /_/ / /__ > [EMAIL PROTECTED] > /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net > <___/ www.mysql.com > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > __________________________________ Do you Yahoo!? Free Pop-Up Blocker - Get it now http://companion.yahoo.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]