Databases :: MySql :: corrupt table repair |
|||
By: michaeltegler  |
Date: 02/08/2003 00:00:00  |
Points: 500 | Status: Answered Quality : Excellent |
|
i've got a corrupt table and reading the mysql docs suggests that i can repair the table with myisamchk. however using ssh to run this command it says that the table doesn't exist. if there's an easier way please let me know. already tried phpmysqladmin several time it can't repair the table. |
|||
| By: wskoczen | Date: 02/08/2003 04:01:00 | |
Type : Comment |
| if your version is > 4.0.2, try to use REPAIR TABLE tbl_name[,tbl_name...] [QUICK] [EXTENDED] USE_FRM mysql will use .frm file to recreate the table; try it with option quick and then extended eventualy. Good Luck Wesley |
|||
| By: michaeltegler | Date: 02/08/2003 06:02:00 | |
Type : Comment |
| running MySQL 3.23.56 |
|||
| By: VGR | Date: 03/08/2003 19:17:00 | |
Type : Answer |
| 1) forget completely about "phpmysqladmin", it's total crap 2) ssh shouldn't prevent you from doing : -connection via sshd( like with telnetd) -mysql --user=root --password=... -use yourdatabase; repair table yourtable; OR with myisamchk -follow the online documentation ; usually ytou just have to make sure you give it the correct FULLPATH or the table to analyse & repair, OR that you're in the correzct directory already : -cd %datadir% (you've to know where are the databases) |
|||
| By: VGR | Date: 03/10/2010 10:34:53 | |
Type : Comment |
| also, see [url=http://www.europeanexperts.org/question/TOUTES/ZONES/1342.html]this thread[/url] | |||
|
Do register to be able to answer |
|||
©2010 These pages are served without commercial sponsorship. (No popup ads, etc...). Bandwidth abuse increases hosting cost forcing sponsorship or shutdown. This server aggressively defends against automated copying for any reason including offline viewing, duplication, etc... Please respect this requirement and DO NOT RIP THIS SITE.
Please DO link to this page!
Contact
- Privacy
- Contact us
- Member Agreement
- Jobs for our Experts
- our friend ActuLab
- Carcasherdotcom Seocontest
- Add Your Link
- Bee Web Directory
- Discover Directory
- FFind Directory
- Link Velocity Directory
- The Little Web Directory
- Red Links
- Tranix
- 2space Global Directory
Fully downloaded more than 1313 Million times
Copyright © 2003 - 2012 The IT European Experts Organization
last update on : 23/07/2008 09:41:27 GMT 0 (CEST)
