flagflag  
1: 2015-01-29 (Thu) 09:31:41 iseki source
Line 1: Line 1:
 +** Maintenance of MySQL [#p08aee0a] 
 +*** エンジンチェック [#ccfee546] 
 + > use information_schema; 
 + > select table_name, engine from tables where table_schema = "jogrid_db"; 
 +#br 
 +*** ISAM 修復 [#d6210ca8] 
 + $ mysqlcheck -c -r -u root -p 
 +#br 
 +*** Innodb 修復 [#o6e69f5d] 
 + > use jogrid_db; 
 + > ALTER TABLE テーブル名 ENGINE=INNODB;


Front page   New List of Pages Search Recent changes   Help   RSS of recent changes (RSS 1.0) RSS of recent changes (RSS 2.0) RSS of recent changes (RSS Atom)

Site Search

Login

Username:

Password:


Lost Password?
Register now!!

Sub Menu

mini Calendar

Last MonthMay 2024Next Month
Su Mo Tu We Th Fr Sa
1 2 3 4
5 6 7 8 9 10 11
12 13 14 15 16 17 18
19 20 21 22 23 24 25
26 27 28 29 30 31
Today

Who's Online

34 user(s) are online (8 user(s) are browsing xpwiki)

Members: 0
Guests: 34

more...

Access Counter

Today : 2501250125012501
Yesterday : 5790579057905790
Total : 2365529723655297236552972365529723655297236552972365529723655297
Powered by XOOPS Cube 2.1© 2001-2006 XOOPS Cube Project
Design by XoopsDesign.com