Wrong connection to DB after restore backup in DATA folder

[ekkelon]

Hello everyone ...
When I try to start the MySQL service on XAMPP 3.3.0 control panel doesn't start; I have followed these step:
1) Renamed DATA folder in DATA_OLD on XAMPP/MySQL
2) Create new DATA folder and copy inside the file from BACKUP folder
3) Copy the folder of my website DB from old DATA folder in new DATA folder
4) Restart the MySQL service from XAMPP control Panel, it start ok
5) when I try to open my localhost WP site the error to DB connection appear!

Can you help me?
Thank you so much.

[Altrea]

Hi,

Try to start MariaDB as console application. To do so, please:

• Open a new XAMPP Shell by clicking the Shell Button in your control panel
• type in the following command
  

  Code: Select all

  mysqld --defaults-file=mysql\bin\my.ini --standalone --console

• copy us the response of the console

[ekkelon]

I don't know how but now it's working well ....
But Now I have different problem ... I try to export the DB from PHPAdmin, I select the correct DB, select quickly option but error message appear "operation failed"
If now I press restart it seem that the download working but final DB-sql is only 56Kb.
Do you think the export DB is not complete?
Thnx.

[ekkelon]

Hi .... here the result of shell request:

Code: Select all

Setting environment for using XAMPP for Windows.
rchec@RUDI c:\xampp
# mysqld --defaults-file=mysql\bin\my.ini --standalone --console
2022-05-09  9:30:45 0 [Note] Using unique option prefix 'key_buffer' is error-prone and can break in the future. Please use the full name 'key_buffer_size' instead.
2022-05-09  9:30:45 0 [Note] mysqld (mysqld 10.4.24-MariaDB) starting as process 16012 ...
2022-05-09  9:30:45 0 [ERROR] InnoDB: The innodb_system data file 'ibdata1' must be writable
2022-05-09  9:30:45 0 [ERROR] InnoDB: The innodb_system data file 'ibdata1' must be writable
2022-05-09  9:30:45 0 [ERROR] Plugin 'InnoDB' init function returned error.
2022-05-09  9:30:45 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2022-05-09  9:30:45 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-05-09  9:30:45 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2022-05-09  9:30:45 0 [ERROR] Aborting

rchec@RUDI c:\xampp
#

What could be the problem?
Thnx.

[Altrea]

This shell command does only work and is only helpful if MariaDB is not already running.
The message that ibdata1 is not writable is a hint that MariaDB is already running.

[ekkelon]

Ok .. thx ...
How I can use it? I'm following your instruction..
Thnx.

[Altrea]

There are some known bugs in phpmyadmin related to current PHP Versions.

There is nothing you can do except:
- Use an earlier XAMPP version
- Try to upgrade phpmyadmin
- Try to dump your database by other methods like mysqldump command line tool