User Tools

Site Tools


sql

SQL

MySQL

  • Navicat<br>

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<br>

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

sql.txt · Last modified: 2017/07/01 12:53 by wikisysop