I've moved this to it's own thread. I think it was burried at the end of another.
Well I thought another thread here might answer my questions, but it seems I am even more of a simpleton and am more confused that ever. I've read all the kb and even searched online. I just need someone to break it down for me in very basic layman terms. I have the questions into support but it's been a day and no response. I really need some help. I can't screw this up.
Situation: Was left holding the admin bag on old online community whose message board is currently offline. Have no prior knowlege of this side of database management or messageboard administration. Until a week ago knew nothing of MySQL php or databases. Still don't, although I've read tons. I think I'm on overload.
Problem - Invision Powerboard will be doing an install on my site here and needs the old board database in order to recreate our board as it was when it went offline due to old crappy host server. I have dled a backup to my hard drive from the old server using the backup function of a 'cpanel' control panel.
Question - How do I get that backup restored to a new db here at DreamHost so IPB can utilize it during the install? I'm not even sure I grasp the concepts. When a backup is done, is it only the data, and not the actall database including it's structure? If so, do I need to import the backup data into a newly created db here, or if self contained can I just upload the backup via ftp and all will be fine? I've read about using shell access, the funky -p -h connect address, all that stuff...I'm just really lost. Could someone who knows the DH control panel and the ins and outs of this PLEASE give me step by step instructions on what's neccesary to get this old backup restored here so IPB can use it? Have I completely confused you? I think I've confused myself even more.
I want to just do a right click/ftp upload, type in my http address and be done, but with all I've read it doesn't seem to be that simple. The db is over 8MB. I've read about splitting and different php commands. When do you know if that's necessary. I'm just really lost. Pleas HELP!
ETA Btw the back up is a DZ (Dzip) compressed file...will it auto extract? What does it change? Do I need to convert it to text? Yes...clueless here.