| Author |
|
ArtM
Joined: 23 Feb 2006
Posts: 59
Location: Bedford NS Canada
|
 Posted: Thu 02 Feb '12 2:08 Post subject: MySQL 5.5.20 Win32 Won't start & Run |
 |
|
I'm trying to re-setup Apache+PHP+Perl+Mysql
Having troubles getting MySQL 5.5.20 to run.
I don't want Innodb & put skip-innodb in my.ini.
Error Log shows:
120201 19:29:13 [Note] Plugin 'FEDERATED' is disabled.
120201 19:29:13 [Note] Plugin 'InnoDB' is disabled.
120201 19:29:13 [ERROR] Unknown/unsupported storage engine: InnoDB
120201 19:29:13 [ERROR] Aborting
120201 19:29:13 [Note] mysqld: Shutdown complete
MySQL won't start.
I've un-commented the skip & Innodb lines in my.ini,
and it STILL complains about Innodb !
Exactly the same error messages.
I've searched for any other My.ini that might take precedence - none. Removed & re-installed Mysqld.exe
Any thoughts towards getting MySQL up & running ?? |
|
| Back to top |
|
Kanashii
Joined: 17 Jul 2006
Posts: 155
Location: Porando
|
| Posted: Thu 02 Feb '12 17:59 Post subject: |
|
|
For windows i better 5.1...
I using 5.5 and its only problems crash etc |
|
| Back to top |
|
Smitty
Joined: 03 Jan 2008
Posts: 197
|
| Posted: Thu 02 Feb '12 18:44 Post subject: |
|
|
| I've been running 5.5 since it's release on Windows and it works great. Never a single crash. Rock solid. |
|
| Back to top |
|
ArtM
Joined: 23 Feb 2006
Posts: 59
Location: Bedford NS Canada
|
| Posted: Thu 02 Feb '12 20:08 Post subject: |
|
|
| Quote: | | I've been running 5.5 since it's release on Windows and it works great. Never a single crash. Rock solid. |
OK Smitty - want to share the secrets of your success ?! Did you do anything special to get it running - my.ini mods, startup sequences, etc. . . . . |
|
| Back to top |
|
ArtM
Joined: 23 Feb 2006
Posts: 59
Location: Bedford NS Canada
|
| Posted: Thu 02 Feb '12 20:14 Post subject: |
|
|
PS - James Blond - your link for MySQL - and other components setup - is a little out of date:
http://www.apachelounge.com/viewtopic.php?p=10613
I changed the mysqld-nt to mysqld & followed the rest. No luck. |
|
| Back to top |
|
admin
Site Admin
Joined: 15 Oct 2005
Posts: 693
|
| Posted: Thu 02 Feb '12 20:33 Post subject: |
|
|
Remove all parameters in my.ini with the word inno in it, except the skip one.
Steffen |
|
| Back to top |
|
Smitty
Joined: 03 Jan 2008
Posts: 197
|
| Posted: Thu 02 Feb '12 21:26 Post subject: |
|
|
I have a basic my.ini file. I do use innoDB.
I originally installed from the x64 ZIP version. I installed the service via the command line using these instructions:
http://dev.mysql.com/doc/refman/5.5/en/windows-start-service.html
On my server, to install the service at the command line:
| Code: | | mysqld --install MySQL --defaults-file=c:\mysql\my.ini |
Here are my my.ini contents:
| Code: |
port=3306
[mysql]
default-character-set=utf8
[mysqld]
max_allowed_packet=8M
port=3306
basedir="C:/mysql/"
datadir="C:/mysql/data/"
character-set-server=utf8
default-storage-engine=INNODB
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
max_connections=410
query_cache_size=297M
table_cache=620
tmp_table_size=600M
thread_cache_size=8
#MyISAM Specific options
myisam_max_sort_file_size=100G
myisam_sort_buffer_size=599M
key_buffer_size=468M
read_rnd_buffer_size=256K
sort_buffer_size=256K
#INNODB Specific options
innodb_data_home_dir="C:/mysql/data/"
innodb_additional_mem_pool_size=22M
innodb_flush_log_at_trx_commit=2
innodb_log_buffer_size=4M
innodb_buffer_pool_size=4G
innodb_log_file_size=256M
innodb_thread_concurrency=8
|
Make sure the above paths exist before starting the service, of course. Also, be sure to change the root password immediately after starting the service since the default root password is blank. |
|
| Back to top |
|
James Blond
Moderator
Joined: 19 Jan 2006
Posts: 7377
Location: Germany, Next to Hamburg
|
| Posted: Fri 03 Feb '12 10:22 Post subject: |
|
|
You are the first one complaining. I'll check that how to and overdo it. The href (link) to MySQL download page is still working. Or do you mean something different that link? |
|
| Back to top |
|
ArtM
Joined: 23 Feb 2006
Posts: 59
Location: Bedford NS Canada
|
| Posted: Sat 04 Feb '12 6:33 Post subject: |
|
|
James - No - just the name mysql-nt to mysqld.
(Though I still can't get MySQL running !) |
|
| Back to top |
|
James Blond
Moderator
Joined: 19 Jan 2006
Posts: 7377
Location: Germany, Next to Hamburg
|
| Posted: Sat 04 Feb '12 12:24 Post subject: |
|
|
| Had 'nt seen it yesterday, but you have to change the default storage engine |
|
| Back to top |
|
ArtM
Joined: 23 Feb 2006
Posts: 59
Location: Bedford NS Canada
|
| Posted: Sat 04 Feb '12 22:01 Post subject: |
|
|
| Quote: | | Had 'nt seen it yesterday, but you have to change the default storage engine |
Bingo !
It seems my old version 5.0.18 of MySQL defaulted to MyIsam as the storage engine. V 5.5.20 defaults to Innodb.
Added lines to My.INI :
skip-innodb
default-storage-engine=MyISAM
And MySQL starts fine.
Thnx for the tip James. |
|
| Back to top |
|
