CODEWITHSUNDEEP
mysqlwordpressphpmyadminlocalhostmamp
kanga
kanga

Reputation: 379

MySQL database import successful but doesn't work

I am updating an existing wordpress website for a client and would like to work on it on my local server, but can't seem to get the database to import correctly. I am using MAMP, with phpMyAdmin.

After creating a new folder with a new install of wordpress on my computer, I imported the .sql.gz database backup from the live site into the local database (via phpMyAdmin). I used the same name for the database as on the live site. Got the message: "Import has been successfully finished, 278 queries executed." When I go to the website, or the WP dashboard, nothing seemed to import. None of the pages, posts, menus, or anything. I checked the wp-config.php, and it is referring to the correct database. So what am I doing wrong? How can I get all the content and settings to show?

Upvotes: 1

Views: 8865

Answers (2)

coletrain
coletrain

Reputation: 2849

When you import the database you will also need to import the xml file from wordpress. All you're really importing are the tags and images etc stored in the database but you will need to export your file from localhost and import into the actual server and you will see all of your posts etc.

Upvotes: 0

Khurram Ilyas
Khurram Ilyas

Reputation: 38

You need to update some information ...

set wp_options table id 1, 34 change it your local server name...

and then goto your admin dashboard ... deactivate the plugins and then activate them to work on local server.

hope this helps...

Upvotes: 2

Related Questions