If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > MySQL > MYSQL Wont install

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 06-18-11, 15:18
TheGateKeeper TheGateKeeper is offline
Registered User
 
Join Date: Jun 2011
Posts: 63
MYSQL Wont install

Hi guys, im having trouble installing MYSQL. Everything goes fine but at the end it says there was a problem creating the instance.

How do i fix this?

Thanks!
Reply With Quote
  #2 (permalink)  
Old 06-18-11, 16:20
healdem healdem is offline
Jaded Developer
 
Join Date: Nov 2004
Location: out on a limb
Posts: 9,250
smartest call, especially if you are not especially experienced in installing MySQL and the like is to consider using a pre packaged installer such as XAMPP
__________________
I'd rather be riding my Versys or my Tiger 800 let alone the Norton
Reply With Quote
  #3 (permalink)  
Old 06-19-11, 04:59
TheGateKeeper TheGateKeeper is offline
Registered User
 
Join Date: Jun 2011
Posts: 63
Anyone?

Need this to work...
Reply With Quote
  #4 (permalink)  
Old 06-19-11, 05:50
TheGateKeeper TheGateKeeper is offline
Registered User
 
Join Date: Jun 2011
Posts: 63
Quote:
Originally Posted by healdem View Post
smartest call, especially if you are not especially experienced in installing MySQL and the like is to consider using a pre packaged installer such as XAMPP
Sint XAMPP an apache variation?

Why does it give me that error?
Reply With Quote
  #5 (permalink)  
Old 06-19-11, 06:00
it-iss.com it-iss.com is offline
Registered User
 
Join Date: Sep 2009
Location: San Sebastian, Spain
Posts: 620
On what platform are you installing? Windows/Linux? Also what message appeared at the end to indicate a problem?
__________________
Ronan Cashell
Senior Oracle/MySQL DBA
http://www.it-iss.com
Reply With Quote
  #6 (permalink)  
Old 06-19-11, 15:31
TheGateKeeper TheGateKeeper is offline
Registered User
 
Join Date: Jun 2011
Posts: 63
Quote:
Originally Posted by it-iss.com View Post
On what platform are you installing? Windows/Linux? Also what message appeared at the end to indicate a problem?
http://img546.imageshack.us/img546/3419/unlffffed.jpg

Here is what it says....
Reply With Quote
  #7 (permalink)  
Old 06-19-11, 17:22
healdem healdem is offline
Jaded Developer
 
Join Date: Nov 2004
Location: out on a limb
Posts: 9,250
check the log file for MySQL, that should tell you why its failing
__________________
I'd rather be riding my Versys or my Tiger 800 let alone the Norton
Reply With Quote
  #8 (permalink)  
Old 06-20-11, 12:31
TheGateKeeper TheGateKeeper is offline
Registered User
 
Join Date: Jun 2011
Posts: 63
Quote:
Originally Posted by healdem View Post
check the log file for MySQL, that should tell you why its failing
I cant find the log file, where is it?
Reply With Quote
  #9 (permalink)  
Old 06-20-11, 12:52
healdem healdem is offline
Jaded Developer
 
Join Date: Nov 2004
Location: out on a limb
Posts: 9,250
__________________
I'd rather be riding my Versys or my Tiger 800 let alone the Norton
Reply With Quote
  #10 (permalink)  
Old 06-20-11, 12:59
TheGateKeeper TheGateKeeper is offline
Registered User
 
Join Date: Jun 2011
Posts: 63
Quote:
Originally Posted by healdem View Post
Yes i tried that before i asked here, and i still cant find it. The command prompt wont work neither.
Reply With Quote
  #11 (permalink)  
Old 06-20-11, 13:32
healdem healdem is offline
Jaded Developer
 
Join Date: Nov 2004
Location: out on a limb
Posts: 9,250
as error messages and warnings are also written tto eh windows event log, check there aswell

so I'd suggest you search for the .err file on your file system.
you should be able to do that using file manager or the black arts of DOS
run an instance of CMD
type dir \*.err /s/w/p
..assuming your installation is on a windows box

if the server is bolluxed then the MySQL command line wont work either

it may bve you need to open the firewall port for MySQL 3306

as said before if you are unfamiliar with installing MySQL then consider using XAMPP. Yes XAMPP co0mes with plenty of baggage, its not just MySQL buit its a pretty complete and fairly painless way of installing MySQL. having said that the last time I downloaded MySQL on a windoiws machine the binary from MySQL worked fine.

I'd suggest you back out your current installation and start again with settings as speicified by MYSQL.. they will be plenty sufficient for development purposes, and leave the configuration of the server on the live system to them what knows
__________________
I'd rather be riding my Versys or my Tiger 800 let alone the Norton
Reply With Quote
  #12 (permalink)  
Old 06-20-11, 13:57
TheGateKeeper TheGateKeeper is offline
Registered User
 
Join Date: Jun 2011
Posts: 63
Found it... here is what it says:

110620 17:48:58 [Note] Plugin 'FEDERATED' is disabled.
110620 17:48:58 InnoDB: The InnoDB memory heap is disabled
110620 17:48:58 InnoDB: Mutexes and rw_locks use Windows interlocked functions
110620 17:48:58 InnoDB: Compressed tables use zlib 1.2.3
110620 17:48:58 InnoDB: Initializing buffer pool, size = 107.0M
110620 17:48:58 InnoDB: Completed initialization of buffer pool
InnoDB: Error: log file .\ib_logfile0 is of different size 0 16777216 bytes
InnoDB: than specified in the .cnf file 0 56623104 bytes!
110620 17:48:58 [ERROR] Plugin 'InnoDB' init function returned error.
110620 17:48:58 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
110620 17:48:58 [ERROR] Unknown/unsupported storage engine: INNODB
110620 17:48:58 [ERROR] Aborting

110620 17:48:58 [Note] C:\Program Files\MySQL\MySQL Server 5.5\bin\mysqld: Shutdown complete
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On