Import old database with existing database

You have an xml file or a sql file? If you have an xml file that was created by the WordPress exporter you should be fine. The posts will just be added to the ones you already have. If you have a sql file it is going to be more complicated. You will probably need to import into a temporary table and then import into WordPress. You may have further problems with images embedded into posts.

It is an xml file. Well, I actually downloaded sql file too.

I tried to upload the xml file and received the following error msg,

“Sorry, there has been an error.
This does not appear to be a WXR file, missing/invalid WXR version number”

Open the files in a text editor and copy the first 5 lines or so. Let me see what they look like.

I hope that this is what you were asking for.

<?xml version=”1.0″ encoding=”utf-8″?>
<!–
– phpMyAdmin XML Dump
– version 3.3.10.2
– https://www.phpmyadmin.net
–
– Host: 216.227.216.46
– Generation Time: Jul 14, 2012 at 11:46 PM
– Server version: 5.0.87
– PHP Version: 5.2.17
–>

Ok. PhpMyAdmin exported it. What did you use to try to import it? PhpMyAdmin or the WordPress importer? The importer probably can’t handle it, and honestly I don’t know would happen if you tried to import with PhpMyAdmin. I’ve never even looked at PhpMyAdmin’s xml export. I will try to remember to take a look tomorrow.

I tried using the wordpress importer. The site hosting has already been transferred so I can’t login to the old wordpress site and export it.

Yes. You are going to have to deal with what you have. At least you have that. If you data is in that file it can be made to work ??

I think that I may have an easier solution. Tell me if I’m wrong, but what I think I can do is put up the old site on my local host and then export the file from the wordpress dashboard on my local host so that I can just import that file on the new, live dashboard. However, I have a problem now. I have WAMP installed, I’ve created the database in phpmyadmin, but for some reason I can’t link the site to the database. Whenever I go to the url I just get a list of all the wp folders. This would probably be a little bit easier for me if the person who originally built the site didn’t put the wp install in a subfolder. It’s in WebsiteFolder/blog/files for wordpress install.

So, to get it running locally then import it is the simplest idea or at least I think. What do you think and any pointers on getting this running locally?

That is a good idea.

It sounds like there is something wrong with your DirectoryIndex value. By default, it is this DirectoryIndex index.html. It needs to be DirectoryIndex index.php. I would have thought that WAMP took care of that but maybe not. You can test it by putting <?php echo 'hello'; ?> in a file named index.php in your root directory and visiting the localhost URL. If it works you should see ‘hello’.

Well, I’m now working on being able to login because I’m having issues resetting the password.

https://www.ads-software.com/support/topic/wordpress-login-page-wont-display?replies=11#post-2988595