CPG Dragonfly™ CMS ⇒ Wiki ⇒ Tips and Tricks

<?php
require_once('config.php');
set_time_limit(0);
header("Content-Type: application/x-gzip; name=\"$dbname.sql.gz\"");
header("Content-disposition: attachment; filename=$dbname.sql.gz");
passthru("mysqldump -f -h$dbhost -u$dbuname -p$dbpass $dbname --add-drop-table | gzip -9cf");

i.b CronJob/SSH

Create a file called mysqlbackup.sh

#! /bin/sh
DBNAME=here
DBUSER=root
DBPASS=fill_in
FILE1=${DBNAME}-`date +%Y%m%d%H%M`.sql
DIR=/home/YOURNAME/
mysqldump -f -hlocalhost -u${DBUSER} -p${DBPASS} --add-drop-table ${DBNAME} | gzip -9c >${DIR}${FILE1}.gz

Updated: Mandag 24 Oktober @ 09:55 by gaban
Created: Onsdag 23 Februar @ 14:24 by Trevor

You are seeing squares or questionmarks on this page?

All content of this website is copyrighted by the Creative Commons NC-SA
The logos and trademarks used on this site are the property of their respective owners
We are not responsible for comments posted by our users, as they are the property of the poster.
Our server runs on a P3 1.2GHz with 512MB RAM with no accelerators

Side Generering tok 0.1347 sekunder og 9 Database Oppkall på 0.0453 sekunder
Memory Usage: 1.47 MB
Interactive software released under GNU GPL, Code Credits, Privacy Policy

CPG Dragonfly™ CMS

DedicatedNow

i. Data Backup

i.a Fast thru PHP on Linux

i.b CronJob/SSH