hi, i am quite new to mysql. i want to implement some sort of archiving tool for archiving(not backup) past database records and later on retrieving them. database records are periodically deleted according some date constraints by a deamon.that is why i want to archive current database records before they are deleted.mysql server/client are running on the same host.so i do not need to cope with network.i have prepared GUI implemented in java for displaying of past records. i decided to use mysqldump for archive script. script will do: A1. mysqldump -t dbName > YYYY_MM_DD_HH_MM_SS.sql A2. tar YYYY_MM_DD_HH_MM_SS.sql A3.gzip YYYY_MM_DD_HH_MM_SS.sql.tar ... also for retrieve script B1.tar zxvf YYYY_MM_DD_HH_MM_SS.sql.tar.gz B2. mysql dbName < YYYY_MM_DD_HH_MM_SS.sql .. here problem is, dump is for restore of databases, hence tries to insert records ,which are deleted from the database, to the same database. i don't want to restore my original database.So, i created another database where archive dumps will be restored .but this time, everytime A1 runs, dump belongs to original table and i have to change database name to the other database name(archive records) so that when B2 runs, dump will be extracted to this temporary database..
my algorithm is described as above. is there another easier method than this one? are there any other ways for archiving and retrieving? thanx in advance -Ilke -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
