phpgroupware-users
[Top][All Lists]
Advanced

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

Re: [Phpgroupware-users] how to save my data


From: Dave Hall
Subject: Re: [Phpgroupware-users] how to save my data
Date: Thu, 19 Jun 2003 08:37:00 +1000

try this:


//backup
$ su
# mysqldump -c --add-drop-table -p phpgroupware >
~/phpgw-backup-DDMMYYYY.sql

//if you want to drop the db ... do this also
# mysql -p 
> DROP DATABASE phpgroupware;

//restore
$ mysql -u root -p < ~/phpgw-backup-DDMMYYYY.sql
$ mysql -u root -p
> GRANT ALL ON phpgroupware.* TO phpgroupwware IDENTIFIED BY
'somelongpasswordiwillforget';

Done

Cheers

Dave
BOYER PASCAL <address@hidden> wrote:

> Hi,
> 
> I would like to know how to save my data.
> 
> I tried this, but it doesn't work:
> 
> su
> /etc/init.d/mysql stop
> cp /var/lib/mysql/phpgroupware/* ~/pgwdata.bkp
> rm /var/lib/mysql/phpgroupware/*
> /etc/init.d/mysql start
> 
> and then, of course, I have no more data about pgw.
> 
> Now, I want to put back my data:
> 
> su
> /etc/init.d/mysql stop
> cp ~/pgwdata.bkp/* /var/lib/mysql/phpgroupware
> /etc/init.d/mysql start
> 
> and I can see my data with PhpMyAdmin, but if I try to login me to 
> pgw I 
> obtain this error message:
> 
> Fatal Error: It appears that you have not created the database 
> tables 
> for phpGroupWare. Click here to run setup.
> 
> What must I do to save correctly my data ?
> 
> 
> Pascal -- France
> 
> 
> 
> _______________________________________________
> Phpgroupware-users mailing list
> address@hidden
> http://mail.gnu.org/mailman/listinfo/phpgroupware-users
> 

Attachment: dave.hall.vcf
Description: Card for <dave.hall@mbox.com.au>


reply via email to

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