boardom

Nodecam · Posted: Mon Apr 22, 2002 7:55 pm Post subject: Changing to a new host?

I may have to switch my weblog to a different host in the very near future, so I was wondering if there is a way to get B2 to import from a different B2 powered blog?

I had a look, and didn't see anything obvious, though I very well might have missed it. I don't know if I'll have time to code something up before my server goes away (though it is coming back eventually, I'd just like to minimize the downtime Smile

Thanks

nessahead · Joined: 12 Mar 2002 Posts: 312 Location: Los Angeles, CA

I guess the problem would be getting the SQL databases from the first server to the next.

If you can use phpMyAdmin, you can export the database as a text file and then import it on the next server. Just click on the name of the database you want to export and then scroll down to where it says "View dump (schema) of database". Select the "Structure and data" radio button and the "Save as file" checbox and then click on the "Go" button. It should then prompt you to save a .sql file.

On your new server, you can use phpMyAdmin to import that .sql file and re-create the database. Then, just copy everything from the old server to the new and change the config file so that it's appropriate to your new domain and you should be gtg. =)

Nodecam · Posted: Mon Apr 22, 2002 10:34 pm Post subject:

I'd never heard of phpMyAdmin before. After much trial and difficulty, I managed to snag a copy, and have figured out how to get the export job done. Now to set up my new server the same way as the old one Smile

Thanks.

michel v · Posted: Tue Apr 23, 2002 12:05 pm Post subject:

Made it a Sticky post.

You can find phpMyAdmin there: http://www.phpwizard.net/projects/phpMyAdmin/

Nodecam · Posted: Wed Apr 24, 2002 6:25 pm Post subject:

Wow - that worked really slick. I went from a formatted hard drive to new server in a couple of hours, all while watching hockey on TV. The database export/import was probably the easiest part of the whole process.

Thanks again.

nessahead · Joined: 12 Mar 2002 Posts: 312 Location: Los Angeles, CA

Woohoo, glad it worked! =)

imeridian · Joined: 12 Feb 2002 Posts: 191

I like doing things on the command line, mostly because it allows me to not worry about ftping things up and down from the servers.

SSH into your current server:

this will make a full database dump with drop tables:

Tara · Joined: 20 May 2002 Posts: 33 Location: Canada

How do I put the new .sql files in? I don't see where to use this Import/Export feature. Could someone please help?

Cyberian75 · Joined: 26 Sep 2002 Posts: 1278 Location: Oregon

Tara,

You can import/export SQL files from within phpMyAdmin. Login to your control panel then phpMyAdmin. If you have several databases, you will have to select a database from the list.

After you select a database, you can run your SQL file in "SQL" section. The link should be located on the top. If you want to export your database, use the "export" section instead.
_________________
Michael P.

Mister44 · Posted: Sat Jan 18, 2003 8:29 pm Post subject:

See the msgs eariler in the thread about phpMyAdmin.

Candle · Joined: 23 Dec 2002 Posts: 547

Wen you open the phpmyadmin you will see on the left where to pick your data base click in then at the top of the page you will see some tabs , click the tab SQL and EXport . if you need to save it use EXport the file to your hard drive and to inport it click SQL and down below you will see where you can look for the sql file on your driveOr Location of the textfile : , just find it and then click go..

ThatGirl4634 · Joined: 20 Nov 2002 Posts: 13 Location: My computer

ok my old host saved it and sent it to me and everything and i sent it to my new host, but whenever she CREATES a new MySQL database it puts misskiss_ in front of the name, but right now it's like dreamingtree_thatgir do I need to rename the database or anythin before uploading it?
_________________
the best siggy ever made was the blank siggy.

Cyberian75 · Joined: 26 Sep 2002 Posts: 1278 Location: Oregon

I believe your new host will need to modify the file and look for any username which needs to be changed.
_________________
Michael P.

ThatGirl4634 · Joined: 20 Nov 2002 Posts: 13 Location: My computer

*gets confused* ok, does she have to change the name BEFORE uploading it or after? and what do you mean about a username may need to be changed?

nevermind that, ok we've got it up and running but my user doeasn't exist, i don't have any of my archives or posts or anything, how to i get those to show up? (my host did all that importing and exporting junk and stuff and i'm using my old database) but how come nothing old is showing up?
_________________
the best siggy ever made was the blank siggy.

macshack · Joined: 17 Jul 2002 Posts: 1204 Location: Phoenix, Az

Hi,

Well is sounds like you got have of the problem (moving) complete, that is creating the database and the install of b2. That meaning, b2 can talk to the database just fine with its new name.

Now for the content. If you did not change the table names that b2 uses, that the content should go back without any need for modification.

The next question is how was the old content saved. You said that you have the file that your old host sent you, can you access/display that file in you text editor? MAKE SURE YOU USE A COPY OF THAT FILE.

If so, what does the first 30 lines look like? Post them if you can.
_________________
Kind Regards,
Michael e