Just copy the 5 or so tables from phpmyadmin and you are done.
Maybe you could ask the customer service to email you a backup copy of the database?
I have an old server running WordPress 1. and I’ve just installed wordpress 1.5.2.1 on a new server. its running but now i want to just import all the entries from the old server.
how do i do that?
My way:
Dump the old database using SQL dump and load it to the new database.
As your new WP installation is new, so just make it point to the uploaded database (from the old db dump) and run upgrade procedures (refer to the readme file). It will take about 2 minutes and you will be done.
Another way (Or the Highway 🙂 ):
Try to emit full RSS feeds from your old blog with 9999 entries.
Use an offline blog editor like Zempt, newzcrawler etc. and read
this feed. Change the settings to now dump it to the new blog.
Check the codex, there may be some procedure already to use RSS feed to populate WP.
Thread Starter
zpao
(@zpao)
So it was much easier than I thought it would be. I forgot that you could set the number of entries to include in the RSS feed.
So for LukeCollison, here is how I did it:
1. log into your old WP and goto options|reading and in Syndication Feeds set most recent: 9999 and make sure you have full text selected.
2. edit wp-admin/import-rss.php on your new server and make the second line look like define('RSSFILE', 'http://www.oldserver.com/wpdir/wp-rss2.php');
3. point your browser to newserver.com/wpdir/wp-admin/import-rss.php
or you can of course just dump the database and then import it (i realized you can just install phpmyadmin if your server doesnt have it. silly me)
Thread Starter
zpao
(@zpao)
although if you do it the RSS way, you will not preserve comments. so if possible, I suggest doing it the database dump then insert
I’m in a similar situation, where I will merge to WP sites, and do have access to the database (through phpMyadmin) … but what about the blog ids – I would expect them to conflict when I import from one to the other ??
Merging two WP databases is virtually impossible.
If one database has only a very few posts, it can probably be done.
If though it has a lot of posts / comments then as you expect there will be numerous conflicts inside the database.
How large are the databases ?
