MySQL bloqueada - LocalHost

_0-0_ #1 Oct '23

Buenas!
Tengo una aplicación web en localhost, hecha con PHP + MySQL (levantada con XAMPP) muy sencillita, una base de datos donde llevo varios registros personales.
El problema es que ayer se fue la luz de casa y se apagó el ordenador y no hay manera de arrancar la base datos, me dice esto:

18:42:00  [mysql] 	Error: MySQL shutdown unexpectedly.
18:42:00  [mysql] 	This may be due to a blocked port, missing dependencies, 
18:42:00  [mysql] 	improper privileges, a crash, or a shutdown by another method.
18:42:00  [mysql] 	Press the Logs button to view error logs and check
18:42:00  [mysql] 	the Windows Event Viewer for more clues
18:42:00  [mysql] 	If you need more help, copy and post this
18:42:00  [mysql] 	entire log window on the forums

Y el Log, tampoco es que de mucha información:

2023-10-03 18:41:59 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2023-10-03 18:41:59 0 [Note] InnoDB: Uses event mutexes
2023-10-03 18:41:59 0 [Note] InnoDB: Compressed tables use zlib 1.2.12
2023-10-03 18:41:59 0 [Note] InnoDB: Number of pools: 1
2023-10-03 18:41:59 0 [Note] InnoDB: Using SSE2 crc32 instructions
2023-10-03 18:41:59 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2023-10-03 18:41:59 0 [Note] InnoDB: Completed initialization of buffer pool
2023-10-03 18:41:59 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2023-10-03 18:41:59 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-10-03 18:41:59 0 [Note] InnoDB: Setting file 'E:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-10-03 18:41:59 0 [Note] InnoDB: File 'E:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2023-10-03 18:41:59 0 [Note] InnoDB: Waiting for purge to start
2023-10-03 18:41:59 0 [Note] InnoDB: 10.4.27 started; log sequence number 1327541; transaction id 5833
2023-10-03 18:41:59 0 [Note] InnoDB: Loading buffer pool(s) from E:\xampp\mysql\data\ib_buffer_pool
2023-10-03 18:41:59 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-10-03 18:41:59 0 [Note] InnoDB: Buffer pool(s) load completed at 231003 18:41:59
2023-10-03 18:41:59 0 [Note] Server socket created on IP: '::'.

¿Tenéis alguna idea de como la puedo levantar?
¿Me recomendáis alguna alternativa para evitar esto?

Gracias!

-nazgul- #2 Oct '23

en my.cnf o como se llame ese fichero en windows:

innodb_force_recovery = 6

Una vez la hayas levantado lo mejor es que hagas esto:

Exporta la bd a .sql
Borra del servidor la BD entera
Importa el SQL que exportaste previamente

1 respuesta

_0-0_ #3 Oct '23

#2 No lo hago sobrevivir:

16:19:20  [main] 	Initializing Control Panel
16:19:20  [main] 	Windows Version:  Enterprise  64-bit
16:19:20  [main] 	XAMPP Version: 8.2.0
16:19:20  [main] 	Control Panel Version: 3.3.0  [ Compiled: Apr 6th 2021 ]
16:19:20  [main] 	Running with Administrator rights - good!
16:19:20  [main] 	XAMPP Installation Directory: "e:\xampp\"
16:19:20  [main] 	Checking for prerequisites
16:19:20  [main] 	All prerequisites found
16:19:20  [main] 	Initializing Modules
16:19:20  [Apache] 	XAMPP Apache is already running on port 80
16:19:20  [Apache] 	XAMPP Apache is already running on port 443
16:19:20  [main] 	Enabling autostart for module "Apache"
16:19:20  [main] 	Enabling autostart for module "MySQL"
16:19:20  [main] 	Starting Check-Timer
16:19:20  [main] 	Control Panel Ready
16:19:20  [Apache] 	Autostart aborted: Apache is already running
16:19:20  [mysql] 	Autostart active: starting...
16:19:20  [mysql] 	Attempting to start MySQL app...
16:19:41  [mysql] 	Attempting to start MySQL app...
16:20:45  [mysql] 	Attempting to start MySQL app...
17:57:08  [mysql] 	Attempting to start MySQL app...
17:57:08  [mysql] 	Status change detected: running
17:57:09  [mysql] 	Status change detected: stopped
17:57:09  [mysql] 	Error: MySQL shutdown unexpectedly.
17:57:09  [mysql] 	This may be due to a blocked port, missing dependencies, 
17:57:09  [mysql] 	improper privileges, a crash, or a shutdown by another method.
17:57:09  [mysql] 	Press the Logs button to view error logs and check
17:57:09  [mysql] 	the Windows Event Viewer for more clues
17:57:09  [mysql] 	If you need more help, copy and post this
17:57:09  [mysql] 	entire log window on the forums

smarquezp #4 Oct '23 Inocente

Por aquí hay algunas soluciones que tal vez podrían valerte aunque son de hace tiempo:
https://stackoverflow.com/questions/18022809/how-to-solve-error-mysql-shutdown-unexpectedly

Por otro lado, hablan de arrancar el xaamp como administrador o cambiar el puerto, que son soluciones más sencillas e igual te funcionan si no lo has probado ya.

MySQL bloqueada - LocalHost

Usuarios habituales

Tags