How Do I Move MYSGL Database From Host

Discussion in 'MySQL' started by Yankee0306, May 20, 2007.

  1. #1
    Hi:

    I bought a site a few days ago and I don't seem to how to move a MYSQL database from one host to another. I used Filezilla and appeared to get the data but no DB structure. Any help would be appreciated.
     
    Yankee0306, May 20, 2007 IP
  2. painthappy

    painthappy Peon

    Messages:
    93
    Likes Received:
    9
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Do you have access via command line? SSH... or only via your web browser?

    if ssh, you can use mysqldump

    mysqldump –-user admin –-password=password mydatabase > sql.dump

    if web browser, you can use the export function
     
    painthappy, May 20, 2007 IP
  3. painthappy

    painthappy Peon

    Messages:
    93
    Likes Received:
    9
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Here's a visual of the phpmyadmin section you should be able to find in either plesk or cpanel.

    [​IMG]


    [​IMG]


    [​IMG]


    Hope that helps ya!


    Carter
     
    painthappy, May 20, 2007 IP
  4. Yankee0306

    Yankee0306 Peon

    Messages:
    594
    Likes Received:
    6
    Best Answers:
    0
    Trophy Points:
    0
    #4
    Thanks so very much. I got it.
     
    Yankee0306, May 21, 2007 IP