Import MySQL databases to new account?

How dim am I?

I had the old db name in both the CREATE and USE strings, which is how the dump came downloaded via phpMyAdmin (at one point, I even tried putting the new db name in both, and of course that didn’t work).

I went back in and edited the dump so that it was CREATE hlo and USE (old db_name) and everything uploaded like a charm. Here’s the results:
http://www.factoidlabs.com/heavy

Many thanks to gamejag, decswxaqz and ardco for persisting with the nudges and advice.

Now I gotta run off and cancel my trouble ticket.

Thanks, all!

mack reed, editorial consultant, Los Angeles
publisher: http://LAVoice.org
HEAVY LITTLE OBJECTS: http://factoidlabs.com/heavy
home: http://factoidlabs.com

cheers

Hurah!
I knew it would be something simple :wink:

Yep. When you’re dealing with a simpleton, that’s always the way.

Thanks, folks!

mack reed, editorial consultant, Los Angeles
publisher: http://LAVoice.org
HEAVY LITTLE OBJECTS: http://factoidlabs.com/heavy
home: http://factoidlabs.com

Well I thought all of the above 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 need 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!