setting up my WP blog

  • Resolved gamegnet

    (@gamegnet)


    18 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

Viewing 9 replies - 1 through 9 (of 9 total)
  • Root

    (@root)

    Have you got access to a cpanel?

    Thread Starter gamegnet

    (@gamegnet)

    Yes

    jkeyes

    (@jkeyes)

    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 https://xxx.com/blog/wp-admin/upgrade.php.

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

    ekusteve

    (@ekusteve)

    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

    jkeyes

    (@jkeyes)

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

    moshu

    (@moshu)

    Nobody ever reading the Codex?
    https://codex.www.ads-software.com/Restoring_Your_Database_From_Backup

    Thread Starter gamegnet

    (@gamegnet)

    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

    moshu

    (@moshu)

    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.

    Thread Starter gamegnet

    (@gamegnet)

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

    Gene

Viewing 9 replies - 1 through 9 (of 9 total)
  • The topic ‘setting up my WP blog’ is closed to new replies.