RE: [Phpgroupware-users] Backing up PHPgroupware

[Bob Crandell]

I wish I knew MySQL better.

Thanks.

Jim Hale (address@hidden) wrote:
>
>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
>>
>
>Voice - 541-689-9159
>FAX - 541-463-1627
>Eugene, Oregon
>
>
>
>
>_______________________________________________
>Phpgroupware-users mailing list
>address@hidden
>http://mail.gnu.org/mailman/listinfo/phpgroupware-users
>
>
>
>_______________________________________________
>Phpgroupware-users mailing list
>address@hidden
>http://mail.gnu.org/mailman/listinfo/phpgroupware-users
>

--
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