ooops i deleted my database [Q and A] - XOOPS Web Application System

ooops i deleted my database

2004/11/16 14:43
hal9000
Just popping in
Posts: 60
Since: 2003/8/6 9

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

Re: ooops i deleted my database

2004/11/16 14:49
Herko
XOOPS is my life!
Posts: 4238
Since: 2002/2/4 1

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

Re: ooops i deleted my database

2004/11/17 9:53
hal9000
Just popping in
Posts: 60
Since: 2003/8/6 9

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?

Re: ooops i deleted my database

2004/11/17 10:50
JasonMR
Just can't stay away
Posts: 655
Since: 2004/6/21

There's a backup module

https://xoops.org/modules/newbb/viewtopic.php?topic_id=24532&forum=29

Re: ooops i deleted my database

2004/11/17 11:15
Alan-A
Not too shy to talk
Posts: 191
Since: 2004/2/17

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

Stats
Goal:	$100.00
Due Date:	Nov 30
Gross Amount:	$0.00
Net Balance:	$0.00
Left to go:	$100.00

ooops i deleted my database

Re: ooops i deleted my database

Re: ooops i deleted my database

Re: ooops i deleted my database

Re: ooops i deleted my database

Login

Search

Recent Posts

Re: Captcha to the registration form

XOOPS MyMenus 1.54.0 Beta 10

Re: XOOPS MyMenus 1.54.0 Beta 7

Re: XOOPS MyMenus 1.54.0 Beta 7

Re: XOOPS MyMenus 1.54.0 Beta 7

Re: XOOPS MyMenus 1.54.0 Beta 7

Re: XOOPS MyMenus 1.54.0 Beta 7

Re: XOOPS MyMenus 1.54.0 Beta 7

Re: XOOPS MyMenus 1.54.0 Beta 7

Re: XOOPS MyMenus 1.54.0 Beta 7

Who's Online

Donat-O-Meter

Latest GitHub Commits

{{ record.sha.slice(0, 7) }} - {{ record.commit.message | truncate }}