48 users online (1 members and 47 guests)  


  Results 1 to 5 of 5

Related

  1. Replies: 1
  2. How to connect to database mysql    Forum: Databases
    Replies: 1
  3. Connecting to Mysql Database    Forum: Databases
    Replies: 3
  4. Clearing out MYSQL database?    Forum: PHP Forum
    Replies: 3
  5. php database host    Forum: Web Hosting Forum
    Replies: 4
  1. #1
    joaopiko's Avatar
    New User

    Status
    Offline
    Join Date
    Feb 2005
    Posts
    3

    Arrow 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 - ******.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 the new host 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 *

    Any help will be highly appreciated

  2. #2
    QuietDean's Avatar
    Administrator

    Status
    Offline
    Join Date
    Oct 2000
    Location
    Bournemouth, UK
    Posts
    2,662
    I'll be honest, I think your best bet may be to ask the phpBB experts on www.phpbb.com support forum.
    If one of our members helps you, please click the icon to add to their reputation!
    No support via email or private message - use the forums!
    Before you ask, have you Searched?

  3. #3
    joaopiko's Avatar
    New User

    Status
    Offline
    Join Date
    Feb 2005
    Posts
    3

    Arrow

    That's the place I went to first.

    I followed their instructions but to no avail. Then I tried phpbbhacks.com. They too gave me similar instructions resulting in the same errors.

    Next, I contacted Ipowerweb ....I have been waiting for an answer for two days!

    I have looked around in several forums and now I am here. I am begining to think the problem is due to the fact that in moving to Ipowerweb, I am moving a notch lower in terms of MySQL versions ......I am not really sure about this ....

  4. #4
    QuietDean's Avatar
    Administrator

    Status
    Offline
    Join Date
    Oct 2000
    Location
    Bournemouth, UK
    Posts
    2,662
    Its quite possible. When moving from lower->higher it tends to be a very graceful move. However, no DB is ever designed to moved higher->lower.

    Might be worth asking the new host if they are willing to upgrade mysql. Loads of cool stuff in mysql4, I cant live without UNION for example.
    If one of our members helps you, please click the icon to add to their reputation!
    No support via email or private message - use the forums!
    Before you ask, have you Searched?

  5. #5
    joaopiko's Avatar
    New User

    Status
    Offline
    Join Date
    Feb 2005
    Posts
    3

    Arrow

    I will try that .....but it probably means shutting down a server with several websites running on it .....If they were planning to do so they just might agree, but I think it's a long shot. Makes me wonder therefore, what they are going to do about it ......They contacted me and said they were working on it.

    Here is what somebody suggested on another forum:
    -------------------------------------
    hello

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

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

    Serban
    -------------------------------------

    I need a crash course on this database stuff ...it's one area I have ignored for many years. I think time is ripe to hit the books!
    Last edited by joaopiko; 02-20-2005 at 11:23 PM.



Tags for this Thread