[ https://forge.continuent.org/jira/browse/SEQUOIA-913?page=all ] Mathieu Peltier closed SEQUOIA-913: -----------------------------------
Tested. > 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 beta3 > > > 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
