cron作业用于在linux / php中备份数据库 [英] cron job for backup the database in linux/php
问题描述
我是新的linux cron工作,我使用mysql DB,我的数据库名称finaldb,我想要每一个小时取这个数据库,
Am new to linux cron job, i am using mysql DB, my database name finaldb, i want to take this database every one hour,
dailbackup,在这个我有文件夹按日期明智,在这个每个文件夹我有备份mysql db文件
I have folder called dailbackup, in this i have folder by date wise,in this each folder i have backup mysql db file
名称像final_db_9.sql(这个备份在早上9点采取) ,final_db_13.sql(这个备份在中午1点到下午1点,像这样,
name like final_db_9.sql (this backup taken at morning 9 am), final_db_13.sql(this backup taken at noon 1pm, like that ,
这个过程目前正在手动进行,是可以让它自动化,任何想法,建议,
this process at present am doing manually , is it possible to make it automation , any ideas, suggestions ,
推荐答案
创建包含以下内容的PHP脚本:
Create a PHP Script containing the following:
$dbFile = 'final_db'.date('H').'.sql.gz';
$dbHost = 'localhost'; // Database Host
$dbUser = 'username'; // Database Username
$dbPass = 'password'; // Database Password
exec( 'mysqldump --host="'.$dbHost.'" --user="'.$dbUser.'" --password="'.$dbPass.'" --add-drop-table "finaldb" | gzip > "'.$dbFile.'"' );
这篇关于cron作业用于在linux / php中备份数据库的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!