First a little history of the problem Im in - Im on a Mac....
I use MampPro to setup my sites on the local server... all well and good. So, every time I fire it up I get the upgrade nag... so, I figure its time, and hit the upgrade... and it does its thing.
BOOM, every database I had there - gone! GRR! Dang! - Fortunately I was proactive and copied all of the previously ( the DB dir Mamp ). The internet tells me to simply put them back in the dir and restart - which I do....
Now PhpMyAdmin "sees" the DB's but does not have index's for any of them - I can see the column structure, but they have this yellow/red error for anything I try to open.
Ok, so I haven't done the latest upgrade just yet but it did include a MySQL upgrade version. Did you run the upgrade script included in MAMP after the upgrade? In the past, MAMP doesn't tell you to do this as part of the upgrade but you need to
Located here: /Applications/MAMP/bin/upgradeMysql.sh
Yes I did that - and i didnt buy the latest upgrade - during this - I got quite flustered and abandonded the cart - so its back at 4.5 and running but the previous DBs are still showing that error
Even though I ran the update DB (in both cases) on them all and got back an error i can post if required....
I'm really only worried about two of them - the others - well, I'll just have to redo them..... :(
A thought just occurred - if you have a working version - and its "updates" db's - why dont I zip up the dbs Im concerned with and forward them to you - you add them to your dbs - run the update to see if that "fixes" them.
If it does then there are two things that could work - export a dump that i can import or send em back and i can see if my sql "sees" them - I could also do a search and replace on the naming structure to match my https://localhost/xxxxxx name.
**Although I'd like to try the import sql option first though - make sense ?!?
Just to confirm, after you did the upgrade and saw no databases and basically things were broke, did you connect to MySQL via Terminal (verify the db's were there first which I think you did) and run the upgrade script and THEN try the repair script and still you did not see any databases? The repair script is in the same directory.
No i did not connect via the terminal - what I did was: I had a copy of the dbs sitting on my desktop - I placed them in the db dir in the library dir, nenamed it to v5.6 and set the orig to .BAK then restarted Mamp and went to the repair database option and, "ran it", it sees the db's but will do nothing - then in phpmyadmin, as I said before, it sees the dbs and the columns for each one, but the index tables are simply not there.
So, I set the DB back to what it was and then copied a single DB (of mine) into the active db dir, mamp "sees it" cannot repair it, same thing......
At the moment I still have this version running - and dont intend to do any more "fiddling" with it as its working - all I'm hoping to do is get the index tables back into 2 dbs of wotk
I'll leave it for others to suggest things, but if you can't go back to the old install MAMP made a backup for you during the initial upgrade, which included backups of all your databases by default (I can't tell if you moved the databases out there already which you should not have done) can you try to restore your sites if you made backups of them that way?
Well, it looks like they are gone - I did move them out as I reinstalled the app and started from zero ..... ( 4.6.5 )
I figured I could get someone to copy what I have into their DBs and run the update using their new version to reset the indexes, then exporting a sql dump file I could import into my ( lesser ) version