How to fix: MySql Database Stopped in Bitnami WAMP

Reparar error: MySql Database Stopped en Bitnami WAMP

Actualmente tengo instalado Bitnami WAMP en mi computadora con Windows 10 para hacer pruebas y trabajos en localhost y hoy me dio un problema. No me era posible conectarme a phpmyadmin en localhost, es decir, ninguna de mis aplicaciones se podía conectar a su base de datos (MySql database).

Inmediatamente abrí Bitnami WAMP Stak Manager Tool que se encuentra en C:\Bitnami\manager-windows.exe o en el menú inicio de Windows 7/10, para revisar su estatus y el servicio de MySql Database estaba detenido.

Lo siguiente fue seleccionar MySql Database, dar click en Configuración y abrir el Log (también esta en C:\Bitnami\mysql\data\mysqld.log).

MySql Database Stopped

Erorres que me arrojo el archivo mysqld.log

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
2017-06-01 11:01:40 1820 [Note] Plugin 'FEDERATED' is disabled.
2017-06-01 11:01:41 1820 [Note] InnoDB: Using atomics to ref count buffer pool pages
2017-06-01 11:01:41 1820 [Note] InnoDB: The InnoDB memory heap is disabled
2017-06-01 11:01:41 1820 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2017-06-01 11:01:41 1820 [Note] InnoDB: Memory barrier is not used
2017-06-01 11:01:41 1820 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-06-01 11:01:41 1820 [Note] InnoDB: Not using CPU crc32 instructions
2017-06-01 11:01:41 e28  InnoDB: Error: unable to create temporary file; errno: 2
2017-06-01 11:01:41 1820 [ERROR] Plugin 'InnoDB' init function returned error.
2017-06-01 11:01:41 1820 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2017-06-01 11:01:41 1820 [ERROR] Unknown/unsupported storage engine: INNODB
2017-06-01 11:01:41 1820 [ERROR] Aborting
 
2017-06-01 11:01:41 1820 [Note] Binlog end
2017-06-01 11:01:41 1820 [Note] Shutting down plugin 'partition'
2017-06-01 11:01:41 1820 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2017-06-01 11:01:41 1820 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2017-06-01 11:01:41 1820 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2017-06-01 11:01:41 1820 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2017-06-01 11:01:41 1820 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2017-06-01 11:01:41 1820 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2017-06-01 11:01:41 1820 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2017-06-01 11:01:41 1820 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2017-06-01 11:01:41 1820 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2017-06-01 11:01:41 1820 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2017-06-01 11:01:41 1820 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2017-06-01 11:01:41 1820 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2017-06-01 11:01:41 1820 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2017-06-01 11:01:41 1820 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2017-06-01 11:01:41 1820 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2017-06-01 11:01:41 1820 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2017-06-01 11:01:41 1820 [Note] Shutting down plugin 'INNODB_METRICS'
2017-06-01 11:01:41 1820 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2017-06-01 11:01:41 1820 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2017-06-01 11:01:41 1820 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2017-06-01 11:01:41 1820 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2017-06-01 11:01:41 1820 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2017-06-01 11:01:41 1820 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2017-06-01 11:01:41 1820 [Note] Shutting down plugin 'INNODB_CMPMEM'
2017-06-01 11:01:41 1820 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2017-06-01 11:01:41 1820 [Note] Shutting down plugin 'INNODB_CMP'
2017-06-01 11:01:41 1820 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2017-06-01 11:01:41 1820 [Note] Shutting down plugin 'INNODB_LOCKS'
2017-06-01 11:01:41 1820 [Note] Shutting down plugin 'INNODB_TRX'
2017-06-01 11:01:41 1820 [Note] Shutting down plugin 'BLACKHOLE'
2017-06-01 11:01:41 1820 [Note] Shutting down plugin 'ARCHIVE'
2017-06-01 11:01:41 1820 [Note] Shutting down plugin 'MRG_MYISAM'
2017-06-01 11:01:41 1820 [Note] Shutting down plugin 'MyISAM'
2017-06-01 11:01:41 1820 [Note] Shutting down plugin 'MEMORY'
2017-06-01 11:01:41 1820 [Note] Shutting down plugin 'CSV'
2017-06-01 11:01:41 1820 [Note] Shutting down plugin 'sha256_password'
2017-06-01 11:01:41 1820 [Note] Shutting down plugin 'mysql_old_password'
2017-06-01 11:01:41 1820 [Note] Shutting down plugin 'mysql_native_password'
2017-06-01 11:01:41 1820 [Note] Shutting down plugin 'binlog'
2017-06-01 11:01:41 1820 [Note] C:\Bitnami\mysql\bin\mysqld.exe: Shutdown complete

Al ver mis resultados me encontre el error: InnoDB: Error: unable to create temporary file; errno: 2,

Entre al archivo C:\Bitnami\mysql\my.ini y encontré dos lineas que manejan algo relacionado con la memoria, pero como la segunda dice mysqldump, que es la que se encarga de hacer respaldos, fue la que modifique y le di el doble de lo que tenia, es decir de 32M la cambie a 64M (no se si funciona con menos).

Agrego un nuevo paso (02/06/2017): que es colocar una carpeta para los archivos temporales.

Después de [mysqld] colocamos una de las siguientes lineas dependiendo si es windows o linux.
tmpdir="C:/Bitnami/temp" <--- En windows 
tmpdir = "/run/mysqld"  <-- En linux

No necesariamente tiene que ser esa ruta, ustedes pueden utilizar la que gusten.

Así quedo mi archivo my.ini, ya modificado.

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
[client]
default-character-set=UTF8
 
[mysqladmin]
user=root
port=3306
 
# The MySQL server
[mysqld]
# set basedir to your installation path
basedir="C:/Bitnami/mysql"
# set datadir to the location of your data directory
datadir="C:/Bitnami/mysql/data"
tmpdir="C:/Bitnami/temp"
port=3306
character-set-server=UTF8
collation-server=utf8_general_ci
max_allowed_packet=32M
bind-address=127.0.0.1
# The default storage engine that will be used when create new tables when
default-storage-engine=INNODB
 
log-error="C:/Bitnami/mysql/data/mysqld.log"
[mysqldump]
max_allowed_packet=64M
 
[mysql]
port=3306

Después de salvar el archivo my.ini y volver a leer el archivo mysql.log, ya no apareció de nuevo el error y todo volvió a la normalidad.

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
2017-06-01 12:19:04 2920 [Note] Plugin 'FEDERATED' is disabled.
2017-06-01 12:19:04 2920 [Note] InnoDB: Using atomics to ref count buffer pool pages
2017-06-01 12:19:04 2920 [Note] InnoDB: The InnoDB memory heap is disabled
2017-06-01 12:19:04 2920 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2017-06-01 12:19:04 2920 [Note] InnoDB: Memory barrier is not used
2017-06-01 12:19:04 2920 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-06-01 12:19:04 2920 [Note] InnoDB: Not using CPU crc32 instructions
2017-06-01 12:19:04 2920 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2017-06-01 12:19:04 2920 [Note] InnoDB: Completed initialization of buffer pool
2017-06-01 12:19:04 2920 [Note] InnoDB: Highest supported file format is Barracuda.
2017-06-01 12:19:05 2920 [Note] InnoDB: 128 rollback segment(s) are active.
2017-06-01 12:19:05 2920 [Note] InnoDB: Waiting for purge to start
2017-06-01 12:19:05 2920 [Note] InnoDB: 5.6.35 started; log sequence number 1783596
2017-06-01 12:19:05 2920 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
2017-06-01 12:19:05 2920 [Note]   - '127.0.0.1' resolves to '127.0.0.1';
2017-06-01 12:19:05 2920 [Note] Server socket created on IP: '127.0.0.1'.
2017-06-01 12:19:05 2920 [Note] Event Scheduler: Loaded 0 events
2017-06-01 12:19:05 2920 [Note] C:\Bitnami\mysql\bin\mysqld.exe: ready for connections.
Version: '5.6.35'  socket: ''  port: 3306  MySQL Community Server (GPL)

Espero les sirva esta solución a MySql database: Error: unable to create temporary file; errno. 🙂