Announcement

Collapse
No announcement yet.

help me - moving servers

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • help me - moving servers

    Hello,

    I'm moving servers
    I repaired and optimized all my tables via phpmyadmin and vbulletin admin center(with no errors)
    my sql file is about 800 mb
    I got backup from ssh as you explain on http://www.vbulletin.com/docs/html/main/moving_servers with this command:

    mysqldump --opt -Q -uUSERNAME -p DATABASENAME > /PATH/TO/DUMP.SQL

    and I put the sql file to my new server
    When my host want to import it, they said me that an error occurs on ssh like that

    # mysql database < database.sql
    ERROR 1062 at line 3153: Duplicate entry 'icin' for key 2

    I said them that they must use this command as you explain on your documention:
    mysql –uUSERNAME –p NEWDBNAME < /PATH/TO/NEW/DUMP.SQL


    I tried to get backup 2 times with trying repairing and optimizing 2 times
    but we got same error when importing via ssh

    my previous mysql version is 3.23.x
    my new mysql version is 4.x

    what should I do?

    now I downloaded *frm *.MYD *.MYI ... files from my previous host's mysql/var/mydomain directory and I saved it as a zip file and uploading to my new host
    I'll say them to put them into my database
    is this a solution for me?

  • #2
    I did it
    I see that some missing tables
    only 48 tables are here
    I think it's about my hosting company "importing sql table limit"
    I'll import others now

    Comment


    • #3
      solved

      Comment

      Loading...
      Working...
      X