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.

Linux SSH MySQL -vs- CPANEL MySQL [moved]

Discussion in 'Database Discussions' started by BigDaddyCool, Feb 6, 2006.

  1. BigDaddyCool

    BigDaddyCool Registered

    Joined:
    Feb 5, 2006
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    Linux SSH MySQL -vs- CPANEL MySQL

    Hi, I'm a Computer Tech/Web Designer/Web Hoster.

    I have come across a rather unique delma that seems to begining to popup left right and center.

    I have a couple of older websites which have been running on a Linux SSH only server. They have MySQL Databases and on the linux box which only support SSH Login.... they work fine.

    I have tried virtually ever possible way to transfer the sites onto a CPANEL Setup, I have evne tried different hosting places with different CPANEL Servers to see if that fixed the problem but much to my dismay it still exists.

    Basically the older sites, dont like the CPANEL username_database name etc.

    If I try transfering the sites to another Linux box only supporting SSH Login they work fine because it doesn't have the annoying.

    username_database
    username_user
    password

    it just has the normal

    database
    username
    password

    This is a MAJOR drawback with CPanel. I'm looking for solutions and fast.
    Cheers
    Jamie
     
  2. eth00

    eth00 Well-Known Member
    PartnerNOC

    Joined:
    Mar 30, 2003
    Messages:
    723
    Likes Received:
    1
    Trophy Points:
    18
    Location:
    NC
    cPanel Access Level:
    Root Administrator
    What sort of "solutions" do you want? You are going to have to hack around stuff either way

    1) Just update the code to reflect the new user

    2) Add the mysql dbs outside of cpanel
    **NOTE** doing this means they are not backed up or transfered within WHM

    Those are your only 2 real options...
     
  3. WestBend

    WestBend Well-Known Member

    Joined:
    Oct 12, 2003
    Messages:
    173
    Likes Received:
    0
    Trophy Points:
    16
    mysqldump..

    dump the sql to a file. create new databases on the cpanel box and import.
     
Loading...

Share This Page