So, did you just buy a WordPress blog on Flippa and now need to get it up and going on your own Webhost? Most likely they gave you the files and the SQL backup for the WordPress database. I’m going to show you what you do with those to get your site up and running.
This is assuming you have already transferred the DNS/domain over. If not, you can always edit your hosts file on your computer to do the steps below before the DNS has even changed over.
Upload your WordPress files to either the root or subdomain of your webhost, depending on your URL configuration.
Create a new mysql database by going into Cpanel and clicking on “MySQL Databases”. Choose a database name, username, and password. They can be whatever you want, just make sure you write it down as you will need this later.
Now that you have your mysql database, you need to take the backup (sql file) that you have from your Flippa purchase, and we are going to upload the contents of the wp db into your new one that you just created. To do this, you will need to go into phpMyAdmin. The link is right next to the previous one in Step 2.
Click on the “Databases” tab at the top, and then click on the name of the database you made in Step 2. Now click on the “Import” tab at the top. Browse your computer for the sql file you have from Flippa and then hit Go. That should have now uploaded all the tables from the blog/site you just purchased into your db that you created in Step 2.
Now we need to tell your WordPress files about the credentials for your db you made in Step 2 so that it can connect. In the root of your web directory, there should be a wp-config.php file. Go ahead and open/edit that and update your mysql database username and password. And that is it! Your blog should now be back to the state it was on its previous webhost.