MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:September 28 2004 10:36pm
Subject:Re: backup question: INSERT statements
View as plain text  
At 19:47 -0230 9/28/04, Neil Zanella wrote:
>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
backup question: INSERT statementsNeil Zanella29 Sep
  • Re: backup question: INSERT statementsPaul DuBois29 Sep