This is a discussion on backup and restore of a dbase within the MySQL forums, part of the Database Server Software category; --> Hi, I would need of an utility for an automatic and scheduled backup of the remote dbase. Do you ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| Hi, I would need of an utility for an automatic and scheduled backup of the remote dbase. Do you have some tip? I have also a little problem with the remote dbase, accidentally I have deleted the content of an 'id'line from a table with all the other values associated. I have the backup copy but only of the local dbase(local.sql). Is it possible to copy the single line from the local dbase to the remote one? Which query I have to write to extract and copy a single id line from a local table to the remote one? Excuse for my little english. Regards and thanks. Jim |
| ||||
| Jim wrote: > Hi, > I would need of an utility for an automatic and scheduled backup of the > remote dbase. Do you have some tip? should work fine with mysqldump used in small script for the cron. > I have the backup copy but only of the local dbase(local.sql). Is it > possible to copy the single line from the local dbase to the remote one? > Which query I have to write to extract and copy a single id line from a > local table to the remote one? If you know the line, then no problems at all. -- //Aho |