RE: [Phpgroupware-users] Backing up PHPgroupware

[Jim Hale]

Super Easy (since I've already had to do it several times already) :)

mysql -u[user account] [name of new MySQL database] < [Name of
Previously Dumped Database] -p

It will prompt you for your MySQL Password and then create the tables
and add the data. 

Jim

-----Original Message-----
From: address@hidden
[mailto:address@hidden
On Behalf Of Bob Crandell
Sent: Friday, April 18, 2003 9:19 AM
To: address@hidden
Subject: RE: [Phpgroupware-users] Backing up PHPgroupware


This looks really good.  How would you restore the database?

Thanks

Jim Hale (address@hidden) wrote:
>
>I have a script that I run 2x day to backup my websites and SQL 
>Databases to a Win2K Box. The lines in my script related to 
>phpGroupWare
>are:
>
>Backup the entire directory structure:
>--------------------------------------
>tar -zcvf halegroup.no-ip.org.tar.gz /home/[path to root of 
>groupware]/*
>
>Dump the database:
>------------------
># Backup SQL Database (phpGroupWare 914002)
>prefix=GWARE
>suffix=`eval date +%m%d%y`
>filename=$prefix$suffix
>mysqldump -u[user account] -p[password] --opt [Name of Groupware 
>Database] > $filename.sql
>
>HTH,
>
>Jim
>

--
Bob Crandell
Assured Computing
When you need to be sure.
address@hidden
www.assuredcomp.com
Voice - 541-689-9159
FAX - 541-463-1627
Eugene, Oregon




_______________________________________________
Phpgroupware-users mailing list
address@hidden
http://mail.gnu.org/mailman/listinfo/phpgroupware-users