https://blog.mdnsolutions.com/daily-backups-with-mysql-using-cronjobs/Automated backups with MySQL using cronjobshttps://i2.wp.com/blog.mdnsolutions.com/wp-content/uploads/2013/11/download.jpeg?fit=275%2C183&ssl=1https://i2.wp.com/blog.mdnsolutions.com/wp-content/uploads/2013/11/download.jpeg?resize=150%2C150&ssl=1Renato MedinaDatabaseMySQLAutomated,cronjob,Database,dump,MySQL,parametersI needed to automate the dump process of my databases and searching on the internet I found a very interest list of commands we can use.
If you wanted daily database dumps to last for a week, you could run something like that:
$ mysqldump -uMY_USERNAME -p MY_PASSWORD MY_DATABASE | gzip...Renato MedinaRenatoMedinamedinadato@gmail.comAdministratorPHP/MySQL Web Developer / Eternal student / A IT lover / Trying to learn to cooking / and so forth..
I am a Bachelor of Computer Information Systems from Brazil. Certified Oracle CMDEV CMDBA. I've been working as a Web Developer PHP and MySQL since 2004. I've also developed several software for companies in various industries. Currently consults MySQL, PHP development and keeps this blog where he talks about the BD among other topics.
My website is http://www.mdnsolutions.com and my blog this one you are in http://blog.mdnsolutions.com.MDN Blog