mysql - InnoDB Corruption in Xampp -

-

i have backup 2 weeks ago last resort, db files seem fine , appears it's libdata1 file having issues. stated, i'm using xampp , mysql crashes right after start it. here error log: http://textuploader.com/7vfd

i hadn't done out of ordinary; seemingly , stopped working.

i looked innodb recovery, solutions tried required mysql functional, isn't due corruption. there way salvage presumably intact ibd files bad libdata1 file?

edit: aware of using innodb_force_recovery = # , had tried it...except had tried in wrong my.ini. had use 1 in bin folder. appears fixed now.

the ibdata1 file contains tablespace information , other metadata mysql database(s).

you can try using innodb_force_recovery = 1 way innodb_force_recovery = 6 see if rectifies problem. try changing in my.cnf (my.ini windows) file , attempt restart mysql server again.

if able start mysql using recovery flag, database in read-only mode. should mysqldump of data, stop mysql, re-install fresh, create database again, , import in data.

here link more info on innodb recovery dev.mysql.

if use linux...

another more complex option use percona recovery tool kit. realign tablespaces. although, experience bit of challenge navigate , takes bit of time implement if newb.

however, akuzminsky creator of toolkit (how cool that!) mentioned has made significant improvements toolkit.

link download toolkit percona.com

link walkthough chrisql.

link akuzinsky's website twindb.

unless data mission critical, revert backup 2 weeks prior. amount of time , effort may end putting recovering data may out way benefit.


Comments

Post a Comment

Popular posts from this blog

python - TypeError: start must be a integer -

-
i trying draw 5 turtles, getting typeerror on line 25. here code: import turtle wn = turtle.screen() redrose = turtle.turtle() color = input("what background color be?") fillcolor_f = input("what color of rose be?") redrose.hideturtle() redrose.speed(30) redrose.penup() redrose.left(180) redrose.forward(175) redrose.right(90) redrose.forward(30) redrose.right(90) redrose.pendown() def drawrose(red): redrose.color("pink") redrose.fillcolor(fillcolor_f) redrose.fill(true) in range(red): redrose.forward(i) redrose.right(49) in range(5): drawrose(redrose) redrose.penup() redrose.forward(350) redrose.right(144) redrose.pendown() redrose.fill(false) drawrose(50) wn.bgcolor(color) i trying draw 5 roses, produces errors. doing in interactivepython.org. you recursively calling drawrose wrong parameter. on line 23 ( for in range(red): ) expect red integer...
Read more

c# - DevExpress RepositoryItemComboBox BackColor property ignored -

-
i have following code almost works properly; private void cbstatus_drawitem(object sender, listboxdrawitemeventargs e) { string item = e.item string; if (item != null) { switch (item) { case "1": e.appearance.forecolor = color.green; e.appearance.backcolor = color.green; break; case "2": e.appearance.forecolor = color.orange; e.appearance.backcolor = color.orange; break; case "3": e.appearance.forecolor = color.red; e.appearance.backcolor = color.red; break; } } } when dropdown shown, items forecolor correct, backcolor remains whatever backcolor of theme is; i.e. if i've got set dark theme, backcolor dark, cells in gridview, rather being green/orange/red. i've tried setting e.appearance.options.usebackcolor trying set e....
Read more

django - Creating multiple model instances in DRF3 -

-
1) create multiple model instances 1 api call, asked here: how create multiple model instances django rest framework? tried solution named in link, no success. i trying upload multiple files in 1 api call. result: files uploaded (only once overwrote perform_create) 1 instance created (if send 2 files, latter created instance). my code: class fileuploadserializer(serializers.modelserializer): def __init__(self, *args, **kwargs): many = kwargs.pop('many', true) super(fileuploadserializer, self).__init__(many=many, *args, **kwargs) class meta: model = fileupload read_only_fields = ('created', 'datafile', 'owner') class fileuploadviewset(viewsets.modelviewset): queryset = fileupload.objects.all() serializer_class = fileuploadserializer parser_classes = (multipartparser, formparser, ) def perform_create(self, serializer): file_list = self.request.data.getlist('file') ...
Read more