--old-passwords../dist/configure./configure./configure --help./configure --without-server./configure --help./configure; make; make install./mysql-test-run.pl./mysql-test-run.pl test_name/usr/local/mysql/bin/mysqlBUILD/autorun.shCRTUSRPRFHot BackupInnoDB Hot BackupInnoDB Hot BackupMYSQLINST/UPGMYSQLMetrowerks CodeWarrior for NetWareNET START MySQLNET STOP MySQLNET START MySQLNET STOP MySQLNotepadPowerArchiverRegistry EditorService Control ManagerStart>Run>cmd.exeText in this styleWinZip\! command\. file_name\? [arg]\C charset_name\P [command]\R [str]\T [file_name]\h [arg]\r [db_name host_name]]\u db_nameaddgroupadduserbashbin/mysql_setpermissionbin/mysqld_safebin/safe_mysqldbisonbzrcat [> filename]cccharset charset_namecharset_name charset_namechrootcmd.execommand.comcomp_errcomp_err [options]comp_err [options] from_file ... to_fileconfigureCREATE TABLE Syntax”Can't initialize character set”tar.gz Packages on Other
Unix-Like Systems”LOAD
DATA LOCAL”ARCHIVE Storage Engine”BLACKHOLE Storage Engine”CSV Storage Engine”EXAMPLE Storage Engine”FEDERATED Storage Engine”MyISAM Storage Engine”configure --helpconfigure.jsconnect [db_name host_name]]cpcrash-mecroncshdelimiter strgcclibmysqld”DBI/DBD
Interface”InnoDB Storage Engine”gdbgmakegnutargpg --importgroupaddgtartar.gz Packages on Other
Unix-Like Systems”gunziphelp [arg]help contentsiccidtuneidtune name parameterinnochecksuminnochecksum [options] file_nameisamchkisamchk -rqisamchk -risamchk [options] tbl_name isamlog [options] [log_file [tbl_name] ...]libtoolmakeDBI/DBD
Interface”make realcleanmake -f Makefile.aperl inst_perl MAP_TARGET=perlmake distcleanmake installInnoDB Storage Engine”make testmake_binary_distributionmake_win_bin_distmake_win_bin_dist [options] package_basename [copy_def ...]make_win_src_distributionmkdev mysqlmkdev mysqlmsql2mysqlmsql2mysqlC-source-file ...my_print_defaultsmy_print_defaults [options] option_group ...myisam_ftdumpmyisam_ftdump [options] tbl_name index_nummyisamchkDELETE Syntax”MyISAM Startup Options”MyISAM Table Maintenance and Crash Recovery”MyISAM Table Optimization”REPAIR TABLE Syntax”MyISAM Tables”MyISAM Tables for Errors”MyISAM Tables”myisamchk Options”MyISAM Table Maintenance Schedule”INSERT Statements”MyISAM Storage Engine”myisamchk --analyzemyisamchk --description --verbosemyisamchk --helpmyisamchk --medium-check tbl_namemyisamchk --recovermyisamchk --safe-recovermyisamchk --safe-recover tbl_namemyisamchk --stats_method=method_name --analyzemyisamchk --unpackmyisamchk --update-statemyisamchk -amyisamchk -rmyisamchk *.MYImyisamchk --analyzemyisamchk --description --verbose tbl_namemyisamchk --fastmyisamchk --helpmyisamchk --keys-used=0 -rq /path/to/db/tbl_name.myisamchk --medium-checkmyisamchk --recover tbl_namemyisamchk --recover --quickmyisamchk --recover tbl_namemyisamchk --recover --quickmyisamchk --safe-recovermyisamchk --silent --force */*.MYImyisamchk --sort-index --sort-records=1myisamchk -amyisamchk -d tbl_namemyisamchk -dvmyisamchk -dv /path/to/table-index-filemyisamchk -dv tbl_namemyisamchk -dvvmyisamchk -dvv tbl_namemyisamchk -e *.MYImyisamchk -edmyisamchk -eimyisamchk -eis tbl_namemyisamchk -eivmyisamchk -eiv tbl_namemyisamchk -rmyisamchk -r database/table.MYImyisamchk -r tbl_namemyisamchk -r -qmyisamchk -r -q --set-character-set=charset_namemyisamchk -r -q tbl_namemyisamchk -rqmyisamchk -rq /path/to/db/tbl_namemyisamchk -s database/*.MYImyisamchk [options] tbl_name ...myisamlogmyisamlog [options] [log_file [tbl_name] ...]myisampackCREATE TABLE Syntax”MERGE Table Advantages and Disadvantages”MyISAM Table Storage Formats”The table is full”INSERT Statements”MERGE Storage Engine”MyISAM Storage Engine”myisampack [options] file_name ...mysql--' as the Start of a Comment”CREATE PROCEDURE and
CREATE FUNCTION Syntax”FOREIGN KEY Constraints”HELP Syntax”Ignoring user”LIMIT Optimization”LOAD DATA FROM MASTER Syntax”LOAD DATA INFILE
Syntax”LOAD TABLE tbl_name FROM
MASTER Syntax”Out of memory”Packet too large”SHOW ENGINE INNODB
STATUS and the InnoDB Monitors”SHOW SLAVE STATUS Syntax”mysql_errno()”mysql_sqlstate()”InnoDB
Database”InnoDB Tablespace”tar.gz Packages on Other
Unix-Like Systems”SELECT and Other Statements”=
Sign”LOAD
DATA LOCAL”BLOB and
TEXT Types”InnoDB Data Dictionary Operations”--safe-updates Option”mysql --helpmysql -u root mysqlmysql ... --debugmysql < file_namemysql [options] db_namemysql mysql < /tmp/mysql.dumpmysql {start|stop}mysql-servermysql-test-runmysql-test-run.plmysql.servermysql.server stopmysql_configmysql_config --libmysqld-libsmysql_config --plugindirmysql_config optionsmysql_convert_table_formatmysql_convert_table_format [options] db_namemysql_create_system_tablesmysql_explain_logmysql_find_rowsmysql_find_rows [options] [file_name ...]mysql_fix_extensionsmysql_fix_extensions data_dirmysql_fix_privilege_tablesCREATE FUNCTION Syntax”mysql_install_dbtar.gz Packages on Other
Unix-Like Systems”InnoDB Tables”mysql_install_db --forcemysql_install_db [options]mysql_secure_installationmysql_setpermissionmysql_setpermission [options]mysql_setpermissionsmysql_stmt_execute()mysql_stmt_prepare()mysql_tableinfomysql_tzinfo_to_sqlmysql_tzinfo_to_sql argumentsmysql_upgradeALTER DATABASE Syntax”CREATE EVENT Syntax”CREATE FUNCTION Syntax”mysql_upgrade mysql_upgrade [options]mysql_waitpidmysql_waitpid [options] pid wait_timemysql_waitpid()mysql_zapmysql_zap [-signal] [-?Ift] patternmysqlaccessmysqlaccess [host_name [user_name [db_name]]] [options]mysqladminCREATE DATABASE Syntax”Can't connect to [local] MySQL server”DROP DATABASE Syntax”FLUSH Syntax”MyISAM Tables”mysqladmin --sleepmysqladmin createmysqladmin debugmysqladmin flush-hostsmysqladmin flush-logsmysqladmin flush-privilegesmysqladmin flush-tablesmysqladmin flush-xxxmysqladmin killmysqladmin passwordmysqladmin processlistmysqladmin processlist statusmysqladmin refreshmysqladmin reloadmysqladmin shutdownmysqladmin variablesmysqladmin vermysqladmin versionmysqladmin --sleepmysqladmin -h localhost variablesmysqladmin -i 5 -r statusmysqladmin -i 5 statusmysqladmin -i10 processlist statusmysqladmin -u root pingmysqladmin -u root drop testmysqladmin -u root processlistmysqladmin -u root processlistmysqladmin [options] command [command-options] [command [command-options]] ...mysqladmin debugmysqladmin extended-statusmysqladmin flush-hostsmysqladmin flush-logsmysqladmin flush-privilegesmysqladmin flush-tablesmysqladmin killKILL Syntax”MySQL server has gone away”mysqladmin passwordmysqladmin processlistmysqladmin refreshmysqladmin reloadmysqladmin reload versionmysqladmin shutdownGRANT Syntax”InnoDB Tablespace”MyISAM Tables”mysqladmin statusmysqladmin variablesmysqladmin variables extended-status processlistmysqladmin versionmysqlanalyzemysqlbinlogBINLOG Syntax”SET Syntax”SHOW BINLOG EVENTS Syntax”START SLAVE Syntax”InnoDB
Database”mysqlbinlog --database=testmysqlbinlog binary-log-file | mysqlmysqlbinlog --database=db2mysqlbinlog --database=testmysqlbinlog [options] log_file ...mysqlbinlog|mysqlmysqlbugmysqlcheckALTER DATABASE Syntax”MyISAM Table Maintenance and Crash Recovery”MyISAM Storage Engine”mysqlcheck --check-upgrademysqlcheck --check-upgrademysqlcheck --repairmysqlcheck [options] [db_name [tbl_name ...]]mysqldFile' Not Found and
Similar Errors”CHECKSUM TABLE Syntax”CREATE FUNCTION Syntax”CREATE VIEW Syntax”Can't connect to [local] MySQL server”Can't create/write to file”Can't initialize character set”Client does not support authentication protocol”FLUSH Syntax”Host 'host_name' is
blocked”INSERT DELAYED Syntax”Ignoring user”InnoDB Configuration”InnoDB General Troubleshooting”InnoDB Startup Options and System Variables”KILL Syntax”LOAD DATA INFILE
Syntax”MyISAM Startup Options”MySQL server has gone away”OPTIMIZE TABLE Syntax”Packet too large”SELECT Syntax”SET TRANSACTION Syntax”SHOW ENGINE INNODB
STATUS and the InnoDB Monitors”SHOW ENGINE Syntax”SHOW VARIABLES Syntax”The table is full”Too many connections”mysql_affected_rows()”mysql_options()”InnoDB Data and Log
Files”InnoDB
Database”InnoDB Auto-Increment Locking”MyISAM Tables”InnoDB Tablespace”InnoDB Initialization Problems”InnoDB Recovery”MyISAM Tables”tar.gz Packages on Other
Unix-Like Systems”LOAD
DATA LOCAL”MyISAM Table Maintenance Schedule”BLACKHOLE Storage Engine”BLOB and
TEXT Types”MyISAM Storage Engine”pdb to create a Windows crashdump”mysqld --helpmysqld --print-defaultsmysqld --removemysqld --consolemysqld --helpmysqld --no-defaults ...mysqld --print-defaultsmysqld --verbose --helpmysqld [options]mysqld-.13mysqld-abc.exemysqld-debugmysqld-maxmysqld-max-ntmysqld-max.exemysqld-ntmysqld_multimysqld_multi [options] {start|stop|report} [GNR[,GNR] ...]mysqld_safeFile' Not Found and
Similar Errors”InnoDB General Troubleshooting”Packet too large”InnoDB Tablespace”tar.gz Packages on Other
Unix-Like Systems”=
Sign”MyISAM Table Maintenance Schedule”mysqld_safe optionsmysqldumpBACKUP TABLE Syntax”CREATE INDEX Syntax”CREATE VIEW Syntax”FOREIGN KEY Constraints”InnoDB Performance Tuning Tips”LOAD DATA FROM MASTER Syntax”LOAD DATA INFILE
Syntax”LOAD TABLE tbl_name FROM
MASTER Syntax”UNINSTALL PLUGIN Syntax”InnoDB Data and Log
Files”InnoDB
Database”InnoDB Database to Another Machine”BLOB and
TEXT Types”InnoDB Buffer Pool”mysqldump --delete-master-logsmysqldump --flush-logsmysqldump --master-datamysqldump --routinesmysqldump --xmlmysqldump --flush-logsmysqldump --helpmysqldump --master-datamysqldump --opt --add-drop-table mysql > /tmp/mysql.dumpmysqldump --quick db_name tbl_name_1 ... tbl_name_n > query.sqlmysqldump --tabmysqldump -Tmysqldump [options] [db_name [tbl_name ...]]mysqldump mysqlmysqldumpslowmysqldumpslow [options] [log_file ...]mysqlhotcopyBACKUP TABLE Syntax”LOAD DATA FROM MASTER Syntax”LOAD TABLE tbl_name FROM
MASTER Syntax”mysqlhotcopy --flushlogmysqlhotcopy argumentsmysqlimportLOAD DATA INFILE
Syntax”LOAD
DATA LOCAL”mysqlimport [options] db_name textfile1 ...mysqlmanagermysqloptimizemysqlrepairmysqlshowSHOW DATABASES Syntax”mysqlshow --status db_namemysqlshow -k db_name tbl_namemysqlshow db_namemysqlshow db_name tbl_namemysqlshow [options] [db_name [tbl_name [col_name]]]mysqlshow db_namemysqlshow mysql usermysqlslapmysqlslap [options]mysqltestndb_restorendb_size.plnm --numeric-sort mysqldnowarningopenssl md5 package_namepack_isampack_isam [options] file_name pager [command]perrorFile' Not Found and
Similar Errors”Can't create/write to file”MyISAM Tables”perror [options] errorcode ...prompt [str]psps xa | grep mysqldpthreadreplacereplace argumentsresolve_stack_dumpresolve_stack_dump [options] symbols_file [numeric_dump_file]resolveipresolveip [options] {host_name|ip-addr} ...rpmrpm --importrsyncsafe_mysqldscpshsource file_namesystem commandtartar.gz Packages on Other
Unix-Like Systems”tcshtee [file_name]ulimitulimit -nulimit -culimit -c 1000000ulimit -c unlimitedulimit -d 256000ulimit -d unlimitedulimit -n 256ulimit -v 80000use db_nameuseraddwarningsyacczip
User Comments
Add your own comment.