Welcome Guest. Please Login or Register  


You are here: Index > AMPPS > General Support > Topic : Windows InnoDB: lbdata1 can't be opened in read-write mode



Threaded Mode | Print  

 Windows InnoDB: lbdata1 can't be opened in read-write mode, Windows InnoDB: lbdata1 can't be opened in read-write mode (0 Replies, Read 11775 times)
mklappen
Group: Member
Post Group: Newbie
Posts: 2
Status:
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/"
to my external drive
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
IP: --   

« Previous    Next »

Threaded Mode | Print  



Jump To :


Users viewing this topic
1 guests, 0 users.


All times are GMT. The time now is March 19, 2024, 8:19 am.

  Powered By AEF 1.0.8 © 2007-2008 Electron Inc.Queries: 11  |  Page Created In:0.291