MySQL Backup task
-
Grande_Assiro
- Posts: 2
- Joined: Mon Mar 23, 2009 3:52 am
- Location: Italy
- Contact:
MySQL Backup task
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
-
Grande_Assiro
- Posts: 2
- Joined: Mon Mar 23, 2009 3:52 am
- Location: Italy
- Contact:
MySQL Backup task
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!
-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!