Three options:

  1. install from scratch, copy & paste (horribly time consuming if your site is complex)
  2. save database, upload all files, create database on GoDaddy server, update config.php to reflect new settings. I tried that and somehow it didn’t work. I think the problem was root_path in config.php - it should not be /mysitename/mycmsmsfolder (or whatever your file directory may show when you view your files) but instead it should be something like :
    /home/content/a/b/c/yourusername/html/yourwebsitename/yourcmsmsfolder- Replace “a/b/c” with the first three letters of your godaddy username, and “yourusername” with your godaddy username
  3. Take the middle road and run install with your new, transferred database (as in 2.) but do not worry about editing config.php. Check off the “create tables” and “install sample content” boxes. This is what I ended up doing and how I realized the root folder was not /mysitename/mycmsmsfolder but /home/content/a/b/c/myusername/html/mysitename/mycmsmsfolder