Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2005

    Arrow Unanswered: Need help migrating phpbb MySQL database to a new host

    I am moving my website to a new host.

    My old server runs: phpMyAdmin 2.6.1 and MySQL 4.1.7 -
    My new server runs: phpMyAdmin 2.4.0 and MySQL 4.0.16 -

    When I try to import the phpbb database using phpMyAdmin into the new host I get the following errors:

    Database clubafri_phpBBForums running on localhost

    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 *

    Any help will be highly appreciated
    Last edited by joaopiko; 02-17-05 at 20:21.

  2. #2
    Join Date
    Feb 2004



    your new server runs mysql 4.0.x which does not support CHARSET.

    delete 'DEFAULT CHARACTER SET latin1 COLLATE..' from your database CREATE statements.


  3. #3
    Join Date
    Feb 2005

    Thumbs up

    I have no clue what you are talking about ....never dealt with databases before bit I will check to see if I can do it.

    Thanks for your help!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts