rugzo Posted November 17, 2008 Share Posted November 17, 2008 Hi all, what is the best way to make autobacks for mysql. I have for example a software called KLS Backup 2008 which can make backups of files and folder but i don't exactly know which folders i have to backup since i am using xampp. Or is there a better way or a software which i can use. Thanks very much... Quote Link to comment https://forums.phpfreaks.com/topic/133092-mysql-backup/ Share on other sites More sharing options...
severndigital Posted November 17, 2008 Share Posted November 17, 2008 you want to make a backup of your entire mySQL?? or just the databases / tables?? Quote Link to comment https://forums.phpfreaks.com/topic/133092-mysql-backup/#findComment-692178 Share on other sites More sharing options...
rugzo Posted November 17, 2008 Author Share Posted November 17, 2008 The databases which i created in mysql... Quote Link to comment https://forums.phpfreaks.com/topic/133092-mysql-backup/#findComment-692248 Share on other sites More sharing options...
revraz Posted November 17, 2008 Share Posted November 17, 2008 You would want to use a Database Backup routine, not files and folders. Quote Link to comment https://forums.phpfreaks.com/topic/133092-mysql-backup/#findComment-692261 Share on other sites More sharing options...
rugzo Posted November 17, 2008 Author Share Posted November 17, 2008 In case the system should crash i want to be able to recovery all the databases and tables with all the settings and storages after a new mysql installation... Quote Link to comment https://forums.phpfreaks.com/topic/133092-mysql-backup/#findComment-692286 Share on other sites More sharing options...
corbin Posted November 17, 2008 Share Posted November 17, 2008 Easiest way is just to do mysqldump in a crontab: IE set up a crontab to run this every 24 hours or something: /path/to/mysqldump -uusername -ppassword --all-databases > /some/file/place/backup.sql Quote Link to comment https://forums.phpfreaks.com/topic/133092-mysql-backup/#findComment-692324 Share on other sites More sharing options...
fenway Posted November 18, 2008 Share Posted November 18, 2008 I would caution against placing a plaintext password in the command line if you're not the only one with access to the box. Quote Link to comment https://forums.phpfreaks.com/topic/133092-mysql-backup/#findComment-692717 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.