At 19:47 -0230 9/28/04, Neil Zanella wrote:
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.
mysqldump --help shows:
-t, --no-create-info
Don't write table creation info.
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
