hello after update to aapanel 7.0.9 i can't start mysql i've tried cd /www/server/data/ mv ibdata1 /tmp/ibdata1.bak mv ib_logfile0 /tmp/ib_logfile0.bak mv ib_logfile1 /tmp/ib_logfile1.bak /etc/init.d/mysqld restart if(window.hljsLoader && !document.currentScript.parentNode.hasAttribute('data-s9e-livepreview-onupdate')) { window.hljsLoader.highlightBlocks(document.currentScript.parentNode); } please help

can't start mySQL

Klaud

hello after update to aapanel 7.0.9
i can't start mysql
i've tried

cd /www/server/data/
mv ibdata1 /tmp/ibdata1.bak
mv ib_logfile0 /tmp/ib_logfile0.bak
mv ib_logfile1 /tmp/ib_logfile1.bak
/etc/init.d/mysqld restart

please help

Klaud

i got it turn back on after removing inno_db_forcerecovery

another problem, some of my site database now empty?

Klaud

aaPanel_Kern

Hello, please do not move files at will. It is recommended that you move the files back and start again. Unable to start, it is recommended that you configure inno_db_forcerecovery

Klaud

aaPanel_Kern

i first try with inno_db_forcerecovery but no luck

then i follow your guide https://www.aapanel.com/forum/d/14659-mysql-1073-mariadb-wont-start/2

now im missing my database how to recover?

aaPanel_Kern

Hello, please make a snapshot backup of the server before proceeding.
Back up the current files, restore the moved files, and then configure inno_db_forcerecovery to the highest number. Will it start normally? If it is not normal, it is recommended that you find a professional data recovery company
Or if you have backup data, you can also restore the data

Klaud

how to i move back the files?

thanks

Klaud

the sql server now can start, but some of the website ask to reinstall wordpress again, it seem the database empty

aaPanel_Kern

Make a server snapshot backup before operating.
If there is a backup, it is recommended that you restore the backup data, otherwise find a professional data recovery company

Klaud

aaPanel_Kern how do i Move back the file could u guide me? And what are those file actually?

aaPanel_Kern

We don't know what specific actions you took
It is recommended that you find professionals to help you
The following is the migration file process, please modify it according to your actual situation

/etc/init.d/mysqld stop
cd /www/server/data/
mv ibdata1 /tmp/ibdata1.bak_100
mv ib_logfile0 /tmp/ib_logfile0.bak_100
mv ib_logfile1 /tmp/ib_logfile1.bak_100

mv /tmp/ibdata1.bak ibdata1
mv /tmp/ib_logfile0.bak ib_logfile0
mv /tmp/ib_logfile1.bak ib_logfile1
/etc/init.d/mysqld start

Klaud

aaPanel_Kern
after moving back, mysql cant start again

Klaud

aaPanel_Kern

Hello, is it impossible to recover using inno_db_forcerecovery?

Klaud

aaPanel_Kern yes I've tried that and still can't start the sql server

aaPanel_Kern

Are there daily backups of the database? Or do you have a backup database?

Klaud

aaPanel_Kern
some have, some don't have, so actually whats the problem? why happens after upgrade from ver 6.x.x to 7.0.9

aaPanel_Kern

It is recommended that you find a professional company to help you handle it.
Upgrading aaPanel will not operate on mysql.
This situation is usually caused by server power outage, forced shutdown of mysql, etc.

Klaud

aaPanel_Kern so it's my database that crashed? Is it still fixable if no backups?
ANy recommendation for professional to handle?

Thanks

aaPanel_Kern

It is recommended that you find a data recovery company to assist you

Klaud