mysql admin information

file locations

example on one machine, 24 apr 2002:

execs:
/usr/bin/mysqlbug
/usr/bin/mysql_convert_table_format
/usr/bin/mysqld_multi
/usr/bin/mysql_fix_privilege_tables
/usr/bin/mysqlhotcopy
/usr/bin/mysql_install_db
/usr/bin/mysql_setpermission
/usr/bin/mysqltest
/usr/bin/mysql_zap

/usr/sbin/mysqld

/etc/rc.d/init.d/mysql

data:
/var/lib/mysql/

config:

user:

"mysql"

client-side MySQL programs:

http://www.mysql.com/doc/en/Client-Side_Overview.html


msql2mysql
A shell script that converts mSQL programs to MySQL. It
doesn't handle all cases, but it gives a good start when
converting. 

mysqlaccess
A script that checks the access privileges for a host,
user, and database combination. 

mysqladmin
Utility for performing administrative operations,
such as creating or dropping databases, reloading the
grant tables, flushing tables to disk, and reopening log
files. mysqladmin can also be used to retrieve version,
process, and status information from the server. 

mysqldump
Dumps a MySQL database into a file as SQL statements or
as tab-separated text files. Enhanced freeware originally
by Igor Romanenko. 

mysqlimport
Imports text files into their respective tables using LOAD
DATA INFILE. 

mysqlshow
Displays information about databases, tables, columns,
and indexes. 

replace
A utility program that is used by msql2mysql, but that
has more general applicability as well. replace changes
strings in place in files or on the standard input. Uses
a finite state machine to match longer strings first. Can
be used to swap strings. For example, this command swaps
a and b in the given files:

$ replace a b b a -- file1 file2 ...