| Author |
Message |
rob684
knows MySQLDumper
Joined: 20 Oct 2011
Posts: 3
|
 Posted:
2011-10-20, 13:59 Backup file removed or overwritten |
  |
Thank you for this great application that I have been using for years.
Now I am using v1.24.4 and only recently discovered the problem below.
When a SQL backup is made, say with name 'backup_1', it is stored in the file list with its timestamp (date + time hh:mm). No problem so far.
However, if I make another backup, say with name 'backup_2', within the same minute (i.e. the timestamp will be the same), the first backup is overwritten by the second.
I guess that the solution is simple: include the timestamp seconds into the backup file management.
PS: No problem if you reply in German.
|
|
   |
|
Anzeigen
|
|
Posted:
Anzeigen |
|
|
| |
|
Jens_K
Moderator
Age: 37
Joined: 04 Sep 2007
Posts: 1707
Location: Nähe Bielefeld
|
|
Posted:
2011-10-20, 14:43 (No subject) |
|
|
 |
|
DSB
Developer
Age: 41
Joined: 30 Apr 2004
Posts: 16049
Location: Reichenberg bei Würzburg
|
|
Posted:
2011-10-20, 17:05 (No subject) |
|
It's not a bug, it's a feature. 
Like Jens said: when you decide to make a second backup in the same minute, the first version is treated as a failure and therefor is overwritten. It doesn't make sense to create 2 backups within the same minute and keep both wasting disk space - so we keep the latest.
_________________
Gruß / Greetings, DSB
Teigwaren heißen Teigwaren, weil sie Teig waren.
Diejenigen, die lautstark darüber diskutieren, warum es nicht geht, mögen bitte jene nicht stören, die es gerade tun.
|
|
 |
|
rob684
knows MySQLDumper
Joined: 20 Oct 2011
Posts: 3
|
|
Posted:
2011-10-20, 18:57 (No subject) |
|
Yes it does sometimes make sense to create more backups within a short time.
For example, I have developed a Joomla! component that has its own config settings stored in a table. If I make changes to the component's config table (e.g. add fields or records), I often make first a backup of the whole site's db WITHOUT the component's config table, and then (within 1 minute sometimes) a backup of only the component's config table. This way I can install the altered config table and can always restore the old situation.
So maybe it is a good idea to add as an extra mysqldumper config option the time span within you want to have the previous backup treated as a failure.
Regards
|
|
| |
|
DSB
Developer
Age: 41
Joined: 30 Apr 2004
Posts: 16049
Location: Reichenberg bei Würzburg
|
|
Posted:
2011-10-20, 19:03 (No subject) |
|
« rob684 » wrote: I often make first a backup of the whole site's db WITHOUT the component's config table, and then (within 1 minute sometimes) a backup of only the component's config table. This way I can install the altered config table and can always restore the old situation.
You don't need to do this. Simply backup the whole database once.
Whenever you need to restore any of the the tables you can select which tables you want to restore. You can restore all tables or just your special config table from the same backup file.
_________________
Gruß / Greetings, DSB
Teigwaren heißen Teigwaren, weil sie Teig waren.
Diejenigen, die lautstark darüber diskutieren, warum es nicht geht, mögen bitte jene nicht stören, die es gerade tun.
|
|
| |
|
rob684
knows MySQLDumper
Joined: 20 Oct 2011
Posts: 3
|
|
Posted:
2011-10-20, 22:54 (No subject) |
|
Ah I see... I hadn't noticed the "choose tables to be restored" button before. Very very bad, because I always tell my clients to carefully look at the screen, because in 90+ % of the cases, the answer is there... and now I fell into the very same pittfall.
Thank you!
Topic closed...
|
|
| |
|
DSB
Developer
Age: 41
Joined: 30 Apr 2004
Posts: 16049
Location: Reichenberg bei Würzburg
|
|
Posted:
2011-10-21, 18:42 (No subject) |
|
This happens to all of us.
Have fun using MySQLDumper.
_________________
Gruß / Greetings, DSB
Teigwaren heißen Teigwaren, weil sie Teig waren.
Diejenigen, die lautstark darüber diskutieren, warum es nicht geht, mögen bitte jene nicht stören, die es gerade tun.
|
|
| |
|
|
|
