I have a 4GB database in MySQL. How can I back it up? Furthermore, is there a way that I can speed up the restoration process in the event that I need to recover?
I currently use a cron job every night that calls mysqldump
to dump everything and I keep 3 days of backups.