[Koha] Upgrade 3.01 to 3.6 on Diff Server

[Josh Mikow]

Hello,

I'm new to Koha, library management and freshening up my Debian skills.
 Recently I was tasked with migrating our current Koha system to a new
server.  The prior admin is no longer around and I have been trying to
understand how Koha works and get a good backup of the system (haven't had
any to date).

I think I have a backup of the database and all of the files/folders that
specified in the koha-install-log file to use on the new server, but I want
to get the update steps down so I know what to do before I try to
upgrade/migrate our production system.

On the new server I've done the following:
* installed Debian 6.
* installed Koha 3.06.04.000
* created a test instance to make sure it works on the localhost

I'm having trouble with the koha-remove command.  When I run it against my
"libtest" instance, it returns with an Error 1396 about not being able to
drop the user 'koha_--'@'%'.  It appears that it is not using the instance
name that I passed in within the DROP command.  I've gone through and run
all of the steps in the koha-remove manually and they work if I type the
instance name for each of the commands.

My biggest questions are:
1. What is the best way to make sure I backup all of the necessary files on
the 3.01 system so that I can successfully get them over to the 3.06 system
to restore?
2. What is the best way to properly restore the 3.01 files under the 3.06
install without causing future problems?
3. What steps do I need to do to upgrade the 3.01 to the 3.06 system?
4. Currently the system is working on localhost but we will need to get it
working on our internet site.  What configuration changes are needed to
work both internally and externally?

Any assistance you can provide as I begin to learn Koha and library
management is greatly appreciated.

Thank you for your time.

Josh Mikow
Volunteer IT Admin