[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql
Subject:    backup question: INSERT statements
From:       Neil Zanella <nzanella () cs ! mun ! ca>
Date:       2004-09-28 22:05:15
Message-ID: Pine.LNX.4.44.0409281943190.7065-100000 () garfield ! cs ! mun ! ca
[Download RAW message or body]


Hello,

I need to backup a mysql database in such a way that the output is
simply a bunch of insert statements. I do not want the database
schema as output as well: just the insert statements. This is
because I already have a script with CREATE statements and
would like to rebuild the database from scratch: since I
need to modify the schema and table structure I prefer
this approach than using ALTER TABLE, given that the
database data size is small and rebuilding from
scratch could add some efficiency.

So how do I get this with myqldump. I just want the
insert statements and the data.

Thanks!!!

Neil


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=mysql@progressive-comp.com

[prev in list] [next in list] [prev in thread] [next in thread]