mzupanI changed my web host from Netfirms to HostGator, but I am getting an error when I attempt to import my previous database to the database at my new host.
Netfirms uses MySQL 5.0.24 and phpMyAdmin 2.4.0.
HostGator uses MySQL 5.0.27 and phpMyAdmin 2.10.0.2.
I followed all of the steps in the "Moving WordPress to a New Server with Fantastico" section of http://codex.wordpress.org/Moving_WordPress but get the error below during the database import in the 'Restore the database' step.
Does anyone know how I can resolve this? I don't know anything about MySQL and was just following the steps.
Error
SQL query:
-- /usr/local/nf/bin/mysqldump --add-drop-table --complete-insert --force --quick --quote-names -h mysqlhost -u u70458530 -p4a85a9 d60415833 wp_categories wp_comments wp_link2cat wp_links wp_options wp_post2cat wp_postmeta wp_posts wp_usermeta wp_users wp_wordbook_errorlogs wp_wordbook_postlogs wp_wordbook_userdata
--
-- MySQL dump 8.22
--
-- Host: mysqlhost Database: d60415833
------------------------------------------------------- --
-- Server version 5.0.24a-log
--
-- Table structure for table 'wp_categories'
--
DROP TABLE IF EXISTS wp_categories ;
MySQL said:
#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 '---------------------------------------------------------
-- Server version 5.0.' at line 1
