No need to turn the board off. :)

Thanks, I appreciate it.

JakeC

Is it normal for the backup made this way to be about half the size of the one that was downloaded via the vB admin backup? And should I be getting "Database Error" emails to my admin account every 2 seconds while backing it up? Other than that, everything seemed to have gone well.

Thanks.

No and No.

teck help me out i got this error

mysqldump --opt -u***** -p clan?racknine?net > /home/myback.sql

mysqldump: Got error: 1130: Host 'localhost.localdomain' is not allowed to connect to this MySQL server when trying to connect

Great Tutorial Teck! Ive been looking for a way to do this for a while.

i have very small board for that reason i share server with someone but dont have have shell access backing up is not a problem i use SQLyog or MySQL-Front clients backing up my database is ok but when i restore it takes ages and i mean ages. The way it backsup is it runs SQL Query on every thing like thousands for word and search they take the most time i was wondering is there a way i can just upload the whole backup file so it dosnt run Queries instead i just delete the old one and replace it with new one.
i have broadband connection so it would take long to uoload the files.
Many Thanks

My backup strategy - this runs as a daily cron job.

My web root and the databases are on /usr not /var - and /usr is on a 40g IDE drive. The rest of the system is on a 10k rpm SCSI drive. No reason for the web content to be faster than my internet connection :)

I get one copy of the backup on each spindle and then manually copy one of the backups to a different machine once a week or so. I guess I could automate that if I wanted to.

#!/bin/sh

service httpd stop

mysqldump -uusername -ppassword -c vb_bassforum > /usr/www/archive/vb_bassforum.sql.dump
mysqldump -uusername -ppassword -c pointbeing > /usr/www/archive/pointbeing.sql.dump
mysqldump -uusername -ppassword -c hcbf > /usr/www/archive/hcbf.sql.dump

service httpd start

cp /var/spool/mail/* /usr/www/archive/mail

#change dump permissions so I can restore databases from remote with phpMyAdmin if I need to.

chown wizard /usr/www/archive/*.dump
chgrp apache /usr/www/archive/*.dump
chmod 660 /usr/www/archive/*.dump

tar cf /archive/backup.tar /usr/www/*

cp /archive/* /usr/archive

A little hint for those who's database does not run on their webserver, i.e. where your host has a dedicated mysql server.

You must use the '-h' option to specify a mysql server

Example:

mysqldump --opt -h mysite.co.uk -u name -p dbname > /home/www.mysite.co.uk/public_html/backup/vbulletin.sql

I spent weeks trying to get my head round this, eventualy our sysadmin helped out with the above info.

use: /var/www/html/backup/blablabla.sql


actually....get it out of 'web accessible' area...
/var/backup/blablabla.sql