aaP_boodyahmed2001k Hi there! I updated my aapanel last day and what happened is that all my WordPress sites DB got empty but the weird thing is that the sites are still working and store data inside the (empty DB) with no problem like a ghost 😅 I tried to import db and its empty tried to restart MySQL and still the issue excites -tried to import DB by using any WordPress plugin and it's empty DB !! the sites working perfectly but no DB tables! tried to create a new DB and connect to the new WordPress by regular installation and it says that it can't connect to my DB! can't delete db from my aapanel error logs when I import a database for a working site it looks so (empty) and the site works perfectly 😥 what should I do? thanks
aaPanel_Kern Hello, updating aapanel will not affect the operation of the website. aapanel is an independent service. Please check what operations you have done. The mysql log indicates that the same port is already in use. You can check the mysql process and port using the command ps aux|grep mysql && netstat -tulnp|grep 3306 aaP_boodyahmed2001k
aaPanel_Kern Try taking a snapshot backup of the server before proceeding. /etc/init.d/mysqld stop ps aux|grep mysql aaP_boodyahmed2001k
aaPanel_Kern Hello, after taking a snapshot of the server, is it normal to forcefully close mysql? Forced shutdown may cause abnormal data loss in the database aaP_boodyahmed2001k
aaP_boodyahmed2001k aaPanel_Kern Everything is running smoothly so far, as if the websites are linked to a database from another world, and I can never access them.
aaPanel_Kern Check the configuration file of the relevant site to see where it is connected. You can use phpmyadmin to check whether the database is normal aaP_boodyahmed2001k
aaP_boodyahmed2001k aaPanel_Kern everything in my config file looks normal but inside the phpmyadmin !! and the site works perfectly ❗
aaPanel_Kern The database table no longer exists. Have you deleted the database and re-created it? If you have old data, you can try to restore it aaP_boodyahmed2001k
aaP_boodyahmed2001k I didn't do anything at all. Everything is as it was, but this problem appeared after the update yesterday! Previously, before the update, I deleted all the files from /www/server/data to free up space. aaPanel_Kern
aaPanel_Kern Hello, please do not delete at will /www/server/data This directory is the database storage directory for mysql aaP_boodyahmed2001k
aaP_boodyahmed2001k aaPanel_Kern Thank you for clarifying that. It seems the issue is related to this. But how can I solve it now?
aaP_boodyahmed2001k aaPanel_Kern I deleted them from the file manager and also emptied the recycle bin 😅
aaPanel_Kern It is recommended that you find a professional company to help you handle it. If you have an old database backup, you can create database for recovery aaP_boodyahmed2001k
aaPanel_Kern Hello, is the problem solved? Try changing the root password in the database interface and then creating the database. Is it normal? aaP_boodyahmed2001k