[Top][All Lists]
[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
>
dave.hall.vcf
Description: Card for <dave.hall@mbox.com.au>