I am moving my website to a new host.
My old server runs: phpMyAdmin 2.6.1 and MySQL 4.1.7 - globat.com
My new server runs: phpMyAdmin 2.4.0 and MySQL 4.0.16 - ipowerweb.com
When I try to import the phpbb database using phpMyAdmin into a new database in the new server I get the following errors:
==================================
Database clubafri_phpBBForums running on localhost
Error
SQL-query :
CREATE DATABASE phpBB-Forums DEFAULTCHARACTER SET latin1 COLLATE latin1_swedish_ci
MySQL said:
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 CHARACTER SET latin1 COLLATE latin1_swedish_ci' at line Back
I believe I am doing something wrong here. Could somebody give me a detailed procedure on how to go about this.
Here are some more details:
The old database name was: phpBB-Forums
I created a new one on Ipowerweb named: clubafri_phpBBForums
then tried to import the db I had saved from
By the way, I have not yet pointed the domain to ipowerweb servers yet.
Any help will be highly appreciated.
