 readme  id readmetxt v 11212123 20091209 220742 ronan exp backup and migrate 2 for drupal 6x by ronan dowling gorton studios ronan at gortonstudios dot com description this module makes the task of backing up your drupal database and migrating data from one drupal install to another easier it provides a function to backup the entire database to file or download and to restore from a previous backup you can also schedule the backup operation compression of backup files is also supported there are options to exclude the data from certain tables such as cache or search index tables to increase efficiency by ignoring data that does not need to be backed up or migrated the backup files are a list of sql statements which can be executed with a tool such as phpmyadmin or the commandline mysql client installation put the module in your drupal modules directory and enable it in admin build modules go to admin user permissions and grant permission to any roles that need to be able to backup or restore the databse configure and use the module at admin content backupmigrate optional enable tokenmodule to allow token replacement in backup file names lighttpd users add the following code to your lighttpconf to secure your backup directories http url sites default files backupmigrate urlaccessdeny very important security note backup files may contain sensitive data and by default are saved to your web server in a directory normally accessible by the public this could lead to a very serious security vulnerability backup and migrate attempts to protect backup files using a htaccess file but this is not guaranteed to work on all environments and is guaranteed to fail on web servers that are not apache you should test to see if your backup files are publicly accessible and if in doubt do not save backups to the server or use the destinations feature to save to a folder outside of your webroot other warnings a failed restore can destroy your database and therefore your entire drupal installation always test backup files on a test environment first if in doubt do not use this module this module has only be tested with mysql and does not work with anyother dbms if you have experiences with postres or any other dbms and are willing to help test and modify the module to work with it please contact the developer at ronan at gortonstudios dot com make sure your php timeout is set high enough to complete a backup or restore operation larger databases require more time also while the module attempts to keep memory needs to a minimum a backup or restore will require significantly more memory then most drupal operations if your backup file contains the sessions table all other users will be logged out after you run a restore to avoid this exclude the sessions table when creating your backups be aware though that you will need to recreate the sessions table if you use this backup on an empty database do not change the file extension of backup files or the restore function will be unable to determine the compression type the file and will not function correctly if a restore fails don t panic the restore file should work with phpmyadmin s import function or with the mysql command line tool if it does not then it is likely corrupt you may panic now make sure that this module is not your only form of backup  