HELP!!!!- changed password for database in PHPmyadmin root MAMP (local develpment) and all hell broke loose
Permalink
I have been trying to get my concrete 5 database on my local machine back up - I changed the root password in phpmyadmin - then MAMP wouldn't start so I restored the MAMP from timeline - this is where the problems started as I still couldn't start the mysql service.
Backed up htpdocs ( sites ) and db folder ( mysql )
deleted MAMP downloaded newest version - installed it -
put folders back in same locations
Started MAMP apache and mysql service - greenlight
Opened phpmyadmin and all the databases were there but looked a little different
Clicked on Concrete 5 database - all the table structure looks right - but
There is no data - clicking on a table name brings up an error #1146 databasename.tablename does not exist
What is perplexing is that an old mysql database ( not Concrete ) that is not CamelCase appears to be working as expected. This is where I am confused. There is a site that I have been working on locally ( thought that backing up the db folder in MAMP was backing it up ) that I have been working on for almost a month - can't read the data. HELP!!!!!
Any ideas would be very appreciated - I have Googled for 2 days and there are far too many people telling what not to do than how to fix it. i.e. make back-up regularly from phpmyadmin sql export. Too late!
Backed up htpdocs ( sites ) and db folder ( mysql )
deleted MAMP downloaded newest version - installed it -
put folders back in same locations
Started MAMP apache and mysql service - greenlight
Opened phpmyadmin and all the databases were there but looked a little different
Clicked on Concrete 5 database - all the table structure looks right - but
There is no data - clicking on a table name brings up an error #1146 databasename.tablename does not exist
What is perplexing is that an old mysql database ( not Concrete ) that is not CamelCase appears to be working as expected. This is where I am confused. There is a site that I have been working on locally ( thought that backing up the db folder in MAMP was backing it up ) that I have been working on for almost a month - can't read the data. HELP!!!!!
Any ideas would be very appreciated - I have Googled for 2 days and there are far too many people telling what not to do than how to fix it. i.e. make back-up regularly from phpmyadmin sql export. Too late!
Still need help - couldn't get it to work- I am desperate at this point been trying to fix for 2 days.
Went step by step in terminal window and got a 1044 access denied error at the end. but it did make an sql file -
-- MySQL dump 10.13 Distrib 5.5.33, for osx10.6 (i386)
--
-- Host: localhost Database: jimDevelop
-- ------------------------------------------------------
-- Server version 5.5.33
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
Not sure what to do with this - Not what I am used to seeing - Is this what I was looking for? or is it incomplete.
I think the problem still has to do with the logfiles being from a different date or something not sure. Please help if you have expertise in this area
Big Karma will be coming your way if you help.
Jim
Went step by step in terminal window and got a 1044 access denied error at the end. but it did make an sql file -
-- MySQL dump 10.13 Distrib 5.5.33, for osx10.6 (i386)
--
-- Host: localhost Database: jimDevelop
-- ------------------------------------------------------
-- Server version 5.5.33
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
Not sure what to do with this - Not what I am used to seeing - Is this what I was looking for? or is it incomplete.
I think the problem still has to do with the logfiles being from a different date or something not sure. Please help if you have expertise in this area
Big Karma will be coming your way if you help.
Jim
Solved - It came down to me following tutorials to fix problem from Google and doing a fresh install of MAMP. Newest version of MAMP changes versions of MySQL - so when I put my backed up DB files back in to the folders - the ibdata1 file is slightly different with newer version ( this is my guess ) fixed it by going back to TIME machine and doing a total restore of MAMP and MAMP Pro which the MySQL is in the application folder - with that restore all files ( including meta files ) were all from matching versions and now all works - after 3 days of reading, testing and frustration I am now back to where I was last Thursday. Thanks to anyone who attempted to help. I am giving keeasti as best answer as his attempt to help led me to think about versions.
Jim
Jim
Glad it's all sorted :)
- it seems that I need to do a mysql dump ( sounds painful ) - explained here
http://www.quora.com/Jordan-Ryan/Web-Dev/How-to-Recover-innoDB-MySQ...
I have not really done much with the terminal window - so I am keeping my fingers crossed. I am posting this just in case someone else has this problem. Will let you know if this fixes it.