Hi Mike,
1. Uh, that's a good idea. I never wrote such instructions, but I can think of two ways right away.
Method I (easy): Create a new backup profile. Using the Files and Directories Exclusion exclude all directories and files on your site's root. If you only want to transfer specific tables (and not everything) you can also use the Exclude Database Tables to exclude the tables you do not want to transfer. Now, take a new backup. What happens is that the backup archive contains only your database (except those you excluded) and the installer script. Nothing else. Use Kickstart to restore it on the .com site and you're done. Only the database is updated, not your site's files.
Method II (complicated): You can create a new profile and set it to database only. Click on the Configure button next to the Database Dump Engine and set the "Size for split SQL dump files" to 0. Then, take a new backup. Instead of an archive you get a SQL file. You can restore that file using phpMyAdmin on your .com site.
2. Yes, the Transfer Wizard does transfer the whole site to a new server. Yes, it can be used when you change hosts. However, depending on host settings, it may not work for some sites. In this case, the solution is trivial. Backup the site you want to transfer. Restore it -using Kickstart- to the new server. Done :)
Nicholas K. Dionysopoulos
Lead Developer and Director
🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!