xoops forums

hal9000

Just popping in
Posted on: 2004/11/16 14:43
hal9000
hal9000 (Show more)
Just popping in
Posts: 60
Since: 2003/8/6 9
#1

ooops i deleted my database

i have had my XOOPS site for over a year and a half now and somehow while cleaning up some redundant old databases i managed to remove my long running database.
other than the usual beg the host to gimmie tha backup (which they might have) is there anything else i can do...

yours - a bit miffed
hal9000

Herko

XOOPS is my life!
Posted on: 2004/11/16 14:49
Herko
Herko (Show more)
XOOPS is my life!
Posts: 4238
Since: 2002/2/4 1
#2

Re: ooops i deleted my database

other then read up on databasemanagement? No, not much. Don't touch the files, as they're configured for the database. Your host should have a backup, I hope it's not from too long ago...

Good luck!

Herko

hal9000

Just popping in
Posted on: 2004/11/17 9:53
hal9000
hal9000 (Show more)
Just popping in
Posts: 60
Since: 2003/8/6 9
#3

Re: ooops i deleted my database

YAY i managed to get my database back from the hosts and its only missing a few days!
I have recreated the DB user and pwd but importing the sql seems to take ages. its a 2.5 meg .sql file.
I just created a new database with the correct name and waited for the upload (sql dump) to work itself out and it all seems fine!!!!

yippie..
oh and cos i just needed the sql backups they didnt charge me..

Is there a simple way of backing up the db say on a weekly basis myself other than via MySQL admin?

JasonMR

Just can't stay away
Posted on: 2004/11/17 10:50
JasonMR
JasonMR (Show more)
Just can't stay away
Posts: 655
Since: 2004/6/21
#4

Re: ooops i deleted my database

There's a backup module

https://xoops.org/modules/newbb/viewto ... p?topic_id=24532&forum=29

Alan-A

Not too shy to talk
Posted on: 2004/11/17 11:15
Alan-A
Alan-A (Show more)
Not too shy to talk
Posts: 191
Since: 2004/2/17
#5

Re: ooops i deleted my database

Hi,
maybe Brash's Post in this thread is also relevant.
Good luck
Alan