MySQL
Downlaod MtySQL :
http://www.mysql.com/downloads/index.html
Access MySQL is easy:
- mysql
- mysql -u orbit -p
- mysql -uzbwu -pwuzhibin
If you are root of mysql server, use GRANT command to add new user.
GRANT only "select" for read-only and backup purpose
SQL commands:
- show database
- show tables
- select * into outfile "/tmp/openshow"
from lisbon;
- desc table2;
Configuration flies of option
Backup SQL
Using tool (AutoMySQLBackup)