Bug #31815 mysqld cannot be backed-up properly when triggers on cluster tables are used
| Submitted: | 24 Oct 2007 14:45 | Modified: | 15 Oct 2009 8:35 |
|---|---|---|---|
| Reporter: | Oli Sennhauser | Email Updates: | |
| Status: | Verified | Impact on me: | |
| Category: | MySQL Server: Command-line Clients | Severity: | S4 (Feature request) |
| Version: | 5.1.x ff. | OS: | Any |
| Assigned to: | CPU Architecture: | Any |
[24 Oct 2007 14:45]
Oli Sennhauser
[30 Oct 2007 11:00]
Oli Sennhauser
Hi Geert I have verified your stuff and it seems to work well... To have it proper we need the following stuff: mysqldump -u root --routines --triggers --skip-add-drop-table --no-data --database backup | sed 's/CREATE TABLE/CREATE TABLE IF NOT EXISTS/g' > dd_backup.sql echo "use mysql;" >> dd_backup.sql mysqldump -u root mysql user >> dd_backup.sql echo "flush privileges;" >> dd_backup.sql Thanks Oli
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.055 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
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.