MySQL failing?

  • Author
    Posts
  • #13128
    Sam Assoum

    I am not a very educated developer, I really only know html and css, and have made a few sites using wordpress. I have started on a new project for work, and as I always have, I started the design on my localhost using xampp and wordpress (it’s not example.com). There seems to be a major sql problem, I wonder if the issue is coding in the theme, but keep in mind after this happened the first time (and I lost all my sql info) I deleted and uninstalled everything and restarted, only to find the issue happening again.

    The issue:

    I installed xampp and wordpress, using localhost as my working domain, did about 10 hours of web design customizing the theme, shutdown the pc, went to sleep. The next day when I start up xampp, apache starts, filezilla starts, and mysql fails. I have the error log but i can’t make any sense of any of it due to my lack of knowledge. Obviously with the sql down I can’t access my site hosted on my localhost. What is the issue? Any ideas?

    I was told the key to the issue is this section of the sql error log:

    InnoDB: Error: could not open single-table tablespace file .\wordpress\wp_terms.ibd
    InnoDB: We do not continue the crash recovery, because the table may become
    InnoDB: corrupt if we cannot apply the log records in the InnoDB log to it.
    InnoDB: To fix the problem and start mysqld:
    InnoDB: 1) If there is a permission problem in the file and mysqld cannot
    InnoDB: open the file, you should modify the permissions.
    InnoDB: 2) If the table is not needed, or you can restore it from a backup,
    InnoDB: then you can remove the .ibd file, and InnoDB will do a normal
    InnoDB: crash recovery and ignore that table.
    InnoDB: 3) If the file system or the disk is broken, and you cannot remove
    InnoDB: the .ibd file, you can set innodb_force_recovery > 0 in my.cnf
    InnoDB: and force InnoDB to continue crash recovery here.

    #13183
    Zed
    Cryout Creations mastermind

    The theme does not communicate with the MySQL database so it cannot cause corruption.

    Sorry, but you’ll have to look some place else for the cause of this – hard disk corruption, memory errors, MySQL version bug, PHP errors, incorrect MySQL shutdown…

    Why don’t you try working on a subfolder/subdomain of a hosted website (via FTP)?


    If you like our creations, help us share by rating them on WordPress.org.
    Please read the available documentation and search the forums before posting.
Viewing 2 posts - 1 through 2 (of 2 total)

The topic ‘MySQL failing?’ is closed to new replies.