The Official BLOG and Wiki for CustomMode.com
[ start | index | login ]
start > mysql

mysql

Created by dmitry. Last edited by dmitry, 2 years and 41 days ago. Viewed 503 times. #6
[diff] [history] [edit] [rdf]
labels
attachments
The MySQL database server is the world's most popular open source database. Over five million installations use MySQL to power high-volume Web sites and other critical business systems ? including industry-leaders like The Associated Press, Google, NASA, Sabre Holdings and Suzuki.

MySQL is an attractive alternative to higher-cost, more complex database technology. Its award-winning speed, scalability and reliability make it the right choice for corporate IT departments, Web developers and packaged software vendors.

>>http://www.mysql.com/

Dump/restore

It's absolutely essential to use

--quote-names or -Q with mysqldump. This will quote database, table, and column names within '`' characters. If the server SQL mode includes the ANSI_QUOTES option, names are quoted within '"' characters. As of MySQL 4.1.1, --quote-names is on by default, but can be disabled with --skip-quote-names.

remote accces over ssh

This article seems to explain things fairly well: >>http://www.vbmysql.com/articles/security/gui-tunnel.html

rpm collection

>>http://fr2.rpmfind.net/linux/rpm2html/search.php?query=mysql&submit=Search+...

linux help

>>http://www.linuxhelp.net/guides/mysql/

Installing on linux is easy

yum install mysql mysql-devel mysql-server
no comments | post comment
custommode.com | ©2000-2005
webmaster at custommode dot com