1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Help/Questions About Transferring a Wordpress Site to Another Host

Discussion in 'Blogging' started by thetvnun, Jun 4, 2011.

  1. thetvnun

    thetvnun Power Member

    Joined:
    Sep 8, 2010
    Messages:
    656
    Likes Received:
    255
    Hey Guys,

    I'm trying to move a Wordpress site to another host, I'm watching these video tutorials and backing up stuff and now I'm at the point where I need to find the old mysql database and move it to the new host.

    But I can't tell which mysql database is for the site, they're names are pretty ambiguous, there are a ton of them.

    How can I tell which mysql is for what site? and which phpmyadmin thing?

    Thanks guys, sorry for being lame.
     
  2. syngenetic

    syngenetic Guest

    Should've remember what you named it while creating your wordpress blog. Open up phpmyadmin and click on one of the database. Then find the tables that has wp_ in front. Click on the export tab, select all and save it. If you need more help, pm me and I'll do it for you.
     
    • Thanks Thanks x 1
  3. IdiotSavant

    IdiotSavant Newbie

    Joined:
    Mar 31, 2011
    Messages:
    32
    Likes Received:
    8
    if you go into your blog folder on your host account, open the wp-config.php file and look for:
    // ** MySQL settings - You can get this info from your web host ** //
    /** The name of the database for WordPress */
    define('DB_NAME', 'hostname_wrd12');
    in this case, the mysql database is wrd12
     
    • Thanks Thanks x 1
  4. thetvnun

    thetvnun Power Member

    Joined:
    Sep 8, 2010
    Messages:
    656
    Likes Received:
    255
    thanks guys! i did it and it worked. i think!