Transfer MYSQL database from one host to another (Need someone)

Discussion in 'MySQL' started by mehdi, Sep 22, 2008.

  1. #1
    Hello, i need someone who can transfer me my site's mysql database from one host to another, its almost 200mb in size. and my network is very slow it cannot handle this.
    Is there anyone who can do it for FREE plz?
    thanks
     
    mehdi, Sep 22, 2008 IP
  2. jliu

    jliu Peon

    Messages:
    235
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    0
    #2
    If you have SSH access, you can perform the following command on your old host:

    mysqldump -u yourusername -p yourpassword databasename > databasename.sql

    Transfer the database using a tool like scp or put the database on your website and download it using wget on your new host.

    To restore your database, perform the following on your new host via SSH:

    mysql -u yourusername -p yourpassword databasename < databasename.sql
     
    jliu, Sep 22, 2008 IP
  3. mehdi

    mehdi Peon

    Messages:
    258
    Likes Received:
    12
    Best Answers:
    0
    Trophy Points:
    0
    #3
    I dnt know how to use SSH !
     
    mehdi, Sep 22, 2008 IP
  4. jliu

    jliu Peon

    Messages:
    235
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    0
    #4
    Does your host have a control panel? If it uses cPanel, I do know that there is a MySQL backup feature in which it will create the backup for you. You then transfer it to your new host. If your new host has cPanel as well, there is a restore MySQL database feature that you can use.
     
    jliu, Sep 22, 2008 IP
  5. mehdi

    mehdi Peon

    Messages:
    258
    Likes Received:
    12
    Best Answers:
    0
    Trophy Points:
    0
    #5
    I have seen the Backup tool of Cpanel, but i am not sure if the hosting gets down and up again, will the backup download resumes from Last Time?
     
    mehdi, Sep 22, 2008 IP
  6. jliu

    jliu Peon

    Messages:
    235
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    0
    #6
    I believe you will need to restart the download.
     
    jliu, Sep 22, 2008 IP
  7. mehdi

    mehdi Peon

    Messages:
    258
    Likes Received:
    12
    Best Answers:
    0
    Trophy Points:
    0
    #7
    yes, and my site downtime sucks..... it down after every half hour.

    PLEASE SOMEONE CAN DO THIS ...........
     
    mehdi, Sep 22, 2008 IP
  8. turnboy

    turnboy Banned

    Messages:
    71
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #8
    what you website domain?
    i will do it for charge(money) but you give me copy of database......
    PM me if u interest....
     
    turnboy, Nov 6, 2008 IP