MySQL stability issues after attempting to backup WAMP -



MySQL stability issues after attempting to backup WAMP -

i trying create backup of wamp directory effort install 32-bit version since need php library required assignment. i'm stand-in while place of employment tries find replacement guy vacated position , set up, , it's bit on head , i'm lost in procedure.

the mysql process keeps crashing when effort create temporary table part of info conversion. error log startup crash:

140620 10:32:24 [note] plugin 'federated' disabled. 140620 10:32:24 innodb: innodb memory heap disabled 140620 10:32:24 innodb: mutexes , rw_locks utilize windows interlocked functions 140620 10:32:24 innodb: compressed tables utilize zlib 1.2.3 140620 10:32:24 innodb: initializing buffer pool, size = 128.0m 140620 10:32:24 innodb: completed initialization of buffer pool 140620 10:32:24 innodb: highest supported file format barracuda. innodb: log scan progressed past checkpoint lsn 343041027227 140620 10:32:24 innodb: database not shut downwards normally! innodb: starting crash recovery. innodb: reading tablespace info .ibd files... innodb: restoring possible half-written info pages doublewrite innodb: buffer... innodb: doing recovery: scanned log sequence number 343041027247 innodb: lastly mysql binlog file position 0 43092, file name .\mysql-bin.000238 140620 10:32:27 innodb: waiting background threads start 140620 10:32:28 innodb: 1.1.8 started; log sequence number 343041027247 140620 10:32:28 innodb: !!! innodb_force_recovery set 4 !!! 140620 10:32:28 [note] recovering after crash using mysql-bin 140620 10:32:28 [note] starting crash recovery... 140620 10:32:28 [note] crash recovery finished. 140620 10:32:28 [note] event scheduler: loaded 8 events 140620 10:32:28 [note] wampmysqld: ready connections. version: '5.5.20-log' socket: '' port: 3306 mysql community server (gpl) 140620 10:32:28 [note] event scheduler: scheduler thread started id 1 140620 10:32:43 [error] cannot find or open table centralprocessing1/importscanning from internal info dictionary of innodb though .frm file the table exists. maybe have deleted , recreated innodb data files have forgotten delete corresponding .frm files of innodb tables, or have moved .frm files database? or, table contains indexes version of engine doesn't support see http://dev.mysql.com/doc/refman/5.5/en/innodb-troubleshooting.html how can resolve problem. 140620 10:32:43 innodb: error: table centralprocessing1.importholdover not exist in innodb internal innodb: info dictionary though mysql trying drop it. innodb: have copied .frm file of table the innodb: mysql database directory database? innodb: dump of tablespace extent descriptor: len 40; hex 0000000000000001000e0000252effffffff000000000004aaaaaaaaaaaaaaaaaaaaaaaaaaaafeff; asc > %. ; innodb: serious error! innodb trying free page 932476 innodb: though marked free in tablespace! innodb: tablespace free space info corrupt. innodb: may need dump innodb tables , recreate whole innodb: database! 140620 10:32:43 innodb: assertion failure in thread 4408 in file fsp0fsp.c line 3265 innodb: intentionally generate memory trap. innodb: if repeated assertion failures or crashes, even innodb: after mysqld startup, there may be innodb: corruption in innodb tablespace. please refer to innodb: http://dev.mysql.com/doc/refman/5.5/en/forcing-innodb-recovery.html innodb: forcing recovery. innodb: thread 5360 stopped in file os0sync.c line 781 innodb: thread 6568 stopped in file os0sync.c line 474

errors show in console include 1146 (table doesn't exist; table it's looking temporary 1 i'm trying make), 1051 (unknown table), 2013 (lost connection), , 2006 (server gone). when seek step through batch file, crashes when effort create new table , i'm not sure can it

mysql wamp innodb

Comments

Post a Comment

Popular posts from this blog

php - Android app custom user registration and login with cookie using facebook sdk -

php - Android app custom user registration and login with cookie using facebook sdk - i developing android application in users need register , log in using facebook. approximately, flow. open app first time, authenticate facebook, data, send info server create them business relationship in application, start session new business relationship in server, cookie perform later interactions. so far good. what need know wich info have send server, can able identify users when log in seccond time. because need start session in server , send cookie android app farther interactions. i'm using php server side language. i thinking getting getaccesstoken() in android facebook sdk, pass server on business relationship creation , storing in android app. but can't manage how login users on sec time utilize app. any suggestions ? in advance ! to uniquely identify user within app, should create request /me , user's id. guaranteed unique , remain con
Read more

django - Access session in user model .save() -

django - Access session in user model .save() - is possible access current session in user model .save()? pseudo code of want achieve: # users.models.py def save(self, *args, **kwargs): created = true if self.pk: created = false super(abstractuser, self).save(*args, **kwargs) # post-save if created: look_for_invite_in_session_and_register_if_found(self, session) seems wrong in architecture. shouldn't access request in models layer. work request must done in view. can this: user, created = abstractuser.objects.get_or_create(name=name) if created: look_for_invite_in_session_and_register_if_found(user, request.session) django session
Read more

php - .htaccess Multiple Rewrite Rules / Prioritizing -

php - .htaccess Multiple Rewrite Rules / Prioritizing - here current htaccess file: rewriteengine on rewritecond %{http_host} !^www\.website\.com [nc] rewritecond %{http_host} ([^.]+)\.website\.com [nc] rewriterule ^(.*)$ http://www.website.com/gotourl.php?urlid=?%1 [l] rewriterule ^(\w+)$ ./gotourl.php?urlid=$1 [nc,l] rewriterule ^(\w+)/$ ./gotourl.php?urlid=$1 [nc,l] the website in question url shortener i'm working on testing/developing , personal use. above code may not ideal i'm not familiar .htaccess , made via googling , testing. want url shortening aspect: http://website.com/1234 -> http://website.com/gotourl.php?urlid=1234 http://website.com/1234/ -> http://website.com/gotourl.php?urlid=1234 the problem cannot figure out how ignore directories. want specific directories go specific pages: http://website.com/img (or) http://website.com/img/ -> http://website.com/img.php http://website.com/img/1234 (or) http://website.com/
Read more