Problems with installing MySQL onto PC

jesta

jesta

jesta

Soldato
Joined
19 Dec 2004
Posts
3,887
I tried to install MySQL server onto my PC but it doesn't seem to install properly, when executing during the MySQL Server Instance Config it always fails opensing the Service(or something similar) does anyone know why?

Also how comes MySQL 5 dosen't have WinMySQLadmin like it had in MySQL4? Do you know where I can download that?

Thanks
 
On the processes it doesn't show MySQL is started.

Do I view the log by opening mysqld? Cos I tried that and it opens then closes straight away. :confused:
 
There should be a mysqld-nt (IIRC) service running, try heading to Control Panel>Administrative Tools>Services.. look for the MySQL entry, start it if it isn't started.

Also look in Event Viewer to see if there are any untoward notifications in there :)
 
The error log file should be located in the data directory where you installed mysql ({HOME}/var/mysql).

The file name should be of the form 'hostname.err' and 'hostname.log', where hostname is the name of the server host.
 
From opening the file ending with .err I got this log:
InnoDB: The first specified data file .\ibdata1 did not exist:
InnoDB: a new database to be created!
061208 0:35:05 InnoDB: Setting file .\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
061208 0:35:05 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...
061208 0:35:06 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
061208 0:35:07 InnoDB: Started; log sequence number 0 0
061208 0:35:14 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt.exe: ready for connections.
Version: '5.0.27-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL)
061208 0:35:53 InnoDB: Operating system error number 32 in a file operation.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/refman/5.0/en/operating-system-error-codes.html
InnoDB: File name .\ibdata1
InnoDB: File operation call: 'open'.
InnoDB: Cannot continue operation.
InnoDB: Error: log file .\ib_logfile0 is of different size 0 5242880 bytes
InnoDB: than specified in the .cnf file 0 10485760 bytes!
070102 11:53:15 [ERROR] Default storage engine (InnoDB) is not available
070102 11:53:15 [ERROR] Aborting

070102 11:53:15 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete

InnoDB: Error: log file .\ib_logfile0 is of different size 0 5242880 bytes
InnoDB: than specified in the .cnf file 0 10485760 bytes!
070102 11:57:45 [ERROR] Default storage engine (InnoDB) is not available
070102 11:57:45 [ERROR] Aborting

070102 11:57:45 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete

InnoDB: Error: log file .\ib_logfile0 is of different size 0 5242880 bytes
InnoDB: than specified in the .cnf file 0 10485760 bytes!
070102 12:03:08 [ERROR] Default storage engine (InnoDB) is not available
070102 12:03:08 [ERROR] Aborting

070102 12:03:08 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete

Thanks
 
C:\Program Files\MySQL\MySQL Server 5.0\data

Delete any log files in that directory.

Also check task manager and ensure that there are no mysql processes running. Kill any that are. You had an error 32 which means that a process was already accessing a file the new process needed.
 
Ok deleted it,do I open MySQL Server Instance Config again and try and see if it works?

Going to work now,so will reply later on.

Thanks so far guys.
 
Open a command line (type 'cmd' in the windows run dialogue box).

Start the server using

"C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld" --console

You should get a load of startup messages in the console. If you have more problems, paste that output here.
 
When I typed that into the command prompt it comes out with the error:
'C:\Program' is not recognized as an internal or external command, operable program or batch file.

Any ideas?This is getting a bit annoying now.lol
 
jesta said:
:o

Just typed that in command prompt but it doesn't show any startup messages at all.What does this mean?
Click to expand...

That is very worrying! You should get some sort of console message... either the command can't be found, the server starting up, or the server failing to start!

May i suggest uninstalling mysql and then I'll walk you through a clean install.
 
Wimnat said:
That is very worrying! You should get some sort of console message... either the command can't be found, the server starting up, or the server failing to start!

May i suggest uninstalling mysql and then I'll walk you through a clean install.
Click to expand...
I've given up on installing it on my laptop now, install it onto my main pc and it worked without a hitch. Which is weird.

Thanks for the help anyways,much appreciated. :)
 
You must log in or register to reply here.
Back
Top Bottom