We are transitioning over to a new forum platform. Please post new issues there. Existing threads will be dealt with here unless you choose to move them over. Visit the new forum

Forum

Thread tagged as: Problem, Hosting

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?

Raul Serrano

Raul Serrano 0 points

  • 3 years ago
Drew McLellan

Drew McLellan 2637 points
Perch Support

It looks like a database server issue - make sure the format you export in is compatible with the server you're importing into.