MySQL failing to launch on localhost
Hello everyone, I'm new here and I have a major development issue that's really time crucial, so any advice is much appreciated.
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. There seems to be a major sql problem, I wonder if the issue is poor 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.
I installed xampp and wordpress, using localhost as my working domain, did about 10 hours of web design customizing my theme I chose, 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?
The log is too many characters to post in this post so here is a link to the file:
Looks like this pretty much gives you the info on what the problem is and possible fixes:
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.
"Please give us a simple answer, so that we don't have to think, because if we think, we might find answers that don't fit the way we want the world to be."
~ Terry Pratchett in Nation
Check the log files for MySQL, in this directory: C:\xampp\mysql\data.
Also check if no other program or service uses the default MySql port. You can do this by using this command:
netstat -an | findstr "3306"
If anything shows up the default mysql port is in use and make sure that there is no other versions of MYSQL installed in your system.
Hope this helps.
Thank you guys, I'm going to look into those options.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Tags for this Thread