KNOWNHOST WIKI

User Tools

Site Tools


developmental:mysql:phpmyadmin-repair-table

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

developmental:mysql:phpmyadmin-repair-table [2018/01/15 16:19]
mscherf created (#177)
developmental:mysql:phpmyadmin-repair-table [2019/10/11 12:44] (current)
Karson N.
Line 9: Line 9:
 If you are in WHM go to Home > SQL Services and click on phpMyAdmin icon: If you are in WHM go to Home > SQL Services and click on phpMyAdmin icon:
  
-  * {{:​developmental:​mysql:​whm-phpmyadmin-link.jpg?​direct&300|}}+  * {{:​developmental:​mysql:​whm-phpmyadmin-link.jpg?​nolink&800|}}
  
 If you are in cPanel go to Home > Databases and click on phpMyAdmin icon: If you are in cPanel go to Home > Databases and click on phpMyAdmin icon:
  
-  * {{:​developmental:​mysql:​cpanel-phpmyadmin-link.jpg?​direct&300|}}+  * {{:​developmental:​mysql:​cpanel-phpmyadmin-link.jpg?​nolink&800|}}
  
 This method works only when damaged table is using MyISAM engine. If InnoDB table is corrupted then more advanced methods should be used. This method works only when damaged table is using MyISAM engine. If InnoDB table is corrupted then more advanced methods should be used.
Line 19: Line 19:
 You can check which table engine is used in phpMyAdmin interface by clicking on database in the menu on the left and opening '​Structure'​ tab. For example, this database has all tables running on MyISAM engine: You can check which table engine is used in phpMyAdmin interface by clicking on database in the menu on the left and opening '​Structure'​ tab. For example, this database has all tables running on MyISAM engine:
  
-  * {{:​developmental:​mysql:​cpanel-phpmyadmin-myisam.jpg?​direct&300|}}+  * {{:​developmental:​mysql:​cpanel-phpmyadmin-myisam.jpg?​nolink&800|}}
  
 This database has all tables running on InnoDB engine: This database has all tables running on InnoDB engine:
  
-  * {{:​developmental:​mysql:​cpanel-phpmyadmin-innodb.jpg?​direct&300|}}+  * {{:​developmental:​mysql:​cpanel-phpmyadmin-innodb.jpg?​nolink&800|}}
  
 At the bottom of the table list you can see default MySQL parameters in bold. At the bottom of the table list you can see default MySQL parameters in bold.
Line 31: Line 31:
 It is strongly recommended to back up database before making changes. To create backup select database in the left menu and go to Export tab. Select “Quick” method and SQL format and then click “Go”. Download .sql file on your PC: It is strongly recommended to back up database before making changes. To create backup select database in the left menu and go to Export tab. Select “Quick” method and SQL format and then click “Go”. Download .sql file on your PC:
  
-  * {{:​developmental:​mysql:​cpanel-phpmyadmin-db-backup.jpg?​direct&300|}}+  * {{:​developmental:​mysql:​cpanel-phpmyadmin-db-backup.jpg?​nolink&800|}}
  
 ===== Repair Multiple Tables ===== ===== Repair Multiple Tables =====
Line 37: Line 37:
 To repair multiple tables open tab '​Structure',​ check the tables you want to repair (you can use 'Check all' option to select all tables), then click on drop-down menu 'With selected:'​ and click on '​Repair table' in Table maintenance section: To repair multiple tables open tab '​Structure',​ check the tables you want to repair (you can use 'Check all' option to select all tables), then click on drop-down menu 'With selected:'​ and click on '​Repair table' in Table maintenance section:
  
-  * {{:​developmental:​mysql:​cpanel-phpmyadmin-multi-table-repair.jpg?​direct&300|}}+  * {{:​developmental:​mysql:​cpanel-phpmyadmin-multi-table-repair.jpg?​nolink&800|}}
  
 After operation finished you will see the results at the top of the section: After operation finished you will see the results at the top of the section:
  
-  * {{:​developmental:​mysql:​cpanel-phpmyadmin-multi-table-repair-success.jpg?​direct&300|}}+  * {{:​developmental:​mysql:​cpanel-phpmyadmin-multi-table-repair-success.jpg?​nolink&800|}}
  
 ===== Repair a Single Table ===== ===== Repair a Single Table =====
Line 49: Line 49:
 In the menu on the left find the database which you need to repair. In the menu on the top go to “Operations” tab, find “Table maintenance” section and click on “Repair table” link: In the menu on the left find the database which you need to repair. In the menu on the top go to “Operations” tab, find “Table maintenance” section and click on “Repair table” link:
  
-  * {{:​developmental:​mysql:​cpanel-phpmyadmin-single-table-repair.jpg?​direct&300|}}+  * {{:​developmental:​mysql:​cpanel-phpmyadmin-single-table-repair.jpg?​nolink&800|}}
  
 Upon successful repair you will see the message on the top: Upon successful repair you will see the message on the top:
  
-  * {{:​developmental:​mysql:​cpanel-phpmyadmin-single-table-repair-success.jpg?​direct&300|}}+  * {{:​developmental:​mysql:​cpanel-phpmyadmin-single-table-repair-success.jpg?​nolink&800|}}
  
developmental/mysql/phpmyadmin-repair-table.txt · Last modified: 2019/10/11 12:44 by Karson N.