Welcome, Guest
Please Login or Register.    Lost Password?

how to restore our owl ?
(1 viewing) (1) Guest
Go to bottomPage: 1
TOPIC: how to restore our owl ?
#4779
how to restore our owl ? 1 Month, 1 Week ago Karma: 0
Hi, B0zz:

We just delete all the document on our 0.96,
then we ftp all files from client , but all the group/users privelege is a mess now ,we also have a backpup of mysql db, could you tell us how can we retore it ?

Thanks
.jOe
vkjuju
Expert Boarder
Posts: 154
graphgraph
User Offline Click here to see the profile of this user
Last Edit: 2010/07/30 03:53 By vkjuju.
The administrator has disabled public write access.
 
#4781
Re:how to restore our owl ? 1 Month, 1 Week ago Karma: 28
You should be able to restore the mysql database from the command line.

mysql> create newdatabase;
mysql> exit

then edit the mysql backup you have and you will need to adjust the groups table inserts and add an Update after the insrt of the Administrator Group.

Code:


INSERT INTO `groups` (`id`, `name`) VALUES
(0, 'Administrators');
update groups set id = '0';
INSERT INTO `groups` (`id`, `name`) VALUES
(1, 'Anonymous'),
(2, 'File Admin'),
.
.
.



Then

mysql -u <your_owl_user> -p < mysql_backup_file.sql

and that should recreate the database
Owl DEV Team
Moderator
Posts: 2220
graph
User Offline Click here to see the profile of this user
Gender: Male b0zzit Location: Ottawa, Ontario, Canada
The administrator has disabled public write access.
 
#4786
Re:how to restore our owl ? 1 Month, 1 Week ago Karma: 0
Thanks, B0zz:

We did a quick and dirty as follows:
1. ftp all files from client to owl
2. import our backup(ie. xxx.sql) by mysqladmin

it looks ok so far, but we'd like to know any potential risks of the above ?

Thanks
.jOe
vkjuju
Expert Boarder
Posts: 154
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#4787
Re:how to restore our owl ? 1 Month, 1 Week ago Karma: 28
If you followed my advice about the GROUP then you should be fine.


B0zz
Owl DEV Team
Moderator
Posts: 2220
graph
User Offline Click here to see the profile of this user
Gender: Male b0zzit Location: Ottawa, Ontario, Canada
The administrator has disabled public write access.
 
Go to topPage: 1

Ad Block