Heidi SQL Error 1067[SOLVED]

[Tichater]

Heyas all!
I was wondering if anyone can help me with this problem.
I was connected to my server the other day. However today when I tried to connect to the DB i get this error; Windows could not start the MySQL5 service on Local Computer.
Error 1067: The process terminated unexpectedly.

Thanks in advance for any help!

and this is when i try to start the service.

[Tichater]

this is the dialog box that pops up when i try to connect.

and this is in the error file.
but i cant find heap in the my.ini at all!


130609 12:21:14 [Note] Plugin 'FEDERATED' is disabled.
130609 12:21:15 InnoDB: The InnoDB memory heap is disabled
130609 12:21:15 InnoDB: Mutexes and rw_locks use Windows interlocked functions
130609 12:21:15 InnoDB: Compressed tables use zlib 1.2.3
130609 12:21:15 InnoDB: Initializing buffer pool, size = 107.0M
130609 12:21:15 InnoDB: Completed initialization of buffer pool
InnoDB: The first specified data file .\ibdata1 did not exist:
InnoDB: a new database to be created!
130609 12:21:15 InnoDB: Setting file .\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
130609 12:21:15 InnoDB: Log file .\ib_logfile0 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile0 size to 54 MB
InnoDB: Database physically writes the file full: wait...
130609 12:21:16 InnoDB: Log file .\ib_logfile1 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile1 size to 54 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: 127 rollback segment(s) active.
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
130609 12:21:18 InnoDB: Waiting for the background threads to start
130609 12:21:19 InnoDB: 1.1.8 started; log sequence number 0
130609 12:21:19 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
130609 12:21:19 [Note] - '0.0.0.0' resolves to '0.0.0.0';
130609 12:21:19 [Note] Server socket created on IP: '0.0.0.0'.
130609 12:21:19 [Note] Event Scheduler: Loaded 0 events
130609 12:21:19 [Note] C:\Program Files (x86)\MySQL

[Tolakram]

Your database file is missing, did you move it? Your disk might also be full, I can't tell from the message. Heidi is a client tool, not a server. The errors you posted look to be MySQL startup errors.

[Graveen]

Don't you have another MySQL server running, ie did you installed DOLSetup.exe before MySQL server ? If yes, you must uninstall DOLSetup (or use the embedded MYSQL server)

[HunabKu]

To have the real error(s) message(s) :
- open command prompt

Code: Select all

win+R

Code: Select all

cmd

- and open you mysql bin directory

Code: Select all

cd C:\Program Files (x86)\MySQL\bin

- Finaly launch the daemon

Code: Select all

mysqld.exe

You will see the error(s) message(s)

[Tichater]

@Tolakram no nothing was moved. (not by me manually) drive has PLENTY of space. MySQL isnt running it wont! ive ran EVERY .exe in its folder! only the instance creator works.

@Graveen I never did anything with any DOLSetup. i downloaded navicat and imported my old DB that worked fine until the free trial ran out. then i uninstalled navicat and installed heidi and that opened fine! and after installing the drivers to sim unlock my phone i tethered my phone and thats when it wouldnt open. a few days prior is last time i used it. it was ok.

@HunabKu i did all that and after mysqld.exe there was nothing. ill post a pic.

[Argo]

you might wanna deinstall your mysql and install mysql and mysql credentials again. then create a new mysql instance and it should work fine.

regards
Argo

[HunabKu]

Do you use the autobuild DoLServer Package or do you install MySQL apart ?

[Graveen]

Same advice than Argo. I had troubles with some versions of MySQL. Uninstall all, reboot, reinstall can help

[Graveen]

Same advice than Argo. I had troubles with some versions of MySQL. Uninstall all, reboot, reinstall can help