Hi
Just installed Ampps on my windows 10 machine to replace WAMP 2.2, but I am running into issues trying to move the mysql data files to an external drive.
I am continually getting the following error in MySQL logs:
InnoDB: .\ibdata1 can't be opened in read-write mode
Here are some steps I have taken.
1. Moved just the data folder from Ampps default location of Code #datadir="{$path}/mysql/data/" Code datadir="G:\databases\data"
restarted mysql, get error host of InnoDB errors starting with Code "InnoDB: .\ibdata1 can't be opened in read-write mode"
2. uncommented the InnoDB paths in my.ini and pointed them to external drive - no change in error message
3. deleted all contents of data folder on my external drive with exception of mysql and performance_schema folders
in all instances I still get the ibdata can't be opened error message. I have granted full permissions to my windows files/folders for all user types so that should not be the issue. I am also able to get into phpMyAdmin and am able to import SQL, create tables, etc... but still the Ampps front end is not showing startup.
Any ideas I would love to move to Ampps, but not being able to have external data is making it rather difficult...
Thanks in advance
|