Search found 1065 matches: InnoDB

Searched query: +InnoDB

Return to advanced search

phpmyadmin shows blank window after changing password

I have xampp (v 5.3.6) installed in windows 8.

Apache:ports:- 444,8081 Mysql:ports:-3306.

I changed the phpmyadin password through http://localhost:8081/security/index.php.

So now my username is :root and password is :qwerty

PhpMyAdmin authentification:cookie (saved in (File: E:\Xamp\security\security\mysqlrootpasswd.txt)).

XAMPP DIRECTORY PROTECTION (.htaccess)

username:balram password:qwerty File: E:\Xamp\security\security\xamppdirpasswd.txt)

But now I cannot access Phpmyadmin as it shows a blank screen.

following is the config.inc.php values:

Code: Select all
/* Authentication type and info */
$cfg['Servers'][$i]['auth_type']     = 'cookie';
// Authentication method (config, http or cookie based)
// Authentication method (config, http or cookie based)
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'qwerty';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['AllowNoPassword'] = true;
$cfg['Lang'] = '';




ERROR LOGS

Code: Select all
APACHE: [Tue Mar 31 22:01:07.006981 2015] [mpm_winnt:notice] [pid 4356:tid 324] AH00364: Child: All worker threads have exited.

[Tue Mar 31 22:01:07.059012 2015] [mpm_winnt:notice] [pid 6780:tid 436]           AH00430: Parent: Child process 4356 exited successfully.

[Tue Mar 31 22:01:10.891319 2015] [ssl:warn] [pid 6860:tid 436] AH01909: www.example.com:443:0 server certificate does NOT include an ID which matches the server name
[Tue Mar 31 22:01:11.368110 2015] [ssl:warn] [pid 6860:tid 436] AH01909: www.example.com:443:0 server certificate does NOT include an ID which matches the server name
[Tue Mar 31 22:01:11.471185 2015] [mpm_winnt:notice] [pid 6860:tid 436] AH00455: Apache/2.4.10 (Win32) OpenSSL/1.0.1i PHP/5.6.3 configured -- resuming normal operations
[Tue Mar 31 22:01:11.471185 2015] [mpm_winnt:notice] [pid 6860:tid 436] AH00456: Apache Lounge VC11 Server built: Jul 17 2014 11:50:08
[Tue Mar 31 22:01:11.471185 2015] [core:notice] [pid 6860:tid 436] AH00094: Command line: 'E:\\xamp\\apache\\bin\\httpd.exe -d E:/Xamp/apache'
[Tue Mar 31 22:01:11.475158 2015] [mpm_winnt:notice] [pid 6860:tid 436] AH00418: Parent: Created child process 2184
[Tue Mar 31 22:01:12.882847 2015] [ssl:warn] [pid 2184:tid 332] AH01909: www.example.com:443:0 server certificate does NOT include an ID which matches the server name
[Tue Mar 31 22:01:13.380254 2015] [ssl:warn] [pid 2184:tid 332] AH01909: www.example.com:443:0 server certificate does NOT include an ID which matches the server name
[Tue Mar 31 22:01:13.486309 2015] [mpm_winnt:notice] [pid 2184:tid 332] AH00354: Child: Starting 150 worker threads.



MYSQL ERROR LOG:

Code: Select all
2015-03-31 22:01:12 1344 [Note] Plugin 'FEDERATED' is disabled.
2015-03-31 22:01:12 9c8 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.
2015-03-31 22:01:12 1344 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-03-31 22:01:12 1344 [Note] InnoDB: The InnoDB memory heap is disabled
2015-03-31 22:01:12 1344 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-03-31 22:01:12 1344 [Note] InnoDB: Memory barrier is not used
2015-03-31 22:01:12 1344 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-03-31 22:01:12 1344 [Note] InnoDB: Not using CPU crc32 instructions
2015-03-31 22:01:12 1344 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2015-03-31 22:01:12 1344 [Note] InnoDB: Completed initialization of buffer pool
2015-03-31 22:01:12 1344 [Note] InnoDB: Highest supported file format is Barracuda.
2015-03-31 22:01:13 1344 [Note] InnoDB: 128 rollback segment(s) are active.
2015-03-31 22:01:13 1344 [Note] InnoDB: Waiting for purge to start
2015-03-31 22:01:13 1344 [Note] InnoDB: 5.6.21 started; log sequence number 1743245
2015-03-31 22:01:13 1344 [Note] Server hostname (bind-address): '*'; port: 3306
2015-03-31 22:01:13 1344 [Note] IPv6 is available.
2015-03-31 22:01:13 1344 [Note]   - '::' resolves to '::';
2015-03-31 22:01:13 1344 [Note] Server socket created on IP: '::'.
2015-03-31 22:01:13 1344 [Note] Event Scheduler: Loaded 0 events
2015-03-31 22:01:13 1344 [Note] E:\xamp\mysql\bin\mysqld.exe: ready for   connections.
Version: '5.6.21'  socket: ''  port: 3306  MySQL Community Server (GPL)


I tried manipulating php.config.inc.php but to no avail. steps given on websites didn't solve my problem

thanks in advance,
balram
by balram
01. April 2015 16:41
 
Forum: XAMPP for Windows
Topic: phpmyadmin shows blank window after changing password
Replies: 0
Views: 276

MySQL startet nicht mehr seit Xampp Update

Ich habe die neuste Version von Xampp gestern installiert und auch angepasst, wie immer. Alles lief, auch nach mehreren Neustarts. Heute morgen aber startet MySQL plötzlich nicht mehr. Habe schon rausgefunden, dass es wohl an 2 Datenbanken liegt. Aber die Datenbanken können nicht defekt sein, da sie im alten Xampp laufen.

Hier das Logfile:

Code: Select all
2015-03-26 12:29:03 2252 [Note] Plugin 'FEDERATED' is disabled.
2015-03-26 12:29:03 11a0 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.
2015-03-26 12:29:03 2252 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-03-26 12:29:03 2252 [Note] InnoDB: The InnoDB memory heap is disabled
2015-03-26 12:29:03 2252 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-03-26 12:29:03 2252 [Note] InnoDB: Memory barrier is not used
2015-03-26 12:29:03 2252 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-03-26 12:29:03 2252 [Note] InnoDB: Not using CPU crc32 instructions
2015-03-26 12:29:03 2252 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2015-03-26 12:29:03 2252 [Note] InnoDB: Completed initialization of buffer pool
2015-03-26 12:29:04 2252 [Note] InnoDB: Highest supported file format is Barracuda.
2015-03-26 12:29:04 2252 [Note] InnoDB: The log sequence numbers 1665234 and 1665234 in ibdata files do not match the log sequence number 1665598 in the ib_logfiles!
2015-03-26 12:29:04 2252 [Note] InnoDB: Database was not shutdown normally!
2015-03-26 12:29:04 2252 [Note] InnoDB: Starting crash recovery.
2015-03-26 12:29:04 2252 [Note] InnoDB: Reading tablespace information from the .ibd files...
2015-03-26 12:29:04 2252 [ERROR] InnoDB: Attempted to open a previously opened tablespace. Previous tablespace phpmyadmin/pma_usergroups uses space ID: 7 at filepath: .\phpmyadmin\pma_usergroups.ibd. Cannot open tablespace _pricats/daten which uses space ID: 7 at filepath: .\_pricats\daten.ibd
InnoDB: Error: could not open single-table tablespace file .\_pricats\daten.ibd
InnoDB: We do not continue the crash recovery, because the table may become
InnoDB: corrupt if we cannot apply the log records in the InnoDB log to it.
InnoDB: To fix the problem and start mysqld:
InnoDB: 1) If there is a permission problem in the file and mysqld cannot
InnoDB: open the file, you should modify the permissions.
InnoDB: 2) If the table is not needed, or you can restore it from a backup,
InnoDB: then you can remove the .ibd file, and InnoDB will do a normal
InnoDB: crash recovery and ignore that table.
InnoDB: 3) If the file system or the disk is broken, and you cannot remove
InnoDB: the .ibd file, you can set innodb_force_recovery > 0 in my.cnf
InnoDB: and force InnoDB to continue crash recovery here.


Wenn ich das aktuelle MySQL Verzeichnis umbenenne und das MySQL aus der alten Xampp installaion in die neue kopiere läuft MySQL wieder. Scheint also irgendwas an der neuen Version zu sein. Wäre echt super, wenn jemand anhand des Logfiles etwas finden würde.
Danke.
by x16
26. March 2015 12:34
 
Forum: MySQL
Topic: MySQL startet nicht mehr seit Xampp Update
Replies: 0
Views: 443

Re: Mysql Error

nixx1401 wrote:2015-03-23 09:13:12 6228 [ERROR] InnoDB: C:\xampp\mysql\data\ibdata1 can't be opened in read-write mode
2015-03-23 09:13:12 6228 [ERROR] InnoDB: The system tablespace must be writable!

Have you tried replacing your mysql->data folder / your mysql folder?
by mark.mcdonald
24. March 2015 14:54
 
Forum: XAMPP for Windows
Topic: Mysql Error
Replies: 3
Views: 383

Mysql Error

I am receiving the following erro when I attempt to start mysql

2015-03-23 09:13:12 6228 [Note] Plugin 'FEDERATED' is disabled.
2015-03-23 09:13:12 1858 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.
2015-03-23 09:13:12 6228 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-03-23 09:13:12 6228 [Note] InnoDB: The InnoDB memory heap is disabled
2015-03-23 09:13:12 6228 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-03-23 09:13:12 6228 [Note] InnoDB: Memory barrier is not used
2015-03-23 09:13:12 6228 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-03-23 09:13:12 6228 [Note] InnoDB: Not using CPU crc32 instructions
2015-03-23 09:13:12 6228 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2015-03-23 09:13:12 6228 [Note] InnoDB: Completed initialization of buffer pool
2015-03-23 09:13:12 6228 [ERROR] InnoDB: C:\xampp\mysql\data\ibdata1 can't be opened in read-write mode
2015-03-23 09:13:12 6228 [ERROR] InnoDB: The system tablespace must be writable!
2015-03-23 09:13:12 6228 [ERROR] Plugin 'InnoDB' init function returned error.
2015-03-23 09:13:12 6228 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2015-03-23 09:13:12 6228 [ERROR] Unknown/unsupported storage engine: InnoDB
2015-03-23 09:13:12 6228 [ERROR] Aborting

2015-03-23 09:13:12 6228 [Note] Binlog end
2015-03-23 09:13:12 6228 [Note] Shutting down plugin 'partition'
2015-03-23 09:13:12 6228 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2015-03-23 09:13:12 6228 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2015-03-23 09:13:12 6228 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2015-03-23 09:13:12 6228 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2015-03-23 09:13:12 6228 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2015-03-23 09:13:12 6228 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2015-03-23 09:13:12 6228 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2015-03-23 09:13:12 6228 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2015-03-23 09:13:12 6228 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2015-03-23 09:13:12 6228 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2015-03-23 09:13:12 6228 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2015-03-23 09:13:12 6228 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2015-03-23 09:13:12 6228 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2015-03-23 09:13:12 6228 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2015-03-23 09:13:12 6228 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2015-03-23 09:13:12 6228 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2015-03-23 09:13:12 6228 [Note] Shutting down plugin 'INNODB_METRICS'
2015-03-23 09:13:12 6228 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2015-03-23 09:13:12 6228 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2015-03-23 09:13:12 6228 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2015-03-23 09:13:12 6228 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2015-03-23 09:13:12 6228 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2015-03-23 09:13:12 6228 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2015-03-23 09:13:12 6228 [Note] Shutting down plugin 'INNODB_CMPMEM'
2015-03-23 09:13:12 6228 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2015-03-23 09:13:12 6228 [Note] Shutting down plugin 'INNODB_CMP'
2015-03-23 09:13:12 6228 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2015-03-23 09:13:12 6228 [Note] Shutting down plugin 'INNODB_LOCKS'
2015-03-23 09:13:12 6228 [Note] Shutting down plugin 'INNODB_TRX'
2015-03-23 09:13:12 6228 [Note] Shutting down plugin 'BLACKHOLE'
2015-03-23 09:13:12 6228 [Note] Shutting down plugin 'ARCHIVE'
2015-03-23 09:13:12 6228 [Note] Shutting down plugin 'MRG_MYISAM'
2015-03-23 09:13:12 6228 [Note] Shutting down plugin 'MyISAM'
2015-03-23 09:13:12 6228 [Note] Shutting down plugin 'MEMORY'
2015-03-23 09:13:12 6228 [Note] Shutting down plugin 'CSV'
2015-03-23 09:13:12 6228 [Note] Shutting down plugin 'sha256_password'
2015-03-23 09:13:12 6228 [Note] Shutting down plugin 'mysql_old_password'
2015-03-23 09:13:12 6228 [Note] Shutting down plugin 'mysql_native_password'
2015-03-23 09:13:12 6228 [Note] Shutting down plugin 'binlog'
2015-03-23 09:13:12 6228 [Note] c:\xampp\mysql\bin\mysqld.exe: Shutdown complete

Any ideas what i should do here.
by nixx1401
23. March 2015 14:27
 
Forum: XAMPP for Windows
Topic: Mysql Error
Replies: 3
Views: 383

Re: Error: MySQL shutdown unexpectedly.

If you can reproduce the "3306 is taken". Run Command Prompt -> Type in: NetStat -o
This will show you a list of services using that port associated with a PID.
Start Task Manager -> Go to Services Tab and search for the same PID and this is what is using that port.
Stop the service and make sure it is not set to start up automatically otherwise you will encounter this issue again.
This should allow you to start MySQL without issue.

Make sure the MySQL service is uninstalled first ->
Re-Download XAMPP and copy over any missing files. Make sure this file exists: "D:\xampp\mysql\data\ib_logfile1"
-2015-02-28 15:07:06 7676 [ERROR] InnoDB: Cannot create D:\xampp\mysql\data\ib_logfile1

Replace this file: D:\xampp\mysql\data\ibdata1
2015-02-28 15:07:22 6052 [ERROR] InnoDB: space header page consists of zero bytes in data file D:\xampp\mysql\data\ibdata1

I would suggest you download a fresh copy of xampp (same version) and replace the mysql folder to start fresh.
I would highly recommend downloading the latest version of XAMPP and getting a fresh start if there is not much developed.
by mark.mcdonald
13. March 2015 17:01
 
Forum: XAMPP for Windows
Topic: Error: MySQL shutdown unexpectedly.
Replies: 1
Views: 801

MySQL would not start

2015-03-09 00:31:48 3372 [Note] Plugin 'FEDERATED' is disabled.
2015-03-09 00:31:48 4290 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.
2015-03-09 00:31:48 3372 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-03-09 00:31:48 3372 [Note] InnoDB: The InnoDB memory heap is disabled
2015-03-09 00:31:48 3372 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-03-09 00:31:48 3372 [Note] InnoDB: Memory barrier is not used
2015-03-09 00:31:48 3372 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-03-09 00:31:48 3372 [Note] InnoDB: Not using CPU crc32 instructions
2015-03-09 00:31:48 3372 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2015-03-09 00:31:48 3372 [Note] InnoDB: Completed initialization of buffer pool
2015-03-09 00:31:49 3372 [Note] InnoDB: Highest supported file format is Barracuda.
2015-03-09 00:31:53 3372 [Note] InnoDB: 128 rollback segment(s) are active.
2015-03-09 00:31:53 3372 [Note] InnoDB: Waiting for purge to start
2015-03-09 00:31:53 3372 [Note] InnoDB: 5.6.21 started; log sequence number 1665234
2015-03-09 00:31:53 3372 [Note] Server hostname (bind-address): '*'; port: 3306
2015-03-09 00:31:53 3372 [Note] IPv6 is available.
2015-03-09 00:31:53 3372 [Note] - '::' resolves to '::';
2015-03-09 00:31:53 3372 [Note] Server socket created on IP: '::'.
2015-03-09 00:31:53 3372 [ERROR] Can't start server: Bind on TCP/IP port: No such file or directory
2015-03-09 00:31:53 3372 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2015-03-09 00:31:53 3372 [ERROR] Aborting
by shumon07
09. March 2015 05:50
 
Forum: XAMPP for Windows
Topic: MySQL would not start
Replies: 1
Views: 468

Re: Change htdoc and mysql dir

Thank you very much for your explanations!!
I've opened the my.cnf file and in the section "mysqld" I can't find "datadir". Where I can put the new wordpress address to load?

Below you can find the contents of my "my.cnf"

Thank you for your support!
:)

Code: Select all
# Example MySQL config file for medium systems.
#
# This is for a system with little memory (32M - 64M) where MySQL plays
# an important part, or systems up to 128M where MySQL is used together with
# other programs (such as a web server)
#
# You can copy this file to
# /etc/my.cnf to set global options,
# mysql-data-dir/my.cnf to set server-specific options (in this
# installation this directory is /Applications/XAMPP/xamppfiles/var/mysql) or
# ~/.my.cnf to set user-specific options.
#
# In this file, you can use all long options that a program supports.
# If you want to know which options a program supports, run the program
# with the "--help" option.

# The following options will be passed to all MySQL clients
[client]
#password   = your_password
port      = 3306
socket      = /Applications/XAMPP/xamppfiles/var/mysql/mysql.sock

# Here follows entries for some specific programs

# The MySQL server
[mysqld]
user = mysql
port=3306
socket      = /Applications/XAMPP/xamppfiles/var/mysql/mysql.sock
skip-external-locking
key_buffer = 16M
max_allowed_packet = 1M
table_open_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M

# Where do all the plugins live
plugin_dir = /Applications/XAMPP/xamppfiles/lib/mysql/plugin/

# Don't listen on a TCP/IP port at all. This can be a security enhancement,
# if all processes that need to connect to mysqld run on the same host.
# All interaction with mysqld must be made via Unix sockets or named pipes.
# Note that using this option without enabling named pipes on Windows
# (via the "enable-named-pipe" option) will render mysqld useless!
#
#skip-networking

# Replication Master Server (default)
# binary logging is required for replication
# log-bin deactivated by default since XAMPP 1.4.11
#log-bin=mysql-bin

# required unique id between 1 and 2^32 - 1
# defaults to 1 if master-host is not set
# but will not function as a master if omitted
server-id   = 1

# Replication Slave (comment out master section to use this)
#
# To configure this host as a replication slave, you can choose between
# two methods :
#
# 1) Use the CHANGE MASTER TO command (fully described in our manual) -
#    the syntax is:
#
#    CHANGE MASTER TO MASTER_HOST=<host>, MASTER_PORT=<port>,
#    MASTER_USER=<user>, MASTER_PASSWORD=<password> ;
#
#    where you replace <host>, <user>, <password> by quoted strings and
#    <port> by the master's port number (3306 by default).
#
#    Example:
#
#    CHANGE MASTER TO MASTER_HOST='125.564.12.1', MASTER_PORT=3306,
#    MASTER_USER='joe', MASTER_PASSWORD='secret';
#
# OR
#
# 2) Set the variables below. However, in case you choose this method, then
#    start replication for the first time (even unsuccessfully, for example
#    if you mistyped the password in master-password and the slave fails to
#    connect), the slave will create a master.info file, and any later
#    change in this file to the variables' values below will be ignored and
#    overridden by the content of the master.info file, unless you shutdown
#    the slave server, delete master.info and restart the slaver server.
#    For that reason, you may want to leave the lines below untouched
#    (commented) and instead use CHANGE MASTER TO (see above)
#
# required unique id between 2 and 2^32 - 1
# (and different from the master)
# defaults to 2 if master-host is set
# but will not function as a slave if omitted
#server-id       = 2
#
# The replication master for this slave - required
#master-host     =   <hostname>
#
# The username the slave will use for authentication when connecting
# to the master - required
#master-user     =   <username>
#
# The password the slave will authenticate with when connecting to
# the master - required
#master-password =   <password>
#
# The port the master is listening on.
# optional - defaults to 3306
#master-port     =  <port>
#
# binary logging - not required for slaves, but recommended
#log-bin=mysql-bin


# Point the following paths to different dedicated disks
tmpdir = /Applications/XAMPP/xamppfiles/temp/mysql
#log-update    = /path-to-dedicated-directory/hostname

# Uncomment the following if you are using BDB tables
#bdb_cache_size = 4M
#bdb_max_lock = 10000

# Comment the following if you are using InnoDB tables
#skip-innodb
innodb_data_home_dir = /Applications/XAMPP/xamppfiles/var/mysql/
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = /Applications/XAMPP/xamppfiles/var/mysql/
# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
innodb_buffer_pool_size = 16M
# Deprecated in 5.6
#innodb_additional_mem_pool_size = 2M
# Set .._log_file_size to 25 % of buffer pool size
innodb_log_file_size = 5M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates

[isamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M

[myisamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M

[mysqlhotcopy]
interactive-timeout

!include /Applications/XAMPP/xamppfiles/mysql/my.cnf                                                             
by dekino
05. March 2015 20:46
 
Forum: XAMPP for Mac OS X
Topic: Change htdoc and mysql dir
Replies: 9
Views: 1387

MySQL does not start

I downloaded XAMPP version 5.6.3 today and MySQL will not start. Everything else starts. I am using Windows 7. This is the error log:
2015-03-03 10:23:54 6232 [Note] Plugin 'FEDERATED' is disabled.
2015-03-03 10:23:54 954 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.
2015-03-03 10:23:54 6232 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-03-03 10:23:54 6232 [Note] InnoDB: The InnoDB memory heap is disabled
2015-03-03 10:23:54 6232 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-03-03 10:23:54 6232 [Note] InnoDB: Memory barrier is not used
2015-03-03 10:23:54 6232 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-03-03 10:23:54 6232 [Note] InnoDB: Not using CPU crc32 instructions
2015-03-03 10:23:54 6232 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2015-03-03 10:23:54 6232 [Note] InnoDB: Completed initialization of buffer pool
2015-03-03 10:23:54 6232 [Note] InnoDB: Highest supported file format is Barracuda.
2015-03-03 10:23:55 6232 [Note] InnoDB: 128 rollback segment(s) are active.
2015-03-03 10:23:55 6232 [Note] InnoDB: Waiting for purge to start
2015-03-03 10:23:55 6232 [Note] InnoDB: 5.6.21 started; log sequence number 1665234
2015-03-03 10:23:55 6232 [Note] Server hostname (bind-address): '*'; port: 3306
2015-03-03 10:23:55 6232 [Note] IPv6 is available.
2015-03-03 10:23:55 6232 [Note] - '::' resolves to '::';
2015-03-03 10:23:55 6232 [Note] Server socket created on IP: '::'.
2015-03-03 10:23:55 6232 [ERROR] Can't start server: Bind on TCP/IP port: No such file or directory
2015-03-03 10:23:55 6232 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2015-03-03 10:23:55 6232 [ERROR] Aborting

2015-03-03 10:23:55 6232 [Note] Binlog end
2015-03-03 10:23:55 6232 [Note] Shutting down plugin 'partition'
2015-03-03 10:23:55 6232 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2015-03-03 10:23:55 6232 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2015-03-03 10:23:55 6232 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2015-03-03 10:23:55 6232 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2015-03-03 10:23:55 6232 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2015-03-03 10:23:55 6232 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2015-03-03 10:23:55 6232 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2015-03-03 10:23:55 6232 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2015-03-03 10:23:55 6232 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2015-03-03 10:23:55 6232 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2015-03-03 10:23:55 6232 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2015-03-03 10:23:55 6232 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2015-03-03 10:23:55 6232 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2015-03-03 10:23:55 6232 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2015-03-03 10:23:55 6232 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2015-03-03 10:23:55 6232 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2015-03-03 10:23:55 6232 [Note] Shutting down plugin 'INNODB_METRICS'
2015-03-03 10:23:55 6232 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2015-03-03 10:23:55 6232 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2015-03-03 10:23:55 6232 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2015-03-03 10:23:55 6232 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2015-03-03 10:23:55 6232 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2015-03-03 10:23:55 6232 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2015-03-03 10:23:55 6232 [Note] Shutting down plugin 'INNODB_CMPMEM'
2015-03-03 10:23:55 6232 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2015-03-03 10:23:55 6232 [Note] Shutting down plugin 'INNODB_CMP'
2015-03-03 10:23:55 6232 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2015-03-03 10:23:55 6232 [Note] Shutting down plugin 'INNODB_LOCKS'
2015-03-03 10:23:55 6232 [Note] Shutting down plugin 'INNODB_TRX'
2015-03-03 10:23:55 6232 [Note] Shutting down plugin 'InnoDB'
2015-03-03 10:23:55 6232 [Note] InnoDB: FTS optimize thread exiting.
2015-03-03 10:23:55 6232 [Note] InnoDB: Starting shutdown...
2015-03-03 10:23:56 6232 [Note] InnoDB: Shutdown completed; log sequence number 1665244
2015-03-03 10:23:56 6232 [Note] Shutting down plugin 'BLACKHOLE'
2015-03-03 10:23:56 6232 [Note] Shutting down plugin 'ARCHIVE'
2015-03-03 10:23:56 6232 [Note] Shutting down plugin 'MRG_MYISAM'
2015-03-03 10:23:56 6232 [Note] Shutting down plugin 'MyISAM'
2015-03-03 10:23:56 6232 [Note] Shutting down plugin 'MEMORY'
2015-03-03 10:23:56 6232 [Note] Shutting down plugin 'CSV'
2015-03-03 10:23:56 6232 [Note] Shutting down plugin 'sha256_password'
2015-03-03 10:23:56 6232 [Note] Shutting down plugin 'mysql_old_password'
2015-03-03 10:23:56 6232 [Note] Shutting down plugin 'mysql_native_password'
2015-03-03 10:23:56 6232 [Note] Shutting down plugin 'binlog'
2015-03-03 10:23:56 6232 [Note] c:\xampp\mysql\bin\mysqld.exe: Shutdown complete

2015-03-03 10:26:10 8224 [Note] Plugin 'FEDERATED' is disabled.
2015-03-03 10:26:10 938 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.
2015-03-03 10:26:10 8224 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-03-03 10:26:10 8224 [Note] InnoDB: The InnoDB memory heap is disabled
2015-03-03 10:26:10 8224 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-03-03 10:26:10 8224 [Note] InnoDB: Memory barrier is not used
2015-03-03 10:26:10 8224 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-03-03 10:26:10 8224 [Note] InnoDB: Not using CPU crc32 instructions
2015-03-03 10:26:10 8224 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2015-03-03 10:26:10 8224 [Note] InnoDB: Completed initialization of buffer pool
2015-03-03 10:26:10 8224 [Note] InnoDB: Highest supported file format is Barracuda.
2015-03-03 10:26:11 8224 [Note] InnoDB: 128 rollback segment(s) are active.
2015-03-03 10:26:11 8224 [Note] InnoDB: Waiting for purge to start
2015-03-03 10:26:11 8224 [Note] InnoDB: 5.6.21 started; log sequence number 1665244
2015-03-03 10:26:11 8224 [Note] Server hostname (bind-address): '*'; port: 3306
2015-03-03 10:26:11 8224 [Note] IPv6 is available.
2015-03-03 10:26:11 8224 [Note] - '::' resolves to '::';
2015-03-03 10:26:11 8224 [Note] Server socket created on IP: '::'.
2015-03-03 10:26:11 8224 [ERROR] Can't start server: Bind on TCP/IP port: No such file or directory
2015-03-03 10:26:11 8224 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2015-03-03 10:26:11 8224 [ERROR] Aborting

2015-03-03 10:26:11 8224 [Note] Binlog end
2015-03-03 10:26:11 8224 [Note] Shutting down plugin 'partition'
2015-03-03 10:26:11 8224 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2015-03-03 10:26:11 8224 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2015-03-03 10:26:11 8224 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2015-03-03 10:26:11 8224 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2015-03-03 10:26:11 8224 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2015-03-03 10:26:11 8224 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2015-03-03 10:26:11 8224 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2015-03-03 10:26:11 8224 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2015-03-03 10:26:11 8224 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2015-03-03 10:26:11 8224 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2015-03-03 10:26:11 8224 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2015-03-03 10:26:11 8224 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2015-03-03 10:26:11 8224 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2015-03-03 10:26:11 8224 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2015-03-03 10:26:11 8224 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2015-03-03 10:26:11 8224 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2015-03-03 10:26:11 8224 [Note] Shutting down plugin 'INNODB_METRICS'
2015-03-03 10:26:11 8224 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2015-03-03 10:26:11 8224 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2015-03-03 10:26:11 8224 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2015-03-03 10:26:11 8224 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2015-03-03 10:26:11 8224 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2015-03-03 10:26:11 8224 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2015-03-03 10:26:11 8224 [Note] Shutting down plugin 'INNODB_CMPMEM'
2015-03-03 10:26:11 8224 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2015-03-03 10:26:11 8224 [Note] Shutting down plugin 'INNODB_CMP'
2015-03-03 10:26:11 8224 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2015-03-03 10:26:11 8224 [Note] Shutting down plugin 'INNODB_LOCKS'
2015-03-03 10:26:11 8224 [Note] Shutting down plugin 'INNODB_TRX'
2015-03-03 10:26:11 8224 [Note] Shutting down plugin 'InnoDB'
2015-03-03 10:26:11 8224 [Note] InnoDB: FTS optimize thread exiting.
2015-03-03 10:26:11 8224 [Note] InnoDB: Starting shutdown...
2015-03-03 10:26:12 8224 [Note] InnoDB: Shutdown completed; log sequence number 1665254
2015-03-03 10:26:12 8224 [Note] Shutting down plugin 'BLACKHOLE'
2015-03-03 10:26:12 8224 [Note] Shutting down plugin 'ARCHIVE'
2015-03-03 10:26:12 8224 [Note] Shutting down plugin 'MRG_MYISAM'
2015-03-03 10:26:12 8224 [Note] Shutting down plugin 'MyISAM'
2015-03-03 10:26:12 8224 [Note] Shutting down plugin 'MEMORY'
2015-03-03 10:26:12 8224 [Note] Shutting down plugin 'CSV'
2015-03-03 10:26:12 8224 [Note] Shutting down plugin 'sha256_password'
2015-03-03 10:26:12 8224 [Note] Shutting down plugin 'mysql_old_password'
2015-03-03 10:26:12 8224 [Note] Shutting down plugin 'mysql_native_password'
2015-03-03 10:26:12 8224 [Note] Shutting down plugin 'binlog'
2015-03-03 10:26:12 8224 [Note] c:\xampp\mysql\bin\mysqld.exe: Shutdown complete

2015-03-03 10:26:25 208 [Note] Plugin 'FEDERATED' is disabled.
2015-03-03 10:26:25 2248 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.
2015-03-03 10:26:25 208 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-03-03 10:26:25 208 [Note] InnoDB: The InnoDB memory heap is disabled
2015-03-03 10:26:25 208 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-03-03 10:26:25 208 [Note] InnoDB: Memory barrier is not used
2015-03-03 10:26:25 208 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-03-03 10:26:25 208 [Note] InnoDB: Not using CPU crc32 instructions
2015-03-03 10:26:25 208 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2015-03-03 10:26:25 208 [Note] InnoDB: Completed initialization of buffer pool
2015-03-03 10:26:25 208 [Note] InnoDB: Highest supported file format is Barracuda.
2015-03-03 10:26:25 208 [Note] InnoDB: 128 rollback segment(s) are active.
2015-03-03 10:26:25 208 [Note] InnoDB: Waiting for purge to start
2015-03-03 10:26:26 208 [Note] InnoDB: 5.6.21 started; log sequence number 1665254
2015-03-03 10:26:26 208 [Note] Server hostname (bind-address): '*'; port: 3306
2015-03-03 10:26:26 208 [Note] IPv6 is available.
2015-03-03 10:26:26 208 [Note] - '::' resolves to '::';
2015-03-03 10:26:26 208 [Note] Server socket created on IP: '::'.
2015-03-03 10:26:26 208 [ERROR] Can't start server: Bind on TCP/IP port: No such file or directory
2015-03-03 10:26:26 208 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2015-03-03 10:26:26 208 [ERROR] Aborting

2015-03-03 10:26:26 208 [Note] Binlog end
2015-03-03 10:26:26 208 [Note] Shutting down plugin 'partition'
2015-03-03 10:26:26 208 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2015-03-03 10:26:26 208 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2015-03-03 10:26:26 208 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2015-03-03 10:26:26 208 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2015-03-03 10:26:26 208 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2015-03-03 10:26:26 208 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2015-03-03 10:26:26 208 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2015-03-03 10:26:26 208 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2015-03-03 10:26:26 208 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2015-03-03 10:26:26 208 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2015-03-03 10:26:26 208 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2015-03-03 10:26:26 208 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2015-03-03 10:26:26 208 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2015-03-03 10:26:26 208 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2015-03-03 10:26:26 208 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2015-03-03 10:26:26 208 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2015-03-03 10:26:26 208 [Note] Shutting down plugin 'INNODB_METRICS'
2015-03-03 10:26:26 208 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2015-03-03 10:26:26 208 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2015-03-03 10:26:26 208 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2015-03-03 10:26:26 208 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2015-03-03 10:26:26 208 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2015-03-03 10:26:26 208 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2015-03-03 10:26:26 208 [Note] Shutting down plugin 'INNODB_CMPMEM'
2015-03-03 10:26:26 208 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2015-03-03 10:26:26 208 [Note] Shutting down plugin 'INNODB_CMP'
2015-03-03 10:26:26 208 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2015-03-03 10:26:26 208 [Note] Shutting down plugin 'INNODB_LOCKS'
2015-03-03 10:26:26 208 [Note] Shutting down plugin 'INNODB_TRX'
2015-03-03 10:26:26 208 [Note] Shutting down plugin 'InnoDB'
2015-03-03 10:26:26 208 [Note] InnoDB: FTS optimize thread exiting.
2015-03-03 10:26:26 208 [Note] InnoDB: Starting shutdown...
2015-03-03 10:26:27 208 [Note] InnoDB: Shutdown completed; log sequence number 1665264
2015-03-03 10:26:27 208 [Note] Shutting down plugin 'BLACKHOLE'
2015-03-03 10:26:27 208 [Note] Shutting down plugin 'ARCHIVE'
2015-03-03 10:26:27 208 [Note] Shutting down plugin 'MRG_MYISAM'
2015-03-03 10:26:27 208 [Note] Shutting down plugin 'MyISAM'
2015-03-03 10:26:27 208 [Note] Shutting down plugin 'MEMORY'
2015-03-03 10:26:27 208 [Note] Shutting down plugin 'CSV'
2015-03-03 10:26:27 208 [Note] Shutting down plugin 'sha256_password'
2015-03-03 10:26:27 208 [Note] Shutting down plugin 'mysql_old_password'
2015-03-03 10:26:27 208 [Note] Shutting down plugin 'mysql_native_password'
2015-03-03 10:26:27 208 [Note] Shutting down plugin 'binlog'
2015-03-03 10:26:27 208 [Note] c:\xampp\mysql\bin\mysqld.exe: Shutdown complete

2015-03-03 10:29:13 208 [Note] Plugin 'FEDERATED' is disabled.
2015-03-03 10:29:13 1878 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.
2015-03-03 10:29:13 208 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-03-03 10:29:13 208 [Note] InnoDB: The InnoDB memory heap is disabled
2015-03-03 10:29:13 208 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-03-03 10:29:13 208 [Note] InnoDB: Memory barrier is not used
2015-03-03 10:29:13 208 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-03-03 10:29:13 208 [Note] InnoDB: Not using CPU crc32 instructions
2015-03-03 10:29:13 208 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2015-03-03 10:29:13 208 [Note] InnoDB: Completed initialization of buffer pool
2015-03-03 10:29:13 208 [Note] InnoDB: Highest supported file format is Barracuda.
2015-03-03 10:29:14 208 [Note] InnoDB: 128 rollback segment(s) are active.
2015-03-03 10:29:14 208 [Note] InnoDB: Waiting for purge to start
2015-03-03 10:29:14 208 [Note] InnoDB: 5.6.21 started; log sequence number 1665264
2015-03-03 10:29:14 208 [Note] Server hostname (bind-address): '*'; port: 3306
2015-03-03 10:29:14 208 [Note] IPv6 is available.
2015-03-03 10:29:14 208 [Note] - '::' resolves to '::';
2015-03-03 10:29:14 208 [Note] Server socket created on IP: '::'.
2015-03-03 10:29:14 208 [ERROR] Can't start server: Bind on TCP/IP port: No such file or directory
2015-03-03 10:29:14 208 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2015-03-03 10:29:14 208 [ERROR] Aborting

2015-03-03 10:29:14 208 [Note] Binlog end
2015-03-03 10:29:14 208 [Note] Shutting down plugin 'partition'
2015-03-03 10:29:14 208 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2015-03-03 10:29:14 208 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2015-03-03 10:29:14 208 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2015-03-03 10:29:14 208 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2015-03-03 10:29:14 208 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2015-03-03 10:29:14 208 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2015-03-03 10:29:14 208 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2015-03-03 10:29:14 208 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2015-03-03 10:29:14 208 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2015-03-03 10:29:14 208 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2015-03-03 10:29:14 208 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2015-03-03 10:29:14 208 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2015-03-03 10:29:14 208 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2015-03-03 10:29:14 208 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2015-03-03 10:29:14 208 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2015-03-03 10:29:14 208 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2015-03-03 10:29:14 208 [Note] Shutting down plugin 'INNODB_METRICS'
2015-03-03 10:29:14 208 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2015-03-03 10:29:14 208 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2015-03-03 10:29:14 208 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2015-03-03 10:29:14 208 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2015-03-03 10:29:14 208 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2015-03-03 10:29:14 208 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2015-03-03 10:29:14 208 [Note] Shutting down plugin 'INNODB_CMPMEM'
2015-03-03 10:29:14 208 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2015-03-03 10:29:14 208 [Note] Shutting down plugin 'INNODB_CMP'
2015-03-03 10:29:14 208 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2015-03-03 10:29:14 208 [Note] Shutting down plugin 'INNODB_LOCKS'
2015-03-03 10:29:14 208 [Note] Shutting down plugin 'INNODB_TRX'
2015-03-03 10:29:14 208 [Note] Shutting down plugin 'InnoDB'
2015-03-03 10:29:14 208 [Note] InnoDB: FTS optimize thread exiting.
2015-03-03 10:29:14 208 [Note] InnoDB: Starting shutdown...
2015-03-03 10:29:15 208 [Note] InnoDB: Shutdown completed; log sequence number 1665274
2015-03-03 10:29:15 208 [Note] Shutting down plugin 'BLACKHOLE'
2015-03-03 10:29:15 208 [Note] Shutting down plugin 'ARCHIVE'
2015-03-03 10:29:15 208 [Note] Shutting down plugin 'MRG_MYISAM'
2015-03-03 10:29:15 208 [Note] Shutting down plugin 'MyISAM'
2015-03-03 10:29:15 208 [Note] Shutting down plugin 'MEMORY'
2015-03-03 10:29:15 208 [Note] Shutting down plugin 'CSV'
2015-03-03 10:29:15 208 [Note] Shutting down plugin 'sha256_password'
2015-03-03 10:29:15 208 [Note] Shutting down plugin 'mysql_old_password'
2015-03-03 10:29:15 208 [Note] Shutting down plugin 'mysql_native_password'
2015-03-03 10:29:15 208 [Note] Shutting down plugin 'binlog'
2015-03-03 10:29:15 208 [Note] c:\xampp\mysql\bin\mysqld.exe: Shutdown complete

2015-03-03 10:30:13 8928 [Note] Plugin 'FEDERATED' is disabled.
2015-03-03 10:30:13 498 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.
2015-03-03 10:30:13 8928 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-03-03 10:30:13 8928 [Note] InnoDB: The InnoDB memory heap is disabled
2015-03-03 10:30:13 8928 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-03-03 10:30:13 8928 [Note] InnoDB: Memory barrier is not used
2015-03-03 10:30:13 8928 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-03-03 10:30:13 8928 [Note] InnoDB: Not using CPU crc32 instructions
2015-03-03 10:30:13 8928 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2015-03-03 10:30:13 8928 [Note] InnoDB: Completed initialization of buffer pool
2015-03-03 10:30:13 8928 [Note] InnoDB: Highest supported file format is Barracuda.
2015-03-03 10:30:14 8928 [Note] InnoDB: 128 rollback segment(s) are active.
2015-03-03 10:30:14 8928 [Note] InnoDB: Waiting for purge to start
2015-03-03 10:30:14 8928 [Note] InnoDB: 5.6.21 started; log sequence number 1665274
2015-03-03 10:30:14 8928 [Note] Server hostname (bind-address): '*'; port: 3306
2015-03-03 10:30:14 8928 [Note] IPv6 is available.
2015-03-03 10:30:14 8928 [Note] - '::' resolves to '::';
2015-03-03 10:30:14 8928 [Note] Server socket created on IP: '::'.
2015-03-03 10:30:14 8928 [ERROR] Can't start server: Bind on TCP/IP port: No such file or directory
2015-03-03 10:30:14 8928 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2015-03-03 10:30:14 8928 [ERROR] Aborting

2015-03-03 10:30:14 8928 [Note] Binlog end
2015-03-03 10:30:14 8928 [Note] Shutting down plugin 'partition'
2015-03-03 10:30:14 8928 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2015-03-03 10:30:14 8928 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2015-03-03 10:30:14 8928 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2015-03-03 10:30:14 8928 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2015-03-03 10:30:14 8928 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2015-03-03 10:30:14 8928 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2015-03-03 10:30:14 8928 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2015-03-03 10:30:14 8928 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2015-03-03 10:30:14 8928 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2015-03-03 10:30:14 8928 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2015-03-03 10:30:14 8928 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2015-03-03 10:30:14 8928 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2015-03-03 10:30:14 8928 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2015-03-03 10:30:14 8928 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2015-03-03 10:30:14 8928 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2015-03-03 10:30:14 8928 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2015-03-03 10:30:14 8928 [Note] Shutting down plugin 'INNODB_METRICS'
2015-03-03 10:30:14 8928 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2015-03-03 10:30:14 8928 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2015-03-03 10:30:14 8928 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2015-03-03 10:30:14 8928 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2015-03-03 10:30:14 8928 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2015-03-03 10:30:14 8928 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2015-03-03 10:30:14 8928 [Note] Shutting down plugin 'INNODB_CMPMEM'
2015-03-03 10:30:14 8928 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2015-03-03 10:30:14 8928 [Note] Shutting down plugin 'INNODB_CMP'
2015-03-03 10:30:14 8928 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2015-03-03 10:30:14 8928 [Note] Shutting down plugin 'INNODB_LOCKS'
2015-03-03 10:30:14 8928 [Note] Shutting down plugin 'INNODB_TRX'
2015-03-03 10:30:14 8928 [Note] Shutting down plugin 'InnoDB'
2015-03-03 10:30:14 8928 [Note] InnoDB: FTS optimize thread exiting.
2015-03-03 10:30:14 8928 [Note] InnoDB: Starting shutdown...
2015-03-03 10:30:15 8928 [Note] InnoDB: Shutdown completed; log sequence number 1665284
2015-03-03 10:30:15 8928 [Note] Shutting down plugin 'BLACKHOLE'
2015-03-03 10:30:15 8928 [Note] Shutting down plugin 'ARCHIVE'
2015-03-03 10:30:15 8928 [Note] Shutting down plugin 'MRG_MYISAM'
2015-03-03 10:30:15 8928 [Note] Shutting down plugin 'MyISAM'
2015-03-03 10:30:15 8928 [Note] Shutting down plugin 'MEMORY'
2015-03-03 10:30:15 8928 [Note] Shutting down plugin 'CSV'
2015-03-03 10:30:15 8928 [Note] Shutting down plugin 'sha256_password'
2015-03-03 10:30:15 8928 [Note] Shutting down plugin 'mysql_old_password'
2015-03-03 10:30:15 8928 [Note] Shutting down plugin 'mysql_native_password'
2015-03-03 10:30:15 8928 [Note] Shutting down plugin 'binlog'
2015-03-03 10:30:15 8928 [Note] c:\xampp\mysql\bin\mysqld.exe: Shutdown complete

2015-03-03 10:37:45 5524 [Note] Plugin 'FEDERATED' is disabled.
2015-03-03 10:37:45 1620 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.
2015-03-03 10:37:45 5524 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-03-03 10:37:45 5524 [Note] InnoDB: The InnoDB memory heap is disabled
2015-03-03 10:37:45 5524 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-03-03 10:37:45 5524 [Note] InnoDB: Memory barrier is not used
2015-03-03 10:37:45 5524 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-03-03 10:37:45 5524 [Note] InnoDB: Not using CPU crc32 instructions
2015-03-03 10:37:46 5524 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2015-03-03 10:37:46 5524 [Note] InnoDB: Completed initialization of buffer pool
2015-03-03 10:37:48 5524 [Note] InnoDB: Highest supported file format is Barracuda.
2015-03-03 10:37:50 5524 [Note] InnoDB: 128 rollback segment(s) are active.
2015-03-03 10:37:51 5524 [Note] InnoDB: Waiting for purge to start
2015-03-03 10:37:51 5524 [Note] InnoDB: 5.6.21 started; log sequence number 1665284
2015-03-03 10:37:51 5524 [Note] Server hostname (bind-address): '*'; port: 3306
2015-03-03 10:37:51 5524 [Note] IPv6 is available.
2015-03-03 10:37:51 5524 [Note] - '::' resolves to '::';
2015-03-03 10:37:51 5524 [Note] Server socket created on IP: '::'.
2015-03-03 10:37:51 5524 [ERROR] Can't start server: Bind on TCP/IP port: No such file or directory
2015-03-03 10:37:51 5524 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2015-03-03 10:37:51 5524 [ERROR] Aborting

2015-03-03 10:37:51 5524 [Note] Binlog end
2015-03-03 10:37:51 5524 [Note] Shutting down plugin 'partition'
2015-03-03 10:37:51 5524 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2015-03-03 10:37:51 5524 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2015-03-03 10:37:51 5524 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2015-03-03 10:37:51 5524 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2015-03-03 10:37:51 5524 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2015-03-03 10:37:51 5524 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2015-03-03 10:37:51 5524 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2015-03-03 10:37:51 5524 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2015-03-03 10:37:51 5524 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2015-03-03 10:37:51 5524 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2015-03-03 10:37:51 5524 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2015-03-03 10:37:51 5524 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2015-03-03 10:37:51 5524 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2015-03-03 10:37:51 5524 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2015-03-03 10:37:51 5524 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2015-03-03 10:37:51 5524 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2015-03-03 10:37:51 5524 [Note] Shutting down plugin 'INNODB_METRICS'
2015-03-03 10:37:51 5524 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2015-03-03 10:37:51 5524 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2015-03-03 10:37:51 5524 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2015-03-03 10:37:51 5524 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2015-03-03 10:37:51 5524 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2015-03-03 10:37:51 5524 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2015-03-03 10:37:51 5524 [Note] Shutting down plugin 'INNODB_CMPMEM'
2015-03-03 10:37:51 5524 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2015-03-03 10:37:51 5524 [Note] Shutting down plugin 'INNODB_CMP'
2015-03-03 10:37:51 5524 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2015-03-03 10:37:51 5524 [Note] Shutting down plugin 'INNODB_LOCKS'
2015-03-03 10:37:51 5524 [Note] Shutting down plugin 'INNODB_TRX'
2015-03-03 10:37:51 5524 [Note] Shutting down plugin 'InnoDB'
2015-03-03 10:37:51 5524 [Note] InnoDB: FTS optimize thread exiting.
2015-03-03 10:37:51 5524 [Note] InnoDB: Starting shutdown...
2015-03-03 10:37:52 5524 [Note] InnoDB: Shutdown completed; log sequence number 1665294
2015-03-03 10:37:52 5524 [Note] Shutting down plugin 'BLACKHOLE'
2015-03-03 10:37:52 5524 [Note] Shutting down plugin 'ARCHIVE'
2015-03-03 10:37:52 5524 [Note] Shutting down plugin 'MRG_MYISAM'
2015-03-03 10:37:52 5524 [Note] Shutting down plugin 'MyISAM'
2015-03-03 10:37:52 5524 [Note] Shutting down plugin 'MEMORY'
2015-03-03 10:37:52 5524 [Note] Shutting down plugin 'CSV'
2015-03-03 10:37:52 5524 [Note] Shutting down plugin 'sha256_password'
2015-03-03 10:37:52 5524 [Note] Shutting down plugin 'mysql_old_password'
2015-03-03 10:37:52 5524 [Note] Shutting down plugin 'mysql_native_password'
2015-03-03 10:37:52 5524 [Note] Shutting down plugin 'binlog'
2015-03-03 10:37:52 5524 [Note] c:\xampp\mysql\bin\mysqld.exe: Shutdown complete

2015-03-03 10:38:05 7096 [Note] Plugin 'FEDERATED' is disabled.
2015-03-03 10:38:05 1bbc 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.
2015-03-03 10:38:05 7096 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-03-03 10:38:05 7096 [Note] InnoDB: The InnoDB memory heap is disabled
2015-03-03 10:38:05 7096 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-03-03 10:38:05 7096 [Note] InnoDB: Memory barrier is not used
2015-03-03 10:38:05 7096 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-03-03 10:38:05 7096 [Note] InnoDB: Not using CPU crc32 instructions
2015-03-03 10:38:05 7096 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2015-03-03 10:38:05 7096 [Note] InnoDB: Completed initialization of buffer pool
2015-03-03 10:38:05 7096 [Note] InnoDB: Highest supported file format is Barracuda.
2015-03-03 10:38:08 7096 [Note] InnoDB: 128 rollback segment(s) are active.
2015-03-03 10:38:08 7096 [Note] InnoDB: Waiting for purge to start
2015-03-03 10:38:08 7096 [Note] InnoDB: 5.6.21 started; log sequence number 1665294
2015-03-03 10:38:08 7096 [Note] Server hostname (bind-address): '*'; port: 3306
2015-03-03 10:38:08 7096 [Note] IPv6 is available.
2015-03-03 10:38:08 7096 [Note] - '::' resolves to '::';
2015-03-03 10:38:08 7096 [Note] Server socket created on IP: '::'.
2015-03-03 10:38:08 7096 [ERROR] Can't start server: Bind on TCP/IP port: No such file or directory
2015-03-03 10:38:08 7096 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2015-03-03 10:38:08 7096 [ERROR] Aborting

2015-03-03 10:38:08 7096 [Note] Binlog end
2015-03-03 10:38:08 7096 [Note] Shutting down plugin 'partition'
2015-03-03 10:38:08 7096 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2015-03-03 10:38:08 7096 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2015-03-03 10:38:08 7096 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2015-03-03 10:38:08 7096 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2015-03-03 10:38:08 7096 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2015-03-03 10:38:08 7096 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2015-03-03 10:38:08 7096 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2015-03-03 10:38:08 7096 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2015-03-03 10:38:08 7096 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2015-03-03 10:38:08 7096 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2015-03-03 10:38:08 7096 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2015-03-03 10:38:08 7096 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2015-03-03 10:38:08 7096 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2015-03-03 10:38:08 7096 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2015-03-03 10:38:08 7096 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2015-03-03 10:38:08 7096 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2015-03-03 10:38:08 7096 [Note] Shutting down plugin 'INNODB_METRICS'
2015-03-03 10:38:08 7096 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2015-03-03 10:38:08 7096 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2015-03-03 10:38:08 7096 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2015-03-03 10:38:08 7096 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2015-03-03 10:38:08 7096 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2015-03-03 10:38:08 7096 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2015-03-03 10:38:08 7096 [Note] Shutting down plugin 'INNODB_CMPMEM'
2015-03-03 10:38:08 7096 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2015-03-03 10:38:08 7096 [Note] Shutting down plugin 'INNODB_CMP'
2015-03-03 10:38:08 7096 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2015-03-03 10:38:08 7096 [Note] Shutting down plugin 'INNODB_LOCKS'
2015-03-03 10:38:08 7096 [Note] Shutting down plugin 'INNODB_TRX'
2015-03-03 10:38:08 7096 [Note] Shutting down plugin 'InnoDB'
2015-03-03 10:38:08 7096 [Note] InnoDB: FTS optimize thread exiting.
2015-03-03 10:38:08 7096 [Note] InnoDB: Starting shutdown...
2015-03-03 10:38:10 7096 [Note] InnoDB: Shutdown completed; log sequence number 1665304
2015-03-03 10:38:10 7096 [Note] Shutting down plugin 'BLACKHOLE'
2015-03-03 10:38:10 7096 [Note] Shutting down plugin 'ARCHIVE'
2015-03-03 10:38:10 7096 [Note] Shutting down plugin 'MRG_MYISAM'
2015-03-03 10:38:10 7096 [Note] Shutting down plugin 'MyISAM'
2015-03-03 10:38:10 7096 [Note] Shutting down plugin 'MEMORY'
2015-03-03 10:38:10 7096 [Note] Shutting down plugin 'CSV'
2015-03-03 10:38:10 7096 [Note] Shutting down plugin 'sha256_password'
2015-03-03 10:38:10 7096 [Note] Shutting down plugin 'mysql_old_password'
2015-03-03 10:38:10 7096 [Note] Shutting down plugin 'mysql_native_password'
2015-03-03 10:38:10 7096 [Note] Shutting down plugin 'binlog'
2015-03-03 10:38:10 7096 [Note] c:\xampp\mysql\bin\mysqld.exe: Shutdown complete
by djx2KingGeorge
03. March 2015 22:42
 
Forum: MySQL
Topic: MySQL does not start
Replies: 1
Views: 366

Please / Error: MySQL shutdown unexpectedly

i need Help Please (Mysql Not Running) .. the XAMPP was running great till i Upgraded it to Version: 5.6.3 :cry: MYSQL Stopped Running

================ ERORR LOG=================
12:58:13 م [main] Initializing Control Panel
12:58:13 م [main] Windows Version: Windows 7 Ultimate 32-bit
12:58:13 م [main] XAMPP Version: 5.6.3
12:58:13 م [main] Control Panel Version: 3.2.1 [ Compiled: May 7th 2013 ]
12:58:13 م [main] Running with Administrator rights - good!
12:58:13 م [main] XAMPP Installation Directory: "c:\xampp\"
12:58:13 م [main] Checking for prerequisites
12:58:19 م [main] All prerequisites found
12:58:19 م [main] Initializing Modules
12:58:20 م [main] Starting Check-Timer
12:58:20 م [main] Control Panel Ready
12:58:41 م [Apache] Attempting to start Apache app...
12:58:41 م [Apache] Status change detected: running
12:58:44 م [mysql] Attempting to start MySQL app...
12:58:44 م [mysql] Status change detected: running
12:58:56 م [mysql] Status change detected: stopped
12:58:56 م [mysql] Error: MySQL shutdown unexpectedly.
12:58:56 م [mysql] This may be due to a blocked port, missing dependencies,
12:58:56 م [mysql] improper privileges, a crash, or a shutdown by another method.
12:58:56 م [mysql] Press the Logs button to view error logs and check
12:58:56 م [mysql] the Windows Event Viewer for more clues
12:58:56 م [mysql] If you need more help, copy and post this
12:58:56 م [mysql] entire log window on the forums

=================== mysql_error.log ===========================
2015-02-15 01:53:31 7864 [Note] Plugin 'FEDERATED' is disabled.
2015-02-15 01:53:31 19b4 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.
2015-02-15 01:53:31 7864 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-02-15 01:53:31 7864 [Note] InnoDB: The InnoDB memory heap is disabled
2015-02-15 01:53:31 7864 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-02-15 01:53:31 7864 [Note] InnoDB: Memory barrier is not used
2015-02-15 01:53:31 7864 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-02-15 01:53:31 7864 [Note] InnoDB: Not using CPU crc32 instructions
2015-02-15 01:53:31 7864 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2015-02-15 01:53:31 7864 [Note] InnoDB: Completed initialization of buffer pool
2015-02-15 01:53:31 7864 [Note] InnoDB: Highest supported file format is Barracuda.
2015-02-15 01:53:32 7864 [Note] InnoDB: 128 rollback segment(s) are active.
2015-02-15 01:53:32 7864 [Note] InnoDB: Waiting for purge to start
2015-02-15 01:53:32 7864 [Note] InnoDB: 5.6.21 started; log sequence number 1665234
2015-02-15 01:53:32 7864 [Note] Server hostname (bind-address): '*'; port: 3306
2015-02-15 01:53:32 7864 [Note] IPv6 is available.
2015-02-15 01:53:32 7864 [Note] - '::' resolves to '::';
2015-02-15 01:53:32 7864 [Note] Server socket created on IP: '::'.
2015-02-15 01:53:34 7864 [Note] Event Scheduler: Loaded 0 events
2015-02-15 01:53:34 7864 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '5.6.21' socket: '' port: 3306 MySQL Community Server (GPL)
2015-02-15 01:59:37 6936 [Note] Plugin 'FEDERATED' is disabled.
2015-02-15 01:59:37 1578 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.
2015-02-15 01:59:37 6936 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-02-15 01:59:37 6936 [Note] InnoDB: The InnoDB memory heap is disabled
2015-02-15 01:59:37 6936 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-02-15 01:59:37 6936 [Note] InnoDB: Memory barrier is not used
2015-02-15 01:59:37 6936 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-02-15 01:59:37 6936 [Note] InnoDB: Not using CPU crc32 instructions
2015-02-15 01:59:38 6936 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2015-02-15 01:59:38 6936 [Note] InnoDB: Completed initialization of buffer pool
2015-02-15 01:59:38 6936 [Note] InnoDB: Highest supported file format is Barracuda.
2015-02-15 01:59:38 6936 [Note] InnoDB: The log sequence numbers 1665234 and 1665234 in ibdata files do not match the log sequence number 1665244 in the ib_logfiles!
2015-02-15 01:59:38 6936 [Note] InnoDB: Database was not shutdown normally!
2015-02-15 01:59:38 6936 [Note] InnoDB: Starting crash recovery.
2015-02-15 01:59:38 6936 [Note] InnoDB: Reading tablespace information from the .ibd files...
2015-02-15 01:59:38 6936 [Note] InnoDB: Restoring possible half-written data pages
2015-02-15 01:59:38 6936 [Note] InnoDB: from the doublewrite buffer...
2015-02-15 01:59:39 6936 [Note] InnoDB: 128 rollback segment(s) are active.
2015-02-15 01:59:39 6936 [Note] InnoDB: Waiting for purge to start
2015-02-15 01:59:39 6936 [Note] InnoDB: 5.6.21 started; log sequence number 1665244
2015-02-15 01:59:39 6936 [Note] Server hostname (bind-address): '*'; port: 3306
2015-02-15 01:59:39 6936 [Note] IPv6 is available.
2015-02-15 01:59:39 6936 [Note] - '::' resolves to '::';
2015-02-15 01:59:39 6936 [Note] Server socket created on IP: '::'.
2015-02-15 01:59:39 6936 [Note] Event Scheduler: Loaded 0 events
2015-02-15 01:59:39 6936 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '5.6.21' socket: '' port: 3306 MySQL Community Server (GPL)
2015-02-15 05:13:59 6936 [Warning] InnoDB: Cannot open table allawag/o065q_assets from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2015-02-15 05:13:59 6936 [Warning] InnoDB: Cannot open table allawag/o065q_associations from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2015-02-15 05:13:59 6936 [Warning] InnoDB: Cannot open table allawag/o065q_banner_clients from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2015-02-15 05:13:59 6936 [Warning] InnoDB: Cannot open table allawag/o065q_banner_tracks from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2015-02-15 05:13:59 6936 [Warning] InnoDB: Cannot open table allawag/o065q_banners from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2015-02-15 05:13:59 6936 [Warning] InnoDB: Cannot open table allawag/o065q_categories from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2015-02-15 05:13:59 6936 [Warning] InnoDB: Cannot open table allawag/o065q_contact_details from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2015-02-15 05:13:59 6936 [Warning] InnoDB: Cannot open table allawag/o065q_content from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2015-02-15 05:13:59 6936 [Warning] InnoDB: Cannot open table allawag/o065q_content_frontpage from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2015-02-15 05:13:59 6936 [Warning] InnoDB: Cannot open table allawag/o065q_content_rating from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2015-02-15 05:13:59 6936 [Warning] InnoDB: Cannot open table allawag/o065q_content_types from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2015-02-15 05:13:59 6936 [Warning] InnoDB: Cannot open table allawag/o065q_contentitem_tag_map from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2015-02-15 05:13:59 6936 [Warning] InnoDB: Cannot open table allawag/o065q_core_log_searches from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2015-02-15 05:13:59 6936 [Warning] InnoDB: Cannot open table allawag/o065q_extensions from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2015-02-15 05:13:59 6936 [Warning] InnoDB: Cannot open table allawag/o065q_finder_filters from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2015-02-15 05:13:59 6936 [Warning] InnoDB: Cannot open table allawag/o065q_finder_links from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2015-02-15 05:13:59 6936 [Warning] InnoDB: Cannot open table allawag/o065q_finder_links_terms0 from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2015-02-15 05:13:59 6936 [Warning] InnoDB: Cannot open table allawag/o065q_finder_links_terms1 from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2015-02-15 05:13:59 6936 [Warning] InnoDB: Cannot open table allawag/o065q_finder_links_terms2 from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2015-02-15 05:13:59 6936 [Warning] InnoDB: Cannot open table allawag/o065q_finder_links_terms3 from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2015-02-15 05:13:59 6936 [Warning] InnoDB: Cannot open table allawag/yu3lk_ak_profiles from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2015-02-15 05:13:59 6936 [Warning] InnoDB: Cannot open table allawag/yu3lk_ak_stats from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2015-02-15 05:13:59 6936 [Warning] InnoDB: Cannot open table allawag/yu3lk_ak_storage from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2015-02-15 05:13:59 6936 [Warning] InnoDB: Cannot open table allawag/yu3lk_contentitem_tag_map from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2015-02-15 05:13:59 6936 [Warning] InnoDB: Cannot open table allawag/yu3lk_jcklanguages from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2015-02-15 05:13:59 6936 [Warning] InnoDB: Cannot open table allawag/yu3lk_jckplugins from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2015-02-15 05:14:00 6936 [Warning] InnoDB: Cannot open table allawag/yu3lk_jcktoolbarplugins from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2015-02-15 05:14:00 6936 [Warning] InnoDB: Cannot open table allawag/yu3lk_jcktoolbars from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2015-02-15 05:14:00 6936 [Warning] InnoDB: Cannot open table allawag/yu3lk_postinstall_messages from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2015-02-15 05:14:00 6936 [Warning] InnoDB: Cannot open table allawag/yu3lk_rokgallery_file_loves from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2015-02-15 05:14:00 6936 [Warning] InnoDB: Cannot open table allawag/yu3lk_rokgallery_file_tags from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2015-02-15 05:14:00 6936 [Warning] InnoDB: Cannot open table allawag/yu3lk_rokgallery_file_views from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2015-02-15 05:14:00 6936 [Warning] InnoDB: Cannot open table allawag/yu3lk_rokgallery_files from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2015-02-15 05:14:00 6936 [Warning] InnoDB: Cannot open table allawag/yu3lk_rokgallery_files_index from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2015-02-15 05:14:00 6936 [Warning] InnoDB: Cannot open table allawag/yu3lk_rokgallery_filters from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2015-02-15 05:14:00 6936 [Warning] InnoDB: Cannot open table allawag/yu3lk_rokgallery_galleries from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2015-02-15 05:14:00 6936 [Warning] InnoDB: Cannot open table allawag/yu3lk_rokgallery_jobs from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2015-02-15 05:14:00 6936 [Warning] InnoDB: Cannot open table allawag/yu3lk_rokgallery_profiles from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2015-02-15 05:14:00 6936 [Warning] InnoDB: Cannot open table allawag/yu3lk_rokgallery_schema_version from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2015-02-15 05:14:00 6936 [Warning] InnoDB: Cannot open table allawag/yu3lk_rokgallery_slice_tags from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2015-02-15 05:14:00 6936 [Warning] InnoDB: Cannot open table allawag/yu3lk_rokgallery_slices from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2015-02-15 05:14:00 6936 [Warning] InnoDB: Cannot open table allawag/yu3lk_rokgallery_slices_index from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2015-02-15 05:14:00 6936 [Warning] InnoDB: Cannot open table allawag/yu3lk_tags from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2015-02-15 05:14:00 6936 [Warning] InnoDB: Cannot open table allawag/yu3lk_ucm_content from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2015-02-15 05:14:00 6936 [Warning] InnoDB: Cannot open table allawag/yu3lk_ucm_history from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2015-02-15 05:14:00 6936 [Warning] InnoDB: Cannot open table allawag/yu3lk_update_sites_extensions from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2015-02-15 05:14:00 6936 [Warning] InnoDB: Cannot open table allawag/yu3lk_user_keys from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2015-02-15 05:42:40 9472 [Note] Plugin 'FEDERATED' is disabled.
2015-02-15 05:42:40 1d2c 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.
2015-02-15 05:42:40 9472 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-02-15 05:42:40 9472 [Note] InnoDB: The InnoDB memory heap is disabled
2015-02-15 05:42:40 9472 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-02-15 05:42:40 9472 [Note] InnoDB: Memory barrier is not used
2015-02-15 05:42:40 9472 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-02-15 05:42:40 9472 [Note] InnoDB: Not using CPU crc32 instructions
2015-02-15 05:42:40 9472 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2015-02-15 05:42:40 9472 [Note] InnoDB: Completed initialization of buffer pool
2015-02-15 05:42:40 9472 [Note] InnoDB: Highest supported file format is Barracuda.
2015-02-15 05:42:41 9472 [Note] InnoDB: The log sequence numbers 1665234 and 1665234 in ibdata files do not match the log sequence number 1665254 in the ib_logfiles!
2015-02-15 05:42:41 9472 [Note] InnoDB: Database was not shutdown normally!
2015-02-15 05:42:41 9472 [Note] InnoDB: Starting crash recovery.
2015-02-15 05:42:41 9472 [Note] InnoDB: Reading tablespace information from the .ibd files...
2015-02-15 05:42:41 9472 [ERROR] InnoDB: Attempted to open a previously opened tablespace. Previous tablespace allawag/o065q_content_types uses space ID: 240 at filepath: .\allawag\o065q_content_types.ibd. Cannot open tablespace allawag/yu3lk_content_types which uses space ID: 240 at filepath: .\allawag\yu3lk_content_types.ibd
InnoDB: Error: could not open single-table tablespace file .\allawag\yu3lk_content_types.ibd
InnoDB: We do not continue the crash recovery, because the table may become
InnoDB: corrupt if we cannot apply the log records in the InnoDB log to it.
InnoDB: To fix the problem and start mysqld:
InnoDB: 1) If there is a permission problem in the file and mysqld cannot
InnoDB: open the file, you should modify the permissions.
InnoDB: 2) If the table is not needed, or you can restore it from a backup,
InnoDB: then you can remove the .ibd file, and InnoDB will do a normal
InnoDB: crash recovery and ignore that table.
InnoDB: 3) If the file system or the disk is broken, and you cannot remove
InnoDB: the .ibd file, you can set innodb_force_recovery > 0 in my.cnf
InnoDB: and force InnoDB to continue crash recovery here.
2015-02-15 05:44:21 5624 [Note] Plugin 'FEDERATED' is disabled.
2015-02-15 05:44:21 1990 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.
2015-02-15 05:44:21 5624 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-02-15 05:44:21 5624 [Note] InnoDB: The InnoDB memory heap is disabled
2015-02-15 05:44:21 5624 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-02-15 05:44:21 5624 [Note] InnoDB: Memory barrier is not used
2015-02-15 05:44:21 5624 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-02-15 05:44:21 5624 [Note] InnoDB: Not using CPU crc32 instructions
2015-02-15 05:44:21 5624 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2015-02-15 05:44:21 5624 [Note] InnoDB: Completed initialization of buffer pool
2015-02-15 05:44:21 5624 [Note] InnoDB: Highest supported file format is Barracuda.
2015-02-15 05:44:21 5624 [Note] InnoDB: The log sequence numbers 1665234 and 1665234 in ibdata files do not match the log sequence number 1665254 in the ib_logfiles!
2015-02-15 05:44:21 5624 [Note] InnoDB: Database was not shutdown normally!
2015-02-15 05:44:21 5624 [Note] InnoDB: Starting crash recovery.
2015-02-15 05:44:21 5624 [Note] InnoDB: Reading tablespace information from the .ibd files...
2015-02-15 05:44:21 5624 [ERROR] InnoDB: Attempted to open a previously opened tablespace. Previous tablespace allawag/o065q_content_types uses space ID: 240 at filepath: .\allawag\o065q_content_types.ibd. Cannot open tablespace allawag/yu3lk_content_types which uses space ID: 240 at filepath: .\allawag\yu3lk_content_types.ibd
InnoDB: Error: could not open single-table tablespace file .\allawag\yu3lk_content_types.ibd
InnoDB: We do not continue the crash recovery, because the table may become
InnoDB: corrupt if we cannot apply the log records in the InnoDB log to it.
InnoDB: To fix the problem and start mysqld:
InnoDB: 1) If there is a permission problem in the file and mysqld cannot
InnoDB: open the file, you should modify the permissions.
InnoDB: 2) If the table is not needed, or you can restore it from a backup,
InnoDB: then you can remove the .ibd file, and InnoDB will do a normal
InnoDB: crash recovery and ignore that table.
InnoDB: 3) If the file system or the disk is broken, and you cannot remove
InnoDB: the .ibd file, you can set innodb_force_recovery > 0 in my.cnf
InnoDB: and force InnoDB to continue crash recovery here.
2015-02-15 05:49:42 7056 [Note] Plugin 'FEDERATED' is disabled.
2015-02-15 05:49:42 1dc8 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.
2015-02-15 05:49:42 7056 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-02-15 05:49:42 7056 [Note] InnoDB: The InnoDB memory heap is disabled
2015-02-15 05:49:42 7056 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-02-15 05:49:42 7056 [Note] InnoDB: Memory barrier is not used
2015-02-15 05:49:42 7056 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-02-15 05:49:42 7056 [Note] InnoDB: Not using CPU crc32 instructions
2015-02-15 05:49:42 7056 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2015-02-15 05:49:42 7056 [Note] InnoDB: Completed initialization of buffer pool
2015-02-15 05:49:42 7056 [Note] InnoDB: Highest supported file format is Barracuda.
2015-02-15 05:49:42 7056 [Note] InnoDB: The log sequence numbers 1665234 and 1665234 in ibdata files do not match the log sequence number 1665254 in the ib_logfiles!
2015-02-15 05:49:42 7056 [Note] InnoDB: Database was not shutdown normally!
2015-02-15 05:49:42 7056 [Note] InnoDB: Starting crash recovery.
2015-02-15 05:49:42 7056 [Note] InnoDB: Reading tablespace information from the .ibd files...
2015-02-15 05:49:42 7056 [ERROR] InnoDB: Attempted to open a previously opened tablespace. Previous tablespace allawag/o065q_content_types uses space ID: 240 at filepath: .\allawag\o065q_content_types.ibd. Cannot open tablespace allawag/yu3lk_content_types which uses space ID: 240 at filepath: .\allawag\yu3lk_content_types.ibd
InnoDB: Error: could not open single-table tablespace file .\allawag\yu3lk_content_types.ibd
InnoDB: We do not continue the crash recovery, because the table may become
InnoDB: corrupt if we cannot apply the log records in the InnoDB log to it.
InnoDB: To fix the problem and start mysqld:
InnoDB: 1) If there is a permission problem in the file and mysqld cannot
InnoDB: open the file, you should modify the permissions.
InnoDB: 2) If the table is not needed, or you can restore it from a backup,
InnoDB: then you can remove the .ibd file, and InnoDB will do a normal
InnoDB: crash recovery and ignore that table.
InnoDB: 3) If the file system or the disk is broken, and you cannot remove
InnoDB: the .ibd file, you can set innodb_force_recovery > 0 in my.cnf
InnoDB: and force InnoDB to continue crash recovery here.
2015-02-19 07:58:41 7632 [Note] Plugin 'FEDERATED' is disabled.
2015-02-19 07:58:42 1dcc 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.
2015-02-19 07:58:42 7632 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-02-19 07:58:42 7632 [Note] InnoDB: The InnoDB memory heap is disabled
2015-02-19 07:58:42 7632 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-02-19 07:58:42 7632 [Note] InnoDB: Memory barrier is not used
2015-02-19 07:58:42 7632 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-02-19 07:58:42 7632 [Note] InnoDB: Not using CPU crc32 instructions
2015-02-19 07:58:42 7632 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2015-02-19 07:58:42 7632 [Note] InnoDB: Completed initialization of buffer pool
2015-02-19 07:58:43 7632 [Note] InnoDB: Highest supported file format is Barracuda.
2015-02-19 07:58:43 7632 [Note] InnoDB: The log sequence numbers 1665234 and 1665234 in ibdata files do not match the log sequence number 1665254 in the ib_logfiles!
2015-02-19 07:58:43 7632 [Note] InnoDB: Database was not shutdown normally!
2015-02-19 07:58:43 7632 [Note] InnoDB: Starting crash recovery.
2015-02-19 07:58:43 7632 [Note] InnoDB: Reading tablespace information from the .ibd files...
2015-02-19 07:58:44 7632 [ERROR] InnoDB: Attempted to open a previously opened tablespace. Previous tablespace allawag/o065q_content_types uses space ID: 240 at filepath: .\allawag\o065q_content_types.ibd. Cannot open tablespace allawag/yu3lk_content_types which uses space ID: 240 at filepath: .\allawag\yu3lk_content_types.ibd
InnoDB: Error: could not open single-table tablespace file .\allawag\yu3lk_content_types.ibd
InnoDB: We do not continue the crash recovery, because the table may become
InnoDB: corrupt if we cannot apply the log records in the InnoDB log to it.
InnoDB: To fix the problem and start mysqld:
InnoDB: 1) If there is a permission problem in the file and mysqld cannot
InnoDB: open the file, you should modify the permissions.
InnoDB: 2) If the table is not needed, or you can restore it from a backup,
InnoDB: then you can remove the .ibd file, and InnoDB will do a normal
InnoDB: crash recovery and ignore that table.
InnoDB: 3) If the file system or the disk is broken, and you cannot remove
InnoDB: the .ibd file, you can set innodb_force_recovery > 0 in my.cnf
InnoDB: and force InnoDB to continue crash recovery here.
2015-02-19 08:11:37 6568 [Note] Plugin 'FEDERATED' is disabled.
2015-02-19 08:11:37 1ad0 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.
2015-02-19 08:11:37 6568 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-02-19 08:11:37 6568 [Note] InnoDB: The InnoDB memory heap is disabled
2015-02-19 08:11:37 6568 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-02-19 08:11:37 6568 [Note] InnoDB: Memory barrier is not used
2015-02-19 08:11:37 6568 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-02-19 08:11:37 6568 [Note] InnoDB: Not using CPU crc32 instructions
2015-02-19 08:11:37 6568 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2015-02-19 08:11:37 6568 [Note] InnoDB: Completed initialization of buffer pool
2015-02-19 08:11:37 6568 [Note] InnoDB: Highest supported file format is Barracuda.
2015-02-19 08:11:37 6568 [Note] InnoDB: The log sequence numbers 1665234 and 1665234 in ibdata files do not match the log sequence number 1665254 in the ib_logfiles!
2015-02-19 08:11:37 6568 [Note] InnoDB: Database was not shutdown normally!
2015-02-19 08:11:37 6568 [Note] InnoDB: Starting crash recovery.
2015-02-19 08:11:37 6568 [Note] InnoDB: Reading tablespace information from the .ibd files...
2015-02-19 08:11:37 6568 [ERROR] InnoDB: Attempted to open a previously opened tablespace. Previous tablespace allawag/o065q_content_types uses space ID: 240 at filepath: .\allawag\o065q_content_types.ibd. Cannot open tablespace allawag/yu3lk_content_types which uses space ID: 240 at filepath: .\allawag\yu3lk_content_types.ibd
InnoDB: Error: could not open single-table tablespace file .\allawag\yu3lk_content_types.ibd
InnoDB: We do not continue the crash recovery, because the table may become
InnoDB: corrupt if we cannot apply the log records in the InnoDB log to it.
InnoDB: To fix the problem and start mysqld:
InnoDB: 1) If there is a permission problem in the file and mysqld cannot
InnoDB: open the file, you should modify the permissions.
InnoDB: 2) If the table is not needed, or you can restore it from a backup,
InnoDB: then you can remove the .ibd file, and InnoDB will do a normal
InnoDB: crash recovery and ignore that table.
InnoDB: 3) If the file system or the disk is broken, and you cannot remove
InnoDB: the .ibd file, you can set innodb_force_recovery > 0 in my.cnf
InnoDB: and force InnoDB to continue crash recovery here.
2015-02-19 08:12:51 7232 [Note] Plugin 'FEDERATED' is disabled.
2015-02-19 08:12:51 d9c 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.
2015-02-19 08:12:51 7232 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-02-19 08:12:51 7232 [Note] InnoDB: The InnoDB memory heap is disabled
2015-02-19 08:12:51 7232 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-02-19 08:12:51 7232 [Note] InnoDB: Memory barrier is not used
2015-02-19 08:12:51 7232 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-02-19 08:12:51 7232 [Note] InnoDB: Not using CPU crc32 instructions
2015-02-19 08:12:51 7232 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2015-02-19 08:12:51 7232 [Note] InnoDB: Completed initialization of buffer pool
2015-02-19 08:12:51 7232 [Note] InnoDB: Highest supported file format is Barracuda.
2015-02-19 08:12:51 7232 [Note] InnoDB: The log sequence numbers 1665234 and 1665234 in ibdata files do not match the log sequence number 1665254 in the ib_logfiles!
2015-02-19 08:12:51 7232 [Note] InnoDB: Database was not shutdown normally!
2015-02-19 08:12:51 7232 [Note] InnoDB: Starting crash recovery.
2015-02-19 08:12:51 7232 [Note] InnoDB: Reading tablespace information from the .ibd files...
2015-02-19 08:12:51 7232 [ERROR] InnoDB: Attempted to open a previously opened tablespace. Previous tablespace allawag/o065q_content_types uses space ID: 240 at filepath: .\allawag\o065q_content_types.ibd. Cannot open tablespace allawag/yu3lk_content_types which uses space ID: 240 at filepath: .\allawag\yu3lk_content_types.ibd
InnoDB: Error: could not open single-table tablespace file .\allawag\yu3lk_content_types.ibd
InnoDB: We do not continue the crash recovery, because the table may become
InnoDB: corrupt if we cannot apply the log records in the InnoDB log to it.
InnoDB: To fix the problem and start mysqld:
InnoDB: 1) If there is a permission problem in the file and mysqld cannot
InnoDB: open the file, you should modify the permissions.
InnoDB: 2) If the table is not needed, or you can restore it from a backup,
InnoDB: then you can remove the .ibd file, and InnoDB will do a normal
InnoDB: crash recovery and ignore that table.
InnoDB: 3) If the file system or the disk is broken, and you cannot remove
InnoDB: the .ibd file, you can set innodb_force_recovery > 0 in my.cnf
InnoDB: and force InnoDB to continue crash recovery here.
2015-02-19 08:15:54 6096 [Note] Plugin 'FEDERATED' is disabled.
2015-02-19 08:15:54 1130 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.
2015-02-19 08:15:54 6096 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-02-19 08:15:54 6096 [Note] InnoDB: The InnoDB memory heap is disabled
2015-02-19 08:15:54 6096 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-02-19 08:15:54 6096 [Note] InnoDB: Memory barrier is not used
2015-02-19 08:15:54 6096 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-02-19 08:15:54 6096 [Note] InnoDB: Not using CPU crc32 instructions
2015-02-19 08:15:54 6096 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2015-02-19 08:15:54 6096 [Note] InnoDB: Completed initialization of buffer pool
2015-02-19 08:15:54 6096 [Note] InnoDB: Highest supported file format is Barracuda.
2015-02-19 08:15:54 6096 [Note] InnoDB: The log sequence numbers 1665234 and 1665234 in ibdata files do not match the log sequence number 1665254 in the ib_logfiles!
2015-02-19 08:15:54 6096 [Note] InnoDB: Database was not shutdown normally!
2015-02-19 08:15:54 6096 [Note] InnoDB: Starting crash recovery.
2015-02-19 08:15:54 6096 [Note] InnoDB: Reading tablespace information from the .ibd files...
2015-02-19 08:15:54 6096 [ERROR] InnoDB: Attempted to open a previously opened tablespace. Previous tablespace allawag/o065q_content_types uses space ID: 240 at filepath: .\allawag\o065q_content_types.ibd. Cannot open tablespace allawag/yu3lk_content_types which uses space ID: 240 at filepath: .\allawag\yu3lk_content_types.ibd
InnoDB: Error: could not open single-table tablespace file .\allawag\yu3lk_content_types.ibd
InnoDB: We do not continue the crash recovery, because the table may become
InnoDB: corrupt if we cannot apply the log records in the InnoDB log to it.
InnoDB: To fix the problem and start mysqld:
InnoDB: 1) If there is a permission problem in the file and mysqld cannot
InnoDB: open the file, you should modify the permissions.
InnoDB: 2) If the table is not needed, or you can restore it from a backup,
InnoDB: then you can remove the .ibd file, and InnoDB will do a normal
InnoDB: crash recovery and ignore that table.
InnoDB: 3) If the file system or the disk is broken, and you cannot remove
InnoDB: the .ibd file, you can set innodb_force_recovery > 0 in my.cnf
InnoDB: and force InnoDB to continue crash recovery here.
2015-02-19 08:20:34 5252 [Note] Plugin 'FEDERATED' is disabled.
2015-02-19 08:20:34 1c54 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.
2015-02-19 08:20:34 5252 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-02-19 08:20:34 5252 [Note] InnoDB: The InnoDB memory heap is disabled
2015-02-19 08:20:34 5252 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-02-19 08:20:34 5252 [Note] InnoDB: Memory barrier is not used
2015-02-19 08:20:34 5252 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-02-19 08:20:34 5252 [Note] InnoDB: Not using CPU crc32 instructions
2015-02-19 08:20:34 5252 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2015-02-19 08:20:34 5252 [Note] InnoDB: Completed initialization of buffer pool
2015-02-19 08:20:34 5252 [Note] InnoDB: Highest supported file format is Barracuda.
2015-02-19 08:20:34 5252 [Note] InnoDB: The log sequence numbers 1665234 and 1665234 in ibdata files do not match the log sequence number 1665254 in the ib_logfiles!
2015-02-19 08:20:34 5252 [Note] InnoDB: Database was not shutdown normally!
2015-02-19 08:20:34 5252 [Note] InnoDB: Starting crash recovery.
2015-02-19 08:20:34 5252 [Note] InnoDB: Reading tablespace information from the .ibd files...
2015-02-19 08:20:34 5252 [ERROR] InnoDB: Attempted to open a previously opened tablespace. Previous tablespace allawag/o065q_content_types uses space ID: 240 at filepath: .\allawag\o065q_content_types.ibd. Cannot open tablespace allawag/yu3lk_content_types which uses space ID: 240 at filepath: .\allawag\yu3lk_content_types.ibd
InnoDB: Error: could not open single-table tablespace file .\allawag\yu3lk_content_types.ibd
InnoDB: We do not continue the crash recovery, because the table may become
InnoDB: corrupt if we cannot apply the log records in the InnoDB log to it.
InnoDB: To fix the problem and start mysqld:
InnoDB: 1) If there is a permission problem in the file and mysqld cannot
InnoDB: open the file, you should modify the permissions.
InnoDB: 2) If the table is not needed, or you can restore it from a backup,
InnoDB: then you can remove the .ibd file, and InnoDB will do a normal
InnoDB: crash recovery and ignore that table.
InnoDB: 3) If the file system or the disk is broken, and you cannot remove
InnoDB: the .ibd file, you can set innodb_force_recovery > 0 in my.cnf
InnoDB: and force InnoDB to continue crash recovery here.
2015-02-19 08:22:51 2192 [Note] Plugin 'FEDERATED' is disabled.
2015-02-19 08:22:51 1334 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.
2015-02-19 08:22:51 2192 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-02-19 08:22:51 2192 [Note] InnoDB: The InnoDB memory heap is disabled
2015-02-19 08:22:51 2192 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-02-19 08:22:51 2192 [Note] InnoDB: Memory barrier is not used
2015-02-19 08:22:51 2192 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-02-19 08:22:51 2192 [Note] InnoDB: Not using CPU crc32 instructions
2015-02-19 08:22:51 2192 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2015-02-19 08:22:51 2192 [Note] InnoDB: Completed initialization of buffer pool
2015-02-19 08:22:51 2192 [Note] InnoDB: Highest supported file format is Barracuda.
2015-02-19 08:22:51 2192 [Note] InnoDB: The log sequence numbers 1665234 and 1665234 in ibdata files do not match the log sequence number 1665254 in the ib_logfiles!
2015-02-19 08:22:51 2192 [Note] InnoDB: Database was not shutdown normally!
2015-02-19 08:22:51 2192 [Note] InnoDB: Starting crash recovery.
2015-02-19 08:22:51 2192 [Note] InnoDB: Reading tablespace information from the .ibd files...
2015-02-19 08:22:51 2192 [ERROR] InnoDB: Attempted to open a previously opened tablespace. Previous tablespace allawag/o065q_content_types uses space ID: 240 at filepath: .\allawag\o065q_content_types.ibd. Cannot open tablespace allawag/yu3lk_content_types which uses space ID: 240 at filepath: .\allawag\yu3lk_content_types.ibd
InnoDB: Error: could not open single-table tablespace file .\allawag\yu3lk_content_types.ibd
InnoDB: We do not continue the crash recovery, because the table may become
InnoDB: corrupt if we cannot apply the log records in the InnoDB log to it.
InnoDB: To fix the problem and start mysqld:
InnoDB: 1) If there is a permission problem in the file and mysqld cannot
InnoDB: open the file, you should modify the permissions.
InnoDB: 2) If the table is not needed, or you can restore it from a backup,
InnoDB: then you can remove the .ibd file, and InnoDB will do a normal
InnoDB: crash recovery and ignore that table.
InnoDB: 3) If the file system or the disk is broken, and you cannot remove
InnoDB: the .ibd file, you can set innodb_force_recovery > 0 in my.cnf
InnoDB: and force InnoDB to continue crash recovery here.
2015-02-19 08:56:00 6952 [Note] Plugin 'FEDERATED' is disabled.
2015-02-19 08:56:00 151c 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.
2015-02-19 08:56:00 6952 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-02-19 08:56:00 6952 [Note] InnoDB: The InnoDB memory heap is disabled
2015-02-19 08:56:00 6952 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-02-19 08:56:00 6952 [Note] InnoDB: Memory barrier is not used
2015-02-19 08:56:00 6952 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-02-19 08:56:00 6952 [Note] InnoDB: Not using CPU crc32 instructions
2015-02-19 08:56:01 6952 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2015-02-19 08:56:01 6952 [Note] InnoDB: Completed initialization of buffer pool
2015-02-19 08:56:01 6952 [Note] InnoDB: Highest supported file format is Barracuda.
2015-02-19 08:56:01 6952 [Note] InnoDB: The log sequence numbers 1665234 and 1665234 in ibdata files do not match the log sequence number 1665254 in the ib_logfiles!
2015-02-19 08:56:01 6952 [Note] InnoDB: Database was not shutdown normally!
2015-02-19 08:56:01 6952 [Note] InnoDB: Starting crash recovery.
2015-02-19 08:56:01 6952 [Note] InnoDB: Reading tablespace information from the .ibd files...
2015-02-19 08:56:01 6952 [ERROR] InnoDB: Attempted to open a previously opened tablespace. Previous tablespace allawag/o065q_content_types uses space ID: 240 at filepath: .\allawag\o065q_content_types.ibd. Cannot open tablespace allawag/yu3lk_content_types which uses space ID: 240 at filepath: .\allawag\yu3lk_content_types.ibd
InnoDB: Error: could not open single-table tablespace file .\allawag\yu3lk_content_types.ibd
InnoDB: We do not continue the crash recovery, because the table may become
InnoDB: corrupt if we cannot apply the log records in the InnoDB log to it.
InnoDB: To fix the problem and start mysqld:
InnoDB: 1) If there is a permission problem in the file and mysqld cannot
InnoDB: open the file, you should modify the permissions.
InnoDB: 2) If the table is not needed, or you can restore it from a backup,
InnoDB: then you can remove the .ibd file, and InnoDB will do a normal
InnoDB: crash recovery and ignore that table.
InnoDB: 3) If the file system or the disk is broken, and you cannot remove
InnoDB: the .ibd file, you can set innodb_force_recovery > 0 in my.cnf
InnoDB: and force InnoDB to continue crash recovery here.
2015-02-19 08:56:14 1452 [Note] Plugin 'FEDERATED' is disabled.
2015-02-19 08:56:14 183c 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.
2015-02-19 08:56:14 1452 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-02-19 08:56:14 1452 [Note] InnoDB: The InnoDB memory heap is disabled
2015-02-19 08:56:14 1452 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-02-19 08:56:14 1452 [Note] InnoDB: Memory barrier is not used
2015-02-19 08:56:14 1452 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-02-19 08:56:14 1452 [Note] InnoDB: Not using CPU crc32 instructions
2015-02-19 08:56:14 1452 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2015-02-19 08:56:14 1452 [Note] InnoDB: Completed initialization of buffer pool
2015-02-19 08:56:14 1452 [Note] InnoDB: Highest supported file format is Barracuda.
2015-02-19 08:56:14 1452 [Note] InnoDB: The log sequence numbers 1665234 and 1665234 in ibdata files do not match the log sequence number 1665254 in the ib_logfiles!
2015-02-19 08:56:14 1452 [Note] InnoDB: Database was not shutdown normally!
2015-02-19 08:56:14 1452 [Note] InnoDB: Starting crash recovery.
2015-02-19 08:56:14 1452 [Note] InnoDB: Reading tablespace information from the .ibd files...
2015-02-19 08:56:14 1452 [ERROR] InnoDB: Attempted to open a previously opened tablespace. Previous tablespace allawag/o065q_content_types uses space ID: 240 at filepath: .\allawag\o065q_content_types.ibd. Cannot open tablespace allawag/yu3lk_content_types which uses space ID: 240 at filepath: .\allawag\yu3lk_content_types.ibd
InnoDB: Error: could not open single-table tablespace file .\allawag\yu3lk_content_types.ibd
InnoDB: We do not continue the crash recovery, because the table may become
InnoDB: corrupt if we cannot apply the log records in the InnoDB log to it.
InnoDB: To fix the problem and start mysqld:
InnoDB: 1) If there is a permission problem in the file and mysqld cannot
InnoDB: open the file, you should modify the permissions.
InnoDB: 2) If the table is not needed, or you can restore it from a backup,
InnoDB: then you can remove the .ibd file, and InnoDB will do a normal
InnoDB: crash recovery and ignore that table.
InnoDB: 3) If the file system or the disk is broken, and you cannot remove
InnoDB: the .ibd file, you can set innodb_force_recovery > 0 in my.cnf
InnoDB: and force InnoDB to continue crash recovery here.
2015-02-19 08:56:16 6960 [Note] Plugin 'FEDERATED' is disabled.
2015-02-19 08:56:16 1404 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.
2015-02-19 08:56:16 6960 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-02-19 08:56:16 6960 [Note] InnoDB: The InnoDB memory heap is disabled
2015-02-19 08:56:16 6960 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-02-19 08:56:16 6960 [Note] InnoDB: Memory barrier is not used
2015-02-19 08:56:16 6960 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-02-19 08:56:16 6960 [Note] InnoDB: Not using CPU crc32 instructions
2015-02-19 08:56:16 6960 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2015-02-19 08:56:16 6960 [Note] InnoDB: Completed initialization of buffer pool
2015-02-19 08:56:16 6960 [Note] InnoDB: Highest supported file format is Barracuda.
2015-02-19 08:56:17 6960 [Note] InnoDB: The log sequence numbers 1665234 and 1665234 in ibdata files do not match the log sequence number 1665254 in the ib_logfiles!
2015-02-19 08:56:17 6960 [Note] InnoDB: Database was not shutdown normally!
2015-02-19 08:56:17 6960 [Note] InnoDB: Starting crash recovery.
2015-02-19 08:56:17 6960 [Note] InnoDB: Reading tablespace information from the .ibd files...
2015-02-19 08:56:17 6960 [ERROR] InnoDB: Attempted to open a previously opened tablespace. Previous tablespace allawag/o065q_content_types uses space ID: 240 at filepath: .\allawag\o065q_content_types.ibd. Cannot open tablespace allawag/yu3lk_content_types which uses space ID: 240 at filepath: .\allawag\yu3lk_content_types.ibd
InnoDB: Error: could not open single-table tablespace file .\allawag\yu3lk_content_types.ibd
InnoDB: We do not continue the crash recovery, because the table may become
InnoDB: corrupt if we cannot apply the log records in the InnoDB log to it.
InnoDB: To fix the problem and start mysqld:
InnoDB: 1) If there is a permission problem in the file and mysqld cannot
InnoDB: open the file, you should modify the permissions.
InnoDB: 2) If the table is not needed, or you can restore it from a backup,
InnoDB: then you can remove the .ibd file, and InnoDB will do a normal
InnoDB: crash recovery and ignore that table.
InnoDB: 3) If the file system or the disk is broken, and you cannot remove
InnoDB: the .ibd file, you can set innodb_force_recovery > 0 in my.cnf
InnoDB: and force InnoDB to continue crash recovery here.
2015-02-19 09:03:06 5712 [Note] Plugin 'FEDERATED' is disabled.
2015-02-19 09:03:06 1b68 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.
2015-02-19 09:03:06 5712 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-02-19 09:03:06 5712 [Note] InnoDB: The InnoDB memory heap is disabled
2015-02-19 09:03:06 5712 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-02-19 09:03:06 5712 [Note] InnoDB: Memory barrier is not used
2015-02-19 09:03:06 5712 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-02-19 09:03:06 5712 [Note] InnoDB: Not using CPU crc32 instructions
2015-02-19 09:03:06 5712 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2015-02-19 09:03:06 5712 [Note] InnoDB: Completed initialization of buffer pool
2015-02-19 09:03:06 5712 [Note] InnoDB: Highest supported file format is Barracuda.
2015-02-19 09:03:06 5712 [Note] InnoDB: The log sequence numbers 1665234 and 1665234 in ibdata files do not match the log sequence number 1665254 in the ib_logfiles!
2015-02-19 09:03:06 5712 [Note] InnoDB: Database was not shutdown normally!
2015-02-19 09:03:06 5712 [Note] InnoDB: Starting crash recovery.
2015-02-19 09:03:06 5712 [Note] InnoDB: Reading tablespace information from the .ibd files...
2015-02-19 09:03:06 5712 [ERROR] InnoDB: Attempted to open a previously opened tablespace. Previous tablespace allawag/o065q_content_types uses space ID: 240 at filepath: .\allawag\o065q_content_types.ibd. Cannot open tablespace allawag/yu3lk_content_types which uses space ID: 240 at filepath: .\allawag\yu3lk_content_types.ibd
InnoDB: Error: could not open single-table tablespace file .\allawag\yu3lk_content_types.ibd
InnoDB: We do not continue the crash recovery, because the table may become
InnoDB: corrupt if we cannot apply the log records in the InnoDB log to it.
InnoDB: To fix the problem and start mysqld:
InnoDB: 1) If there is a permission problem in the file and mysqld cannot
InnoDB: open the file, you should modify the permissions.
InnoDB: 2) If the table is not needed, or you can restore it from a backup,
InnoDB: then you can remove the .ibd file, and InnoDB will do a normal
InnoDB: crash recovery and ignore that table.
InnoDB: 3) If the file system or the disk is broken, and you cannot remove
InnoDB: the .ibd file, you can set innodb_force_recovery > 0 in my.cnf
InnoDB: and force InnoDB to continue crash recovery here.
2015-03-02 12:58:49 11572 [Note] Plugin 'FEDERATED' is disabled.
2015-03-02 12:58:51 169c 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.
2015-03-02 12:58:51 11572 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-03-02 12:58:51 11572 [Note] InnoDB: The InnoDB memory heap is disabled
2015-03-02 12:58:51 11572 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-03-02 12:58:51 11572 [Note] InnoDB: Memory barrier is not used
2015-03-02 12:58:51 11572 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-03-02 12:58:51 11572 [Note] InnoDB: Not using CPU crc32 instructions
2015-03-02 12:58:52 11572 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2015-03-02 12:58:52 11572 [Note] InnoDB: Completed initialization of buffer pool
2015-03-02 12:58:53 11572 [Note] InnoDB: Highest supported file format is Barracuda.
2015-03-02 12:58:53 11572 [Note] InnoDB: The log sequence numbers 1665234 and 1665234 in ibdata files do not match the log sequence number 1665254 in the ib_logfiles!
2015-03-02 12:58:53 11572 [Note] InnoDB: Database was not shutdown normally!
2015-03-02 12:58:53 11572 [Note] InnoDB: Starting crash recovery.
2015-03-02 12:58:53 11572 [Note] InnoDB: Reading tablespace information from the .ibd files...
2015-03-02 12:58:55 11572 [ERROR] InnoDB: Attempted to open a previously opened tablespace. Previous tablespace allawag/o065q_content_types uses space ID: 240 at filepath: .\allawag\o065q_content_types.ibd. Cannot open tablespace allawag/yu3lk_content_types which uses space ID: 240 at filepath: .\allawag\yu3lk_content_types.ibd
InnoDB: Error: could not open single-table tablespace file .\allawag\yu3lk_content_types.ibd
InnoDB: We do not continue the crash recovery, because the table may become
InnoDB: corrupt if we cannot apply the log records in the InnoDB log to it.
InnoDB: To fix the problem and start mysqld:
InnoDB: 1) If there is a permission problem in the file and mysqld cannot
InnoDB: open the file, you should modify the permissions.
InnoDB: 2) If the table is not needed, or you can restore it from a backup,
InnoDB: then you can remove the .ibd file, and InnoDB will do a normal
InnoDB: crash recovery and ignore that table.
InnoDB: 3) If the file system or the disk is broken, and you cannot remove
InnoDB: the .ibd file, you can set innodb_force_recovery > 0 in my.cnf
InnoDB: and force InnoDB to continue crash recovery here.
by weeshi
02. March 2015 12:45
 
Forum: MySQL
Topic: Please / Error: MySQL shutdown unexpectedly
Replies: 1
Views: 287

Error: MySQL shutdown unexpectedly.

Hi,

I have never worked with XAMPP, so I am sorry for my maybe stupid questions. I have downloaded the programme and I wanted to start MySQL, but an error message appeared, which said that the port: 3306 would be already taken. I have restarted the programme and un- and reinstalled the MySQL Service. Now another error message appears:

Code: Select all
21:07:55  [mysql]    Attempting to start MySQL service...
21:07:56  [mysql]    Status change detected: running
21:08:01  [mysql]    Status change detected: stopped
21:08:01  [mysql]    Error: MySQL shutdown unexpectedly.
21:08:01  [mysql]    This may be due to a blocked port, missing dependencies,
21:08:01  [mysql]    improper privileges, a crash, or a shutdown by another method.
21:08:01  [mysql]    Press the Logs button to view error logs and check
21:08:01  [mysql]    the Windows Event Viewer for more clues
21:08:01  [mysql]    If you need more help, copy and post this
21:08:01  [mysql]    entire log window on the forums


Here is also the Log-File:

Code: Select all
2015-02-28 15:07:06 7676 [Note] Plugin 'FEDERATED' is disabled.
2015-02-28 15:07:06 1df4 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.
2015-02-28 15:07:06 7676 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-02-28 15:07:06 7676 [Note] InnoDB: The InnoDB memory heap is disabled
2015-02-28 15:07:06 7676 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-02-28 15:07:06 7676 [Note] InnoDB: Memory barrier is not used
2015-02-28 15:07:06 7676 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-02-28 15:07:06 7676 [Note] InnoDB: Not using CPU crc32 instructions
2015-02-28 15:07:06 7676 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2015-02-28 15:07:06 7676 [Note] InnoDB: Completed initialization of buffer pool
2015-02-28 15:07:06 7676 [Note] InnoDB: The first specified data file D:\xampp\mysql\data\ibdata1 did not exist: a new database to be created!
2015-02-28 15:07:06 7676 [Note] InnoDB: Setting file D:\xampp\mysql\data\ibdata1 size to 10 MB
2015-02-28 15:07:06 7676 [Note] InnoDB: Database physically writes the file full: wait...
2015-02-28 15:07:06 7676 [Note] InnoDB: Setting log file D:\xampp\mysql\data\ib_logfile101 size to 5 MB
2015-02-28 15:07:06 7676 [ERROR] InnoDB: Cannot create D:\xampp\mysql\data\ib_logfile1
2015-02-28 15:07:06 7676 [ERROR] Plugin 'InnoDB' init function returned error.
2015-02-28 15:07:06 7676 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2015-02-28 15:07:06 7676 [ERROR] Unknown/unsupported storage engine: InnoDB
2015-02-28 15:07:06 7676 [ERROR] Aborting

2015-02-28 15:07:06 7676 [Note] Binlog end
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'partition'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'INNODB_METRICS'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'INNODB_CMPMEM'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'INNODB_CMP'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'INNODB_LOCKS'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'INNODB_TRX'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'BLACKHOLE'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'ARCHIVE'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'MRG_MYISAM'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'MyISAM'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'MEMORY'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'CSV'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'sha256_password'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'mysql_old_password'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'mysql_native_password'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'binlog'
2015-02-28 15:07:06 7676 [Note] d:\xampp\mysql\bin\mysqld.exe: Shutdown complete

2015-02-28 15:07:22 6052 [Note] Plugin 'FEDERATED' is disabled.
2015-02-28 15:07:22 1f58 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.
2015-02-28 15:07:22 6052 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-02-28 15:07:22 6052 [Note] InnoDB: The InnoDB memory heap is disabled
2015-02-28 15:07:22 6052 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-02-28 15:07:22 6052 [Note] InnoDB: Memory barrier is not used
2015-02-28 15:07:22 6052 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-02-28 15:07:22 6052 [Note] InnoDB: Not using CPU crc32 instructions
2015-02-28 15:07:22 6052 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2015-02-28 15:07:22 6052 [Note] InnoDB: Completed initialization of buffer pool
2015-02-28 15:07:22 6052 [Note] InnoDB: Restoring page 0 of tablespace 0
2015-02-28 15:07:22 6052 [Warning] InnoDB: Doublewrite does not have page_no=0 of space: 0
2015-02-28 15:07:22 6052 [ERROR] InnoDB: space header page consists of zero bytes in data file D:\xampp\mysql\data\ibdata1
2015-02-28 15:07:22 6052 [ERROR] InnoDB: Could not open or create the system tablespace. If you tried to add new data files to the system tablespace, and it failed here, you should now edit innodb_data_file_path in my.cnf back to what it was, and remove the new ibdata files InnoDB created in this failed attempt. InnoDB only wrote those files full of zeros, but did not yet use them in any way. But be careful: do not remove old data files which contain your precious data!
2015-02-28 15:07:22 6052 [ERROR] Plugin 'InnoDB' init function returned error.
2015-02-28 15:07:22 6052 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2015-02-28 15:07:22 6052 [ERROR] Unknown/unsupported storage engine: InnoDB
2015-02-28 15:07:22 6052 [ERROR] Aborting

2015-02-28 15:07:22 6052 [Note] Binlog end
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'partition'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'INNODB_METRICS'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'INNODB_CMPMEM'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'INNODB_CMP'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'INNODB_LOCKS'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'INNODB_TRX'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'BLACKHOLE'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'ARCHIVE'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'MRG_MYISAM'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'MyISAM'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'MEMORY'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'CSV'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'sha256_password'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'mysql_old_password'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'mysql_native_password'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'binlog'
2015-02-28 15:07:22 6052 [Note] D:\xampp\mysql\bin\mysqld.exe: Shutdown complete


I am sorry, if this problem has already been solved here, but I have not found it.

Please help me, I do not have an idea what it could be.
by grifon
28. February 2015 21:09
 
Forum: XAMPP for Windows
Topic: Error: MySQL shutdown unexpectedly.
Replies: 1
Views: 801

Mysql unable to start

Error are as below:
2015-02-28 23:05:58 1218 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.
150228 23:05:58 [Note] InnoDB: Using mutexes to ref count buffer pool pages
150228 23:05:58 [Note] InnoDB: The InnoDB memory heap is disabled
150228 23:05:58 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
150228 23:05:58 [Note] InnoDB: Memory barrier is not used
150228 23:05:58 [Note] InnoDB: Compressed tables use zlib 1.2.3
150228 23:05:58 [Note] InnoDB: Not using CPU crc32 instructions
150228 23:05:58 [Note] InnoDB: Initializing buffer pool, size = 16.0M
150228 23:05:58 [Note] InnoDB: Completed initialization of buffer pool
150228 23:05:59 [Note] InnoDB: Highest supported file format is Barracuda.
150228 23:05:59 [Note] InnoDB: The log sequence numbers 1665234 and 1665234 in ibdata files do not match the log sequence number 1665314 in the ib_logfiles!
150228 23:05:59 [Note] InnoDB: Database was not shutdown normally!
150228 23:05:59 [Note] InnoDB: Starting crash recovery.
150228 23:05:59 [Note] InnoDB: Reading tablespace information from the .ibd files...
150228 23:05:59 [Note] InnoDB: Restoring possible half-written data pages
150228 23:05:59 [Note] InnoDB: from the doublewrite buffer...
150228 23:06:00 [Note] InnoDB: 128 rollback segment(s) are active.
150228 23:06:00 [Note] InnoDB: Waiting for purge to start
150228 23:06:00 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.22-71.0 started; log sequence number 1665314
150228 23:06:00 [Note] Plugin 'FEEDBACK' is disabled.
150228 23:06:00 [Note] Server socket created on IP: '::'.
150228 23:06:00 [ERROR] Missing system table mysql.roles_mapping; please run mysql_upgrade to create it
150228 23:06: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
150228 23:06:01 [ERROR] Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.
150228 23:06:01 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1146: Table 'mysql.gtid_slave_pos' doesn't exist
150228 23:06:01 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '10.0.16-MariaDB' socket: '' port: 3307 mariadb.org binary distribution
2015-02-28 23:07:50 bbc 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.
150228 23:07:50 [Note] InnoDB: Using mutexes to ref count buffer pool pages
150228 23:07:50 [Note] InnoDB: The InnoDB memory heap is disabled
150228 23:07:50 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
150228 23:07:50 [Note] InnoDB: Memory barrier is not used
150228 23:07:50 [Note] InnoDB: Compressed tables use zlib 1.2.3
150228 23:07:50 [Note] InnoDB: Not using CPU crc32 instructions
150228 23:07:50 [Note] InnoDB: Initializing buffer pool, size = 16.0M
150228 23:07:50 [Note] InnoDB: Completed initialization of buffer pool
150228 23:07:50 [ERROR] InnoDB: C:\xampp\mysql\data\ibdata1 can't be opened in read-write mode
150228 23:07:50 [ERROR] InnoDB: The system tablespace must be writable!
150228 23:07:50 [ERROR] Plugin 'InnoDB' init function returned error.
150228 23:07:50 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
150228 23:07:50 [Note] Plugin 'FEEDBACK' is disabled.
150228 23:07:50 [ERROR] Unknown/unsupported storage engine: InnoDB
150228 23:07:50 [ERROR] Aborting

150228 23:07:50 [Note] c:\xampp\mysql\bin\mysqld.exe: Shutdown complete


Already run mysql_upgrade.exe but still can't solve the problem?

Previously i did install an older version of MariaDB using the .msi older version file but then i uninstall it already.

Note: Using XAMPP v5.6.3 and MariaDB 10.0.16.
by Nickdearoj
28. February 2015 16:34
 
Forum: MySQL
Topic: Mysql unable to start
Replies: 1
Views: 456

Fehler: MySQL wurde unerwartet beendet

Hallo,

ich habe noch nie mit XAMPP gearbeitet, also möchte ich mich schon jetzt für meine vielleicht blöden Fragen entschuldigen. Ich habe mir das Programm runtergeladen und wollte MySQL starten, jedoch kam immer die Meldung, dass der port: 3306 schon besetzt sei. Ich habe das Programm als Administrator neu gestartet und den MySQL Service de- und reinstalliert. Nun kommt nicht mehr die vorherige Fehlermeldung, sondern:

Code: Select all
15:17:38  [mysql]    Versuche MySQL Windows Dienst zu starten...
15:17:38  [mysql]    Statusänderung erkannt: gestartet
15:17:44  [mysql]    Statusänderung erkannt: gestoppt
15:17:44  [mysql]    Fehler: MySQL wurde unerwartet beendet
15:17:44  [mysql]    Ursache könnte ein geblockter Port, fehlende Abhängigkeiten,
15:17:44  [mysql]    fehlende Berechtigungen, ein Absturz oder ein Abbruch einer anderen Methode sein.
15:17:44  [mysql]    Drücke den Logs Button um error logs zu sehen und prüfe
15:17:44  [mysql]    im Windows Event Viewer für weitere Hinweise
15:17:44  [mysql]    Wenn du weitere Hilfe benötigst, kopiere den kompletten Inhalt des Log Fensters
15:17:44  [mysql]    und füge ihn als Ergänzung in einem neuen Forum Eintrag hinzu.


Hier ist auch die Log-Datei:

Code: Select all
2015-02-28 15:07:06 7676 [Note] Plugin 'FEDERATED' is disabled.
2015-02-28 15:07:06 1df4 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.
2015-02-28 15:07:06 7676 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-02-28 15:07:06 7676 [Note] InnoDB: The InnoDB memory heap is disabled
2015-02-28 15:07:06 7676 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-02-28 15:07:06 7676 [Note] InnoDB: Memory barrier is not used
2015-02-28 15:07:06 7676 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-02-28 15:07:06 7676 [Note] InnoDB: Not using CPU crc32 instructions
2015-02-28 15:07:06 7676 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2015-02-28 15:07:06 7676 [Note] InnoDB: Completed initialization of buffer pool
2015-02-28 15:07:06 7676 [Note] InnoDB: The first specified data file D:\xampp\mysql\data\ibdata1 did not exist: a new database to be created!
2015-02-28 15:07:06 7676 [Note] InnoDB: Setting file D:\xampp\mysql\data\ibdata1 size to 10 MB
2015-02-28 15:07:06 7676 [Note] InnoDB: Database physically writes the file full: wait...
2015-02-28 15:07:06 7676 [Note] InnoDB: Setting log file D:\xampp\mysql\data\ib_logfile101 size to 5 MB
2015-02-28 15:07:06 7676 [ERROR] InnoDB: Cannot create D:\xampp\mysql\data\ib_logfile1
2015-02-28 15:07:06 7676 [ERROR] Plugin 'InnoDB' init function returned error.
2015-02-28 15:07:06 7676 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2015-02-28 15:07:06 7676 [ERROR] Unknown/unsupported storage engine: InnoDB
2015-02-28 15:07:06 7676 [ERROR] Aborting

2015-02-28 15:07:06 7676 [Note] Binlog end
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'partition'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'INNODB_METRICS'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'INNODB_CMPMEM'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'INNODB_CMP'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'INNODB_LOCKS'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'INNODB_TRX'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'BLACKHOLE'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'ARCHIVE'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'MRG_MYISAM'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'MyISAM'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'MEMORY'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'CSV'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'sha256_password'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'mysql_old_password'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'mysql_native_password'
2015-02-28 15:07:06 7676 [Note] Shutting down plugin 'binlog'
2015-02-28 15:07:06 7676 [Note] d:\xampp\mysql\bin\mysqld.exe: Shutdown complete

2015-02-28 15:07:22 6052 [Note] Plugin 'FEDERATED' is disabled.
2015-02-28 15:07:22 1f58 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.
2015-02-28 15:07:22 6052 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-02-28 15:07:22 6052 [Note] InnoDB: The InnoDB memory heap is disabled
2015-02-28 15:07:22 6052 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-02-28 15:07:22 6052 [Note] InnoDB: Memory barrier is not used
2015-02-28 15:07:22 6052 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-02-28 15:07:22 6052 [Note] InnoDB: Not using CPU crc32 instructions
2015-02-28 15:07:22 6052 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2015-02-28 15:07:22 6052 [Note] InnoDB: Completed initialization of buffer pool
2015-02-28 15:07:22 6052 [Note] InnoDB: Restoring page 0 of tablespace 0
2015-02-28 15:07:22 6052 [Warning] InnoDB: Doublewrite does not have page_no=0 of space: 0
2015-02-28 15:07:22 6052 [ERROR] InnoDB: space header page consists of zero bytes in data file D:\xampp\mysql\data\ibdata1
2015-02-28 15:07:22 6052 [ERROR] InnoDB: Could not open or create the system tablespace. If you tried to add new data files to the system tablespace, and it failed here, you should now edit innodb_data_file_path in my.cnf back to what it was, and remove the new ibdata files InnoDB created in this failed attempt. InnoDB only wrote those files full of zeros, but did not yet use them in any way. But be careful: do not remove old data files which contain your precious data!
2015-02-28 15:07:22 6052 [ERROR] Plugin 'InnoDB' init function returned error.
2015-02-28 15:07:22 6052 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2015-02-28 15:07:22 6052 [ERROR] Unknown/unsupported storage engine: InnoDB
2015-02-28 15:07:22 6052 [ERROR] Aborting

2015-02-28 15:07:22 6052 [Note] Binlog end
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'partition'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'INNODB_METRICS'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'INNODB_CMPMEM'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'INNODB_CMP'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'INNODB_LOCKS'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'INNODB_TRX'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'BLACKHOLE'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'ARCHIVE'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'MRG_MYISAM'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'MyISAM'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'MEMORY'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'CSV'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'sha256_password'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'mysql_old_password'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'mysql_native_password'
2015-02-28 15:07:22 6052 [Note] Shutting down plugin 'binlog'
2015-02-28 15:07:22 6052 [Note] D:\xampp\mysql\bin\mysqld.exe: Shutdown complete


Tut mir leid, wenn dieses Problem bereits irgendwo hier gelöst wurde, ich habe es nicht gefunden.

Bitte helft mir, ich habe keine Ahnung, was das bedeuten könnte.
by grifon
28. February 2015 15:30
 
Forum: XAMPP für Windows
Topic: Fehler: MySQL wurde unerwartet beendet
Replies: 12
Views: 1095

localhost and phpmyadmin failed to connect

First of all I'm sorry for my english

I've got a problem with Xampp on my laptop on Windows 7 x64
I had read a lot of topic's on forums and I have tried every way to fix my problem
I have tried change a ports from 80 to 8081 etc.., remove "#" before 127.0.0.1 in hosts from Windows/system32/drivers/etc/hosts and etc...
After running Xampp control panel as administrator I clic start Apache and Mysql
MySql is running immediately but apache after approximately even 10 min
That's a content from Apache error.log
[Sat Feb 21 08:57:55.820454 2015] [ssl:warn] [pid 5916:tid 568] AH01909: www.example.com:443:0 server certificate does NOT include an ID which matches the server name
[Sat Feb 21 08:57:56.694055 2015] [core:warn] [pid 5916:tid 568] AH00098: pid file C:/xampp/apache/logs/httpd.pid overwritten -- Unclean shutdown of previous Apache run?
[Sat Feb 21 08:57:57.271256 2015] [ssl:warn] [pid 5916:tid 568] AH01909: www.example.com:443:0 server certificate does NOT include an ID which matches the server name
[Sat Feb 21 08:57:57.598857 2015] [mpm_winnt:notice] [pid 5916:tid 568] AH00455: Apache/2.4.10 (Win32) OpenSSL/1.0.1i PHP/5.6.3 configured -- resuming normal operations
[Sat Feb 21 08:57:57.598857 2015] [mpm_winnt:notice] [pid 5916:tid 568] AH00456: Apache Lounge VC11 Server built: Jul 17 2014 11:50:08
[Sat Feb 21 08:57:57.598857 2015] [core:notice] [pid 5916:tid 568] AH00094: Command line: 'c:\\xampp\\apache\\bin\\httpd.exe -d C:/xampp/apache'
[Sat Feb 21 08:57:57.614457 2015] [mpm_winnt:notice] [pid 5916:tid 568] AH00418: Parent: Created child process 5872
[Sat Feb 21 08:57:59.736060 2015] [ssl:warn] [pid 5872:tid 580] AH01909: www.example.com:443:0 server certificate does NOT include an ID which matches the server name
[Sat Feb 21 08:58:00.438062 2015] [ssl:warn] [pid 5872:tid 580] AH01909: www.example.com:443:0 server certificate does NOT include an ID which matches the server name
[Sat Feb 21 08:58:00.531662 2015] [mpm_winnt:notice] [pid 5872:tid 580] AH00354: Child: Starting 150 worker threads.

That's a content from Mysql error.log

2015-02-21 08:45:54 5324 [Note] Plugin 'FEDERATED' is disabled.
2015-02-21 08:45:54 1704 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.
2015-02-21 08:45:54 5324 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-02-21 08:45:54 5324 [Note] InnoDB: The InnoDB memory heap is disabled
2015-02-21 08:45:54 5324 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-02-21 08:45:54 5324 [Note] InnoDB: Memory barrier is not used
2015-02-21 08:45:54 5324 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-02-21 08:45:54 5324 [Note] InnoDB: Not using CPU crc32 instructions
2015-02-21 08:45:54 5324 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2015-02-21 08:45:54 5324 [Note] InnoDB: Completed initialization of buffer pool
2015-02-21 08:45:54 5324 [Note] InnoDB: Highest supported file format is Barracuda.
2015-02-21 08:45:54 5324 [Note] InnoDB: The log sequence numbers 0 and 0 in ibdata files do not match the log sequence number 1600724 in the ib_logfiles!
2015-02-21 08:45:54 5324 [Note] InnoDB: Database was not shutdown normally!
2015-02-21 08:45:54 5324 [Note] InnoDB: Starting crash recovery.
2015-02-21 08:45:54 5324 [Note] InnoDB: Reading tablespace information from the .ibd files...
2015-02-21 08:45:54 5324 [Note] InnoDB: Restoring possible half-written data pages
2015-02-21 08:45:54 5324 [Note] InnoDB: from the doublewrite buffer...
2015-02-21 08:45:55 5324 [Note] InnoDB: 128 rollback segment(s) are active.
2015-02-21 08:45:55 5324 [Note] InnoDB: Waiting for purge to start
2015-02-21 08:45:55 5324 [Note] InnoDB: 5.6.21 started; log sequence number 1600724
2015-02-21 08:45:55 5324 [Note] Server hostname (bind-address): '*'; port: 3306
2015-02-21 08:45:55 5324 [Note] IPv6 is available.
2015-02-21 08:45:55 5324 [Note] - '::' resolves to '::';
2015-02-21 08:45:55 5324 [Note] Server socket created on IP: '::'.
2015-02-21 08:48:55 5324 [Warning] InnoDB: Cannot open table mysql/slave_master_info from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2015-02-21 08:48:55 5324 [Warning] Info table is not ready to be used. Table 'mysql.slave_master_info' cannot be opened.
2015-02-21 08:48:55 5324 [Warning] InnoDB: Cannot open table mysql/slave_worker_info from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2015-02-21 08:48:55 5324 [Warning] InnoDB: Cannot open table mysql/slave_relay_log_info from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2015-02-21 08:48:55 5324 [Warning] Info table is not ready to be used. Table 'mysql.slave_relay_log_info' cannot be opened.
2015-02-21 08:48:55 5324 [Note] Event Scheduler: Loaded 0 events
2015-02-21 08:48:55 5324 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '5.6.21' socket: '' port: 3306 MySQL Community Server (GPL)

When Apache and Mysql is already running , I try to enter localhost in my browser, but I get the message that: "Failed to connect " and when I press the "Admin " in the Xampp control panel, information in the browser is the same. What should I do. I'm not young but I want to learn something. Thanks in advance for any help
by Igor1947
21. February 2015 09:00
 
Forum: XAMPP for Windows
Topic: localhost and phpmyadmin failed to connect
Replies: 6
Views: 1193

MySQL deaktiviert?

hallo,

das problem ist sicher schon mehrfach vorgekommen, ich bin aber weder hier (durch die suchfunktion) noch über google zu einer lösung gekommen.
ich kenne mich mit netzwerken leider nicht besonders aus.

habe xampp installiert, kann sowohl apache als auch mysql starten, aber wenn ich mir den status ansehe, steht, dass die mysql datenbank deaktiviert ist, beim sicherheitscheck steht, "Ein MySQL Server läuft nicht oder wird von einer Firewall geblockt!".

daraufhin habe ich die firewall ausgeschaltet, es geht aber trotzdem nicht.
ich habe auch die UAC (user account control) zeitweilig deaktiviert, da bei der installation eine meldung kam, dass dies eventuell probleme verursacht. ändert auch nichts.
als firewall verwende ich outpost security free.

ich hoffe, jemand von euch kann mir helfen, ich bedanke mich schon mal im voraus, ich komme offensichtlich allein nicht mehr weiter.



hier der error log von mysql:
2015-02-18 10:38:44 6844 [Note] Plugin 'FEDERATED' is disabled.
2015-02-18 10:38:44 1914 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.
2015-02-18 10:38:44 6844 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-02-18 10:38:44 6844 [Note] InnoDB: The InnoDB memory heap is disabled
2015-02-18 10:38:44 6844 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-02-18 10:38:44 6844 [Note] InnoDB: Memory barrier is not used
2015-02-18 10:38:44 6844 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-02-18 10:38:44 6844 [Note] InnoDB: Not using CPU crc32 instructions
2015-02-18 10:38:44 6844 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2015-02-18 10:38:44 6844 [Note] InnoDB: Completed initialization of buffer pool
2015-02-18 10:38:44 6844 [Note] InnoDB: Highest supported file format is Barracuda.
2015-02-18 10:38:44 6844 [Note] InnoDB: 128 rollback segment(s) are active.
2015-02-18 10:38:44 6844 [Note] InnoDB: Waiting for purge to start
2015-02-18 10:38:44 6844 [Note] InnoDB: 5.6.21 started; log sequence number 1665234
2015-02-18 10:38:44 6844 [Note] Server hostname (bind-address): '*'; port: 3306
2015-02-18 10:38:44 6844 [Note] IPv6 is available.
2015-02-18 10:38:44 6844 [Note] - '::' resolves to '::';
2015-02-18 10:38:44 6844 [Note] Server socket created on IP: '::'.
2015-02-18 10:38:45 6844 [Note] Event Scheduler: Loaded 0 events
2015-02-18 10:38:45 6844 [Note] p:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '5.6.21' socket: '' port: 3306 MySQL Community Server (GPL)
2015-02-18 10:48:34 7064 [Note] Plugin 'FEDERATED' is disabled.
2015-02-18 10:48:34 1b9c 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.
2015-02-18 10:48:34 7064 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-02-18 10:48:34 7064 [Note] InnoDB: The InnoDB memory heap is disabled
2015-02-18 10:48:34 7064 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-02-18 10:48:34 7064 [Note] InnoDB: Memory barrier is not used
2015-02-18 10:48:34 7064 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-02-18 10:48:34 7064 [Note] InnoDB: Not using CPU crc32 instructions
2015-02-18 10:48:34 7064 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2015-02-18 10:48:34 7064 [Note] InnoDB: Completed initialization of buffer pool
2015-02-18 10:48:34 7064 [Note] InnoDB: Highest supported file format is Barracuda.
2015-02-18 10:48:34 7064 [Note] InnoDB: The log sequence numbers 1665234 and 1665234 in ibdata files do not match the log sequence number 1665244 in the ib_logfiles!
2015-02-18 10:48:34 7064 [Note] InnoDB: Database was not shutdown normally!
2015-02-18 10:48:34 7064 [Note] InnoDB: Starting crash recovery.
2015-02-18 10:48:34 7064 [Note] InnoDB: Reading tablespace information from the .ibd files...
2015-02-18 10:48:35 7064 [Note] InnoDB: Restoring possible half-written data pages
2015-02-18 10:48:35 7064 [Note] InnoDB: from the doublewrite buffer...
2015-02-18 10:48:35 7064 [Note] InnoDB: 128 rollback segment(s) are active.
2015-02-18 10:48:35 7064 [Note] InnoDB: Waiting for purge to start
2015-02-18 10:48:35 7064 [Note] InnoDB: 5.6.21 started; log sequence number 1665244
2015-02-18 10:48:35 7064 [Note] Server hostname (bind-address): '*'; port: 3306
2015-02-18 10:48:35 7064 [Note] IPv6 is available.
2015-02-18 10:48:35 7064 [Note] - '::' resolves to '::';
2015-02-18 10:48:35 7064 [Note] Server socket created on IP: '::'.
2015-02-18 10:48:35 7064 [Note] Event Scheduler: Loaded 0 events
2015-02-18 10:48:35 7064 [Note] p:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '5.6.21' socket: '' port: 3306 MySQL Community Server (GPL)
2015-02-18 11:11:34 7492 [Note] Plugin 'FEDERATED' is disabled.
2015-02-18 11:11:34 1d48 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.
2015-02-18 11:11:34 7492 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-02-18 11:11:34 7492 [Note] InnoDB: The InnoDB memory heap is disabled
2015-02-18 11:11:34 7492 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-02-18 11:11:34 7492 [Note] InnoDB: Memory barrier is not used
2015-02-18 11:11:34 7492 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-02-18 11:11:34 7492 [Note] InnoDB: Not using CPU crc32 instructions
2015-02-18 11:11:34 7492 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2015-02-18 11:11:34 7492 [Note] InnoDB: Completed initialization of buffer pool
2015-02-18 11:11:34 7492 [Note] InnoDB: Highest supported file format is Barracuda.
2015-02-18 11:11:34 7492 [Note] InnoDB: The log sequence numbers 1665234 and 1665234 in ibdata files do not match the log sequence number 1665254 in the ib_logfiles!
2015-02-18 11:11:34 7492 [Note] InnoDB: Database was not shutdown normally!
2015-02-18 11:11:34 7492 [Note] InnoDB: Starting crash recovery.
2015-02-18 11:11:34 7492 [Note] InnoDB: Reading tablespace information from the .ibd files...
2015-02-18 11:11:34 7492 [Note] InnoDB: Restoring possible half-written data pages
2015-02-18 11:11:34 7492 [Note] InnoDB: from the doublewrite buffer...
2015-02-18 11:11:34 7492 [Note] InnoDB: 128 rollback segment(s) are active.
2015-02-18 11:11:34 7492 [Note] InnoDB: Waiting for purge to start
2015-02-18 11:11:34 7492 [Note] InnoDB: 5.6.21 started; log sequence number 1665254
2015-02-18 11:11:34 7492 [Note] Server hostname (bind-address): '*'; port: 3306
2015-02-18 11:11:34 7492 [Note] IPv6 is available.
2015-02-18 11:11:34 7492 [Note] - '::' resolves to '::';
2015-02-18 11:11:34 7492 [Note] Server socket created on IP: '::'.
2015-02-18 11:11:35 7492 [Note] Event Scheduler: Loaded 0 events
2015-02-18 11:11:35 7492 [Note] p:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '5.6.21' socket: '' port: 3306 MySQL Community Server (GPL)
2015-02-18 11:14:12 920 [Note] Plugin 'FEDERATED' is disabled.
2015-02-18 11:14:12 1e94 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.
2015-02-18 11:14:12 920 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-02-18 11:14:12 920 [Note] InnoDB: The InnoDB memory heap is disabled
2015-02-18 11:14:12 920 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-02-18 11:14:12 920 [Note] InnoDB: Memory barrier is not used
2015-02-18 11:14:12 920 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-02-18 11:14:12 920 [Note] InnoDB: Not using CPU crc32 instructions
2015-02-18 11:14:12 920 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2015-02-18 11:14:12 920 [Note] InnoDB: Completed initialization of buffer pool
2015-02-18 11:14:13 920 [Note] InnoDB: Highest supported file format is Barracuda.
2015-02-18 11:14:13 920 [Note] InnoDB: The log sequence numbers 1665234 and 1665234 in ibdata files do not match the log sequence number 1665264 in the ib_logfiles!
2015-02-18 11:14:13 920 [Note] InnoDB: Database was not shutdown normally!
2015-02-18 11:14:13 920 [Note] InnoDB: Starting crash recovery.
2015-02-18 11:14:13 920 [Note] InnoDB: Reading tablespace information from the .ibd files...
2015-02-18 11:14:13 920 [Note] InnoDB: Restoring possible half-written data pages
2015-02-18 11:14:13 920 [Note] InnoDB: from the doublewrite buffer...
2015-02-18 11:14:13 920 [Note] InnoDB: 128 rollback segment(s) are active.
2015-02-18 11:14:13 920 [Note] InnoDB: Waiting for purge to start
2015-02-18 11:14:13 920 [Note] InnoDB: 5.6.21 started; log sequence number 1665264
2015-02-18 11:14:13 920 [Note] Server hostname (bind-address): '*'; port: 3306
2015-02-18 11:14:13 920 [Note] IPv6 is available.
2015-02-18 11:14:13 920 [Note] - '::' resolves to '::';
2015-02-18 11:14:13 920 [Note] Server socket created on IP: '::'.
2015-02-18 11:14:13 920 [Note] Event Scheduler: Loaded 0 events
2015-02-18 11:14:13 920 [Note] p:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '5.6.21' socket: '' port: 3306 MySQL Community Server (GPL)
by lalofee
18. February 2015 11:33
 
Forum: XAMPP für Windows
Topic: MySQL deaktiviert?
Replies: 2
Views: 647

MYSQL Wont even start please help

Whenever i try to start my mysql database it doest start it brings up the fallowing:
12:33:42 AM [mysql] Error: MySQL shutdown unexpectedly.
12:33:42 AM [mysql] This may be due to a blocked port, missing dependencies,
12:33:42 AM [mysql] improper privileges, a crash, or a shutdown by another method.
12:33:42 AM [mysql] Press the Logs button to view error logs and check
12:33:42 AM [mysql] the Windows Event Viewer for more clues
12:33:42 AM [mysql] If you need more help, copy and post this
12:33:42 AM [mysql] entire log window on the forums
Then so i got to the error log thing and i get this:
2015-02-18 00:30:41 400 [Note] Plugin 'FEDERATED' is disabled.
2015-02-18 00:30:41 668 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.
2015-02-18 00:30:41 400 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-02-18 00:30:41 400 [Note] InnoDB: The InnoDB memory heap is disabled
2015-02-18 00:30:41 400 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-02-18 00:30:41 400 [Note] InnoDB: Memory barrier is not used
2015-02-18 00:30:41 400 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-02-18 00:30:41 400 [Note] InnoDB: Not using CPU crc32 instructions
2015-02-18 00:30:41 400 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2015-02-18 00:30:41 400 [Note] InnoDB: Completed initialization of buffer pool
2015-02-18 00:30:41 400 [Note] InnoDB: Highest supported file format is Barracuda.
2015-02-18 00:30:41 400 [Note] InnoDB: 128 rollback segment(s) are active.
2015-02-18 00:30:41 400 [Note] InnoDB: Waiting for purge to start
2015-02-18 00:30:41 400 [Note] InnoDB: 5.6.21 started; log sequence number 1665234
2015-02-18 00:30:41 400 [ERROR] C:\xampp\mysql\bin\mysqld: unknown variable 'master-host=dwmprohosting'
2015-02-18 00:30:41 400 [ERROR] Aborting

2015-02-18 00:30:41 400 [Note] Binlog end
2015-02-18 00:30:41 400 [Note] Shutting down plugin 'partition'
2015-02-18 00:30:41 400 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2015-02-18 00:30:41 400 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2015-02-18 00:30:41 400 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2015-02-18 00:30:41 400 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2015-02-18 00:30:41 400 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2015-02-18 00:30:41 400 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2015-02-18 00:30:41 400 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2015-02-18 00:30:41 400 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2015-02-18 00:30:41 400 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2015-02-18 00:30:41 400 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2015-02-18 00:30:41 400 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2015-02-18 00:30:41 400 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2015-02-18 00:30:41 400 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2015-02-18 00:30:41 400 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2015-02-18 00:30:41 400 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2015-02-18 00:30:41 400 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2015-02-18 00:30:41 400 [Note] Shutting down plugin 'INNODB_METRICS'
2015-02-18 00:30:41 400 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2015-02-18 00:30:41 400 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2015-02-18 00:30:41 400 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2015-02-18 00:30:41 400 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2015-02-18 00:30:41 400 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2015-02-18 00:30:41 400 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2015-02-18 00:30:41 400 [Note] Shutting down plugin 'INNODB_CMPMEM'
2015-02-18 00:30:41 400 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2015-02-18 00:30:41 400 [Note] Shutting down plugin 'INNODB_CMP'
2015-02-18 00:30:41 400 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2015-02-18 00:30:41 400 [Note] Shutting down plugin 'INNODB_LOCKS'
2015-02-18 00:30:41 400 [Note] Shutting down plugin 'INNODB_TRX'
2015-02-18 00:30:41 400 [Note] Shutting down plugin 'InnoDB'
2015-02-18 00:30:41 400 [Note] InnoDB: FTS optimize thread exiting.
2015-02-18 00:30:41 400 [Note] InnoDB: Starting shutdown...
2015-02-18 00:30:43 400 [Note] InnoDB: Shutdown completed; log sequence number 1665244
2015-02-18 00:30:43 400 [Note] Shutting down plugin 'BLACKHOLE'
2015-02-18 00:30:43 400 [Note] Shutting down plugin 'ARCHIVE'
2015-02-18 00:30:43 400 [Note] Shutting down plugin 'MRG_MYISAM'
2015-02-18 00:30:43 400 [Note] Shutting down plugin 'MyISAM'
2015-02-18 00:30:43 400 [Note] Shutting down plugin 'MEMORY'
2015-02-18 00:30:43 400 [Note] Shutting down plugin 'CSV'
2015-02-18 00:30:43 400 [Note] Shutting down plugin 'sha256_password'
2015-02-18 00:30:43 400 [Note] Shutting down plugin 'mysql_old_password'
2015-02-18 00:30:43 400 [Note] Shutting down plugin 'mysql_native_password'
2015-02-18 00:30:43 400 [Note] Shutting down plugin 'binlog'
2015-02-18 00:30:43 400 [Note] C:\xampp\mysql\bin\mysqld: Shutdown complete

2015-02-18 00:32:06 3200 [Note] Plugin 'FEDERATED' is disabled.
2015-02-18 00:32:06 3b8 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.
2015-02-18 00:32:06 3200 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-02-18 00:32:06 3200 [Note] InnoDB: The InnoDB memory heap is disabled
2015-02-18 00:32:06 3200 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-02-18 00:32:06 3200 [Note] InnoDB: Memory barrier is not used
2015-02-18 00:32:06 3200 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-02-18 00:32:06 3200 [Note] InnoDB: Not using CPU crc32 instructions
2015-02-18 00:32:06 3200 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2015-02-18 00:32:06 3200 [Note] InnoDB: Completed initialization of buffer pool
2015-02-18 00:32:06 3200 [Note] InnoDB: Highest supported file format is Barracuda.
2015-02-18 00:32:06 3200 [Note] InnoDB: 128 rollback segment(s) are active.
2015-02-18 00:32:06 3200 [Note] InnoDB: Waiting for purge to start
2015-02-18 00:32:06 3200 [Note] InnoDB: 5.6.21 started; log sequence number 1665244
2015-02-18 00:32:06 3200 [ERROR] C:\xampp\mysql\bin\mysqld: unknown variable 'master-host=dwmprohosting'
2015-02-18 00:32:06 3200 [ERROR] Aborting

2015-02-18 00:32:06 3200 [Note] Binlog end
2015-02-18 00:32:06 3200 [Note] Shutting down plugin 'partition'
2015-02-18 00:32:06 3200 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2015-02-18 00:32:06 3200 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2015-02-18 00:32:06 3200 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2015-02-18 00:32:06 3200 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2015-02-18 00:32:06 3200 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2015-02-18 00:32:06 3200 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2015-02-18 00:32:06 3200 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2015-02-18 00:32:06 3200 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2015-02-18 00:32:06 3200 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2015-02-18 00:32:06 3200 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2015-02-18 00:32:06 3200 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2015-02-18 00:32:06 3200 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2015-02-18 00:32:06 3200 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2015-02-18 00:32:06 3200 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2015-02-18 00:32:06 3200 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2015-02-18 00:32:06 3200 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2015-02-18 00:32:06 3200 [Note] Shutting down plugin 'INNODB_METRICS'
2015-02-18 00:32:06 3200 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2015-02-18 00:32:06 3200 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2015-02-18 00:32:06 3200 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2015-02-18 00:32:06 3200 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2015-02-18 00:32:06 3200 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2015-02-18 00:32:06 3200 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2015-02-18 00:32:06 3200 [Note] Shutting down plugin 'INNODB_CMPMEM'
2015-02-18 00:32:06 3200 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2015-02-18 00:32:06 3200 [Note] Shutting down plugin 'INNODB_CMP'
2015-02-18 00:32:06 3200 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2015-02-18 00:32:06 3200 [Note] Shutting down plugin 'INNODB_LOCKS'
2015-02-18 00:32:06 3200 [Note] Shutting down plugin 'INNODB_TRX'
2015-02-18 00:32:06 3200 [Note] Shutting down plugin 'InnoDB'
2015-02-18 00:32:06 3200 [Note] InnoDB: FTS optimize thread exiting.
2015-02-18 00:32:06 3200 [Note] InnoDB: Starting shutdown...
2015-02-18 00:32:08 3200 [Note] InnoDB: Shutdown completed; log sequence number 1665254
2015-02-18 00:32:08 3200 [Note] Shutting down plugin 'BLACKHOLE'
2015-02-18 00:32:08 3200 [Note] Shutting down plugin 'ARCHIVE'
2015-02-18 00:32:08 3200 [Note] Shutting down plugin 'MRG_MYISAM'
2015-02-18 00:32:08 3200 [Note] Shutting down plugin 'MyISAM'
2015-02-18 00:32:08 3200 [Note] Shutting down plugin 'MEMORY'
2015-02-18 00:32:08 3200 [Note] Shutting down plugin 'CSV'
2015-02-18 00:32:08 3200 [Note] Shutting down plugin 'sha256_password'
2015-02-18 00:32:08 3200 [Note] Shutting down plugin 'mysql_old_password'
2015-02-18 00:32:08 3200 [Note] Shutting down plugin 'mysql_native_password'
2015-02-18 00:32:08 3200 [Note] Shutting down plugin 'binlog'
2015-02-18 00:32:08 3200 [Note] C:\xampp\mysql\bin\mysqld: Shutdown complete

2015-02-18 00:33:37 3216 [Note] Plugin 'FEDERATED' is disabled.
2015-02-18 00:33:37 3216 [Warning] The option innodb (skip-innodb) is deprecated and will be removed in a future release
2015-02-18 00:33:37 3216 [Note] Plugin 'InnoDB' is disabled.
2015-02-18 00:33:37 3216 [ERROR] C:\xampp\mysql\bin\mysqld: unknown variable 'master-host=dwmprohosting'
2015-02-18 00:33:37 3216 [ERROR] Aborting

2015-02-18 00:33:37 3216 [Note] Binlog end
2015-02-18 00:33:37 3216 [Note] Shutting down plugin 'partition'
2015-02-18 00:33:37 3216 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2015-02-18 00:33:37 3216 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2015-02-18 00:33:37 3216 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2015-02-18 00:33:37 3216 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2015-02-18 00:33:37 3216 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2015-02-18 00:33:37 3216 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2015-02-18 00:33:37 3216 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2015-02-18 00:33:37 3216 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2015-02-18 00:33:37 3216 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2015-02-18 00:33:37 3216 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2015-02-18 00:33:37 3216 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2015-02-18 00:33:37 3216 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2015-02-18 00:33:37 3216 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2015-02-18 00:33:37 3216 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2015-02-18 00:33:37 3216 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2015-02-18 00:33:37 3216 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2015-02-18 00:33:37 3216 [Note] Shutting down plugin 'INNODB_METRICS'
2015-02-18 00:33:37 3216 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2015-02-18 00:33:37 3216 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2015-02-18 00:33:37 3216 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2015-02-18 00:33:37 3216 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2015-02-18 00:33:37 3216 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2015-02-18 00:33:37 3216 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2015-02-18 00:33:37 3216 [Note] Shutting down plugin 'INNODB_CMPMEM'
2015-02-18 00:33:37 3216 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2015-02-18 00:33:37 3216 [Note] Shutting down plugin 'INNODB_CMP'
2015-02-18 00:33:37 3216 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2015-02-18 00:33:37 3216 [Note] Shutting down plugin 'INNODB_LOCKS'
2015-02-18 00:33:37 3216 [Note] Shutting down plugin 'INNODB_TRX'
2015-02-18 00:33:37 3216 [Note] Shutting down plugin 'BLACKHOLE'
2015-02-18 00:33:37 3216 [Note] Shutting down plugin 'ARCHIVE'
2015-02-18 00:33:37 3216 [Note] Shutting down plugin 'MRG_MYISAM'
2015-02-18 00:33:37 3216 [Note] Shutting down plugin 'MyISAM'
2015-02-18 00:33:37 3216 [Note] Shutting down plugin 'MEMORY'
2015-02-18 00:33:37 3216 [Note] Shutting down plugin 'CSV'
2015-02-18 00:33:37 3216 [Note] Shutting down plugin 'sha256_password'
2015-02-18 00:33:37 3216 [Note] Shutting down plugin 'mysql_old_password'
2015-02-18 00:33:37 3216 [Note] Shutting down plugin 'mysql_native_password'
2015-02-18 00:33:37 3216 [Note] Shutting down plugin 'binlog'
2015-02-18 00:33:37 3216 [Note] C:\xampp\mysql\bin\mysqld: Shutdown complete


I need a lot of help my business depends on this.
by DwMProHosting
18. February 2015 01:38
 
Forum: MySQL
Topic: MYSQL Wont even start please help
Replies: 1
Views: 424
PreviousNext

Return to advanced search