Planet MySQL - Archives - Restoring from a mysqldump into tables with trigge...

English

Restoring from a mysqldump into tables with triggers

-0

posted by Baron Schwartz (xaprb) on Thu 08 Jan 2009 13:26 UTC (Add To MySQL Librarian)
Tags:

(edit) Maatkit, sql, Backups, mysql, mysqldump, Triggers

This is actually old news, but I never thought to file a bug report (until now) or say anything to anyone about it. If you use mysqldump to dump and restore a MySQL table that has INSERT triggers, you can get different data in your restored database than you had when you dumped. [...]

Votes:

You must be logged in with a MySQL account to vote on Planet MySQL entries. More information on PlanetMySQL voting.

Planet MySQL © 1995-2008 MySQL AB, 2008-2010 Sun Microsystems, Inc.,
2010, Oracle Corporation and/or its affiliates.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.

Search

MySQL Links

Other Links

Planetarium