What is a MySQL dump and how do I do it?

Discussion in 'Blogging' started by GPS Mapper, Oct 29, 2006.

0
  1. #1
    Hi all-

    I helped a friend get a WP blog started, with the intention of partnering. We made it an add-on domain to my BlueHost account. The partnership is dissolving and we want to put him (and his blog) on his own Bluehost account. I asked BlueHost how this is done, and they responded...

    You will need to both copy the files/folders containing the WP installation and also perform a MySQL Dump for the database it uses. These will need to be uploaded and imported to the new account and it's database.

    So my questions are, what is a MySQL dump (just a data export?) and how do I do it? I'm a little weak on the tech stuff, and any help you can give would be greatly appreciated.
     
    GPS Mapper, Oct 29, 2006 IP
  2. minstrel

    minstrel Illustrious Member

    Messages:
    15,082
    Likes Received:
    1,243
    Best Answers:
    0
    Trophy Points:
    480
    #2
    Yes. You use phpMyAdmin to do a database export (structure and data). Then create a new (empty) database and do an import to the new database.
     
    minstrel, Oct 29, 2006 IP
    GPS Mapper likes this.
  3. GPS Mapper

    GPS Mapper Peon

    Messages:
    267
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Thanks minstrel. I'll check it out. Do I use phpMyAdmin to do the import too?
     
    GPS Mapper, Oct 29, 2006 IP
  4. minstrel

    minstrel Illustrious Member

    Messages:
    15,082
    Likes Received:
    1,243
    Best Answers:
    0
    Trophy Points:
    480
    #4
    Yes. Use it to create the empty database and then to import the SQL file (export file).
     
    minstrel, Oct 29, 2006 IP