Page 1 of 1

Backing up htdocs an mysql

PostPosted: 13. November 2003 19:53
by Repute Online Media
Hi ther foulks,

How can I manage that my /htdocs and al Mysql databases are backtup to /opt/lampp/backup or an other harddrive?

Any ideas?

Thnx,

Repute

PostPosted: 13. November 2003 22:13
by Kristian Marcroft
Hi,...

with a Shell/Bash Script in a cronjob...

for mySQL this would look like:
Code: Select all
#!/bin/sh
mysqldump -u root --password=[rootpass] --opt --all-databases > backup.sql
echo "mySQL Backup completed"


to backup your htdocs I would use a tar command...

So long
KriS

PostPosted: 14. November 2003 18:53
by Hansi
hmm, bei mir kommt immer

/var/backup/backup: mysqldump: command not found

bitte um hilfe :(

PostPosted: 14. November 2003 19:03
by Kristian Marcroft
Hi,

please try

/opt/lampp/bin/mysqldump


So long
KriS

PostPosted: 14. November 2003 22:58
by Hansi
WoW es funktioniert, thx!! ;)

Aber jetzt noch eine frage, wie importier ich diesen dump? also ich weiss wie man tabellen in eine datenbank mit phpmyadmin importiert, aber wie mach ich das mit 5 datenbanken?

PostPosted: 15. November 2003 07:25
by Kristian Marcroft
Hi Hansi,

just for the Records, this is the english part of the Forum.
Please stick to the english... otherwise we wouldn't need it.

Back to your question....
How to restore...
http://faq.kwm-web.info/index.php?sid=6 ... 49&lang=de

Please also be carefull here, that "mysql" won't work, you need "/opt/lampp/bin/mysql"

So long
KriS

PostPosted: 15. November 2003 13:38
by Shoukri
in this thread ( http://community.apachefriends.org/f/viewtopic.php?t=3094 ) was a backupscript posted (i hate my english *g*)

Code: Select all
#! /bin/sh

#Date etc. 
DATUM=`date '+%Y-%m-%d'`

echo "BackUp script Starting...."

mkdir /backup
cd /backup

tar zcvf backup_root_${DATUM}.tar.gz /root
tar zcvf backup_mysql_${DATUM}.tar.gz /opt/lampp/var/mysql
tar zcvf backup_log_${DATUM}.tar.gz /opt/lampp/logs
tar zcvf backup_homeusr_${DATUM}.tar.gz /home/
tar zcvf backup_etc_${DATUM}.tar.gz /opt/lampp/etc

echo "Backup Data created...!"
echo "BackUp Data transfering..."

cd /backup

ftp -in <<EOF
open <IP OF YOUR FTP SERVER>
user USERNAME PASSWORD
bin
hash
prompt
cd html
put backup_root_${DATUM}.tar.gz
put backup_mysql_${DATUM}.tar.gz
put backup_log_${DATUM}.tar.gz
put backup_homeusr_${DATUM}.tar.gz
put backup_etc_${DATUM}.tar.gz
QUIT
EOF

rm -rf /backup

echo "Finish!"

exit 0