please help me I restarted my server after that mysql has not been started I tried many times, and anybody helps me, there are my 2 sites that have been hosted on it, and I am very frustrated about it

mh_bhatti Hi, please check the mysql log. What error content is displayed? cat /www/server/data/*.err|grep -i -C 10 error

2022-07-07T18:52:05.173957Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2022-07-07T18:52:05.173973Z 0 [Note] Shutting down plugin 'MEMORY' 2022-07-07T18:52:05.173979Z 0 [Note] Shutting down plugin 'CSV' 2022-07-07T18:52:05.173982Z 0 [Note] Shutting down plugin 'sha256_password' 2022-07-07T18:52:05.173984Z 0 [Note] Shutting down plugin 'mysql_native_password' 2022-07-07T18:52:05.174114Z 0 [Note] Shutting down plugin 'binlog' 2022-07-07T18:52:05.177477Z 0 [Note] /www/server/mysql/bin/mysqld: Shutdown complete

mh_bhatti Hello, can you check the error by executing the command as I said? There is no relevant error in the information you gave, so I can't handle it for you. cat /www/server/data/*.err|grep -i -C 10 error

cat: /www/server/data/exandnext-new.err: Permission denied it shows me this

2022-07-07T18:52:03.396474Z 0 [Note] Binlog end 2022-07-07T18:52:03.398547Z 0 [Note] Shutting down plugin 'ngram' 2022-07-07T18:52:03.398566Z 0 [Note] Shutting down plugin 'partition' 2022-07-07T18:52:03.398569Z 0 [Note] Shutting down plugin 'BLACKHOLE' 2022-07-07T18:52:03.398571Z 0 [Note] Shutting down plugin 'ARCHIVE' 2022-07-07T18:52:03.398573Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2022-07-07T18:52:03.398608Z 0 [Note] Shutting down plugin 'MRG_MYISAM' 2022-07-07T18:52:03.398610Z 0 [Note] Shutting down plugin 'MyISAM' 2022-07-07T18:52:03.400601Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' [opc@exandnext-new ~]$

there are too many lines there but copied last few lines,

mh_bhatti Please use root user to view

i only have private key, or can i sent the error file here download from aapanel

mysql is not started after restart server

aaPanel_Kern

If you delete mysql, please back up the /www/server/data directory before operating

mh_bhatti

which folder contains my latest datbase ?

aaPanel_Kern

mh_bhatti
Database storage directory: /www/server/data

mh_bhatti

i don't found any sql file there

mh_bhatti

this folder contains all database files how to i ulitize it after reinstall a datbase ?

mh_bhatti

aaPanel_Kern

mh_bhatti
Upgrading in aapanel is to reinstall the new version. Make a backup of the /www/server/data directory. Try to copy the database directory to /www/server/data/ after the installation is complete, it may not be necessary to test

like:cp -rpa /back/data/sql_exandnext /www/server/data/

mh_bhatti

as i said there are lot of files in sql_exandnext folder i ve to download all the folder or a specific database file ?

aaPanel_Kern

mh_bhatti
can also do a snapshot backup of the server, copying the entire /www/server/data directory for backup.
cp -arpf /www/server/data /www/backup/

mh_bhatti

yes, I downloaded the whole "data" folder into my local computer, whats the next?

mh_bhatti

aaPanel_Kern

mh_bhatti
Hi, has your problem been solved?

« Previous Page