#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2004
    Posts
    8
    Rep Power
    0

    mysql installation problems


    I have php and apache set up on my desktop , for my testing server. since port 80 was not accessible, I had to configure my apache server to use port 8080. i have tested these settings and both apache and PHP are working fine. the problem starts with mysql. i have installed mysql to the default C:\MySQL . i can not start mysql.i always get the error "cannot connect to localhost (10061)" . i searched for solutions to this error, but most solutions on the forum didnt work for my particular problem. would this have anything to do with my localhost being localhost:8080, instead of the default localhost on port 80. is there any way of pointing mysql to localhost:8080
    I have windows XP,php,apache
    i would really appreciate any form of help
  2. #2
  3. (retired)
    Devshed Supreme Being (6500+ posts)

    Join Date
    Dec 2003
    Location
    The Laboratory
    Posts
    10,101
    Rep Power
    0
    I'd bet money that MySQL isn't starting.

    Go to C:\MySQL\data\ and read the file that ends in .err - tell us what that says.

    Cheers,
    Simon
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2004
    Posts
    8
    Rep Power
    0
    i am novice and the contents of the error file are like greek to me. i have pasted the whole file below:

    InnoDB: The first specified data file .\ibdata1 did not exist:
    InnoDB: a new database to be created!
    041030 15:22:00 InnoDB: Setting file .\ibdata1 size to 10 MB
    InnoDB: Database physically writes the file full: wait...
    041030 15:22:04 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...
    041030 15:22:08 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: Doublewrite buffer not found: creating new
    InnoDB: Cannot create doublewrite buffer: you must
    InnoDB: increase your buffer pool size.
    InnoDB: Cannot continue operation.
    041030 15:28:04 InnoDB: Database was not shut down normally!
    InnoDB: Starting crash recovery.
    InnoDB: Reading tablespace information from the .ibd files...
    InnoDB: Restoring possible half-written data pages from the doublewrite
    InnoDB: buffer...
    041030 15:28:04 InnoDB: Starting log scan based on checkpoint at
    InnoDB: log sequence number 0 30960.
    InnoDB: Doing recovery: scanned up to log sequence number 0 30960
    041030 15:28:05 InnoDB: Flushing modified pages from the buffer pool...
    InnoDB: Doublewrite buffer not found: creating new
    InnoDB: Cannot create doublewrite buffer: you must
    InnoDB: increase your buffer pool size.
    InnoDB: Cannot continue operation.
    InnoDB: Error: log file .\ib_logfile0 is of different size 0 10485760 bytes
    InnoDB: than specified in the .cnf file 0 5242880 bytes!
    041030 16:09:17 [ERROR] Can't init databases
    041030 16:09:17 [ERROR] Aborting

    041030 16:09:17 [NOTE] mysqld-nt: Shutdown complete

    InnoDB: Error: log file .\ib_logfile0 is of different size 0 10485760 bytes
    InnoDB: than specified in the .cnf file 0 5242880 bytes!
    041030 16:09:41 [ERROR] Can't init databases
    041030 16:09:41 [ERROR] Aborting

    041030 16:09:41 [NOTE] mysqld: Shutdown complete

    InnoDB: Error: log file .\ib_logfile0 is of different size 0 10485760 bytes
    InnoDB: than specified in the .cnf file 0 5242880 bytes!
    041030 18:58:27 Can't init databases
    041030 18:58:27 Aborting

    041030 18:58:27 InnoDB: Warning: shutting down a not properly started
    InnoDB: or created database!
    041030 18:58:27 MySql: Shutdown Complete

    InnoDB: Error: log file .\ib_logfile0 is of different size 0 10485760 bytes
    InnoDB: than specified in the .cnf file 0 5242880 bytes!
    041030 18:58:58 Can't init databases
    041030 18:58:58 Aborting

    041030 18:58:58 InnoDB: Warning: shutting down a not properly started
    InnoDB: or created database!
    041030 18:58:58 MySql: Shutdown Complete

    InnoDB: Error: log file .\ib_logfile0 is of different size 0 10485760 bytes
    InnoDB: than specified in the .cnf file 0 5242880 bytes!
    041030 19:22:09 Can't init databases
    041030 19:22:09 Aborting

    041030 19:22:09 InnoDB: Warning: shutting down a not properly started
    InnoDB: or created database!
    041030 19:22:09 MySql: Shutdown Complete

    InnoDB: Error: log file .\ib_logfile0 is of different size 0 10485760 bytes
    InnoDB: than specified in the .cnf file 0 5242880 bytes!
    041030 19:38:08 Can't init databases
    041030 19:38:08 Aborting

    041030 19:38:08 InnoDB: Warning: shutting down a not properly started
    InnoDB: or created database!
    041030 19:38:08 MySql: Shutdown Complete

    InnoDB: Error: log file .\ib_logfile0 is of different size 0 10485760 bytes
    InnoDB: than specified in the .cnf file 0 5242880 bytes!
    041030 19:42:11 Can't init databases
    041030 19:42:11 Aborting

    041030 19:42:12 InnoDB: Warning: shutting down a not properly started
    InnoDB: or created database!
    041030 19:42:12 MySql: Shutdown Complete

    InnoDB: Error: log file .\ib_logfile0 is of different size 0 10485760 bytes
    InnoDB: than specified in the .cnf file 0 5242880 bytes!
    041030 19:45:46 Can't init databases
    041030 19:45:46 Aborting

    041030 19:45:46 InnoDB: Warning: shutting down a not properly started
    InnoDB: or created database!
    041030 19:45:46 MySql: Shutdown Complete

    InnoDB: Error: log file .\ib_logfile0 is of different size 0 10485760 bytes
    InnoDB: than specified in the .cnf file 0 5242880 bytes!
    041030 19:46:38 Can't init databases
    041030 19:46:38 Aborting

    041030 19:46:38 InnoDB: Warning: shutting down a not properly started
    InnoDB: or created database!
    041030 19:46:38 MySql: Shutdown Complete
  6. #4
  7. (retired)
    Devshed Supreme Being (6500+ posts)

    Join Date
    Dec 2003
    Location
    The Laboratory
    Posts
    10,101
    Rep Power
    0
    Great

    Ok, look in the mysql/scripts/ directory. There should be a script called "mysql_install_db" -- run it (try typing the name in dos.).

    I don't have a windows machine here - but I've got one at home which I'll check if you can't get this working
  8. #5
  9. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2004
    Posts
    8
    Rep Power
    0
    sorry, no luck
  10. #6
  11. (retired)
    Devshed Supreme Being (6500+ posts)

    Join Date
    Dec 2003
    Location
    The Laboratory
    Posts
    10,101
    Rep Power
    0
    Hmm.. do you need InnoDB tables?

    If so have a look here
  12. #7
  13. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2002
    Location
    Toronto
    Posts
    5
    Rep Power
    0
    Originally Posted by tonderai76
    sorry, no luck

    I had the same error, and this is how i fixed it.

    1. Make sure you back up entire data directory and also do am mysql dump, so you have a backup.

    2. Shutdown mysql server

    3. create a temp directory anywhere, but not in your 'data' directory.

    4. move all the ib_* files (e.g. mv ib_* /home/nsakic/temp) to the temp directory.

    5. Male sure your cnf file is in place and you've configured whatever you wanted configure, e.g. memory usage etc etc.

    6. Start mysql server, it will create all the ib_* files based on your my.cnf file.


    You can remove my.cnf file totally and start mysql, it will start. Then you can do a dump and delete those database(s) and shut mysql down. Follow from step 3 then.

    -nsakic

IMN logo majestic logo threadwatch logo seochat tools logo