Well, that is a good start! Great. You are doing fine
Windows... 2003, 2008?
Maybe you could ask the Support area of Godaddy about the plan (managed vs unmanaged) you currently have or about its characteristics?
Ok then, your first asked, "how do i migrate the current Moodle" but then you continued with "or more specifically how to I export all the current data we have."
So I would first like to ask you: is your goal to have a complete working Moodle site in this server, that is, the Moodle code, the moodledata directory and the Moodle database? Or you just want to bring the Moodle database into this server, that is, the Moodle code and moodledata directory will remain in another server?
Two more questions. What is the current version of the Moodle installation? And, is the current MySQL database completely in UTF8?
About the last question, you might want to check and confirm by running the following three SQL statements. The first one checks the database; the second one, all the tables; and the third one, the text-type columns of each table. Please make sure you change the db_name string in each query with the real name of your database.
** 1. Check database
SELECT schema_name, default_character_set_name "character_set", default_collation_name "collation"
WHERE schema_name = 'db_name';
** 2. check tables
SELECT t.table_schema, t.table_name, ccsa.character_set_name "table_character_set", t.table_collation
FROM information_schema.`tables` t,
WHERE ccsa.collation_name = t.table_collation
AND t.table_schema = 'db_name';
** 3. Check columns
SELECT table_schema, table_name,
column_name, character_set_name "column_character_set", collation_name "column_collation",
WHERE table_schema = 'db_name'
AND data_type IN ('char', 'varchar', 'tinytext', 'text', 'mediumtext', 'longtext', 'enum', 'set');
Save each result into a text file so you can review the report. The first report will be very short, and the last one a bit long
Doing a database backup and restore is not difficult but one must take care with how it is encoded. Not doing this can lead one to end up with a corrupted database, and we do not want that.
The idea is to start with a complete UTF8 DB, so depending on the results you get, we might actually be able to start with the dump command or we might need to first convert it.