XAMPP MySQL is not bootable

Yesterday, in a variety of ways to test MySQL database backup and recovery operations, the recovery process, MySQL will not start.

Tips are as follows:

22:59:43  [MySQL]     attempting to start MySQL app ... 22:59:43  [MySQL]     status change detected:running22:59:44  [MySQL]     status change detected:stopped22 : 59:44  [MySQL]     error:mysql shutdown unexpectedly.22:59:44  [MySQL] This may     is due to a blocked port, MI ssing dependencies, 22:59:44  [MySQL]     improper privileges, a crash, or a shutdown by another method.22:59:44
    [mysql] Press the     Logs button to view error Logs and check22:59:44  [MySQL] the     Windows Event Viewer for M  Ore clues22:59:44  [MySQL]     If You need more help, copy and post this22:59:44  [MySQL]     entire log window On the Forums

This is due to a blocked port, missing dependencies, first I looked at the port and 3306 ports were not occupied.

See a workaround to run the batch file on the Web, but reboot required:

Http://wenku.baidu.com/link?url=fqqupfW1yxGYGtw3tGZe9HvzQxrSb2zQ3wiOJAi01ncikuFJAE1LJqQv0J97AocA-trfWz_ Wpajqfjdtxwtc4msahput3mjmchk3bgfwlga

I was x, just wrote a lot, the results after the submission of the display can not find the server,,, and then the drafts are not in the box, really all kinds of back

In short, all kinds of methods have been tried, can not be solved, finally can only re-unloading load solution.

The E:\xampp_new\mysql\data database has just replaced the file, after the replacement, MySQL will not start, and finally found that MySQL does not start because of the replacement of the data database file.

After removing ibdata1, ib_logfile1, and Ib_logfile0 multiple times, MySQL can start, and after the first deletion, it still does not start.

Through the operation found that the use of direct copy, paste database file method, the database is not feasible, will cause the database can not start, even if the subsequent deletion of log files, the database may be started, but also cannot browse the database table file.

Error log:

2014-11-25 23:57:55 4336 [Note] Plugin ' Federated ' is disabled.2014-11-25 23:57:55 2720 InnoDB:Warning:Using Innodb_addi Tional_mem_pool_size is DEPRECATED. This option is removed in future releases, together with the option Innodb_use_sys_malloc and with the InnoDB ' s intern Al memory allocator.2014-11-25 23:57:55 4336 [Note] innodb:using Atomics to ref count buffer pool pages2014-11-25 23:57:5 5 4336 [note] innodb:the InnoDB memory heap is disabled2014-11-25 23:57:55 4336 [note] innodb:mutexes and rw_locks use W indows Interlocked functions2014-11-25 23:57:55 4336 [Note] innodb:compressed tables use zlib 1.2.32014-11-25 23:57:55 43  [note] innodb:not using CPU crc32 instructions2014-11-25 23:57:55 4336 [note] innodb:initializing buffer pool, size = 16.0m2014-11-25 23:57:55 4336 [note] innodb:completed initialization of buffer pool2014-11-25 23:57:55 4336 [note] InnoD B:highest supported file format is barracuda.2014-11-25 23:57:55 4336 [Warning] innodb:resizing redo log froM 2*3072 to 2*320 pages, lsn=16259872014-11-25 23:57:55 4336 [Warning] innodb:starting to delete and rewrite log files.20 14-11-25 23:57:55 4336 [note] innodb:setting log file E:\xampp_new\mysql\data\ib_logfile101 size to 5 mb2014-11-25 23:57: 4336 [note] innodb:setting log file E:\xampp_new\mysql\data\ib_logfile1 size to 5 mb2014-11-25 23:57:56 4336 [note] in Nodb:renaming log file E:\xampp_new\mysql\data\ib_logfile101 to E:\xampp_new\mysql\data\ib_logfile02014-11-25 23:57:56 4336 [Warning] innodb:new log files created, lsn=16259872014-11-25 23:57:56 4336 [Note] innodb:128 rollback SEG ment (s) is active.2014-11-25 23:57:56 4336 [note] innodb:waiting for purge to start2014-11-25 23:57:56 4336 [note] Innod B:5.6.16 started; Log sequence number 16259872014-11-25 23:57:56 4336 [Warning] No existing UUID have been found, so we assume it is T He first time the this server has been started. Generating a new uuid:d2275b21-74bb-11e4-8165-74d435fb4eb2.2014-11-25 23:57:56 4336 [notE] Server hostname (bind-address): ' * '; port:33062014-11-25 23:57:56 4336 [note] IPv6 is available.2014-11-25 23:57:56 4336 [note]-':: ' resolves to ':: '; 2014 -11-25 23:57:56 4336 [Note] Server socket created on IP: ':: '.

XAMPP MySQL is not bootable