I worked with MySql 4.0.13 last week and saw some features of SQL had been added to 4.1.0 and though I could run multiple versions. I had a long thread on the general tab which ended up in me having to de-install 4.0.13 and I am attempting to re-install that and install 4.1.0 for the first time. (My next task is to upgrade to 4.0.14 as I see they have incremented the production version to 4.0.14, but first I want to see if I can still access the old databases! First things first!)

Anyway I was going through section 2.1 of the new manual and got to 2.1.3.1 where I am to start the server for the first time. Below is a listing of what happened. It is slightly different from the output in the manual. More importantly system has hung.

Details (Thanks Paul!)

I am running Windows 2000, Version 5.0 (build 2195, Service Pack 2) (In case it matters, I have about 20 GB available on my 40GB hard drive and 192MB of RAM. I haven't invoked mysql yet, so I don't use any options as yet. 4.0.13 is in folder C:\mysql-4.0.13 extracted with the setup utility provided. 4.1.0 was simply extracted to folder C:\mysql-4.1.0.

C:\my.cnf is as follows:

# options for default service (MySql) [mysqld] basedir = C:/mysql-4.0.13/mysql port = 3306

#options for default service (mysqld2) [mysqld2] basedir = c:/mysql-4.1.0/mysql port = 3307 protocol = mypipe2

C:\my-opts1 is as follows:

[mysqld] basedir = C:/mysql-4.0.13/mysql datadir = C:/mysql-4.0.13/mysql/data port = 3306

C:\my-opts2.cnf is as follows:

[mysqld2] basedir = C:/mysql-4.1.0/mysql datadir = C:/mysql-4.1.0/mysql/data port = 3307 protocol = mypipe2

I noticed a mysql.opt and it has (I didn't create this so I don't know if it was part of the setup file, so I don't know where to find the file: \.mysql_history or if it is pointing to the right directory) :

# Options file generated by MySQL client

user=root host=localhost port=3306 num_of_queries=100 timeout=60 defbase= socket= queries_file=/.mysql_history queries_root= last_database_file= terminator=, enclose=' password=1 compress=0 ask=1 max_width=50 update_timeout= 10.00 font_used= style_file=

and C:\WINNT\my.ini is a very elegant ;-):

[WinMySQLAdmin] Server=C:/mysql-4.0.13/mysql/bin/mysqld.exe

Output from the "console"

C:\mysql-4.0.13\mysql\bin>mysqld --console InnoDB: The first specified data file .\ibdata1 did not exist: InnoDB: a new database to be created! 030724 11:03:09 InnoDB: Setting file .\ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait... 030724 11:03:11 InnoDB: Log file .\ib_logfile0 did not exist: new to be created

InnoDB: Setting log file .\ib_logfile0 size to 5 MB InnoDB: Database physically writes the file full: wait... 030724 11:03:12 InnoDB: Log file .\ib_logfile1 did not exist: new to be created

InnoDB: Setting log file .\ib_logfile1 size to 5 MB InnoDB: Database physically writes the file full: wait... InnoDB: Doublewrite buffer not found: creating new InnoDB: Doublewrite buffer created InnoDB: Creating foreign key constraint system tables InnoDB: Foreign key constraint system tables created 030724 11:03:34 InnoDB: Started mysqld: ready for connections. Version: '4.0.13-max-debug' socket: '' port: 3306

Thanks for any assistance!