MySQL Backuper does not handle autoincrement in tables that have quoted name "`"
--------------------------------------------------------------------------------
Key: SEQUOIA-913
URL: https://forge.continuent.org/jira/browse/SEQUOIA-913
Project: Sequoia
Type: Bug
Components: Backup System
Versions: Sequoia 2.10.5
Reporter: Mathieu Peltier
Assigned to: Mathieu Peltier
Priority: Critical
Fix For: Sequoia 2.10.6, Sequoia 3.0
Autoincrement are stored at the end of the dump that is done by the backuper.
If a table is called 1 (create table `1` ... ), then a line will be added at
the end of the file to store its autoincrment value at the moment of the dump.
This line will be an invalid SQL statement : "alter table 1 ..." and should be
"alter table `1` ..." instead.
This wrong line will prevent from restoring this dump.
Possible workarounds :
- use a script based backuper
- Update the dump file manually either by removing these rows (can bring
inconsistencies) or by adding quotes around these tablenames " ` ".
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://forge.continuent.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
