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.

MySQL Help

Discussion in 'General Discussion' started by DarkElf, Aug 30, 2005.

  1. DarkElf

    DarkElf Member

    Joined:
    Dec 18, 2003
    Messages:
    11
    Likes Received:
    0
    Trophy Points:
    1
    I'm moving sites from a busted server. I can get the sites themselves to move correctly, but due to mysql not working correctly on old server, cannot get the tables from databases moved. I have the mysql backup tzr.gz file, but not siure how to get it into place witrh correct permissions, etc?

    Can someone please help?
     
  2. ecwebtechie

    ecwebtechie Well-Known Member

    Joined:
    Mar 22, 2005
    Messages:
    49
    Likes Received:
    0
    Trophy Points:
    6
    all the files and directories under the directory

    /var/lib/mysql

    should be owned by mysql.mysql

    once you copy the files from the old server.. restart your mysql in the new server before you try accessing any db. you might get 127 storage error.
     
  3. AndyReed

    AndyReed Well-Known Member
    PartnerNOC

    Joined:
    May 29, 2004
    Messages:
    2,222
    Likes Received:
    3
    Trophy Points:
    38
    Location:
    Minneapolis, MN
    Use scp command to transfer the zipped file from the old to the new server.
     
  4. Murtaza_t

    Murtaza_t Well-Known Member

    Joined:
    Jan 24, 2005
    Messages:
    476
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Earth
    cPanel Access Level:
    Website Owner
    I think the best way is to get the dump of database (.sql file)
    Transfer them with ftp and restore it. This has always worked for us...
    you may find it difficult restoring .tar.gz files unless to are wel known to Linux.
     
Loading...

Share This Page