On Sun, Sep 16, 2007 at 06:02:59PM +0000, Moshiur Rahman Khan wrote: > "login using your MySQL database cliREPAIR TABLE interfaces;" > because I am not that much sound in MySQL. I can easily access database but > what will be the command for "REPAIR TABLE interfaces ?
You need to use the MySQL cli, which is the command line interface program. On my Linux server it is called mysql. Assuming your username is myuser and your database is called jffnms, I would type $ mysql -u myuser -p jffnms Enter password: (I type my database password here) Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 3744 Server version: 5.0.45-Debian_1-log Debian etch distribution Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> ^^ See that prompt? That's my mysql cli program prompt. Then type that command mysql> REPAIR TABLE interfaces; +-------------------+--------+----------+----------+ | Table | Op | Msg_type | Msg_text | +-------------------+--------+----------+----------+ | jffnms.interfaces | repair | status | OK | +-------------------+--------+----------+----------+ 1 row in set (0.01 sec) For more information about what is happening here http://dev.mysql.com/doc/refman/5.0/en/repair-table.html [usual rant about how good mysql is at corrupting tables removed] - Craig -- Craig Small GnuPG:1C1B D893 1418 2AF4 45EE 95CB C76C E5AC 12CA DFA5 http://www.enc.com.au/ csmall at : enc.com.au http://www.debian.org/ Debian GNU/Linux, software should be Free ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ jffnms-users mailing list jffnms-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jffnms-users
