[bzcomputers]

Originally Posted by delds

I have 2 questions, is there a way to set daily auto backups or do I only have the options of weekly? Manual backups can be run at any time.

2nd Is it possible to remove the date prefex on the tables when backed up so for example it would backuup
access.sql
as
access.sql and not 2014-09-15-Access.sql ??

If I ever had to re upload I would not want the prefix on the tables and would have to rename each one first.
The folder gets names by date do I really need the tables with the prefex also?

next when downloading it to my local computer what mode should it be in ascii or binary?

Yes, this mod is automatically set for doing daily backups. You need to adjust the "Date Format" option to set how many backups you would like to keep. You will find information on this at this link in the settings: http://uk.php.net/manual/en/function.date.php. What you may have currently set is "W" which will save each backup as the week number of the year. With a setting of "W" every daily backup for 7 days will overwrite itself when created and at the end of the year you will have 52 backups (probably not what you are looking for). I recommend a setting of "D" which will save your backups by day of the week. So you'll have one backup for each day of the week and the following week the backups will begin to overwrite each other. This way you will never have more than 7 backups saved.

Second, the prefix is just added to the file names, the tables contained within the .sql files are unchanged (no prefix added).

Last, when transferring use binary to be safe. Ascii transfers everything as a regular text file which can corrupt some data within the database. I also highly recommend using the option to combine all tables into one backup file and using Gzip. Less chance of issues all the way around.