Moving a sql database?

Discussion in 'Site & Server Administration' started by jjoshua, Dec 26, 2006.

  1. #1
    How do you transport a whole website, including an SQL database that I downloaded the backup files?
     
    jjoshua, Dec 26, 2006 IP
  2. koolasia

    koolasia Banned

    Messages:
    1,413
    Likes Received:
    59
    Best Answers:
    0
    Trophy Points:
    0
    #2
    do u have ssh access if ur not sure just hire some1 to do it for u
     
    koolasia, Dec 26, 2006 IP
  3. jezza chan

    jezza chan Active Member

    Messages:
    1,488
    Likes Received:
    70
    Best Answers:
    0
    Trophy Points:
    90
    #3
    Use phpmyadmin to re-upload your MySQL file and just download your files via FTP and just upload them to your new host.
     
    jezza chan, Dec 26, 2006 IP
  4. daboss

    daboss Guest

    Messages:
    2,249
    Likes Received:
    151
    Best Answers:
    0
    Trophy Points:
    0
    #4
    if you're using cpanel:
    1. do a full site back up
    2. get that backup to your local workstation/laptop
    3. contact your new host and get them to restore the backup

    as simple as that! ;)
     
    daboss, Dec 26, 2006 IP
  5. nddb

    nddb Peon

    Messages:
    803
    Likes Received:
    30
    Best Answers:
    0
    Trophy Points:
    0
    #5
    Careful with PHPMyAdmin, the newer versions may be ok, I've had issues with export/import in the past...
     
    nddb, Dec 26, 2006 IP
  6. Imran

    Imran Notable Member

    Messages:
    2,340
    Likes Received:
    190
    Best Answers:
    0
    Trophy Points:
    230
    #6
    It depends on What platform the web site is on. And What Server administration software is being used, With cpanel we can create a full backup, if the new host is using same cpanel based servers they can do cpanel - cpanel transfers. you can request them to do this.
    If you have ssh access you can login and download files. or transfer them to your site directly.
    Same applies with db's.

    I have a very good experience in this field, I have transfered huge and big website's some times manually downloading all files and then re uploading.
    If you need my services you can contact me, if the site less then 100mb I will do this for free(as I always give away freebies to DP members).
    Regards.
     
    Imran, Dec 26, 2006 IP
  7. toby

    toby Notable Member

    Messages:
    6,923
    Likes Received:
    269
    Best Answers:
    0
    Trophy Points:
    285
    #7
    better to do it ourself as when we hire someone, that someone may steal the codes.. sorry to sound a little harsh but it happens
     
    toby, Dec 27, 2006 IP
  8. Imran

    Imran Notable Member

    Messages:
    2,340
    Likes Received:
    190
    Best Answers:
    0
    Trophy Points:
    230
    #8
    Professionals are more worried about their customer's and their reputation rather then stealing others code.
     
    Imran, Dec 27, 2006 IP
  9. jjoshua

    jjoshua Well-Known Member

    Messages:
    257
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    118
    #9
    Well, really appreciate the help here, I am going to change host as you see, my website is getting a lot of downtime. Gonna do the operation myself, hope it goes well. Still waiting for the present host to go up again so that I can get the latest backup files.
     
    jjoshua, Dec 27, 2006 IP
  10. Imran

    Imran Notable Member

    Messages:
    2,340
    Likes Received:
    190
    Best Answers:
    0
    Trophy Points:
    230
    #10
    That really sucks, to get a back up you have to wait for your host to get their servers back online, is certainly not acceptable.
     
    Imran, Dec 27, 2006 IP