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

Wordpress blog transfer question

Discussion in 'Blogging' started by joe0074, Jan 14, 2010.

  1. joe0074

    joe0074 Regular Member

    Joined:
    Dec 1, 2008
    Messages:
    410
    Likes Received:
    128
    Hi there,

    I want to transfer wordpress blog but when I log in to my phpMyAdmin page on the left hand side there is a bunch of wrdp1, wrdp2, wrdp3.....wrdp40 ( I have 40 wordpress blogs) I'm so confuse which one is for which website. I don't want to export the wrong database. How do I know that I pick the right wrdp ?

    Thanks in advance for your reply.

    Joe
     
  2. origin

    origin Regular Member

    Joined:
    Nov 11, 2008
    Messages:
    334
    Likes Received:
    90
    Home Page:
    Check your current wp-config.php file:

    Code:
    // ** MySQL settings - You can get this info from your web host ** //
    /** The name of the database for WordPress */
    define('DB_NAME', 'wptest');
    
    In my example, wptest is my database.
     
    • Thanks Thanks x 2
  3. joe0074

    joe0074 Regular Member

    Joined:
    Dec 1, 2008
    Messages:
    410
    Likes Received:
    128
    Sorry, where can I find wp-config.php file?

    Is there any easier way? like showing the domain name?
     
    Last edited: Jan 14, 2010
  4. origin

    origin Regular Member

    Joined:
    Nov 11, 2008
    Messages:
    334
    Likes Received:
    90
    Home Page:
    It's the same place with index.php on your current blog (usually /public_html). Use File Manager (from CPanel) to view the content of that file or download it (save it) to your pc. Open it via notepad or any text editor.
     
    • Thanks Thanks x 1
  5. joe0074

    joe0074 Regular Member

    Joined:
    Dec 1, 2008
    Messages:
    410
    Likes Received:
    128
    Oh man! it is a so complicated for a newbie.
    Don't know why they don't show the domain name, so we can pick it right away.
    I'm so scary to try.

    So from your example, wptest is your database.
    then what we have to do next at phpMyAdmin page.
    Will we know which wrdp on the left side to click on?

    Do you understand my point, right?
    I don't know which wrdp (1, 2,3...40) on the left side of phpMyAdmin page to click on.
    Which one is the right one of the website that I want to transfer ?
     
    Last edited: Jan 14, 2010
  6. origin

    origin Regular Member

    Joined:
    Nov 11, 2008
    Messages:
    334
    Likes Received:
    90
    Home Page:
    Don't worry, exporting process won't harm your database.

    From phpMyAdmin, click desired database (in my example is clicking wptest), then click Export menu on the top, select whether you want to export database as SQL (plain text file, uncompress), zip, or tar gzip. Click Go, your database export process should be asking to save it on your pc. Save it.

    Note that, the process of importing is a bit different after you have a database backup (exported from your db). You might need to change your wp_config.php since most account has different prefix for database, for example:
    current database: yoursite_blog1
    your new domain is bhwact. Your database when it's created with the same name (blog1) will be recorded as bhwact_blog1

    In this case, your WP configuration still referring to yoursite_blog1, you need to change it to bhwact_blog1

    Well, first step not always be easy, good luck.
     
    • Thanks Thanks x 1
  7. joe0074

    joe0074 Regular Member

    Joined:
    Dec 1, 2008
    Messages:
    410
    Likes Received:
    128
    Yes, I'm done.

    Wordpress is transfered successfully.

    Thank you so much.
     
    Last edited: Jan 15, 2010