[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
RE: [Phpgroupware-users] Backing up PHPgroupware
From: |
Jim Hale |
Subject: |
RE: [Phpgroupware-users] Backing up PHPgroupware |
Date: |
Fri, 18 Apr 2003 11:52:38 -0500 |
Well, I definitely ain't no pro - I was trying to figure out how to
backup my databases automatically several months ago and found the
answer(s) from being a user of phpNuke. :)
Jim
-----Original Message-----
From: address@hidden
[mailto:address@hidden
On Behalf Of Bob Crandell
Sent: Friday, April 18, 2003 11:24 AM
To: address@hidden
Subject: RE: [Phpgroupware-users] Backing up PHPgroupware
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
_______________________________________________
Phpgroupware-users mailing list
address@hidden
http://mail.gnu.org/mailman/listinfo/phpgroupware-users