MySQL not launching on XAMPP -


i can't mysql launch via xampp, fine last time opened few months back;

updated errors after have followed my.cnf recovery:

2013-10-06 19:29:23 7920 [note] plugin 'federated' disabled. 2013-10-06 19:29:23 15fc innodb: warning: using innodb_additional_mem_pool_size deprecated. option may removed in future releases, option innodb_use_sys_malloc , innodb's internal memory allocator. 2013-10-06 19:29:23 7920 [note] innodb: innodb memory heap disabled 2013-10-06 19:29:23 7920 [note] innodb: mutexes , rw_locks use windows interlocked functions 2013-10-06 19:29:23 7920 [note] innodb: compressed tables use zlib 1.2.3 2013-10-06 19:29:23 7920 [note] innodb: not using cpu crc32 instructions 2013-10-06 19:29:23 7920 [note] innodb: initializing buffer pool, size = 16.0m 2013-10-06 19:29:23 7920 [note] innodb: completed initialization of buffer pool 2013-10-06 19:29:23 7920 [note] innodb: highest supported file format barracuda. 2013-10-06 19:29:23 7920 [note] innodb: log sequence numbers 0 , 0 in ibdata files not match log sequence number 198755718 in ib_logfiles! 2013-10-06 19:29:23 7920 [note] innodb: database not shutdown normally! 2013-10-06 19:29:23 7920 [note] innodb: starting crash recovery. 2013-10-06 19:29:23 7920 [note] innodb: reading tablespace information .ibd files... 2013-10-06 19:29:23 7920 [error] innodb: attempted open opened tablespace. previous tablespace bitnami_wordpress/wp_usermeta uses space id: 2 @ filepath: .\bitnami_wordpress\wp_usermeta.ibd. cannot open tablespace mysql/innodb_index_stats uses space id: 2 @ filepath: .\mysql\innodb_index_stats.ibd innodb: error: not open single-table tablespace file .\mysql\innodb_index_stats.ibd innodb: not continue crash recovery, because table may become innodb: corrupt if cannot apply log records in innodb log it. innodb: fix problem , start mysqld: innodb: 1) if there permission problem in file , mysqld cannot innodb: open file, should modify permissions. innodb: 2) if table not needed, or can restore backup, innodb: can remove .ibd file, , innodb normal innodb: crash recovery , ignore table. innodb: 3) if file system or disk broken, , cannot remove innodb: .ibd file, can set innodb_force_recovery > 0 in my.cnf innodb: , force innodb continue crash recovery here.

base on suggestions of error log, think should try this. planned write in comment, hard read, i'll make answer instead

you can't launch mysql because xampp can't open file .\mysql\innodb_index_stats.ibd shown in

error: not open single-table tablespace file .\mysql\innodb_index_stats.ibd

and here suggestions how fix it:

1) if there permission problem in file , mysqld cannot open file, should modify permissions.

(1) permission. go .\mysql\innodb_index_stats.ibd , check if have permission read innodb_index_stats.ibd

2) if table not needed, or can restore backup, can remove .ibd file, , innodb normal crash recovery , ignore table.

(2) can try delete .\mysql\innodb_index_stats.ibd. suggestion copy innodb_index_stats.ibd location in case else happen

3) if file system or disk broken, , cannot remove .ibd file, can set innodb_force_recovery > 0 in my.cnf , force innodb continue crash recovery here.

(3) if can't delete nnodb_index_stats.ibd, can try modify my.cnf file , set innodb_force_recovery > 0 (you can use notepad or notepad++ edit file. locate in xampp\mysql\

try these first see if helps

update please try locate file ibdata1 locate @ xampp\mysql\data , delete or rename it, restart xampp, hope gonna work you


Comments

Post a Comment

Popular posts from this blog

java.util.scanner - How to read and add only numbers to array from a text file -

i'm learning java , have question regarding reading file want read numbers file contains strings well. here example of file: 66.56 "3 java 3-43 5-42 2.1 1 and here coding: public class test { public static void main (string [] args){ if (0 < args.length) { file x = new file(args[0]); try{ scanner in = new scanner( new fileinputstream(x)); arraylist<double> test = new arraylist<>(); while(in.hasnext()){ if(in.hasnextdouble()){ double f=in.nextdouble(); test.add(f);} else {in.next();} } catch(ioexception e) { system.err.println("exception during reading: " + e); } } my problem add 66.56,2.1 , 1 doesn't add 3 after "3 or ignores 3-43 , 5-42 can tell me how skip strings , add doubles here? thanks all said 3 ie; "3, 3-43 , 4-42 strings either u read string , split , check number @ " , - or put in space between characters , integers. jvm after compilation tre...
Read more

rewrite - Trouble with Wordpress multiple custom querystrings -

i'm working on adding multiple querystring , doesn't seem work. i've found codes seems work others might i'm missing something. i want like: http://mydomain.com/board/?getyear=2013&getsometext2=sometext to http://mydomain.com/board/2013/sometext/ i added code below functions.php file. doesn't seem work should though. this works. echoing querystring gets both variable without problem. http://mydomain.com/board/2013/sometext/ but doesn't. tested querystring vis isset() seems nothing being set/get http://mydomain.com/board/2013/ function add_query_vars($vars) { $vars[] = "getyear"; $vars[] = "getsometext2"; return $vars; } add_filter('query_vars', 'add_query_vars'); function add_rewrite_rules($arules) { $anewrules = array('board/([^/]+)/([^/]+)/?$' => 'index.php?pagename=board&getyear=$matches[1]&getsometext2=$matches[2]'); $arules = $a...
Read more