PDA

View Full Version : restore/install working backup


WhiteRook
7-1-05, 03:18 PM
I've got an error message when trying to enter my forums, Nothing specific, just
"there seems to be a data base problem, sorry for the inconvenience"

I'd like to install a previous back up that I know works, but fail to find
any resources on the "how to install backup database" ... I've made various searches here to find the answer, but still fail to find anything conclusive.

I've read the following tutorial. It does well for loading up new data, and creating
a back up copy of your data base, but noting on installing a backup.

http://pownuke.com/phpmyadmin/

I've read threads of many different kinds of problems...replys to most say "you should
install a back up" or "Try to repair the table option from phpmyAdmin" I see no such option in "MyAdmin". I see a list of backups in my powweb op site, but nothing on how
to install one of them... I can download them to my computer, but it doesn't look the same as the database I see in the phpadmin site... (when viewed with notepad) I don't want to install something that doesn't belong there (even if I could insall one)

How do you know which table, if any, is the problem?

Is there a tutorial for the sql that powweb uses... (i'm not even sure there are different
types of sql). I don't wish to start learning the wrong type.

I have a friend that has been doing all my database installations, but I don't want to keep bothering him for help...But then, I'm a bit nervous messin' with anything in there.
Not the best of places to run the o'l "trial and error" method of education :D

Thanks for any help offered... I'll keep looking around for some answers...

Regards,

WhiteRook

lucky760
7-1-05, 03:22 PM
View the answer on this page: https://phpmyadmin.powweb.com/Documentation.html
It's in section 6.5.

Basically, in phpmyadmin you just browse to the local backup on your system and upload it. phpmyadmin will parse it and execute each query in it.

WhiteRook
7-1-05, 03:31 PM
Jeez Lucky.... I'm sorry for wasting your time. I saw that documentation a while back, and meant to read it, but didn't.

I appreciate your help. That answers it very well !