Importing WP database

I want to import an old site database to the new site. Both site have the same host.

I made a new database and added a user setting to it. In my wp-config php file, i change the db_name to the new database and the db_user to the added user.

I don't know what I am doing wrong. When I enter my new site URL in the adress bar, it goes back to the old site (it is behaving as if I am doing a redirect)

What is wrong?

 

Sounds like you need to change the url entries in the database?

There are two main entries in the options table that has the url.

Login phpmyadmin and open options table and change those two main URL fields to have the new URL.

Or it can be changed by opening the raw .sql file too before importing.


Boulder

 

export from ole site

and import new site.

Are you correct user and password?

 

I have had the same problem before. This is what I did to fix it.

1. Go to Old or new (Which ever you are trying to make now) phpmyadmin database.

2. Do a Overall search for the website's URL or the name itself from the Search Query.

3. Edit all of the URL's to the new ones (From the old ones or w/e your trying to do)

4. Save and you should see a change.

 

I am transferring a WP blog also. It is transferred but how do I open wp-config to change the database, user name and password?

Chad

 

@Clipovich

Try opening it in notepad or another text editor

 

Got it. Thanks. That worked. I have never used php and when I tried clicking on it, my Windows Picture It program was trying to open it. I'm such a newb. Thanks for the help.