MYSQL broken

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

MYSQL broken

Postby tichy » 20. February 2019 16:08

Hallo,


I was just cxonfiguring local sendmail with google as told here, when the MYSQL DB stopped working:

https://stackoverflow.com/questions/15965376/how-to-configure-xampp-to-send-mail-from-localhost


I have no clue why it stopped working and how to fix this mess!

Thats my mysql_error.log

2019-02-20 16:11:25 2fb8 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.
2019-02-20 16:11:25 12216 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

2019-02-20 16:11:25 12216 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2019-02-20 16:11:25 12216 [Note] InnoDB: The InnoDB memory heap is disabled
2019-02-20 16:11:25 12216 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-02-20 16:11:25 12216 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2019-02-20 16:11:25 12216 [Note] InnoDB: Compressed tables use zlib 1.2.3
2019-02-20 16:11:25 12216 [Note] InnoDB: Using generic crc32 instructions
2019-02-20 16:11:25 12216 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2019-02-20 16:11:25 12216 [Note] InnoDB: Completed initialization of buffer pool
2019-02-20 16:11:25 12216 [Note] InnoDB: Highest supported file format is Barracuda.
2019-02-20 16:11:25 12216 [Note] InnoDB: The log sequence number 1835037 in ibdata file do not match the log sequence number 4779857 in the ib_logfiles!
2019-02-20 16:11:26 12216 [Note] InnoDB: Restoring possible half-written data pages from the doublewrite buffer...
2019-02-20 16:11:27 12216 [Note] InnoDB: 128 rollback segment(s) are active.
2019-02-20 16:11:27 12216 [Note] InnoDB: Waiting for purge to start
2019-02-20 16:11:27 12216 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.38-83.0 started; log sequence number 4779857
2019-02-20 16:11:27 11344 [Note] InnoDB: Dumping buffer pool(s) not yet started
2019-02-20 16:11:27 12216 [Note] Plugin 'FEEDBACK' is disabled.
2019-02-20 16:11:27 12216 [ERROR] Can't open shared library 'D:\Server\mysql\lib\plugin\ha_archive.so.dll' (errno: 2, Das angegebene Modul wurde nicht gefunden.

)
2019-02-20 16:11:27 12216 [ERROR] Can't open shared library 'D:\Server\mysql\lib\plugin\ha_blackhole.so.dll' (errno: 2, Das angegebene Modul wurde nicht gefunden.

)
2019-02-20 16:11:27 12216 [ERROR] Can't open shared library 'D:\Server\mysql\lib\plugin\ha_federated.so.dll' (errno: 2, Das angegebene Modul wurde nicht gefunden.

)
2019-02-20 16:11:27 12216 [ERROR] Plugin 'innodb' already installed
2019-02-20 16:11:27 12216 [Note] Server socket created on IP: '::'.
2019-02-20 16:11:27 12216 [ERROR] Fatal error: mysql.user table is damaged or in unsupported 3.20 format.


and that happens when I start mysql_start.bat

D:\Server>mysql_start
Diese Eingabeforderung nicht waehrend des Running beenden
Please dont close Window while MySQL is running
MySQL is trying to start
Please wait ...
MySQL is starting with mysql\bin\my.ini (console)
2019-02-20 16:06:31 12240 [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.
2019-02-20 16:06:31 12240 [Note] mysql\bin\mysqld (mysqld 10.1.32-MariaDB) starting as process 10972 ...

MySQL konnte nicht gestartet werden
MySQL could not be started
Drücken Sie eine beliebige Taste . . .


Hmpppfff.... I dont get it! :(
tichy
 
Posts: 7
Joined: 30. October 2007 11:49

Re: MYSQL broken

Postby tichy » 22. February 2019 12:17

OK... I found out excactly WHEN it stops working.

I import an .sql file .... it works fine, runs and everything is well.
but when I now stop the Database and want restart it again, it wont work anymore.

So inside the .sql is something I import, that prevents the MYSQL from being started again.

Any Idea what this could be?
tichy
 
Posts: 7
Joined: 30. October 2007 11:49

Re: MYSQL broken

Postby Altrea » 22. February 2019 13:28

What exactly is inside this sql file?
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 9564
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Re: MYSQL broken

Postby tichy » 22. February 2019 13:43

Well. It is a file from a contractor... i cant post it here.

I try to describe:
its a DB with 20+ tables and lots of data. 5Mb+ filesize
But i observed that when I import the file the content of the RIGHTS tab change.
Its like inside the sql is not only the DB Data but also some rightsmanagment stuff.
It seems a User and some more stuff is imported too.

This could be relevant to this error message:
2019-02-20 16:11:27 12216 [ERROR] Fatal error: mysql.user table is damaged or in unsupported 3.20 format.
tichy
 
Posts: 7
Joined: 30. October 2007 11:49

Re: MYSQL broken

Postby tichy » 22. February 2019 14:02

OK i downloaded DBeaver and looked into the .sql file.

there is a lot of stuff like:
DROP TABLE IF EXISTS `procs_priv`;


and ... thats seems to have nothing todo with the data I want to import.
tichy
 
Posts: 7
Joined: 30. October 2007 11:49

Re: MYSQL broken

Postby Altrea » 22. February 2019 14:20

are there any statements in it relating the database mysql?
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 9564
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 63 guests