i want mysqldump table definition , table data every day, config cron job comand: "mysqldump -u user -pxxxxx site_db | gzip > backup/site/site_t_$(date | awk {'print $1""$2""$3"_"$4'}).sql.gz" export table definition. correct command export data? thanks
by default mysqldump exports data - have use --no-data flag make export structure. since yours doing default, means "no-data" set in mysql options file, can find following these directions.
Comments
Post a Comment