Forum
Error uploading database
Hi, I am moving my localhost site to server. When uploading I get this error:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'CREATE TABLE `perch2_settings` (
`settingID` varchar(60) NOT NULL DEFAULT '',
' at line 49
Support service told me I have to eliminate this info from dump and put them back again manually
/*!40101 SET NAMES utf8mb4 */;
and
INSERT INTO `perch2_resource_tags`
Is this a Perch issue?
It looks like a database server issue - make sure the format you export in is compatible with the server you're importing into.