I found success when I installed the same version fully on the live server, then copied the config.php file from test server to live server moodle folder. Finally, import sql using phpmyadmin on live server, go to sql tab, from memory you browse to the gzip or uncompressed sql file from test server and hit go! The database will have all records imported.
HTH,
Jason
Hardware and performance
Transferring a moodle install to a live server...
This discussion has been locked so you can no longer reply to it.