Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Site Up again
2 views
Skip to first unread message
Fredy Rouge Rouge
Feb 26, 2014, 9:11:43 PM2/26/14
to Mozilla Québec
Hola,
Our site was down, today I take some time to look this issue and
finally I found an ftp account, using this account I got the MySQL
access from our wordpress config file.
I found the problem:
mysql> describe wp_options
-> ;
ERROR 145 (HY000): Table './wordpress_f2/wp_options' is marked as
crashed and should be repaired
I try to do a backup without success:
mysqldump: Got error: 145: Table './wordpress_f2/wp_options' is marked
as crashed and should be repaired when using LOCK TABLES
I do the recover process without backup:
mysql> REPAIR TABLE wp_options
3 rows in set (0.85 sec)
Now our site is back :)
The cause of this issue? I have not idea, maybe:
Often after running out of disk space or a similar unexpected event,
some of the database tables may have become corrupt. This often occurs
after you experience out of disk space problems on the disk partition
where your database resides. In the above example the EXTRNLNKS table
became corrupt and needs to be repaired.
https://confluence.atlassian.com/display/CONFKB/MySQL+Table+is+Marked+as+Crashed+and+Should+be+Repaired
--
Fredy Rouge - Leader, Créatif, Autodidacte et Geek ☺
Our site was down, today I take some time to look this issue and
finally I found an ftp account, using this account I got the MySQL
access from our wordpress config file.
I found the problem:
mysql> describe wp_options
-> ;
ERROR 145 (HY000): Table './wordpress_f2/wp_options' is marked as
crashed and should be repaired
I try to do a backup without success:
mysqldump: Got error: 145: Table './wordpress_f2/wp_options' is marked
as crashed and should be repaired when using LOCK TABLES
I do the recover process without backup:
mysql> REPAIR TABLE wp_options
3 rows in set (0.85 sec)
Now our site is back :)
The cause of this issue? I have not idea, maybe:
Often after running out of disk space or a similar unexpected event,
some of the database tables may have become corrupt. This often occurs
after you experience out of disk space problems on the disk partition
where your database resides. In the above example the EXTRNLNKS table
became corrupt and needs to be repaired.
https://confluence.atlassian.com/display/CONFKB/MySQL+Table+is+Marked+as+Crashed+and+Should+be+Repaired
--
Fredy Rouge - Leader, Créatif, Autodidacte et Geek ☺
Alexandre Grenier
Feb 27, 2014, 10:00:27 AM2/27/14
to Mozilla Québec - ⚜ Ensemble, cultivons Internet ⚜ - Liste de discussion
Hola! That's awesome you fixed it!
Ça me fait penser à un truc... je me demande ce que Firefox utilise comme BD intégrée coté client... je pense que Chrome c'est LevelDB... est-ce que des plans pour BD Mozilla existe?
Alex - 514-625-3542
Hola,
_______________________________________________
community-quebec mailing list
communit...@lists.mozilla.org
https://lists.mozilla.org/listinfo/community-quebec
Fredy Rouge Rouge
Feb 27, 2014, 10:50:35 PM2/27/14
to Mozilla Québec - ⚜, Ensemble, cultivons Internet ⚜, - Liste de discussion
En 2012 étais SQLite
http://www.aaron-powell.com/posts/2012-10-05-indexeddb-storage.html
Je ne sais pas maintenant.
http://www.aaron-powell.com/posts/2012-10-05-indexeddb-storage.html
Je ne sais pas maintenant.
0 new messages