The InnoDB is the XAMPP database engine and it seems to not

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

The InnoDB is the XAMPP database engine and it seems to not

Postby barbara-nj » 02. February 2016 13:57

I have been trying to use an Adobe Dreamweaver Extension with XAMPP to create a WordPress site, which requires a MYSQL database. It appears that the database cannot be created. Below is the MYSQL errorlog that I received. Appreciate help. Thanks

2015-11-10 15:26:56 10fc 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-11-10 15:26:56 4348 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2015-11-10 15:26:56 4348 [Note] InnoDB: The InnoDB memory heap is disabled
2015-11-10 15:26:56 4348 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-11-10 15:26:56 4348 [Note] InnoDB: Memory barrier is not used
2015-11-10 15:26:56 4348 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-11-10 15:26:56 4348 [Note] InnoDB: Not using CPU crc32 instructions
2015-11-10 15:26:56 4348 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2015-11-10 15:26:56 4348 [Note] InnoDB: Completed initialization of buffer pool
2015-11-10 15:26:56 4348 [Note] InnoDB: Highest supported file format is Barracuda.
2015-11-10 15:26:57 4348 [Note] InnoDB: 128 rollback segment(s) are active.
2015-11-10 15:26:57 4348 [Note] InnoDB: Waiting for purge to start
2015-11-10 15:26:57 4348 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.26-74.0 started; log sequence number 1835027
2015-11-10 15:26:57 6140 [Note] InnoDB: Dumping buffer pool(s) not yet started
2015-11-10 15:26:57 4348 [Note] Plugin 'FEEDBACK' is disabled.
2015-11-10 15:26:57 4348 [Note] Server socket created on IP: '::'.
2015-11-10 15:26:57 4348 [Note] Event Scheduler: Loaded 0 events
2015-11-10 15:26:57 4348 [Note] C:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '10.1.8-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
2015-11-10 15:27:11 5152 [Note] C:\xampp\mysql\bin\mysqld.exe: Normal shutdown

2015-11-10 15:27:11 5152 [Note] Event Scheduler: Purging the queue. 0 events
2015-11-10 15:27:11 5732 [Note] InnoDB: FTS optimize thread exiting.
2015-11-10 15:27:11 5152 [Note] InnoDB: Starting shutdown...
2015-11-10 15:27:13 5152 [Note] InnoDB: Shutdown completed; log sequence number 1835037
2015-11-10 15:27:13 5152 [Note] C:\xampp\mysql\bin\mysqld.exe: Shutdown complete

2016-02-01 12:18:42 c64 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.
2016-02-01 12:18:42 3172 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-02-01 12:18:42 3172 [Note] InnoDB: The InnoDB memory heap is disabled
2016-02-01 12:18:42 3172 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-02-01 12:18:42 3172 [Note] InnoDB: Memory barrier is not used
2016-02-01 12:18:42 3172 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-02-01 12:18:42 3172 [Note] InnoDB: Not using CPU crc32 instructions
2016-02-01 12:18:42 3172 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-02-01 12:18:42 3172 [Note] InnoDB: Completed initialization of buffer pool
2016-02-01 12:18:43 3172 [Note] InnoDB: Highest supported file format is Barracuda.
2016-02-01 12:18:43 3172 [Note] InnoDB: 128 rollback segment(s) are active.
2016-02-01 12:18:43 3172 [Note] InnoDB: Waiting for purge to start
2016-02-01 12:18:43 3172 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.26-74.0 started; log sequence number 1835037
2016-02-01 12:18:44 3196 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-02-01 12:18:44 3172 [Note] Plugin 'FEEDBACK' is disabled.
2016-02-01 12:18:44 3172 [Note] Server socket created on IP: '::'.
2016-02-01 12:18:44 3172 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '10.1.9-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
barbara-nj
 
Posts: 8
Joined: 30. March 2015 16:44
Operating System: windows 7

Re: The InnoDB is the XAMPP database engine and it seems to

Postby Nobbie » 02. February 2016 14:28

There is no error.

barbara-nj wrote:It appears that the database cannot be created.


We cannot do anything without knowing the error message.
Nobbie
 
Posts: 13183
Joined: 09. March 2008 13:04

Re: The InnoDB is the XAMPP database engine and it seems to

Postby barbara-nj » 02. February 2016 23:37

Ok, let me go into a further explanation and see where we go.

I am using a Adobe Dreamweaver extension called "WP site designer" which requires the installation of XAMPP to be able to run php on the computer while developing a WordPress site. It starts out with a form that collects information such as you would submit on a webhost to install an instance of WordPress and creates a database. The WordPress site, in this case was created, but the database was not. I sent the XAMPP logs for the Apache and Mysql error logs to the extension developer along with the information that the process had created the WordPress site but when I tried to start WordPress the message said that the database did not exist. They said the mysql error log indicated that there was problem with xampp in creating the database and that I should send the contents of the error log here. I did call up phpmyadmin to veryify that the database was not created.

Here is the error message after I tried to create Wordpress and database
Can’t select database

We were able to connect to the database server (which means your username and password is okay) but not able to select the wp-1 database.

Are you sure it exists?
Does the user root have permission to use the wp-1 database?
On some systems the name of your database is prefixed with your username, so it would be likeusername_wp-1. Could that be the problem?


So where do I go from here?
barbara-nj
 
Posts: 8
Joined: 30. March 2015 16:44
Operating System: windows 7

Re: The InnoDB is the XAMPP database engine and it seems to

Postby Nobbie » 02. February 2016 23:42

Obviuosly, you specified a database (wp-1) which does not exist.

barbara-nj wrote: did call up phpmyadmin to veryify that the database was not created.


Yes, of course not. You have to create that database in phpmyadmin and after you apply the database name to wordpress.
Last edited by Nobbie on 03. February 2016 10:44, edited 1 time in total.
Nobbie
 
Posts: 13183
Joined: 09. March 2008 13:04

Re: The InnoDB is the XAMPP database engine and it seems to

Postby barbara-nj » 03. February 2016 00:13

IOT, the database has to be created manually
barbara-nj
 
Posts: 8
Joined: 30. March 2015 16:44
Operating System: windows 7

Re: The InnoDB is the XAMPP database engine and it seems to

Postby Nobbie » 03. February 2016 10:45

What means "IOT"??
Nobbie
 
Posts: 13183
Joined: 09. March 2008 13:04

Re: The InnoDB is the XAMPP database engine and it seems to

Postby barbara-nj » 03. February 2016 15:03

Sorry,IOT should have been IOW - in other words

In other words, I have to create the database manually. It can't be created through an executive program.
barbara-nj
 
Posts: 8
Joined: 30. March 2015 16:44
Operating System: windows 7


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 126 guests