22-06-2023, 04:43 PM
(21-06-2023, 04:34 PM)sysme escribió: Sin ese fichero no podemos recupearar datos ...
El apagón no puede borrar el fichero, es muy raro, lo que si puede es dajarlo corrupto y por tanto inservible ... pero hacerlo desaparecer no lo he visto nunca.
como te comenté, pude dar con el archivo ibdata1 pero pesa 0 kb, seguí nuevamente tus paso y ahora me arrojó un .err nuevo y este es el contenido:
InnoDB: Error: auto-extending data file .\ibdata1 is of a different size
InnoDB: 0 pages (rounded down to MB) than specified in the .cnf file:
InnoDB: initial 1664 pages, max 0 (relevant if non-zero) pages!
InnoDB: Could not open or create data files.
InnoDB: If you tried to add new data files, and it failed here,
InnoDB: you should now edit innodb_data_file_path in my.cnf back
InnoDB: to what it was, and remove the new ibdata files InnoDB created
InnoDB: in this failed attempt. InnoDB only wrote those files full of
InnoDB: zeros, but did not yet use them in any way. But be careful: do not
InnoDB: remove old data files which contain your precious data!
230622 11:40:27 [ERROR] Default storage engine (InnoDB) is not available
230622 11:40:27 [ERROR] Aborting
230622 11:40:27 [Note] mysqld-nt: Shutdown complete
InnoDB: Error: auto-extending data file .\ibdata1 is of a different size
InnoDB: 0 pages (rounded down to MB) than specified in the .cnf file:
InnoDB: initial 1664 pages, max 0 (relevant if non-zero) pages!
InnoDB: Could not open or create data files.
InnoDB: If you tried to add new data files, and it failed here,
InnoDB: you should now edit innodb_data_file_path in my.cnf back
InnoDB: to what it was, and remove the new ibdata files InnoDB created
InnoDB: in this failed attempt. InnoDB only wrote those files full of
InnoDB: zeros, but did not yet use them in any way. But be careful: do not
InnoDB: remove old data files which contain your precious data!
230622 11:40:32 [ERROR] Default storage engine (InnoDB) is not available
230622 11:40:32 [ERROR] Aborting
230622 11:40:32 [Note] mysqld-nt: Shutdown complete