Kalpeshkumar Posted September 2, 2019 Share Posted September 2, 2019 Hey larry, I am great admirer of your book. i had purchased and read all your books related to PHP and MySQL and i learned a lot so that i was able to devlop laboratory information system for my clinical laboratory on my own. However i have one suggestion for 'PHP and MySQL book'. Please include one dedicated chapter for backing up and restoring mysql database by PHP. currently i am using phpmyadmin for that but i very much like to create interface in my own PHP project for backup and restoring database. desparetly waiting for such chapter written in your unique style. Thank you Link to comment Share on other sites More sharing options...
Larry Posted September 3, 2019 Share Posted September 3, 2019 Thanks so much for the nice words. I really appreciate it. And it's great to hear you've been able to make great use of the information already! Thanks, too, for the suggestion. I thiiiiink I actually wrote such an example in one of my books, but I forget which now. Personally, though, I prefer to backup databases using the command-line tools, although that does require better access and knowledge. In any case, thank you again for the nice words and suggestion. Cheers! Link to comment Share on other sites More sharing options...
Kalpeshkumar Posted September 15, 2019 Author Share Posted September 15, 2019 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) Link to comment Share on other sites More sharing options...
Necuima Posted September 16, 2019 Share Posted September 16, 2019 The backup and restore functionality is in Larry's book "PHP 5 Advanced", Chapter 10. Link to comment Share on other sites More sharing options...
Larry Posted September 20, 2019 Share Posted September 20, 2019 Hey Dr. Kalpesh! Thanks so much for sharing what you're doing. That's just so wonderful to hear! Kudos for that and for the work you're doing!!! Thanks, Necuima, for sharing the specific chapter. That code can be found at: https://www.larryullman.com/downloads/phpvqp2_scripts.zip Link to comment Share on other sites More sharing options...
Recommended Posts