WordPress local (XAMPP) to Bluehost
-
Dear readers,
I created a webshop and want to migrate it to blue host before putting any more time in it. I created wordpress at my blue host account and removed all the content that the new database contained so I can start fresh. But I get a error when importing the mysql.sql file, the error is the following:
#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 ‘STATS_PERSISTENT=0’ at line 16
Here does the error come from:
REATE TABLE IF NOT EXISTS innodb_index_stats (
database_name varchar(64) COLLATE utf8_bin NOT NULL,
table_name varchar(64) COLLATE utf8_bin NOT NULL,
index_name varchar(64) COLLATE utf8_bin NOT NULL,
last_update timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
stat_name varchar(64) COLLATE utf8_bin NOT NULL,
stat_value bigint(20) unsigned NOT NULL,
sample_size bigint(20) unsigned DEFAULT NULL,
stat_description varchar(1024) COLLATE utf8_bin NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin STATS_PERSISTENT=0;
REATE TABLE IF NOT EXISTS innodb_index_stats (
database_name varchar(64) COLLATE utf8_bin NOT NULL,
table_name varchar(64) COLLATE utf8_bin NOT NULL,
index_name varchar(64) COLLATE utf8_bin NOT NULL,
last_update timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
stat_name varchar(64) COLLATE utf8_bin NOT NULL,
stat_value bigint(20) unsigned NOT NULL,
sample_size bigint(20) unsigned DEFAULT NULL,
stat_description varchar(1024) COLLATE utf8_bin NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin STATS_PERSISTENT=0;Why am I getting the error?
-
Hi there,
This is the WordPress.COM support forum. You need to post to the WordPress.ORG support forum for help with your site because it is not hosted by WordPress.COM.WordPress.com and WordPress.org are completely separate and have different logins and have separate support forums. http://support.wordpress.com/com-vs-org/
If you don’t have a username account at WordPress.ORG click http://wordpress.org/support/ and register one on the top right hand corner of the page that opens, so you can post to the support forums there and receive advice from WordPress.ORG bloggers.
-
Hello!
This is a WordPress.COM forum. Please post the same post at the WordPress.ORG forum. They will be able to give you the appropriate answer.
https://wordpress.org/support/ -
-
- The topic ‘WordPress local (XAMPP) to Bluehost’ is closed to new replies.
WordPress.com Forums 