I've been doing a bit of Googling, and I can't seem to find an answer to this. I've just built myself a shiny, new Ubuntu 12.04 install. Now, back in the day when I installed my WordPress sites (4 of them), I wasn't exactly saavy.
What I'd like to do now is migrate them to the new server, and have them all on the same database (just to simplify things). I realise I have to rename my tables from wp-*** to somethingelse-***, but I'm just struggling with the logic of migrating.
Could any of you lovely people even give me some high level direction?
Thanks in advance!