SQL

From SysAdmins
Jump to: navigation, search

MySQL

  • Navicat

If you need a GUI for the Administration of MySQL, you should try Navicat, this is a greate tool for admins, under Windows and Linux.

  • Backup Dumpfile

create a script:

year=`date +%Y`
month=`date +%m`
day=`date +%d`
mysqldump -h HOSTNAME -u USERNAME -pPASSWORD --opt DATABASE > /home/backup/mysql/backup-$year-$month-$day.sql



MsSQL