Moving hosts, will the DB be an issue?

Discussion in 'MySQL' started by tarponkeith, Sep 2, 2007.

0
  1. #1
    I've got a large mysql DB... A few thousand records... Will this be an issue when I make the move to a new webhost?

    I've heard all you have to do is a "mysql dump" somehow, then run the "dumped" file at your new host; is it really that easy?

    Thanks for any help :)
     
    tarponkeith, Sep 2, 2007 IP
  2. jmhyer123

    jmhyer123 Peon

    Messages:
    542
    Likes Received:
    25
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Yeah it is usually that easy ;) If you have phpMyAdmin you can just export your tables or the whole database and then import it on the new db and it will be an exact copy of the old one.
     
    jmhyer123, Sep 2, 2007 IP
    tarponkeith likes this.
  3. gibex

    gibex Active Member

    Messages:
    1,060
    Likes Received:
    21
    Best Answers:
    0
    Trophy Points:
    95
    #3
    yes, it;s easy
    1. make a db dump (db backup)
    2. restore it in new host

    it's better to make it on linux prompt with mysql command. phpmysqladmin has some limits about db file size on import.
     
    gibex, Sep 2, 2007 IP
  4. cb711

    cb711 Well-Known Member

    Messages:
    1,739
    Likes Received:
    34
    Best Answers:
    0
    Trophy Points:
    115
    #4
    should be very easy. I have done it multiple times with cPanel.
     
    cb711, Sep 2, 2007 IP
  5. Kuldeep1952

    Kuldeep1952 Active Member

    Messages:
    290
    Likes Received:
    18
    Best Answers:
    0
    Trophy Points:
    60
    #5
    A few thousand records is not much, but it does not give any indication of the db size. You can see the size in phpmyadmin. When you take a backup in phpmyadmin, if the size of the gzip backup is upto 2 MB, you can import using phpmyadmin. Otherwise you can use a script "bigdump", to import larger dbs.
     
    Kuldeep1952, Sep 3, 2007 IP