• today i can not start mysql from my xampp installation at first time.
    Wordpress 4.5 is installed after the release.

    mysql_error.log

    2016-04-26  9:31:11 5080 [ERROR] InnoDB: Attempted to open a previously opened tablespace. Previous tablespace phpmyadmin/pma__table_coords uses space ID: 19 at filepath: .\phpmyadmin\pma__table_coords.ibd. Cannot open tablespace usr_web94_3/wp_termmeta which uses space ID: 19 at filepath: .\usr_web94_3\wp_termmeta.ibd
    InnoDB: Error: could not open single-table tablespace file .\usr_web94_3\wp_termmeta.ibd
    InnoDB: We do not continue the crash recovery, because the table may become 
    
    2016-04-26  9:35:13 2504 [ERROR] mysqld.exe: Table '.\mysql\db' is marked as crashed and should be repaired
    2016-04-26  9:35:13 2504 [Warning] Checking table:   '.\mysql\db'
    2016-04-26  9:35:13 2504 [ERROR] mysql.db: 1 client is using or hasn't closed the table properly
    2016-04-26  9:35:14 2504 [ERROR] mysqld.exe: Table '.\mysql\tables_priv' is marked as crashed and should be repaired
    2016-04-26  9:35:14 2504 [Warning] Checking table:   '.\mysql\tables_priv'
    2016-04-26  9:35:14 2504 [ERROR] mysql.tables_priv: 1 client is using or hasn't closed the table properly
    2016-04-26  9:35:14 2504 [ERROR] mysqld.exe: Table '.\mysql\columns_priv' is marked as crashed and should be repaired
    2016-04-26  9:35:14 2504 [Warning] Checking table:   '.\mysql\columns_priv'
    2016-04-26  9:35:14 2504 [ERROR] mysql.columns_priv: 1 client is using or hasn't closed the table properly
    2016-04-26  9:35:14 2504 [ERROR] mysqld.exe: Table '.\mysql\procs_priv' is marked as crashed and should be repaired
    2016-04-26  9:35:14 2504 [Warning] Checking table:   '.\mysql\procs_priv'
    2016-04-26  9:35:14 2504 [ERROR] mysql.procs_priv: 1 client is using or hasn't closed the table properly
    2016-04-26  9:35:14 2504 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
    Version: '10.1.10-MariaDB'  socket: ''  port: 3306  mariadb.org binary distribution
    2016-04-26  9:35:23 5200 [ERROR] mysqld.exe: Table '.\usr_web94_3\wp_options' is marked as crashed and should be repaired
    2016-04-26  9:35:23 5200 [Warning] Checking table:   '.\usr_web94_3\wp_options'
    2016-04-26  9:35:25 5200 [ERROR] mysqld.exe: Table '.\usr_web94_3\wp_usermeta' is marked as crashed and should be repaired
    2016-04-26  9:35:25 5200 [Warning] Checking table:   '.\usr_web94_3\wp_usermeta'
    2016-04-26  9:35:26 5200 [ERROR] mysqld.exe: Table '.\usr_web94_3\wp_posts' is marked as crashed and should be repaired
    2016-04-26  9:35:26 5200 [Warning] Checking table:   '.\usr_web94_3\wp_posts'
    2016-04-26  9:35:26 5200 [ERROR] mysqld.exe: Table '.\usr_web94_3\wp_term_taxonomy' is marked as crashed and should be repaired
    2016-04-26  9:35:26 5200 [Warning] Checking table:   '.\usr_web94_3\wp_term_taxonomy'
    2016-04-26  9:35:26 5200 [ERROR] mysqld.exe: Table '.\usr_web94_3\wp_term_relationships' is marked as crashed and should be repaired
    2016-04-26  9:35:26 5200 [Warning] Checking table:   '.\usr_web94_3\wp_term_relationships'
    2016-04-26  9:35:26 5200 [ERROR] mysqld.exe: Table '.\usr_web94_3\wp_postmeta' is marked as crashed and should be repaired
    2016-04-26  9:35:26 5200 [Warning] Checking table:   '.\usr_web94_3\wp_postmeta'
    2016-04-26  9:38:15 1908 [Note] c:\xampp\mysql\bin\mysqld.exe: Normal shutdown

    Then i moved wp_termmeta.frm and wp_termmeta.ibd and i could started mysql again and the mysql and WP is running.

    Now the table wp_termmeta is no longer in database but WP 4.5 and the update 4.5.1 is running.

    Whats the problem?

  • The topic ‘Database crash – wp_metaterm’ is closed to new replies.