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... 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?? 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... 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. 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... 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 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. Link to comment https://forums.phpfreaks.com/topic/133092-mysql-backup/#findComment-692717 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.