Thanks to the OP author for his HOWTO.
I followed it all, it took some fixes related to the pieces of software I'm using, until it worked OK. But then I "discovered" an even easier way to do it using Akeeba Backup.
Anyway, here's how I moved (actually copied) my web-site from the server where it runs successfully , but which is too slow responding if some mass editing is needed , to my desktop to do all editing here (in effect, moved it to "another host").
1.I Installed XAMPP
(recommended) bundle on my desktop (Fedora 17 Linux). A couple of fixes were needed to make it run OK and show the PHPmyadmin window properly and in English (for some reason it defaults to German !!).
2.On my site running under Joomla! I installed Akeeba backup
and did full backup of the site. This is under Components --> Akeeba Backup.
(Installing Akeeba Backup is so simple and straightforward that it's not worth explaining here really).
Download the backup and extract it into the folder where your new site is going to reside. With XAMPP it is "/opt/lampp/htdocs/$yoursite", but in any case it is a folder in the web-server's root.
Then you access the extracted backup through the browser window at "http://$yourservername/$yoursite/index.php" (substituting your server name and yoursite folder name where you extracted your backup).
This will open up the page with Akeeba restore instruction and step by step restore your site and database. You'll need, of course, your d_base name, user and password for this stuff to work
. These are the values you created following the tutorial in the OP.
One small addition people usually don't consider worth mentioning, but without this trifle the site won't show up and Joomla! won't have permissions to write files. That folder where you extract your backup, everything must be owned by the apache web-server unprivileged user. In Fedora 17 it is user "nobody". On Ubuntu it is user "www-something...". So I had to do
sudo chown -R nobody:nobody $my-site-folder/*
...Perhaps, when you're moving from one hosting to another, the ownership issue is being resolved by the server itself. But if you're moving to your own machine, then it's another matter. In any case, this is worth mentioning if we're giving people universal instructions...
PS: I can see that people still use ancient versions of Joomla!, with which Akeeba Backup may not be working OK. My site is using the latest Joomla!... but anyway, I thought it worth mentioning here. As I noticed, BTW, this Akeeba Backup does about the same thing as this very tutorial posted in the OP.