WordPress.org

Ready to get started?Download WordPress

Forums

[resolved] setting up my WP blog (10 posts)

  1. gamegnet
    Member
    Posted 7 years ago #

    Hello,

    I recently bought gamedeveloping.net from a fellow WP user. However, he did not export the database correctly. I believe he used phpMyAdmin to export it. What I have now is a .sql file that is the database, and I have no idea how to import that into WP.

    Any help would be greatly appreciated. I've been trying to figure this out for quite some time now and couldn't come up with a solution.

    Thanks,
    Gene

  2. Root
    Member
    Posted 7 years ago #

    Have you got access to a cpanel?

  3. gamegnet
    Member
    Posted 7 years ago #

    Yes

  4. jkeyes
    Member
    Posted 7 years ago #

    What you need to do is execute the SQL (you can use the command line or phpMyAdmin for this). This should recreate all of the tables the blog needs for you.

    To use phpMyAdmin to do this, log in, select the database from the drop down in the left hand sidebar, select the SQL tab when it appears, paste the SQL, and then click Go.

    Check the names of the tables and then edit your wp-config.php to point at these tables by setting $table_prefix.

    I think all that's left to do then is to run the upgrade script http://xxx.com/blog/wp-admin/upgrade.php.

    Make sure you keep a secure backup of your SQL file just in case.

  5. ekusteve
    Member
    Posted 7 years ago #

    Then create a database in cpanel for your blog and add the user to the database.....this is the info you will need for your config file.

    Open your database in phpMyAdmin...should be a link for phpMyAdmin at the bottom of the page where you see your database in Cpanel. Once the database is open, select Import and follow the prompts to import the sql file.

    Steve

  6. jkeyes
    Member
    Posted 7 years ago #

    Oops, yeah for my approach you needed to already have a database created.

  7. moshu
    Member
    Posted 7 years ago #

  8. gamegnet
    Member
    Posted 7 years ago #

    Ok, so I created a new database, and imported the sql file.

    Where do I find wp-config.php?
    And is the upgrade script link supposed to lead me to xxx.com?

    Gene

  9. moshu
    Member
    Posted 7 years ago #

    The wp-config.php doesn't exist. You will save the wp-config-sample.php AS wp-config.php and edit it according to the instructions.

    The second question doesn't make sense.
    Don't bother about "upgrade" when you are at the installation phase.

  10. gamegnet
    Member
    Posted 7 years ago #

    Ok, looks like I have it up and working.
    Thank you everyone! You've been a great help.

    Gene

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags