Suggest me.

Discussion in 'MySQL' started by fireservice, Aug 17, 2008.

  1. #1
    i have a forum and want to change the hosting.

    now i wanna to know that
    how i backup my all data base and how to upload then into my new hosting.

    and what times it takes to upload(for per 10 MB.)

    plz give me suggestion.
     
    fireservice, Aug 17, 2008 IP
  2. iRakic

    iRakic Member

    Messages:
    40
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    43
    #2
    It depends of script that you are using, database and you host options.

    Generally most of script are written in PHP, and use MySQL as database, and host use cPanel as web-based control panel for administration.
    If this is the case then:
    1. You will need to download your script thru FTP, and then upload it to new host.
    2. Make a database backup, by going into cPanel, and then into phpMyAdmin (web-based database administration), and export a database. After DB is exported then go to new host create new DB, DB user (and password), and go into phpMyAdmin, and import that DB.
    3. Change configuration file that point to you new DB (db host, db name, db user, db password)

    That will be it in most cases.

    Keep in mind that some host have maximum file upload limit, so if you have some DB that is big, then DB upload is a little bit different.

    About time for uploading new DB, that depend on many factors, like Internet connecting (yours and host's), DB size, DB storage engine, server resources speed (CPU, memory...), does DB need to perform some query(s)...
     
    iRakic, Aug 17, 2008 IP
  3. kailash

    kailash Well-Known Member

    Messages:
    1,248
    Likes Received:
    42
    Best Answers:
    0
    Trophy Points:
    190
    #3
    If your both hosts cPanel then you can tell your new host to transfer your account from old host. It is very easy to transfer the account from one cPanel server to another. It will transfer all your data including database and email accounts else you will need to follow the steps provided by iRakic.

    Kailash
     
    kailash, Aug 17, 2008 IP
  4. vetrox

    vetrox Guest

    Messages:
    48
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #4
    Its easy if you want to transfer to a new host - jusst submit a ticket to your new host and ask them to complete a accoutn transfer from yuor old host and just sit back and wait
     
    vetrox, Aug 17, 2008 IP
  5. blueribbon

    blueribbon Peon

    Messages:
    29
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #5
    well, its only easy when the new host and old host are using the same or compatible control panels, otherwise databases and files need to be moved manually of course... definetely ask your host though if its possibe for them to do it automatically
     
    blueribbon, Aug 18, 2008 IP