phpgroupware-users
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[Phpgroupware-users] RE: Backing up PHPgroupware


From: Hsing-Foo wang
Subject: [Phpgroupware-users] RE: Backing up PHPgroupware
Date: Sat, 19 Apr 2003 08:19:38 +0000

Hi,

When I try your script I get:

$filename.sql ambiguous redirect

Any idea why? I think the line suffix='eval date +%m%d%y' has something to do 
with it.

TIA

Regards,
Hsing-Foo


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





reply via email to

[Prev in Thread] Current Thread [Next in Thread]