Hi
I've read a lot of threads of issues with the DATABASECHANGELOG locking the database in a loop. I have the issue that my raspberry pi went suddenly went out of power. Even though the i run it on the same server with same ip etc etc it complains that the database_mv_db file is locked and it stays in that loop.
If i remove the database.mv.db file I can start the server but loosing a lot of my data.
I tried to install mysql to access the database from prompt by "mysql -usa -p database.mv.db" to be able to alter the value of the lock.
Unfortunately I have tried user: SA with everything from no password to all my known passwords, also tried users such as admin, root etc. It just says "Access denied for user sa@localhost"
I also tried to download some tools on windows machine to open the database.mv.db to be able to alter it.... no luck there either.
Can someone help me with a way of solving this ? Either how to alter my current database and remove the lock, or if I should continue with the fresh new empty database.mv.db and try to import the old database.mv.db. But where and how to i import a .db file into the new .db file ?
It seems like this DATABASECHANGELOG has caused some headache before. :)
Many thanks!
Hi
I've read a lot of threads of issues with the DATABASECHANGELOG locking the database in a loop. I have the issue that my raspberry pi went suddenly went out of power. Even though the i run it on the same server with same ip etc etc it complains that the database_mv_db file is locked and it stays in that loop.
If i remove the database.mv.db file I can start the server but loosing a lot of my data.
I tried to install mysql to access the database from prompt by "mysql -usa -p database.mv.db" to be able to alter the value of the lock.
Unfortunately I have tried user: SA with everything from no password to all my known passwords, also tried users such as admin, root etc. It just says "Access denied for user sa@localhost"
I also tried to download some tools on windows machine to open the database.mv.db to be able to alter it.... no luck there either.
Can someone help me with a way of solving this ? Either how to alter my current database and remove the lock, or if I should continue with the fresh new empty database.mv.db and try to import the old database.mv.db. But where and how to i import a .db file into the new .db file ?
It seems like this DATABASECHANGELOG has caused some headache before. :)
Many thanks!