The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

transfer SQL to other server problem

Discussion in 'Database Discussions' started by snaaps, Nov 6, 2004.

  1. snaaps

    snaaps Member

    Joined:
    Oct 8, 2004
    Messages:
    20
    Likes Received:
    0
    Trophy Points:
    1
    HI,
    I have all my accounts transfer to my own dedicated server.
    (before that I have a reseller account, also cpanel)

    Now I have the problem that he not transfer the tables in de sql databases.
    He only transfer the sql databases without the tables!

    I have tried to copy manuley the tables, but that dont work!
    I get the follow mesage:
    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 22

    can anybody help me?
     
  2. Starteck2002

    Starteck2002 Member

    Joined:
    May 27, 2004
    Messages:
    22
    Likes Received:
    0
    Trophy Points:
    0
    anyone know what causes this? I am getting an exact same error.
     
  3. dalem

    dalem Well-Known Member
    PartnerNOC

    Joined:
    Oct 24, 2003
    Messages:
    2,577
    Likes Received:
    40
    Trophy Points:
    48
    Location:
    SLC
    cPanel Access Level:
    DataCenter Provider
    check the mysql ver between the servers

    from the error i would guess your trrying to upload a 4.1 sql into a 4.0
     
  4. Starteck2002

    Starteck2002 Member

    Joined:
    May 27, 2004
    Messages:
    22
    Likes Received:
    0
    Trophy Points:
    0
    LOL - i was just coming back here to let everyone know I had sorted it and how...only Dalem beat me to it ;-)

    For those that want to know, I have a reseller account with mySQL version 4.1.14-standard and a dedicated server with mySQL version 4.0.24-standard.

    My choices were hard... do I upgrade the dedicated servers SQL?...nope! Too many problems will come my way from the 100's of people I have hosted on it...

    I just did an SQL dump but made sure I exported it in version 40 compatible format :)

    It's going to make my life a bit harder but I can handle that. Only another 200+ accounts to go - and I don't have the root password... <OUCH!>
     
  5. samspin

    samspin Registered

    Joined:
    Aug 9, 2005
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    Same mistake...

    I too am moving to a new server. On the old, I had a reseller account...
    And I no longer have access to it.
    I did a full backup of the accounts to move them, it restores all the files, but it won't restore the databases' tables. Exactly as above. And I can't go back and re-export them because the old reseller account with my old host is gone now!
    All I have are the .sql files. And I can't simply upload them... I either get a blank screen (restore a MySQL database) or 'you have an error in your SQL syntax' in phpmyadmin. I have no idea what version it was exported in...
    All I know is that the phpMyAdmin is version 2.6.4-pl2, and mysql is version 4.0.25-standard.
    Is there any way out of this mess? My friends are having a go at me cuz their sites forums are down after I moved them! And I look bad!
    I am root user, by the way...
     
  6. Starteck2002

    Starteck2002 Member

    Joined:
    May 27, 2004
    Messages:
    22
    Likes Received:
    0
    Trophy Points:
    0
    can you not upgrade/downgrade your mySQL? If you make it the same version you can just import easily :)
     
  7. sv1

    sv1 Well-Known Member

    Joined:
    Aug 31, 2003
    Messages:
    135
    Likes Received:
    0
    Trophy Points:
    16
    40 compatible just saved my butt! :)
     
  8. Starteck2002

    Starteck2002 Member

    Joined:
    May 27, 2004
    Messages:
    22
    Likes Received:
    0
    Trophy Points:
    0
    Nice one ;-) Glad you got it sorted :)
     
Loading...

Share This Page