This is not related to EE.  If that’s not OK, I understand.  Delete. 

I moved my EE installation to a new server.  I “dumped” my MySQL data and uploaded it to the new server.  No probs. 

But… When I look at my new EE install, while everything functions, all my blog entries from today (made on the old server but supposedly now on the new server) don’t show up.  It stops at yesterday. 

I compare the databases using phpMyAdmin, and sure enough, the newly uploaded database is missing today’s entries. Yet when I look at the .SQL file in a text editor, the entries seem to be there. 

This isn’t a crisis—I could just re-post them on the new server—but it concerns me that something went awry. 

Any suggestions?

Sounds odd if they aren’t showing in the database itself.  What version of mysql is being run on each server?  And if you look at the old server via phpmyadmin- the entries are there?  If you look at the db via phpmyadmin on the new one, they aren’t?  What happens if you do a fresh export from both old and new- and look in a text editor.  Are the entries in there?

Heh- hope that makes sense!

Robin Sowell - 29 June 2008 07:55 AM

Heh- hope that makes sense!

It’s very hard to make sense of what I wrote! 

This is sort of a moot point now that I’ve simply re-entered the missing entries, but for curiosity…

The old server’s mySQL version was 5.0.27, and the new one is 5.0.45. 

The old server definitely contains the entries, and I see them in EE. But as I said, after I exported that database file, then uploaded it to the new server, the entries from the past 24 hours or so on the old server disappeared.  I tried again by exporting a fresh copy, but same thing!  Th entries don’t show up in the new install of EE and in phpMyAdmin they don’t show up in the new database. 

To answer your last question:  I exported the new server’s database after uploading it from the old server, and looked at it in a text editor, and sure enough the new stuff wasn’t there.  So it seems to get lost from the database sometime after the moment I click “upload” on my FTP client.

That’s just weird.  I’d almost guess the import timed out, but I wouldn’t expect the only consequence of that to be missing entries from the last 24 hours.  No way.

And the sql/csv you uploaded to the new server- double checking that via text edit the entries are there?  My first bet would be they aren’t- and it exported a cached copy.  Because if that’s not it- it’s very, very weird.  I’d guess at phpmyadmin doing something- but I’ve never seen it do something quite like that!

Robin Sowell - 01 July 2008 07:22 AM

... it exported a cached copy. ...

Robin that thought crossed my mind (in retrospect, of course—not at the time), because I’d done some test jobs before committing to the final switch of servers and finally going for it, and I’d wondered if I wasn’t uploading the wrong copy (but I checked and re-checked!).  As I said I never considered that I’d get caught up some sort of weird cache problem. 

Thanks a lot for your input.

Just glad it was easy to get the new bits in there.  Though yea- I hate a mystery I can’t solve

But- I’ll close this one out anyway.  Chalk it up to the gremlins.