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.

URGENT: Cannot Transfer a Site

Discussion in 'General Discussion' started by mss6, Nov 29, 2005.

  1. mss6

    mss6 Member

    Joined:
    Jun 19, 2003
    Messages:
    19
    Likes Received:
    0
    Trophy Points:
    1
    Hi,

    I'm having a difficult time with a new customer :(

    I moved his site from old server to mine. Both run cPanel. All files were moved except mysql dbs!! I tired to move the dbs manually and got the following errors:

    root@server [/tmp/dbs]# mysql -udbuser_move -p1234 user_vb < ./user_vb.sql
    ERROR 1064 at line 21: 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 6

    The sql backup file was generated on the old server, which runs MySQL 4.1.13. My server runs 4.0.25. Can this version incompatibility be an issue?!
     
  2. mss6

    mss6 Member

    Joined:
    Jun 19, 2003
    Messages:
    19
    Likes Received:
    0
    Trophy Points:
    1
    Help Please :eek:
     
  3. azimpact

    azimpact Member

    Joined:
    May 27, 2005
    Messages:
    17
    Likes Received:
    0
    Trophy Points:
    1
    There is your answer!

    I had the same thing happen to me and had to update my server MySql so the other version would work. Most likely, had it been the other way around, you would not be having a problem.

     
Loading...

Share This Page