Apache Friends Support Forum

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!

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?

What exactly is inside this sql file?

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.

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.

are there any statements in it relating the database mysql?

Apache Friends Support Forum

MYSQL broken

MYSQL broken

Re: MYSQL broken

Re: MYSQL broken

Re: MYSQL broken

Re: MYSQL broken

Re: MYSQL broken