Hi!
We have noticed some mails posted by Windows users having problem
in the first start of mysqld.exe on Windows platforms. Then, below
the explanations how to avoid the problems reported:
1- According with our MySQL-Max download page is noticed that the
regular distribution 3.23.38, contains the MySQL-Max stuff.
The MySQL-Max stuff has additional features:
- Support for transactions with two types of tables: InnoDB and
BDB.
- Support for symbolic links to have databases on another place
than the default one.
- The servers which have the MySQL-Max support are:
mysqld.exe
mysqld-max.exe
mysqld-max-nt.exe
2- When the MySQL-Max servers are started, the InnoBD routines tries
to found the paths for its data and log files. When aren't specified
that data on the \my.cnf or \WindDir\my.ini file, the server launches
the following warning message:
Can't initialize InnoDB as 'innodb_data_file_path' is not set
The above means that the InnoDB tables are disabled, however the
server is ready for the others tables.
C:\mysql\bin>mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 3.23.38-max
Type 'help;' or '\h' for help. Type '\c' to clear the buffer
mysql> show variables like "have_innodb";
+---------------+----------+
| Variable_name | Value |
+---------------+----------+
| have_innodb | DISABLED |
+---------------+----------+
1 row in set (0.05 sec)
If you don't want the InnoDB tables support and to avoid the above
warning message, you could create the \my.cnf or \WindDir\my.ini file
and add the below variable:
[mysqld]
skip-innodb
Otherwise if you want the InnoDB tables support, you need to read in
our Manual how to prepare the configuration file. Below the
preliminaries instructions:
- Create the log and data directories, for example: c:\ibdata and
c:\iblogs.
- Create the configuration file and edit the variables according
with the Manual instructions. Notice that the sizes of the files
can't exceed 2000M.
- Start the server and you will see, the messages that InnoDB are
creating the files:
C:\mysql\bin>mysqld-max --standalone
InnoDB: The first specified data file c:\ibdata\ibdata1 did not
exist:
InnoDB: a new database to be created!
InnoDB: Setting file c:\ibdata\ibdata1 size to 26214400
InnoDB: Database physically writes the file full: wait...
InnoDB: Data file c:\ibdata\ibdata2 did not exist: new to be created
InnoDB: Setting file c:\ibdata\ibdata2 size to 38797312
InnoDB: Database physically writes the file full: wait...
InnoDB: Data file c:\ibdata\ibdata3 did not exist: new to be created
InnoDB: Setting file c:\ibdata\ibdata3 size to 104857600
InnoDB: Database physically writes the file full: wait...
InnoDB: Data file c:\ibdata\ibdata4 did not exist: new to be created
InnoDB: Setting file c:\ibdata\ibdata4 size to 314572800
InnoDB: Database physically writes the file full: wait...
InnoDB: Log file c:\iblogs\ib_logfile0 did not exist: new to be
created
InnoDB: Setting log file c:\iblogs\ib_logfile0 size to 5242880
InnoDB: Log file c:\iblogs\ib_logfile1 did not exist: new to be
created
InnoDB: Setting log file c:\iblogs\ib_logfile1 size to 5242880
InnoDB: Log file c:\iblogs\ib_logfile2 did not exist: new to be
created
InnoDB: Setting log file c:\iblogs\ib_logfile2 size to 5242880
InnoDB: Started
Notice that you can to start the server as service on WinNT and
Win2k OSs. The server should be used is the mysqld-max-nt.exe
3- The mysqld.exe on Win9x
How mentioned above, this server has the Max stuff, however on the
3.23.38 distribution was compiled with the InnoDB library with a
pre-processor define option for NT platform, which cause a handle
exception when tries to create the data and log files.
If you want to use InnoDB tables on Win9x, use instead the mysqld-max.exe
server.
Also this server doesn't has the symbolic link support.
Those problem already are fixed and in the next release, the mysqld.exe
should be able to run on Win9x with the InnoDB and symbolic link supports.
4- Using Symbolic Links
To use this support we explains it with a sample:
Do you want a database called mylink on the d:\mydata directory.
First create on \mysql\data directory a file called mylink.sym.
Edit this file with the text: d:\mydata\mylink\
Notice the trailing backlash in the end of the path. This is important
only in the 3.23.38 distribution. In the next MySQL release will added
code to handle a path like: d:\mydata\mylink
Create the directory d:\mydata\mylink
Add to configuration file the variable use-symbolic-links. If you
aren't starting the server as service you should use the
--use-symbolic-links as parameter in the command line.
Regards,
Miguel
__ ___ ________ __
/ |/ /_ __/ __/ __ \/ / http://www.mysql.com/
/ /|_/ / // /\ \/ /_/ / /__ Miguel Solórzano <[EMAIL PROTECTED]>
/_/ /_/\_, /___/\___\_\___/ Săo Paulo, Brazil
<___/ Development Team
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
