WampServer

Hi gurus

I exported my database from HostGator via phpAdmin to .gz file about 400k. When i try to import to my localhost (wamp), the #1064 error reported, I think it has something to do with version syntax.

The phpAdmin version is HostGator is 4.3.8 while my wamp is running 4.0.4, Is this the cause of the failure to import to my localhost.

Or it is the version the MySQL, HostGator is on 5.5.42-37.1 while the localhost is 5.6.12-log

The export was done including dropping the USE database.

Please help.



Edited 1 time(s). Last edit at 11/16/2015 03:23PM by FuzMic.

Hi,

> the #1064 error reported

What is the COMPLETE and EXACT error message?

---------------------------------------------------------------
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons

Thanks Otomatic,

The exact response is quoted at the bottom.

What i found in the import is only 8 of tables before this troubled table were created without problem. This 9th table insertion creates the Error

Also the sql have following
DROP DATABASE `fuzmic_ptg`;
DROP TABLE IF EXISTS `xo57k_assets`;
CREATE TABLE IF NOT EXISTS `xo57k_assets` (....l

Hope you will enlighten me to get a quick fix as we keep struggling to face unrelenting changes. Cheers!





Quote

Error
SQL query:

INSERT INTO `xo57k_chronoengine_chronoforms` (`id`, `title`, `params`, `extras`, `published`, `app`, `form_type`, `content`) VALUES (21, 'Register', '{"description":"Basic contact form secured with captcha, using the GCoreUI simple theme","setup":"0","theme":"bootstrap3","tight_layout":"1"}', 'YTozOntzOjY6ImZpZWxkcyI7YToyMTp7aToxNzthOjEzOntzOjU6ImxhYmVsIjtzOjIwOiJSZWdpc3RyYXRpb24gRGV0YWlscyI7czoxNDoiY29udGFpbmVyX3R5cGUiO3M6NToicGFuZWwiO3M6NToidGl0bGUiO3M6MjA6IlJlZ2lzdHJhdGlvbiBEZXRhaWxzIjtzOjI6ImlkIjtzOjIzOiJjaHJvbm9mb3JtLWNvbnRhaW5lci0xNyI7czo1OiJjbGFzcyI7czoyMDoiY2hyb25vZm9ybS1jb250YWluZXIiO3M6MTA6InN0YXJ0X2NvZGUiO3M6MDoiIjtzOjg6ImVuZF9jb2RlIjtzOjA6IiI7czo0OiJuYW1lIjtzOjk6ImNvbnRhaW5lciI7czoxMToicmVuZGVyX3R5cGUiO3M6OToiY29udGFpbmVyIjtzOjQ6InR5cGUiO3M6OToiY29udGFpbmVyIjtzOjQ6InNpemUiO2E6MTp7czo1OiJ3aWR0aCI7czoyOiI5OSI7fXM6OToiY29sbGFwc2VkIjtzOjE6IjAiO3M6MTI6ImNvbnRhaW5lcl9pZCI7czoxOiIwIjt9aToxODthOjU6e3M6NjoiaW5wdXRzIjthOjM6e3M6MTA6ImRyb3Bkb3duMTYiO2E6MjA6e3M6NDoibmFtZSI7czo0OiJ5ZWFy[...]

MySQL said: Documentation

#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 '?' at line 2



Edited 1 time(s). Last edit at 11/17/2015 03:31AM by FuzMic.

Hi,

> DROP DATABASE `fuzmic_ptg`;
> DROP TABLE IF EXISTS `xo57k_assets`;
> CREATE TABLE IF NOT EXISTS `xo57k_assets` (....l

With DROP DATABASE, what is the DATABASE where the tables are created?

---------------------------------------------------------------
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons

Thanks, Thanks Ota

Your prompt makes me relook at the .sql and found that i did not

CREATE DATABASE IF NOT EXISTS `fuzmic_ptg` after DROP DATABASE `fuzmic_ptg`; when i export.

All tested and done, nothing to do with version just my slip up. Cheers!


PS Just found that .gz downloaded still has this problem, the above works on .zip download. Any reason you can think off.



Edited 1 time(s). Last edit at 11/18/2015 06:26AM by FuzMic.