Move from MySQL4 to MySQL5 hoses tables?
|
billc108
Joined: 2009-10-09
Posts: 8 |
Posted: Fri, 2009-10-09 09:44
|
|
Hi folks, I've had Gallery2 running for a couple of clients for several years now. Due to a database meltdown last night I moved the databases from a MySQL4 installation to a MySQL5 on a different server. All the other databases I moved (quite a few) are working properly on the new server EXCEPT the Gallery dbs, which are only displaying 2 of the 46 tables in phpMyAdmin. (g2_SequenceId and g2_SequenceLock). They appear to have the same settings as all the other tables: 0660 (-rw-rw----) with owner and group set to _mysql. The db itself is set as drwx------. I've checked permissions and ownership on the db files, and set them as I did on all the other dbs. Any clues appreciated. Obviously this may not be specifically a G2 problem, but as those are the only dbs which are exhibiting problems i thought someone here may have a clue, especially if it's related to some difference between MySQL 4 and 5. Thanks in advance. |
|
Posts: 16503
What do you mean by "displaying"? If you are only seeing 2 tables I can only think the either the import didn't import successfully, or the export from the old DB didn't export successfully.
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here
Posts: 8
Sorry if I wasn't completely clear... it had been a long night with no sleep as I took care of all the other dbs.
By "displaying" I mean displaying in phpMyAdmin.
My "import" process, if that's what you want to call it, was to go and pull the raw datafiles from the non-working database instance and put them into the data directory on the working MySQL5 one, then change the owner/group/permissions and restart MySQL. I'd have done nice tidy downloads with sql inserts and all that if the MySQL4 dbs hadn't mysteriously stopped responding (I still haven't gotten to the bottom of that yet), but didn't really have that option available. All the dbs showed up and most of them are working fine, but these two Gallery dbs apparently have a different structure.
And by that I mean that I'm used to each table having several files: a .MYI a MYD and a .frm. The two tables from the Gallery dbs which do display have all three... the other 44 tables have only .frm files.
I set Gallery on one of the sites on debug, and I'm getting error messages like:
1146: Table 'gallery2test.g2_usergroupmap' doesn't exist
You can see the whole works at <http://greenbuilder.com/proudmary/main.php>.
I may try doing a fresh install of the same version of Gallery in a dummy db to see what it's *supposed* to have in there... maybe that'll help my figure this out.
Posts: 16503
I don't know anything about using the MySQL DB files like that. I just do a dump from phpMyAdmin (or the command line if following instructions on the internet) and then import the sql dump into the new DB.
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here
Posts: 8
If phpMyAdmin was working, that would have been my choice too...
Posts: 16503
oh, so your old DB really got hosed? Maybe the old G2 stuff got corrupt.
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here
Posts: 8
Maybe... but every other db on that server (other than the two Gallery dbs) are working fine on the new server. And both these galleries are not particularly active.... one in fact probably hasn't had anything added in over a year. So I suspect that the db itself didn't get hosed. It apparently was mysql itself that took the hit.