0

i am almost new in PHP, MySQL. i want to develop a database query/stored procedure/script by which i can do followings: 1) read a text file, where daily-backup start time and target location is written. 2) on this time, the script will be automatically executed. 3) so that there will be a backup copy created in the user specified target location. 4) additionally, i want to create an encrypted and zipped backup copy.

i have already searched for this type of requirement, but still don't find any proper solution.

please suggest me how can i do this job. thanks in advance.

Md. Muzahid-ul Islam
  • 1
  • 3
  • 2
    Start by learning programming. – Daan Dec 11 '14 at 11:22
  • @Daan, thanks. i have already learnt other scripting :) now its time to work on php. and i hope u suggest me regarding the mentioned issue. not about learning lang. thanks. – Md. Muzahid-ul Islam Dec 11 '14 at 11:57
  • The simplest use `mysqldump` : see for example http://stackoverflow.com/questions/6750531/using-a-php-file-to-generate-a-mysql-dump – toto21 Dec 11 '14 at 12:12
  • thanks @toto21. this is a manual backup approach. but i am looking for automated system. i.e. is there anything like - i can create any Agent in Mysql which will fire in a certain time and execute the sqldump related script (db-script)? i have implemented this sort of job in MS Sql Server. – Md. Muzahid-ul Islam Dec 11 '14 at 18:08
  • Create cron job - see : http://stackoverflow.com/questions/18737407/how-to-create-cron-job-using-php – toto21 Dec 12 '14 at 11:12

0 Answers0