Ravens PHP Scripts: Forums
 

 
  Forum Index  •  Forum FAQ  •  Search  •  Memberlist  •  Usergroups  •  Profile  •  Log in to check your private messages  •  Log in

How do I restore a sql backup of my database
 View next topic
View previous topic
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    Ravens PHP Scripts And Web Hosting Forum Index -> phpnuke 7.0
Author Message
sqzdog
Involved
Involved



Joined: Sep 22, 2003
Posts: 252
PostPosted: Sat Aug 07, 2004 9:32 am Reply with quote
Want to do an sql restore from a back up using phpmyadmin. Never done it before. Can anyone help me out? Do I just run the sql file?
 
View user's profile Send private message Send e-mail
sixonetonoffun
Spouse Contemplates Divorce



Joined: Jan 02, 2003
Posts: 2496
PostPosted: Sat Aug 07, 2004 9:43 am Reply with quote
I'd create a new empty database and install the backup to that if it succeeds change your nuke config.php to point to the new DB. This leaves the original just in case so to speak.

_________________
[b][size=5]openSUSE 11.4-x86 | Linux 2.6.37.1-1.2desktop i686 | KDE: 4.6.41>=4.7 | XFCE 4.8 | AMD Athlon(tm) XP 3000+ | MSI K7N2 Delta-L | 3GB Black Diamond DDR
| GeForce 6200@433Mhz 512MB | Xorg 1.9.3 | NVIDIA 270.30[/size:2b8 
View user's profile Send private message
Raven
Site Admin/Owner



Joined: Aug 27, 2002
Posts: 17088
PostPosted: Sat Aug 07, 2004 9:46 am Reply with quote
Do what Six advises Wink - This also might help [ Only registered users can see links on this board! Get registered or login! ]
 
View user's profile Send private message
sqzdog
PostPosted: Sat Aug 07, 2004 12:15 pm Reply with quote
My host did a restore for me from July 31. Now I get this when i hit the homepage

Quote:

Fatal error: Call to undefined function: message_die() in /home/sqzdog/public_html/db/db.php on line 88
 
Raven
PostPosted: Sat Aug 07, 2004 3:38 pm Reply with quote
Look at the FAQ Wink
 
sqzdog
PostPosted: Sat Aug 07, 2004 5:24 pm Reply with quote
Raven, I have my tables back-up from this morning. My host installed a back-up from July 31st. How do I overwrite the sql that shows my members, my forum posts and my news stories?, then how do I do it? Do I just cut and paste those areas and hit "go"?
 
Raven
PostPosted: Sat Aug 07, 2004 5:40 pm Reply with quote
As I posted in that link above
Quote:
When you are in phpMyAdmin, you can DROP selected tables. Once they are DROPPED, you can run your SQL to recreate them.
Because there is so much interdepndencies to match up, you really should do what Six advises. Creat a brand new database with your backup SQL. Then point your config to the new database and work out the kinks.
 
sqzdog
PostPosted: Sat Aug 07, 2004 5:42 pm Reply with quote
The problem I am having is I am not sure where to find this file at. I did a full site backup and there are a bunch of folders and I am not sure what it is called or what folder it might be under. I use Cpanel and generated the back up from there.
 
Raven
PostPosted: Sat Aug 07, 2004 6:26 pm Reply with quote
Your cPanel should have an automatic restore. See this [ Only registered users can see links on this board! Get registered or login! ]
 
Display posts from previous:       
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    Ravens PHP Scripts And Web Hosting Forum Index -> phpnuke 7.0


 Jump to:   




View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum


Powered by phpBB © 2001-2007 phpBB Group
All times are GMT - 6 Hours
 
Forums ©