grantjm Posted April 22, 2003 Share Posted April 22, 2003 Hello, I would like to install some of the contributions. But before I embark on this seemingly daunting task - I would like to "backup " my Database etc. I went here " ]http://www.oscommerce.com/community/contri...ons,847"[/url] and found the contribution to do the backup. My question is it says: # this mod allows you to keep a defined number of old backups # this should be run from a crontab What is a "crontab"? BG Making the internet community better. Knowledge is power. Link to comment Share on other sites More sharing options...
carlp Posted April 22, 2003 Share Posted April 22, 2003 You can run a backup from your admin section of the Catalog. You will need to go to Tools > Database Backup. You will find the first time you do this, you will get some errors. You will need to edit your configure.php in admin/includes/ and setup the backup directory. You will then need to create that directory in your admin folder: Line 39 define('DIR_FS_BACKUP', DIR_FS_ADMIN . 'backups/'); This means I have a directory structure like this /home/web/catalog/admin/backups See what I'm doing?You will then need to set the permissions on this, im not sure what you would need to do in Windows (i'm pure Linux) but in Linux you would need to do chmod 644 backups/ I believe 644 is the correct number. Then go to create your backup. You will know when it works, cos you can download the backups. I always download the backups. I find it more safer that way. That is why my directory is CHMOD 777 because I just use it as a jail to create the backup. Crontab: A crontab is a Linux/Unix script that will do an action that you ask. If you don't understand them, I would suggest that you don't try to use them. They can be very difficult. FYI the command to create a crontab is crontab -e as a user in your Linux/UNIX system. Hope this helps :) Kindest Regards, Carl Pickering If there is light at the end of the tunnel, switch it off. I have to save on my electricity bill Link to comment Share on other sites More sharing options...
grantjm Posted April 22, 2003 Author Share Posted April 22, 2003 Thank you. It looks like it worked. Another thing, How can I test the integrity of the "backed up" Database? BG Making the internet community better. Knowledge is power. Link to comment Share on other sites More sharing options...
carlp Posted April 22, 2003 Share Posted April 22, 2003 Thank you. It looks like it worked. Another thing, How can I test the integrity of the "backed up" Database? Look at the size I guess. I don't believe there is any way. What the backup does it run a standard MySQL server command mysqldump. That command is very good. So in all honesty, I don't know!. *shrug* Try it, see what happens. Kindest Regards, Carl Pickering If there is light at the end of the tunnel, switch it off. I have to save on my electricity bill Link to comment Share on other sites More sharing options...
orchard Posted April 22, 2003 Share Posted April 22, 2003 You could restore the backup to a test site. You can look at the backup in wordpad just make sure it at least looks like text. In olden times the men were made of iron and the ships were made of wood; now it's the other way around. :wink: Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.