Page 1 of 1
MySQL Backup task
Posted: Sat Jul 24, 2010 10:15 am
by Grande_Assiro
Hello everybody!I've just purchased my personal copy of RT 4.1 and I'm very very satisfied!!I would like to know if it is possible to schedule a backup of a MySQL database via RoboTask...It would be absolutely great since I use RT to automate the backups of a lot of websites with a lot of MySQL databases (backup paranoia of web admin, I guess...)Who could give me a hint? I'd really appreciate it!Grande Assiro aka Andrew
MySQL Backup task
Posted: Sat Jul 24, 2010 10:28 am
by Grande_Assiro
I forgot to mention...I'm quite newbie with MySQL management: what I've seen so far around is the mysqldump command:mysqldump
-u [username] -p [password] [databasename] > [backupfile.sql]Now, what I need to know is how to run this command and how to backup (via FTP I guess) the backupfile.sql on my local PC.I've seen that there's the SQL query in RT so I guess I should use that.As I've said before, every hint is precious!