Forum

I am in the process of moving our site to a new host. I uploaded all the mp3s, and exported the database from the former host and imported it to the new one. No sermons! Any idea what I did wrong?

http://aisquith.dreamhosters.c…..o-sermons/

The site is working at its new location again. This appears to be some kind of database issue. I have imported the database, and I can see the sb tables in the database but no sermons.

DmdStar said:

First, can I assume you are on a shared host with MySQL?

Where did you export from? Did you use PHPMyAdmin (usually an option for MySQL administration in the control panel).

If you export/import with that utility, it should ensure you have all the data.

When you export, before importing to the new location, you can also search the .SQL file (it's just a text file) for references to your old server's physical path ( ie. /home/wp-admin … etc)…and replace it with the new server's path, if its different.

Hopefully that's helpful. It can be annoying changing hosts.

Good questions. Yes, I am on shared host using MySQL. At first, I used Godaddy's admin panel to export the database and I imported that. Next I exported it using PHPMyAdmin and then imported that file. Funny thing is, when I look at the database, the tables are all there but the names are there twice — the first instance is the same tables with slightly weird names. I deleted the duplicate tables (only the ones with the messed up names) and had to re-install Wordpress.

Matt – I am going to delete the existing database,create a new blank one, and start over.

DmdStar said:

Did you, perhaps, install Wordpress with a different prefix than your old host? That would most certainly cause a problem when importing the tables… but that,too, can be fixed with a simple find/replace with the .SQL file in Notepad.

You, sir, are a genius. 'Twas the prefix. I had to change the "stable prefix" in wp-config to "wp" and once I did that, it all worked. Thanks!