The imported tables have no prefix at all. And the wp-config.php points to wp_ tables.
They have no prefix? Just tables like posts and users ? Where did you export this database from?
nope, no prefix at all indeed. I exported them from plesk / phpmyadmin of the old site. I assume they have been created this way (without prefix) by the guy who created the site a few years ago.
What was the $table_prefix set to in the old site’s wp-config.php file?
You can’t import non-WordPress post tables into a WordPress database and expect them to just work. The database structures are probably completely different. You’ll have to import the posts, if possible. What was the original site built with?
I’m not sure. it was a flash website I think.
Hence my idea to export without structure (in CSV) and import the data directly in the wp_post table.
Will give it a try at least.
Thank you very much James. I just tried the CSV importer but I get the following error:
Skipped 245 posts (most likely due to empty title, body and excerpt).
Imported 0 posts and 0 comments in 0.20 seconds.
I will try the other method or modify my spreadsheet manually so that the column match the structure of wordpress.
Thank you again !
(@mubashirrao)
15 years, 6 months ago
Hi Everyone!
Yesterday night my website got hacked! 🙁 but i made a backup just before it got hacked the backup i have was made by a plugin and thats in sql format. I have that sql database and now i want to import it in my new wordpress blog on new host so i can show my posts and comments and images that i have in that database. I imported SQL database via phpMyAdmin but when i opened my blog there is no post no image no comments either :(( so please any can help me about this? how do i show my posts, comments and images? or i am importing it wrong? there was successful message after importing database. I need Help! Please guyz help me out!