뭐..여튼;; 내가 개발을 할수는 없고-0-ㅋㅋㅋ
열시미들 하고 계시니../
db가 삑사리 하면..
mysqlcheck라는 명령어를 통해서 복구 가능하다/
root@thedino:/# mysqlcheck
mysqlcheck Ver 2.4.3 Distrib 4.0.24, for pc-linux-gnu (i486)
By Jani Tolonen, 2001-04-20, MySQL Development Team
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license.
This program can be used to CHECK (-c,-m,-C), REPAIR (-r), ANALYZE (-a)
or OPTIMIZE (-o) tables. Some of the options (like -e or -q) can be
used at the same time. It works on MyISAM and in some cases on BDB tables.
Please consult the MySQL manual for latest information about the
above. The options -c,-r,-a and -o are exclusive to each other, which
means that the last option will be used, if several was specified.
The option -c will be used by default, if none was specified. You
can change the default behavior by making a symbolic link, or
copying this file somewhere with another name, the alternatives are: mysqlrepair: The default option will be -r
mysqlanalyze: The default option will be -a
mysqloptimize: The default option will be -o
Usage: mysqlcheck [OPTIONS] database [tables]
OR mysqlcheck [OPTIONS] --databases DB1 [DB2 DB3...]
OR mysqlcheck [OPTIONS] --all-databases
Default options are read from the following files in the given order:
/etc/mysql/my.cnf /var/lib/mysql/my.cnf ~/.my.cnf
The following groups are read: mysqlcheck client
The following options may be given as the first argument:
--print-defaults Print the program argument list and exit
--no-defaults Don't read default options from any options file
--defaults-file=# Only read default options from the given file #
--defaults-extra-file=# Read this file after the global files are read
-A, --all-databases Check all the databases. This will be same as
--databases with all databases selected.
-a, --analyze Analyze given tables.
-1, --all-in-1 Instead of issuing one query for each table, use one
query per database, naming all tables in the database in
a comma-separated list.
--auto-repair If a checked table is corrupted, automatically fix it.
Repairing will be done after all tables have been
checked, if corrupted ones were found.
--character-sets-dir=name
Directory where character sets are
-c, --check Check table for errors
-C, --check-only-changed
Check only tables that have changed since last check or
haven't been closed properly.
--compress Use compression in server/client protocol.
-B, --databases To check several databases. Note the difference in usage;
In this case no tables are given. All name arguments are
regarded as databasenames.
-#, --debug[=name] Output debug log. Often this is 'd:t:o,filename'
--default-character-set=name
Set the default character set
-F, --fast Check only tables that haven't been closed properly
-f, --force Continue even if we get an sql-error.
-e, --extended If you are using this option with CHECK TABLE, it will
ensure that the table is 100 percent consistent, but will
take a long time. If you are using this option with
REPAIR TABLE, it will force using old slow repair with
keycache method, instead of much faster repair by
sorting.
-?, --help Display this help message and exit.
-h, --host=name Connect to host.
-m, --medium-check Faster than extended-check, but only finds 99.99 percent
of all errors. Should be good enough for most cases.
-o, --optimize Optimize table.
-p, --password[=name]
Password to use when connecting to server. If password is
not given it's solicited on the tty.
-P, --port=# Port number to use for connection.
-q, --quick If you are using this option with CHECK TABLE, it
prevents the check from scanning the rows to check for
wrong links. This is the fastest check. If you are using
this option with REPAIR TABLE, it will try to repair only
the index tree. This is the fastest repair method for a
table.
-r, --repair Can fix almost anything except unique keys that aren't
unique.
-s, --silent Print only error messages.
-S, --socket=name Socket file to use for connection.
--tables Overrides option --databases (-B).
-u, --user=name User for login if not current user.
--use-frm When used with REPAIR, get table structure from .frm
file, so the table can be repaired even if .MYI header is
corrupted.
-v, --verbose Print info about the various stages.
-V, --version Output version information and exit.
Variables (--variable-name=value)
and boolean options {FALSE|TRUE} Value (after reading options)
--------------------------------- -----------------------------
all-databases FALSE
all-in-1 FALSE
auto-repair FALSE
character-sets-dir (No default value)
compress FALSE
databases FALSE
default-character-set (No default value)
fast FALSE
force FALSE
extended FALSE
host (No default value)
port 0
quick FALSE
silent FALSE
socket (No default value)
user (No default value)
use-frm FALSE
뭐// 도움말은 위와 같으나..............
그냥 간단하게 하나만 기억하자.-_-;;
