Get SQL from backed up INNOB databases (quick $50.00)
Permalink 1 user found helpful
I posted this in For others to catch-up - this is how this mess started.
Changed password for MYSQL and then shut down Mysql - MYsql would not start again from MAMP - so since I had done very little work before this happened - I made sure I had back-up of all sites ( htdoc folder) and the mysql folder.
Then I reloaded MAMP - Clicked Start and the apache and mysql started as they should.
I then went to my Time machine back-up from the day before and loaded the db folder ( all the mysql tables) back into my new MAMP folders ( same location )
Opened up phpmyadmin and all the databases were there - clicked on a database and all the fields showed up on the left ( tables ) but when I click on them - no data!
After hours and hours of reading online - I think that my problem is MySQL stores data for Innob databases in one file - The file also holds an id for each table. This is where things get hairy. You can't just open the file and change it to match the id that Mysql is now giving it ( with the new reload ) in other words the id's don't match. And that is what got me to here.
And now I am stumped-
I will pay anyone 50.00 to get an SQL dump that I can import in to PHPmyadmin from my files ( one site only ) - see attachment- Hope someone can help - getting desperate.
Jim Robinson
Changed password for MYSQL and then shut down Mysql - MYsql would not start again from MAMP - so since I had done very little work before this happened - I made sure I had back-up of all sites ( htdoc folder) and the mysql folder.
Then I reloaded MAMP - Clicked Start and the apache and mysql started as they should.
I then went to my Time machine back-up from the day before and loaded the db folder ( all the mysql tables) back into my new MAMP folders ( same location )
Opened up phpmyadmin and all the databases were there - clicked on a database and all the fields showed up on the left ( tables ) but when I click on them - no data!
After hours and hours of reading online - I think that my problem is MySQL stores data for Innob databases in one file - The file also holds an id for each table. This is where things get hairy. You can't just open the file and change it to match the id that Mysql is now giving it ( with the new reload ) in other words the id's don't match. And that is what got me to here.
And now I am stumped-
I will pay anyone 50.00 to get an SQL dump that I can import in to PHPmyadmin from my files ( one site only ) - see attachment- Hope someone can help - getting desperate.
Jim Robinson
sorry the one database that is important to me ( not backed up with sql dump is - Soccertronics
This has been solved - Went back to time machine and loaded the complete MAMP from last Thursday and now it works like before. I think that the versions of mySQL were different and the newer mySQL had problems reading the ibdata1 file. This is my guess. Thanks to anyone who had a look at this problem for me.
Jim
Jim
