• Hi, I’ve just installed Apache V2.0.52, Php V5.03 and MySQL V4.1.9 (along with MySQL Administrator). The machine in Win2K Pro, and PHP is running as an Apache2 module.

    I have phpMyAdmin, and Blog-CMS both working fine (databases made and working), but whenever I try to set up WordPress, my mysqld-nt service crashes! It crashes when going to step 2 of the installation. I downloaded the current V1.22 “Mingus”. Database tables are made before the crash…

    Anyone have any idea?

Viewing 9 replies - 1 through 9 (of 9 total)
  • Thread Starter iandol

    (@iandol)

    Here is the step 2 results (returned about 40 seconds after MySQL has crashed – though my service is set to restart automatically):

    First we’re going to create the necessary blog tables in the database…

    The first table has been created! …

    The test post has been inserted correctly…

    Categories are up and running…

    Comments are groovy…

    Post metadata table ready to go…

    Option Tables created okay.

    Option Data inserted okay.

    Links option data inserted okay.

    Database error: [Lost connection to MySQL server during query]
    INSERT INTO wp_options (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(86,’default_geourl_lat ‘, 8, 0.0, ‘The default Latitude ICBM value – see here’, 8, 20)

    Database error: [Can’t connect to MySQL server on ‘localhost’ (10061)]
    INSERT INTO wp_options (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(87,’default_geourl_lon’, 8, 0.0, ‘The default Longitude ICBM value’, 8, 20)

    Database error: [Can’t connect to MySQL server on ‘localhost’ (10061)]
    INSERT INTO wp_optiongroups (group_id, group_name, group_desc) VALUES(9,’Geo Options’, ‘Settings which control the posting and display of Geo Options’)

    Database error: [Can’t connect to MySQL server on ‘localhost’ (10061)]
    INSERT INTO wp_optiongroup_options (group_id, option_id, seq) VALUES(9,84,1)

    Database error: [Can’t connect to MySQL server on ‘localhost’ (10061)]
    INSERT INTO wp_optiongroup_options (group_id, option_id, seq) VALUES(9,85,1)

    Database error: [Can’t connect to MySQL server on ‘localhost’ (10061)]
    INSERT INTO wp_optiongroup_options (group_id, option_id, seq) VALUES(9,86,1)

    Database error: [Can’t connect to MySQL server on ‘localhost’ (10061)]
    INSERT INTO wp_optiongroup_options (group_id, option_id, seq) VALUES(9,87,1)

    Geo option data inserted okay.

    OK. We’re nearly done now. We just need to ask you a couple of things:

    What is the web address of your WordPress installation? (We probably guessed it for you correctly.)

    Looks like your DB server is not started correctly. Contact your host.
    Are other databases working?

    ewwww. I’m assuming that your using a windows server?

    Thread Starter iandol

    (@iandol)

    Yes, I have phpMyAdmin working (It has created advanced tables for itself), and I have installed another PHP blog system, Blog:CMS and PunBB forum each using the MySQL database. Note that WP tables are created, the issue is at some point around “INSERT INTO wp_options” – WP does something to make MySQL crash.

    I am using windows.

    Thread Starter iandol

    (@iandol)

    Hmmm, I jst noticed this thread:

    http://wordpress.org/support/topic.php?id=18010

    Where others have noted crashes with recent MySQL versions, and suggest a downgrade. Can any developers comment on whether this issue is being addressed – it’d be nice not to have to depend on old versions of the core dev system to get things to work…

    Thread Starter iandol

    (@iandol)

    Just to update this thread: I upgraded to V1.5 of WP, and the MySQL crash going to stage 3 of the install was fixed.

    WP 1.2.2

    Windows XP Service Pack 2 using IIS
    MySQL 4.1.9
    PHP 5.0.3

    mysql-nt.exe crashes every time while running Step 2 of the installation. No error messages are displayed as it bombs before it has a chance to.

    ———————————-
    Step 2

    First we’re going to create the necessary blog tables in the database…

    The first table has been created! …

    The test post has been inserted correctly…

    Categories are up and running…

    Comments are groovy…

    Post metadata table ready to go…

    Option Tables created okay.

    Option Data inserted okay.

    Links option data inserted okay.
    ———————————-

    I’d love to get my hands on 1.5, but the beta list site is down. Can anyone help me out?

    List site is working for me now. Must have been something on my end. Going to try 1.5 as soon as I can get my hands on it.

    Could anyone send me 1.5? I haven’t been able to find it anywhere. I’m not receiving anything from the beta list yet. I’d love to work on development soon.

    Moderator James Huff

    (@macmanx)

    Volunteer Moderator

Viewing 9 replies - 1 through 9 (of 9 total)
  • The topic ‘Crashing MySQL Database’ is closed to new replies.