[ https://forge.continuent.org/jira/browse/SEQUOIA-913?page=all ]
Mathieu Peltier resolved SEQUOIA-913:
-------------------------------------
Resolution: Fixed
Fixed in CVS HEAD and BRANCH_sequoia-2_10. Note that table name containing 2
"`" (eg: `test```) do not seem to be supported by sequoia parser. This will be
tracked by another jira.
> 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
> Assignee: 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
