- b2evolution CMS Support Forums
- b2evolution Support
- General Support
- Error importing MySQL DB (v0.9.1 to 1.10.2)
1 troy___tlc Jul 08, 2007 08:01
My b2evolution Version: Not Entered
I am moving my blog to a new host and decided to upgrade b2evolution as well.
- I have successfully done a new install of 1.10.2 and modified the _main.php to have all needed elements.
- I have moved all images from old site to new (inside Media folder)
- Receive error when attempting to import database. From current host it looks like I am only able to export the MySQL DB through a backup wizard that provides a .gz file. File size is 860 KB. When I attempt to import existing DB into new one I receive this error message:
-------------------------------------------------
SQL query:
CREATE TABLE `evo_antispam` (
`aspm_ID` bigint( 11 ) NOT NULL AUTO_INCREMENT ,
`aspm_string` varchar( 80 ) NOT NULL default '',
`aspm_source` enum( 'local', 'reported', 'central' ) NOT NULL default 'reported',
PRIMARY KEY ( `aspm_ID` ) ,
UNIQUE KEY `aspm_string` ( `aspm_string` )
) ENGINE = MYISAM AUTO_INCREMENT =19 DEFAULT CHARSET = latin1
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 'DEFAULT CHARSET=latin1' at line 7
------------------------------------------------
Any advice on how to resolve would be fantastic!
- Troy @ TLC Creative
Try unzipping the file (tar gz; use google) and see if it comes up with a sql file in plain ascii (readable). Import thisnew file.
If this doesn't work check if the CHARSET is set correctly (is the source in Latin-1, is the target database set in latin-1 or UTF-8)
Good luck