I've been trying to transfer my cloud Prestashop to my own server but I keep having problem with my SQL database.
ErrorStatic analysis:
4 errors were found during analysis.
Unexpected beginning of statement. (near "eMagicOne" at position 0) Unexpected beginning of statement. (near "Store" at position 10) Unexpected beginning of statement. (near "Manager" at position 16) Unrecognized statement type. (near "for" at position 24)
SQL query:
eMagicOne Store Manager for PrestaShop 2.28.0.1597 SET FOREIGN_KEY_CHECKS=0
MySQL said:
#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 'eMagicOne Store Manager for PrestaShop 2.28.0.1597 SET FOREIGN_KEY_CHECKS=0' at line 1
This is what happens everytime I try to import the SQL database in PHPMYADMIN
This is the start of my SQL file:
# eMagicOne Store Manager for PrestaShop 2.28.0.1597
# ---------------------------------------
# Host :
# Port : 0
# Database : cloud_www_***private***_com
SET FOREIGN_KEY_CHECKS=0;
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
DROP TABLE IF EXISTS `ps_access`;
CREATE TABLE `ps_access` (
Do you see anything weird ? Thanks for the support