Hi guys
I'm trying to duplicate a ProcessWire site on a different server so I can work on it.
The good news is the live and the test servers are identical VPS. I already have multiple PW sites running on both.
I can export the DB from the Live server but when I try to import to Test server I get the following error.
Am I correct in thnking this error in the SQL syntax is being generated at the export stage?
IE my Live PW site wouldn't be working with a syntax error so I must be messing up the export of the .sql file
There is nothing at line 48 but a find command shows
CREATE TABLE `fieldtype_options` (
`fields_id` int(10) UNSIGNED NOT NULL,
`option_id` int(10) UNSIGNED NOT NULL,
`title` text,
`value` varchar(255) DEFAULT NULL,
`sort` int(10) UNSIGNED NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
BTW, my server setup is:
Version Plesk v12.5.30_build1205150826.19 os_CentOS 6 OS CentOS 6.3 (Final)
MySQL: 5.5.41
PHP: 5.6.19