Drupal moving database from one server to another

So I wanted to get a site I've been making 'live' which meant transferring from the test server to the real one. How to do this? I remember in Joomla it was as easy as pie, not so with Drupal, although not too tough.

Basically:

1. move all files
2. move all tables from database

So, in myPHPadmin you can export, but I was coming up with an error:

Error

SQL query:

--
-- Database: `sitename_pw`
--
CREATE DATABASE IF NOT EXISTS `sitename_pw` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
 

MySQL said: 

#1044 - Access denied for user 'my_user_name'@'localhost' to database 'sitename_pw'

So I found this website which explained that you have to export the tables within a database, rather then a whole database. To do this you have to be looking at the database tables, then press the export button to export just the tables.

Then when you import them, you have to be actually in the new database and press the import button

watermarking photos in Aperture 2

Well, it could have been easier. Found a good tutorial here.

Simply put, you just have to make a picture file of the watermark you want on your images. Then, go to Aperture > Presets > Export and it's down the bottom.

Then when you export versions, it puts the watermark image on.

Transferring from blogger/blogspot to joomla

So, I'm hoping to make a website for myself, which I want this blog to be a part of. But how to do it. Well, at first I thought I'd just have it as a feed, but actually I want to incorporate it fully into the joomla site. So.... here's what i found on the amazing thing called the internet:

Found on this forum

1. Export xml from blogger
2. import to wordpress
3. export from wordpress to joomla

Looks like wordpress is the go-between. Not found anything more recent then 2009, so maybe there is a straight blogger to joomla extension?

Found a how to website with information on the wordpress to joomla conversion. Need to install JoomBlog extension.

Also found this blog on how to do it. Costs $15 to by feed2post though

Just had a quick search on the extensions directory for joomla and found this PLo Blogger, which duplicates blogs on your joomla site onto your blogger site. This would be a good way to have them both up and running, and not loose any followers and such.

The question is: Is it worth the hassle? Perhaps keep blogger going, and make a new blog for other things on the joomla site. Might be the best thing to do?