I just moved my gallery from one server to a new one and re-installed 4images. I want all of my old settings and users set on the new server so I followed the instructions to upload the backup SQL file in phpMyAdmin. However, near the end, I get this error message:
Error
SQL query:
CREATE TABLE 4images_categories(
cat_id int( 10 ) unsigned NOT NULL AUTO_INCREMENT ,
cat_name varchar( 255 ) NOT NULL default '',
cat_description text NOT NULL ,
cat_parent_id int( 10 ) unsigned NOT NULL default '0',
cat_hits int( 10 ) unsigned NOT NULL default '0',
cat_order int( 10 ) unsigned NOT NULL default '0',
auth_viewcat tinyint( 2 ) NOT NULL default '0',
auth_viewimage tinyint( 2 ) NOT NULL default '0',
auth_download tinyint( 2 ) NOT NULL default '0',
auth_upload tinyint( 2 ) NOT NULL default '0',
auth_directupload tinyint( 2 ) NOT NULL default '0',
auth_vote tinyint( 2 ) NOT NULL default '0',
auth_sendpostcard tinyint( 2 ) NOT NULL default '0',
auth_readcomment tinyint( 2 ) NOT NULL default '0',
auth_postcomment tinyint( 2 ) NOT NULL default '0',
sort_order varchar( 5 ) NOT NULL default 'ASC',
sort_field varchar( 20 ) NOT NULL default 'image_name',
PRIMARY KEY ( cat_id ) ,
KEY cat_parent_id( cat_parent_id ) ,
KEY cat_order( cat_order )
) ENGINE = MYISAM DEFAULT CHARSET = latin1
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 'DEFAULT CHARSET=latin1' at line 22
My new host (AN Hosting) uses phpMyAdmin 2.6.4.
Please help!