X-Forums

Computer, Games, and Technology

MySQL Error 0

3 posts

  1. -Poe-

    Regular
    Joined: Apr '08
    Posts: 35

    The infamous error Zero. I'm not sure if it's a system permissions error, or a corruption somewhere in my Windows install that's causing it, but I CANNOT GET PAST IT. I've tried every possible solution I could find. I used regedit to ensure that the service was deleted, then uninstalled, deleted, and reinstalled my copy of MySQL 5.0 about 5 times. I've tried Manually starting, and creating said service, but I barely understand how. My .err file shows the following error:

    080404 0:49:30 InnoDB: Log file .\ib_logfile0 did not exist: new to be created
    InnoDB: Setting log file .\ib_logfile0 size to 10 MB
    InnoDB: Database physically writes the file full: wait...
    080404 0:49:30 InnoDB: Log file .\ib_logfile1 did not exist: new to be created
    InnoDB: Setting log file .\ib_logfile1 size to 10 MB
    InnoDB: Database physically writes the file full: wait...
    InnoDB: Cannot initialize created log files because
    InnoDB: data files are corrupt, or new data files were
    InnoDB: created when the database was started previous
    InnoDB: time but the database was not shut down
    InnoDB: normally after that.
    080404 0:49:31 [ERROR] Default storage engine (InnoDB) is not available
    080404 0:49:31 [ERROR] Aborting

    080404 0:49:31 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete

    InnoDB: No valid checkpoint found.
    InnoDB: If this error appears when you are creating an InnoDB database,
    InnoDB: the problem may be that during an earlier attempt you managed
    InnoDB: to create the InnoDB data files, but log file creation failed.
    InnoDB: If that is the case, please refer to
    InnoDB: http://dev.mysql.com/doc/refman/5.0/en/error-creating-innodb.html
    080404 0:58:22 [ERROR] Default storage engine (InnoDB) is not available
    080404 0:58:22 [ERROR] Aborting

    080404 0:58:23 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete

    InnoDB: No valid checkpoint found.
    InnoDB: If this error appears when you are creating an InnoDB database,
    InnoDB: the problem may be that during an earlier attempt you managed
    InnoDB: to create the InnoDB data files, but log file creation failed.
    InnoDB: If that is the case, please refer to
    InnoDB: http://dev.mysql.com/doc/refman/5.0/en/error-creating-innodb.html
    080404 1:01:23 [ERROR] Default storage engine (InnoDB) is not available
    080404 1:01:23 [ERROR] Aborting

    080404 1:01:23 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete

    InnoDB: The first specified data file .\ibdata1 did not exist:
    InnoDB: a new database to be created!
    080404 1:04:28 InnoDB: Setting file .\ibdata1 size to 10 MB
    InnoDB: Database physically writes the file full: wait...
    InnoDB: Error: all log files must be created at the same time.
    InnoDB: All log files must be created also in database creation.
    InnoDB: If you want bigger or smaller log files, shut down the
    InnoDB: database and make sure there were no errors in shutdown.
    InnoDB: Then delete the existing log files. Edit the .cnf file
    InnoDB: and start the database again.
    080404 1:04:28 [ERROR] Default storage engine (InnoDB) is not available
    080404 1:04:28 [ERROR] Aborting

    080404 1:04:28 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete

    InnoDB: No valid checkpoint found.
    InnoDB: If this error appears when you are creating an InnoDB database,
    InnoDB: the problem may be that during an earlier attempt you managed
    InnoDB: to create the InnoDB data files, but log file creation failed.
    InnoDB: If that is the case, please refer to
    InnoDB: http://dev.mysql.com/doc/refman/5.0/en/error-creating-innodb.html
    080404 1:12:19 [ERROR] Default storage engine (InnoDB) is not available
    080404 1:12:19 [ERROR] Aborting

    080404 1:12:19 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete

    InnoDB: No valid checkpoint found.
    InnoDB: If this error appears when you are creating an InnoDB database,
    InnoDB: the problem may be that during an earlier attempt you managed
    InnoDB: to create the InnoDB data files, but log file creation failed.
    InnoDB: If that is the case, please refer to
    InnoDB: http://dev.mysql.com/doc/refman/5.0/en/error-creating-innodb.html
    080404 1:27:21 [ERROR] Default storage engine (InnoDB) is not available
    080404 1:27:21 [ERROR] Aborting

    080404 1:27:21 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete

    InnoDB: No valid checkpoint found.
    InnoDB: If this error appears when you are creating an InnoDB database,
    InnoDB: the problem may be that during an earlier attempt you managed
    InnoDB: to create the InnoDB data files, but log file creation failed.
    InnoDB: If that is the case, please refer to
    InnoDB: http://dev.mysql.com/doc/refman/5.0/en/error-creating-innodb.html
    080404 1:45:23 [ERROR] Default storage engine (InnoDB) is not available
    080404 1:45:23 [ERROR] Aborting

    080404 1:45:23 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete

    InnoDB: No valid checkpoint found.
    InnoDB: If this error appears when you are creating an InnoDB database,
    InnoDB: the problem may be that during an earlier attempt you managed
    InnoDB: to create the InnoDB data files, but log file creation failed.
    InnoDB: If that is the case, please refer to
    InnoDB: http://dev.mysql.com/doc/refman/5.0/en/error-creating-innodb.html
    080404 1:46:04 [ERROR] Default storage engine (InnoDB) is not available
    080404 1:46:04 [ERROR] Aborting

    080404 1:46:04 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete

    InnoDB: No valid checkpoint found.
    InnoDB: If this error appears when you are creating an InnoDB database,
    InnoDB: the problem may be that during an earlier attempt you managed
    InnoDB: to create the InnoDB data files, but log file creation failed.
    InnoDB: If that is the case, please refer to
    InnoDB: http://dev.mysql.com/doc/refman/5.0/en/error-creating-innodb.html
    080404 1:46:22 [ERROR] Default storage engine (InnoDB) is not available
    080404 1:46:22 [ERROR] Aborting

    080404 1:46:22 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete

    InnoDB: No valid checkpoint found.
    InnoDB: If this error appears when you are creating an InnoDB database,
    InnoDB: the problem may be that during an earlier attempt you managed
    InnoDB: to create the InnoDB data files, but log file creation failed.
    InnoDB: If that is the case, please refer to
    InnoDB: http://dev.mysql.com/doc/refman/5.0/en/error-creating-innodb.html
    080404 1:46:33 [ERROR] Default storage engine (InnoDB) is not available
    080404 1:46:33 [ERROR] Aborting

    080404 1:46:33 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete

    InnoDB: The first specified data file C:\MySQL InnoDB Datafiles\ibdata1 did not exist:
    InnoDB: a new database to be created!
    080404 1:52:01 InnoDB: Setting file C:\MySQL InnoDB Datafiles\ibdata1 size to 10 MB
    InnoDB: Database physically writes the file full: wait...
    InnoDB: Error: all log files must be created at the same time.
    InnoDB: All log files must be created also in database creation.
    InnoDB: If you want bigger or smaller log files, shut down the
    InnoDB: database and make sure there were no errors in shutdown.
    InnoDB: Then delete the existing log files. Edit the .cnf file
    InnoDB: and start the database again.
    080404 1:52:01 [ERROR] Default storage engine (InnoDB) is not available
    080404 1:52:01 [ERROR] Aborting

    080404 1:52:01 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete

    InnoDB: No valid checkpoint found.
    InnoDB: If this error appears when you are creating an InnoDB database,
    InnoDB: the problem may be that during an earlier attempt you managed
    InnoDB: to create the InnoDB data files, but log file creation failed.
    InnoDB: If that is the case, please refer to
    InnoDB: http://dev.mysql.com/doc/refman/5.0/en/error-creating-innodb.html
    080404 2:12:16 [ERROR] Default storage engine (InnoDB) is not available
    080404 2:12:16 [ERROR] Aborting

    080404 2:12:16 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete

    InnoDB: No valid checkpoint found.
    InnoDB: If this error appears when you are creating an InnoDB database,
    InnoDB: the problem may be that during an earlier attempt you managed
    InnoDB: to create the InnoDB data files, but log file creation failed.
    InnoDB: If that is the case, please refer to
    InnoDB: http://dev.mysql.com/doc/refman/5.0/en/error-creating-innodb.html
    080404 2:14:06 [ERROR] Default storage engine (InnoDB) is not available
    080404 2:14:06 [ERROR] Aborting

    080404 2:14:06 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete

    InnoDB: No valid checkpoint found.
    InnoDB: If this error appears when you are creating an InnoDB database,
    InnoDB: the problem may be that during an earlier attempt you managed
    InnoDB: to create the InnoDB data files, but log file creation failed.
    InnoDB: If that is the case, please refer to
    InnoDB: http://dev.mysql.com/doc/refman/5.0/en/error-creating-innodb.html
    080404 2:15:39 [ERROR] Default storage engine (InnoDB) is not available
    080404 2:15:39 [ERROR] Aborting

    080404 2:15:39 [Note] C:\PROGRA~1\MySQL\MYSQLS~1.0\bin\MYSQLD~2.EXE: Shutdown complete

    InnoDB: No valid checkpoint found.
    InnoDB: If this error appears when you are creating an InnoDB database,
    InnoDB: the problem may be that during an earlier attempt you managed
    InnoDB: to create the InnoDB data files, but log file creation failed.
    InnoDB: If that is the case, please refer to
    InnoDB: http://dev.mysql.com/doc/refman/5.0/en/error-creating-innodb.html
    080404 2:21:08 [ERROR] Default storage engine (InnoDB) is not available
    080404 2:21:08 [ERROR] Aborting

    080404 2:21:08 [Note] C:\PROGRA~1\MySQL\MYSQLS~1.0\bin\MYSQLD~2.EXE: Shutdown complete

    I'm probably making a silly little mistake somewhere, so forgive my n00b-ness, and please help me. And yes, I've referred to "http://dev.mysql.com/doc/refman/5.0/en/error-creating-innodb.html" and it's of no help.

    ... I'm going to try one more clean install, regedit and all, and if it doesn't work, I'm going to stifle the urge to throw my laptop in the aquarium, and go to bed.

    Posted 1 year ago » Permalink

  2. -Poe-

    Regular
    Joined: Apr '08
    Posts: 35

    *Hoots & Cheers* I did SOMETHING stupid, because 6th time's the CHARM! I'll post here if I have any more problems!

    Posted 1 year ago » Permalink

  3. -Poe-

    Regular
    Joined: Apr '08
    Posts: 35

    Got it running, making my GM Character now, thanks Reaper! YOU ROCK!!!

    Posted 1 year ago » Permalink

RSS feed for this topic

Reply

You must log in to post.

Topic Info

General

Discuss about anything else

1,272 Topics – 6,705 Posts