Importing database into wordpress

Megan's picture

She has: 11,421 posts

Joined: Jun 1999

Another thing that LIam would normally help me with but can't right now...

Last week we decided to move my blog over to the dedicated server. Liam was going to put the database in for me but now I need to do it myself. The question is, how? Do I need to learn how to SSH? I should probably learn that anyway. I was able to export the database from my old hosting account through .... what-che-me-callit- that mySQL browser-based manager thingy. We have the same thing on that dedicated server but there's no option to import a database there.

Can I do this myself or should I wait until Liam can help me? I'd hate for the site to be down for that long Sad Not that anyone visits my site that much but there's some stuff I'd like to blog about now.

demonhale's picture

He has: 3,278 posts

Joined: May 2005

do you have phpmyadmin on the new server? its easier to backup/restore/transfer a mysql db using the admin...

Megan's picture

She has: 11,421 posts

Joined: Jun 1999

phpmyadmin, is that what it's called? Okay, I think that's what I was using in the first place. On our server, though, there is no import link. On my old hosting account there was, but not on this one. So what next?

P.S. Sorry for being so dumb about this. I don't have the link to the server control panel here so I can't go and check.

They have: 13 posts

Joined: Aug 2006

hi

They have: 13 posts

Joined: Aug 2006

i'm new to this site

Megan's picture

She has: 11,421 posts

Joined: Jun 1999

Hi bzooks Smiling Why don't you head over to the Introductions forum and introduce yourself ? Smiling

They have: 13 posts

Joined: Aug 2006

hi, where would i find that?

They have: 13 posts

Joined: Aug 2006

this is my first time on this site

demonhale's picture

He has: 3,278 posts

Joined: May 2005

you could try backing upd the old db using phpmyadmin, and use myadmin to restore to the new server for less trouble... as for the concern, the best answer I found is that you can go into the database you wish to import to and click the "SQL" tab at the top. On the next screen there should be a textarea, under that look for a text input field (one line) and a 'Choose' or 'Browse' button to the right of it. Click the button, find your backup and submit the form. Anything over the 3-5mb mark will probably not work.

timjpriebe's picture

He has: 2,667 posts

Joined: Dec 2004

Normally databases are just exported as SQL statements, Megan. So in phpMyAdmin, there should be an option for running SQL. You just paste all your SQL into a textbox there, run it, and you're good to go.

That's how it's worked when I've done it, anyway.

Megan's picture

She has: 11,421 posts

Joined: Jun 1999

Okay, thanks!! Sounds like I could definitely do that. Now too bad I'm going to be away for the weekend and the login info and database backup are on my home computer Sad

They have: 13 posts

Joined: Aug 2006

hi megan,

have a great weekend. we can chat when you get back.

rusty

They have: 13 posts

Joined: Aug 2006

megan are you near niagra falls?

Megan's picture

She has: 11,421 posts

Joined: Jun 1999

bzooks1 wrote: megan are you near niagra falls?

Not far, actually. A little over an hour's drive Smiling

Hopefully I'll have time to fix this site this weekend! Going away for the weekend always makes my weeknights really busy!

DC_Sara's picture

She has: 392 posts

Joined: Jan 2002

Good luck with that Megan! I've done that before, it's pretty easy.

Megan's picture

She has: 11,421 posts

Joined: Jun 1999

Well, I managed to get the database in but it still doesn't work! It all seemed fine when I uploaded it into the control panel, but when I set up the config file and went to load the page it just came up blank!

Liam is helping me now. I really wanted to do this myself though Sad

demonhale's picture

He has: 3,278 posts

Joined: May 2005

retrace what you might have done wrong, or just Liam to assist you, not do it for you... so youll learn and eventually you can do it yourself...

Megan's picture

She has: 11,421 posts

Joined: Jun 1999

I figured it out - had the wrong url listed in the control panel. That's all!

Thanks though Smiling Liam spent a lot of time trying to figure it out! It's the simple things that get you every time Smiling

demonhale's picture

He has: 3,278 posts

Joined: May 2005

thats good that your db is ok now...

Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.