Thanks larry for response, i had gone through PHP for web, Effortless E commerce, PHP and MySQL for dynamic websites. all three books but didn't find chapter on using PHP for Mysql backup and restoring.
I want to write the PHP code that can take a backup of two particular tables of database and then truncate those tables while preserving the data of last 1 month. i intend to save those backup files on portable drive as in my country we have to preserve clinical data for quite long time. while truncating table i want to preserve last 1 month's data as if some patient had lost their blood report then we can provide them without requiring backed up files.
I think many budding PHP developers might be going though the same problem as these functionalities are very common. and if you write one dedicated book/ chapter on such aspect i am very much interested to buy one.
I want to share something important with you. I am working in government run hospital which provide services at very nominal charges (e.g. 0.07 USD for blood glucose) and by developing PHP-MySQL based laboratory information system, i was able to save lots and lots of papers almost 500 pages per day. I am glad to inform you that without your books this would not be possible.
Thanks and with regards
Dr. Kalpesh (MD, Biochemistry)