SOLVED - MYSQL error, please help
Permalink
Installed concrete5.6.1.2 and wanted to use the backup from my test location to the live location. But when trying to restore I get this error:
etc. etc.
mysql error: [1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CREATE TABLE IF NOT EXISTS `AreaPermissionAssignments` ( `cID` int(10) unsign' at line 3] in EXECUTE("DROP TABLE IF EXISTS AreaPermissionAssignments; CREATE TABLE IF NOT EXISTS `AreaPermissionAssignments` ( `cID` int(10) unsigned NOT NULL default '0', `arHandle` varchar(255) NOT NULL, `pkID` int(10) unsigned NOT NULL default '0', `paID` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`cID`,`arHandle`,`pkID`,`paID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; DROP TABLE IF EXISTS AreaPermissionBlockTypeAccessList; CREATE TABLE IF NOT EXISTS `AreaPermissionBlockTypeAccessList` ( `paID` int(10) unsigned NOT NULL default '0', `peID` int(10) unsigned NOT NULL default '0', `permission` varchar(1) NOT NULL default '1', PRIMARY KEY (`paID`,`peID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; DROP TABLE IF EXISTS AreaPermissionBlockTypeAccessListCustom; CREATE TABLE IF NOT EXISTS `AreaPermissionBlockTypeAccessListCustom` ( `paID` int(10) unsigned NOT NULL default '0', `peID` int(10) unsigned NOT NULL default '0', `btID` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`paID`,`peID`,`btID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; DROP TABLE IF EXISTS Areas; CREATE TABLE IF NOT EXISTS `Areas` ( `arID` int(10) unsigned NOT NULL auto_increment, `cID` int(10) unsigned NOT NULL default '0', `arHandle` varchar(255) NOT NULL, `arOverrideCollectionPermissions` tinyint(1) NOT NULL default '0', `arInheritPermissionsFromAreaOnCID` int(10) unsigned NOT NULL default '0', `arIsGlobal` int(1) unsigned NOT NULL default '0', PRIMARY KEY (`arID`), KEY `arIsGlobal` (`arIsGlobal`), KEY `cID` (`cID`), KEY `arHandle` (`arHandle`) ) ENGINE=MyISAM AUTO_INCREMENT=223 DEFAULT CHARSET=utf8; INSERT INTO Areas VALUES(1,106,'Header',0,0,0) ,(2,106,'Column 1',0,0,0) ,(3,106,'Column 2',0,0,0) ,(4,106,'Column 3',0,0,0) ,(5,106,'Column 4',0,0,0) ,(6,105,'Primary',0,0,0) ,(7,105,'Secondary 1',0,0,0) ,(8,105,'Secondary 2',0,0,0) ,(9,105,'Secondary 3',0,0,0) ,(10,105,'Secondary 4',0,0,0) ,(11,105,'Secondary 5',0,0,0) ,(12,1,'Header Nav',0,0,0) ,(13,1,'Header',0,0,0) ,(14,1,'Sidebar',0,0,0) ,(15,1,'Main',0,0,0) ,(16,1,'afbeeldingen',0,0,0) ,(17,124,'Main',0,0,0) ,(18,125,'afbeeldingen',0,0,0) ,(19,125,'main',0,0,0)
etc. etc.
Yes I Dashboard >system & settings > backup in Concrete5. And used this with several other website and never got a problem.
Now I used my on site a test site and got this SQL error.
I do no understand what you are saying. I already made a backup of the database using the dashboard backup function...
Now I used my on site a test site and got this SQL error.
I do no understand what you are saying. I already made a backup of the database using the dashboard backup function...
Got it working.
Didn't use the build in back-up system. just used MySql to export and import the database. Weird problem tho...
Didn't use the build in back-up system. just used MySql to export and import the database. Weird problem tho...
You need that backup and you also need a backup of the MySQL database the local site was installed on.
Then you can restore the database backup to the new database and the C5 backup to the new install of C5.