mysql won't launch (XAMPP v3.2.1)

Problems with the Windows version of XAMPP, questions, comments, and anything related.

mysql won't launch (XAMPP v3.2.1)

Postby dDesign » 09. May 2016 11:43

Dear Apache Friends,

Today i wanted to work on my website after 2 weeks of vacation. My laptop (Acer aspire v15 nitro - black edition) has been in sleeping mode while the servers where running. But after i launched Apache (launches perfectly), i wanted to launch MySQL too, that didn't work out well.

After i click on "Start" .. it will run for some seconds and then it stops running, giving the next bug in the log:

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

I tried many things, like deleting the "ibdata1" file and restart XAMP - no effect
Also tried to change the port of the MySQL and launching the MySQL upgrade didnt show any effects.

This is what the error log looks like:

2016-05-09 12:38:00 1ce0 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
160509 12:38:00 [Note] InnoDB: Using mutexes to ref count buffer pool pages
160509 12:38:00 [Note] InnoDB: The InnoDB memory heap is disabled
160509 12:38:00 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
160509 12:38:00 [Note] InnoDB: Memory barrier is not used
160509 12:38:00 [Note] InnoDB: Compressed tables use zlib 1.2.3
160509 12:38:00 [Note] InnoDB: Not using CPU crc32 instructions
160509 12:38:00 [Note] InnoDB: Initializing buffer pool, size = 16.0M
160509 12:38:00 [Note] InnoDB: Completed initialization of buffer pool
160509 12:38:00 [Note] InnoDB: Highest supported file format is Barracuda.
160509 12:38:00 [Note] InnoDB: The log sequence numbers 1665234 and 1665234 in ibdata files do not match the log sequence number 73591974 in the ib_logfiles!
160509 12:38:00 [Note] InnoDB: Database was not shutdown normally!
160509 12:38:00 [Note] InnoDB: Starting crash recovery.
160509 12:38:00 [Note] InnoDB: Reading tablespace information from the .ibd files...
160509 12:38:00 [Note] InnoDB: Restoring possible half-written data pages
160509 12:38:00 [Note] InnoDB: from the doublewrite buffer...
160509 12:38:01 [Note] InnoDB: 128 rollback segment(s) are active.
160509 12:38:01 [Note] InnoDB: Waiting for purge to start
160509 12:38:01 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.22-72.0 started; log sequence number 73591974
160509 12:38:01 [Note] Plugin 'FEEDBACK' is disabled.
160509 12:38:01 [Note] Server socket created on IP: '::'.
160509 12:38:01 [Warning] 'db' entry 'column 'sql_mode' at position 14 to have type set('real_as_float','pipes_as_concat','ansi_quotes','ignore_space','ignore_bad_table_options','only_full_group_by','no_unsigned_subtraction','no_d IR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2@51110 9:19:23 [ERROR] Missing system table mysql.roles_mapping; please run mysql_upgrade to create it

151110 9:19:23 [ERROR] Incorrect definition of table mysql.event: expected' had database in mixed case that has been forced to lowercase because lower_case_table_names is set. It will not be possible to remove this privilege using REVOKE.
160509 12:38:01 [Warning] 'db' entry ''no_zero_date','invalid_dates','error_for_division_by_zero','traditional','no_auto_create_user','high_not_precedence','no_engine_substitution','pad_char_to_full_length'), found type set('real_ AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNOR@TIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_ZERO_IN_DATE',' had database in mixed case that has been forced to lowercase because lower_case_table_names is set. It will not be possible to remove this privilege using REVOKE.
160509 12:38:01 [Warning] 'db' entry 'ql40','ansi','no_auto_value_on_zero','no_backslash_escapes','strict_trans_tables','strict_a

151110 9:19:23 [error] event scheduler: an error occurred when initializing system tables. disabli ng the Event Scheduler.

151110 9:19:23 [Warnin@'ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYS' had database in mixed case that has been forced to lowercase because lower_case_table_names is set. It will not be possible to remove this privilege using REVOKE.
160509 12:38:01 [Warning] 'db' entry '.

version: '10.0.17-mariadb' socket: '' port: 3306 mariadb.org binary distribution

151209 9:38:40 [error] missing system table mysql.roles_mapping; please run mysql_upgrade to create it

151209 9:38:40 [ERROR] Incorrect definition of@ave replication state from table mysql.gtid_slave_pos: 1146: Table 'mysql.gtid_slave_pos' doesn't exist

151110 9:19:23 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections' had database in mixed case that has been forced to lowercase because lower_case_table_names is set. It will not be possible to remove this privilege using REVOKE.
160509 12:38:01 [Warning] 'db' entry 'ed_subtraction','no_dir_in_create','postgresql','oracle','mssql','db2','maxdb','no_key_options','no_table_options','no_field_options','mysql323','mysql40','ansi','no_auto_value_on_zero','no_ba CKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_A@expected column 'sql_mode' at position 14 to have type set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','IGNORE_BAD_TABLE_OPTIONS','ONLY_FULL_GROUP_BY','NO_UNSIGN' had database in mixed case that has been forced to lowercase because lower_case_table_names is set. It will not be possible to remove this privilege using REVOKE.
160509 12:38:01 [Warning] 'db' entry 'found type set('real_as_float','pipes_as_concat','ansi_quotes','ignore_space','not_used','only_full_group_by','no_unsigned_subtraction','no_dir_in_create','postgresql','oracle','mssql','db2',' MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_F@IN_DATE','NO_ZERO_DATE','INVALID_DATES','ERROR_FOR_DIVISION_BY_ZERO','TRADITIONAL','NO_AUTO_CREATE_USER','HIGH_NOT_PRECEDENCE','NO_ENGINE_SUBSTITUTION','PAD_CHAR_TO_FULL_LENGTH'),' had database in mixed case that has been forced to lowercase because lower_case_table_names is set. It will not be possible to remove this privilege using REVOKE.
160509 12:38:01 [Warning] 'db' entry 'ystem tables. disabling the event scheduler.

151209 9:38:40 [warning] failed to load slave replication state from table mysql.gtid_slave_pos: 1146: table 'mysql.gtid_slave_pos' doesn't exist

151209 9:38:40 [Note] c:\xampp\mysql\bin\mysq@323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_A

151209 9:38:40 [ERROR] Event Scheduler: An error occurred when initializing s' had database in mixed case that has been forced to lowercase because lower_case_table_names is set. It will not be possible to remove this privilege using REVOKE.
160509 12:38:01 [Warning] 'db' entry '_table_stats" is binary(4) not null but should be int not null (type mismatch).

2015-12-09 09:45:27 8f4c innodb: error: fetch of persistent statistics requested for table "wordpress"."wp_opti ons" but the required system tables mysql.innodb@nnections.

Version: '10.0.17-MariaDB' socket: '' port: 3306 mariadb.org binary distribution

2015-12-09 09:45:27 8f4c InnoDB: Error: Column last_update in table "mysql"."innodb' had database in mixed case that has been forced to lowercase because lower_case_table_names is set. It will not be possible to remove this privilege using REVOKE.
160509 12:38:01 [Warning] 'db' entry 'odb_table_stats" is binary(4) not null but should be int not null (type mismatch).

2015-12-09 09:45:27 8f4c innodb: error: fetch of persistent statistics requested for table "wordpress"."wp_p osts" but the required system tables mysql.innod@ql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead.

2015-12-09 09:45:27 8f4c InnoDB: Error: Column last_update in table "mysql"."inn' had database in mixed case that has been forced to lowercase because lower_case_table_names is set. It will not be possible to remove this privilege using REVOKE.
160509 12:38:01 [Warning] 'db' entry 'nodb_table_stats" is binary(4) not null but should be int not null (type mismatch).

2015-12-09 09:45:27 8f4c innodb: error: fetch of persistent statistics requested for table "wordpress"."wp_ postmeta" but the required system tables mysql.i@sql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead.

2015-12-09 09:45:27 8f4c InnoDB: Error: Column last_update in table "mysql"."in' had database in mixed case that has been forced to lowercase because lower_case_table_names is set. It will not be possible to remove this privilege using REVOKE.
160509 12:38:01 [Warning] 'db' entry '."innodb_table_stats" is binary(4) not null but should be int not null (type mismatch).

2015-12-09 09:45:28 8f4c innodb: error: fetch of persistent statistics requested for table "wordpress". "wp_terms" but the required system tables mysql.@d mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead.

2015-12-09 09:45:28 8f4c InnoDB: Error: Column last_update in table "mysql"' had database in mixed case that has been forced to lowercase because lower_case_table_names is set. It will not be possible to remove this privilege using REVOKE.
160509 12:38:01 [Warning] 'db' entry '"."innodb_table_stats" is binary(4) not null but should be int not null (type mismatch).

2015-12-09 09:45:28 8f4c innodb: error: fetch of persistent statistics requested for table "wordpress" ."wp_term_taxonomy" but the required system tabl@nd mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead.

2015-12-09 09:45:28 8f4c InnoDB: Error: Column last_update in table "mysql' had database in mixed case that has been forced to lowercase because lower_case_table_names is set. It will not be possible to remove this privilege using REVOKE.
160509 12:38:01 [Warning] 'db' entry 'le "mysql"."innodb_table_stats" is binary(4) not null but should be int not null (type mismatch).

2015-12-09 09:45:28 8f4c innodb: error: fetch of persistent statistics requested for table "w ordpress"."wp_term_relationships" but the requir@e_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead.

2015-12-09 09:45:28 8f4c InnoDB: Error: Column last_update in tab' had database in mixed case that has been forced to lowercase because lower_case_table_names is set. It will not be possible to remove this privilege using REVOKE.
160509 12:38:01 [Warning] 'db' entry '_update in table "mysql"."innodb_table_stats" is binary(4) not null but should be int not null (type mismatch).

2015-12-09 09:45:28 8f4c innodb: error: fetch of persistent statistics requeste d for table "wordpress"."wp_users" but the requi@ql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead.

2015-12-09 09:45:28 8f4c InnoDB: Error: Column last' had database in mixed case that has been forced to lowercase because lower_case_table_names is set. It will not be possible to remove this privilege using REVOKE.
160509 12:38:01 [Warning] 'db' entry 't_update in table "mysql"."innodb_table_stats" is binary(4) not null but should be int not null (type mismatch).

2015-12-09 09:45:29 8f4c innodb: error: fetch of persistent statistics request ed for table "wordpress"."wp_usermeta" but the r@sql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead.

2015-12-09 09:45:29 8f4c InnoDB: Error: Column las' had database in mixed case that has been forced to lowercase because lower_case_table_names is set. It will not be possible to remove this privilege using REVOKE.
160509 12:38:01 [Warning] 'db' entry ' last_update in table "mysql"."innodb_table_stats" is binary(4) not null but should be int not null (type mismatch).

2015-12-09 09:45:29 8f4c innodb: error: fetch of persistent statistics req uested for table "wordpress"."wp_comments" but t@s mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead.

2015-12-09 09:45:29 8f4c InnoDB: Error: Column' had database in mixed case that has been forced to lowercase because lower_case_table_names is set. It will not be possible to remove this privilege using REVOKE.
160509 12:38:01 [ERROR] Missing system table mysql.roles_mapping; please run mysql_upgrade to create it
160509 12:38:01 [ERROR] Incorrect definition of table mysql.event: expected column 'sql_mode' at position 14 to have type set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','IGNORE_BAD_TABLE_OPTIONS','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_ZERO_IN_DATE','NO_ZERO_DATE','INVALID_DATES','ERROR_FOR_DIVISION_BY_ZERO','TRADITIONAL','NO_AUTO_CREATE_USER','HIGH_NOT_PRECEDENCE','NO_ENGINE_SUBSTITUTION','PAD_CHAR_TO_FULL_LENGTH'), found type set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','NOT_USED','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_A
160509 12:38:01 [ERROR] Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.
160509 12:38:01 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1146: Table 'mysql.gtid_slave_pos' doesn't exist
160509 12:38:01 [Warning] Neither --relay-log nor --relay-log-index were used; so replication may break when this MySQL server acts as a slave and has his hostname changed!! Please use '--log-basename=#' or '--relay-log=mysql-relay-bin' to avoid this problem.
160509 12:38:01 [Note] Started replication for '160420 14:08:50 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
'
160509 12:38:01 [ERROR] Master '160420 14:08:50 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
': Slave I/O: Unable to load replication GTID slave state from mysql.gtid_slave_pos: Table 'mysql.gtid_slave_pos' doesn't exist, Internal MariaDB error code: 1146
160509 12:38:01 [Note] Master '160420 14:08:50 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
': Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.\mysql-relay-bin-160420@002014@003a08@003a50@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.000001' position: 4
160509 12:38:01 [ERROR] Master '160420 14:08:50 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
': Slave I/O: Fatal error: Invalid (empty) username when attempting to connect to the master server. Connection attempt terminated. Internal MariaDB error code: 1593
160509 12:38:01 [ERROR] Master '160420 14:08:50 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
': Slave SQL: Unable to load replication GTID slave state from mysql.gtid_slave_pos: Table 'mysql.gtid_slave_pos' doesn't exist, Internal MariaDB error code: 1146
160509 12:38:01 [Note] Master '160420 14:08:50 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
': Slave I/O thread killed while connecting to master
160509 12:38:01 [Note] Master '160420 14:08:50 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
': Slave I/O thread exiting, read up to log 'FIRST', position 4
160509 12:38:01 [Note] Started replication for 'Version: '10.0.17-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
'
160509 12:38:01 [ERROR] Master 'Version: '10.0.17-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
': Slave I/O: Unable to load replication GTID slave state from mysql.gtid_slave_pos: Table 'mysql.gtid_slave_pos' doesn't exist, Internal MariaDB error code: 1146
160509 12:38:01 [Note] Master 'Version: '10.0.17-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
': Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.\mysql-relay-bin-version@003a@0020@002710@002e0@002e17@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.000001' position: 4
160509 12:38:01 [ERROR] mysqld.exe: File 'C:\xampp\mysql\data\master-2016@002d04@002d20@002014@003a09@003a06@00207d70@0020innodb@003a@0020error@003a@0020column@0020last_update@0020in@0020table@0020@0022mysql@0022@002e@0022innodb_table_stats@0022@0020is@0020binary@00284@0029@0020not@0020null@0020but@0020should@0020be@0020int@0020not@0020null@0020@0028type@0020mismatch@0029@002e@000d.info' not found (Errcode: 2 "No such file or directory")
160509 12:38:01 [ERROR] Master 'Version: '10.0.17-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
': Slave I/O: Fatal error: Invalid (empty) username when attempting to connect to the master server. Connection attempt terminated. Internal MariaDB error code: 1593
160509 12:38:01 [ERROR] Master 'Version: '10.0.17-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
': Slave SQL: Unable to load replication GTID slave state from mysql.gtid_slave_pos: Table 'mysql.gtid_slave_pos' doesn't exist, Internal MariaDB error code: 1146
160509 12:38:01 [ERROR] Failed to create a new master info file (file 'C:\xampp\mysql\data\master-2016@002d04@002d20@002014@003a09@003a06@00207d70@0020innodb@003a@0020error@003a@0020column@0020last_update@0020in@0020table@0020@0022mysql@0022@002e@0022innodb_table_stats@0022@0020is@0020binary@00284@0029@0020not@0020null@0020but@0020should@0020be@0020int@0020not@0020null@0020@0028type@0020mismatch@0029@002e@000d.info', errno 2)
160509 12:38:01 [Note] Master 'Version: '10.0.17-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
': Slave I/O thread killed while connecting to master
160509 12:38:01 [ERROR] Initialized Master_info from 'master-2016@002d04@002d20@002014@003a09@003a06@00207d70@0020innodb@003a@0020error@003a@0020column@0020last_update@0020in@0020table@0020@0022mysql@0022@002e@0022innodb_table_stats@0022@0020is@0020binary@00284@0029@0020not@0020null@0020but@0020should@0020be@0020int@0020not@0020null@0020@0028type@0020mismatch@0029@002e@000d.info' failed
160509 12:38:01 [Note] Master 'Version: '10.0.17-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
': Slave I/O thread exiting, read up to log 'FIRST', position 4
160509 12:38:01 [ERROR] mysqld.exe: File 'C:\xampp\mysql\data\master-2016@002d04@002d20@002014@003a09@003a06@00207d70@0020innodb@003a@0020error@003a@0020fetch@0020of@0020persistent@0020statistics@0020requested@0020for@0020table@0020@0022wordpress@0022@002e@0022wp_options@0022@0020but@0020the@0020required@0020system@0020tables@0020mysql@002einnodb_table_stats@0020and@0020mysql@002einnod.info' not found (Errcode: 2 "No such file or directory")
160509 12:38:01 [ERROR] Failed to create a new master info file (file 'C:\xampp\mysql\data\master-2016@002d04@002d20@002014@003a09@003a06@00207d70@0020innodb@003a@0020error@003a@0020fetch@0020of@0020persistent@0020statistics@0020requested@0020for@0020table@0020@0022wordpress@0022@002e@0022wp_options@0022@0020but@0020the@0020required@0020system@0020tables@0020mysql@002einnodb_table_stats@0020and@0020mysql@002einnod.info', errno 2)
160509 12:38:01 [ERROR] Initialized Master_info from 'master-2016@002d04@002d20@002014@003a09@003a06@00207d70@0020innodb@003a@0020error@003a@0020fetch@0020of@0020persistent@0020statistics@0020requested@0020for@0020table@0020@0022wordpress@0022@002e@0022wp_options@0022@0020but@0020the@0020required@0020system@0020tables@0020mysql@002einnodb_table_stats@0020and@0020mysql@002einnod.info' failed
160509 12:38:01 [ERROR] mysqld.exe: File 'C:\xampp\mysql\data\master-2016@002d04@002d20@002014@003a09@003a06@00207d70@0020innodb@003a@0020error@003a@0020column@0020last_update@0020in@0020table@0020@0022mysql@0022@002e@0022innodb_table_stats@0022@0020is@0020binary@00284@0029@0020not@0020null@0020but@0020should@0020be@0020int@0020not@0020null@0020@0028type@0020mismatch@0029@002e@000d.info' not found (Errcode: 2 "No such file or directory")
160509 12:38:01 [ERROR] Failed to create a new master info file (file 'C:\xampp\mysql\data\master-2016@002d04@002d20@002014@003a09@003a06@00207d70@0020innodb@003a@0020error@003a@0020column@0020last_update@0020in@0020table@0020@0022mysql@0022@002e@0022innodb_table_stats@0022@0020is@0020binary@00284@0029@0020not@0020null@0020but@0020should@0020be@0020int@0020not@0020null@0020@0028type@0020mismatch@0029@002e@000d.info', errno 2)
160509 12:38:01 [ERROR] Initialized Master_info from 'master-2016@002d04@002d20@002014@003a09@003a06@00207d70@0020innodb@003a@0020error@003a@0020column@0020last_update@0020in@0020table@0020@0022mysql@0022@002e@0022innodb_table_stats@0022@0020is@0020binary@00284@0029@0020not@0020null@0020but@0020should@0020be@0020int@0020not@0020null@0020@0028type@0020mismatch@0029@002e@000d.info' failed



Hope you guys can help me out.

Regards,


Davey
dDesign
 
Posts: 10
Joined: 09. May 2016 11:03
XAMPP version: v3.2.1
Operating System: Windows 10

Re: mysql won't launch (XAMPP v3.2.1)

Postby JJ_Tagy » 09. May 2016 17:20

dDesign wrote:I tried many things, like deleting the "ibdata1" file and restart XAMP - no effect

Why would you do that? Do you not like your database?

Based off your description, you already had stuff running and tried to start again resulting in ports in use message.
JJ_Tagy
 
Posts: 678
Joined: 30. January 2012 13:44
Operating System: Windows 10 Pro x64

Re: mysql won't launch (XAMPP v3.2.1)

Postby dDesign » 10. May 2016 07:41

So u mean i basicly removed my whole website by deleting that file? I hope not :( (i recovered the XAMPP folder from a backup created on 27th of April)
I tried to restart many times, even with a good pause of 10 minutes leaving it off. But still giving that error.
Do you know how to get rid of the "ports in use" message?


I was wrong about the version of my XAMPP btw, it's XAMPP Version: 5.6.14 instead of the title post: 3.2.1
dDesign
 
Posts: 10
Joined: 09. May 2016 11:03
XAMPP version: v3.2.1
Operating System: Windows 10

Re: mysql won't launch (XAMPP v3.2.1)

Postby JJ_Tagy » 10. May 2016 11:26

It's possible the database is now corrupt.

Overall, I think you are missing a bunch of information. The error log is only a piece of a puzzle. What processes are using your ports? Did you "upgrade" from a previous XAMPP or overwrite database from somewhere? What configurations did you change? It's is impossible to troubleshoot what is going on without enough information. That and you seem to have rushed into a bunch of "fixes" that didn't work for you.
JJ_Tagy
 
Posts: 678
Joined: 30. January 2012 13:44
Operating System: Windows 10 Pro x64

Re: mysql won't launch (XAMPP v3.2.1)

Postby dDesign » 10. May 2016 12:08

I use default ports (3306) for mysql and there are no further processes which run on this port. I started with a clean installation, installed wordpress and from then i started changing a theme, only added some plugins from the wordpress library, which where capable with my wordpress version. Further i didn't change anything. It went from working 100% properly to this annoying error. Like i mentioned before, i didn't touched my laptop since 2 weeks ago, untill yesterday. The last day i worked on it, i left it in sleep mode and opened it once or twice that day. So i litteraly didn't change anything on purpose. I've made a backup of my XAMPP folder (where my lost website is in) and installed XAMPP another time. If i switch my wordpress folder from htdocs to the clean version, there are no problems running Apache and mysql, but if i transfer the "DATA" folder from my backup, which located in the mysql folder, the error will pop up again, so it must be in the "DATA" folder i guess. I've done a recovery from 27th of April, but i guess since then the problem already showed up, because recovery doesn't seem to effect something. (whats pretty logic because i didnt change anything).

Yes, i rushed into a bunch of fixes, but if a fix doesn't seem to fix anything, i recover it back from 27th April.
Let me know if you need more information!

Thanks for the help and attention!
dDesign
 
Posts: 10
Joined: 09. May 2016 11:03
XAMPP version: v3.2.1
Operating System: Windows 10

Re: mysql won't launch (XAMPP v3.2.1)

Postby dDesign » 11. May 2016 11:54

bumb :oops:

After this i hope someone could help me out because i need to finish school these 2 upcomming months. :(
dDesign
 
Posts: 10
Joined: 09. May 2016 11:03
XAMPP version: v3.2.1
Operating System: Windows 10


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 51 guests