Problem..

Discussion in 'Site & Server Administration' started by terryuk, May 9, 2006.

0
  1. #1
    I have recently moved to a new dedi box from a VPS as my sites are too CPU intense, and the VPS was displaying errors alot of the time, i have my new box.. i have tried transfering the sites over using WHM transfer wizard, but the files have been added, but not the mySQL db's, and users for the sites.

    My VPS is half dead, i can only access it via SSH. My providor is trying to fix this issue but they are taking forever, so i sort of need to get it fixed asap as my websites are down :|

    Anyone have suggestions?

    Thanks
     
    terryuk, May 9, 2006 IP
  2. QiSoftware

    QiSoftware Well-Known Member

    Messages:
    805
    Likes Received:
    10
    Best Answers:
    0
    Trophy Points:
    158
    #2
    Use the full site backup utility which will create the right SQL commands and export the data-- for insertion into the new host. The database backup files will be located in a top level directory and called SQL-- or something like that.

    Q...
     
    QiSoftware, May 9, 2006 IP
  3. theblight

    theblight Peon

    Messages:
    246
    Likes Received:
    9
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Through ssh:

    First:

    Go to the location of your website files then issue this command:

    tar cvfz mybackup.tgz /location/of/websitefiles

    mv mybackup.tgz to the ftp repository then download through ftp

    Second:

    change directory into or go to the data directory of mysql

    then again issue this command:

    tar cvfz mydatabase.tgz *

    mv mydatabase.tgz to the ftp repository then download through ftp


    Hope it Helps
     
    theblight, May 10, 2006 IP