| User | Post |
|
2:23 am
16 June, 2010
|
webservant
| | Parkville, MD | |
| Guru | posts 164 |
|
|
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/
|
|
|
|
|
3:29 am
16 June, 2010
|
webservant
| | Parkville, MD | |
| Guru | posts 164 |
|
|
For anyone who looked at the site and found… nothing… I was working on it. It is now up and running here: http://aisquith.dreamhosters.c…..o-sermons/
|
|
|
|
|
3:45 am
16 June, 2010
|
webservant
| | Parkville, MD | |
| Guru | posts 164 |
|
|
Post edited 2:56 am – 16 June, 2010 by webservant
Post edited 2:57 am – 16 June, 2010 by webservant
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.
|
|
|
|
|
2:19 pm
16 June, 2010
|
DmdStar
| | Dodgeville, WI USA | |
| Enthusiast | posts 42 |
|
|
Post edited 1:21 pm – 16 June, 2010 by DmdStar
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.
|
|
|
|
|
3:13 pm
16 June, 2010
|
webservant
| | Parkville, MD | |
| Guru | posts 164 |
|
|
Post edited 2:15 pm – 16 June, 2010 by webservant
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.
|
|
|
|
|
3:51 pm
16 June, 2010
|
DmdStar
| | Dodgeville, WI USA | |
| Enthusiast | posts 42 |
|
|
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.
|
|
|
|
|
10:12 pm
16 June, 2010
|
webservant
| | Parkville, MD | |
| Guru | posts 164 |
|
|
Matt – I am going to delete the existing database,create a new blank one, and start over.
|
|
|
|
|
1:22 am
17 June, 2010
|
webservant
| | Parkville, MD | |
| Guru | posts 164 |
|
|
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.
Argh – deleted my database, reimported… to no avail. Still getting tables (not all of them… only Sermon Browser) showing up in 2 places: the first set with names that have a correct prefix (sb) but then an underscore and the following letters "npdzjh" then another underscore followed by the remainder of the table name. If I delete the incorrectly named SB tables, then Sermon Browser reports on the search page that I have 8 sermons – but none shows up.
|
|
|
|
|
9:26 pm
18 June, 2010
|
webservant
| | Parkville, MD | |
| Guru | posts 164 |
|
|
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!
|
|
|
|
|
9:50 pm
18 June, 2010
|
DmdStar
| | Dodgeville, WI USA | |
| Enthusiast | posts 42 |
|
|
Excellent! Good to hear you are back in business. 
|
|
|
|
Login 
Register 
Search 
Forum
How do I?
Print this Post 
Topic RSS 
