By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,458 Members | 1,294 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,458 IT Pros & Developers. It's quick & easy.

Restoring php nuke db after crash

P: n/a
Greetings.

I was running PHP Nuke on a Win2k box using Apache2Triad. Fortunately I
backed up the drive using windows backup prior to the hard drive failure.

Now I have installed Apache2Triad on another machine and wish to reimport
the mySQL database that PHP Nuke relies upon. If anyone can tell me how to
do this I would be very grateful.

Thanks in advance.
Jul 20 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
OK. So it seems there is a directory: c:\apache2\mysql\data\nuke which has
mysql tables for nuke. Do I just replace this whole directory with the one
from backup? Or should I replace the whole htdocs directory? Do I need to
stop all mysql and apache services prior to doing this?

"steve" <Us************@dbForumz.com> wrote in message
news:41**********@news.athenanews.com...
"Yair Sageev" wrote:
> Greetings.
>
> I was running PHP Nuke on a Win2k box using Apache2Triad. Fortunately
> I
> backed up the drive using windows backup prior to the hard drive
> failure.
>
> Now I have installed Apache2Triad on another machine and wish to
> reimport
> the mySQL database that PHP Nuke relies upon. If anyone can tell

me
> how to
> do this I would be very grateful.
>
> Thanks in advance.


I gather that you have a disk image of your mysql database. If so,
then simply create a database with the same name as before, and copy
all the files into it from your backup. Then you would have to repair
all the tables inside, and you are done.

--
http://www.dbForumz.com/ This article was posted by author's request
Articles individually checked for conformance to usenet standards
Topic URL:

http://www.dbForumz.com/mySQL-Restor...ict145109.html Visit Topic URL to contact author (reg. req'd). Report abuse:

http://www.dbForumz.com/eform.php?p=485720
Jul 20 '05 #2

P: n/a
"Yair Sageev" wrote:
OK. So it seems there is a directory: c:\apache2\mysql\data\nuke which has
mysql tables for nuke. Do I just replace this whole directory with
the one
from backup? Or should I replace the whole htdocs directory? Do I
need to
stop all mysql and apache services prior to doing this?

"steve" <Us************@dbForumz.com> wrote in message
news:4134f9d1

_6@news.athenanews.com...
"Yair Sageev" wrote:
> Greetings.
>
> I was running PHP Nuke on a Win2k box using Apache2Triad.

Fortunately
> I
> backed up the drive using windows backup prior to the hard drive > failure.
>
> Now I have installed Apache2Triad on another machine and wish to > reimport
> the mySQL database that PHP Nuke relies upon. If anyone

can tell
me
> how to
> do this I would be very grateful.
>
> Thanks in advance.


I gather that you have a disk image of your mysql database. If

so,
then simply create a database with the same name as before, and

copy
all the files into it from your backup. Then you would have to

repair
all the tables inside, and you are done.

--
http://www.dbForumz.com/ This article was posted by

authors request
Articles individually checked for conformance to usenet standards
Topic URL:

http://www.dbForumz.com/mySQL-Restor...ict145109.html
Visit Topic URL to contact author (reg. reqd). Report

abuse:
http://www.dbForumz.com/eform.php?p=485720


Yair, just replace the data directory (nuke) with the backup. And
then you have to issue mysql "repair" command on all the tables, one
at a time (yikes).

Good idea to shut down mysql as well.

--
http://www.dbForumz.com/ This article was posted by author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbForumz.com/mySQL-Restor...ict145109.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbForumz.com/eform.php?p=486670
Jul 20 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.