I have been working for days to get my first Drupal site transferred from the localhost to the webhost server. In the creation of the site I used the Acquia Drupal stack and have the site ready to go live, but cannot seem to getting to work. I am using HostGator as my server to host the site, I created an empty database to transfer everything into but nothing.
I've scanned the internet and even search YouTube for a solution, and the best one I found was from lynda.org (http://www.youtube.com/watch?v=zh6Vunp7M8U). In the video is suggests using FileZilla for the FTP. With the exception of changing the site file name as it says in the video I followed everything step by step (I did not see "web accessible url' anywhere on the hosting server). There are many issues that have come up though on the install:
1. When transferring the files using FileZilla I copied the main folder like the video says to the public_html folder. Out of the thousands of files contained within it only 20 transferred, and I have no idea why. Under the "Failed Transfers" tab it merely states next to each file "Could not start transfer". I even tried added individual folders within the main after the queue finished and they still came up as "Could not start transfer".
2. When dealing with moving the database I clicked on the "Manage my database" button on the Acquia Dev Desktop Control Panel, which opened the phpMyAdmin. Then I went to export the database to transfer to the new, empty database that I created on the server where the website will be hosted. There is a "Quick - display only the minimal options" or a "Custom - display all possible options" and I chose the custom, and made sure to do SQL for the format (on the video the file is a .sql.gz while mine is just a .sql). First I tried it exporting only "pracentil" database of the site then tried it with both the "pracentil" and "information_schema" together.
When importing just the pracentil database to the new database I receive this error:
-- Database: `pracentil`
CREATE DATABASE `pracentil` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
MySQL said: Documentation
#1044 - Access denied for user 'pracent1'@'localhost' to database 'pracentil' "
When importing both the pracentil and information_schema databases to the new database I receive this error:
-- Database: `information_schema`
CREATE DATABASE `information_schema` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
MySQL said: Documentation
#1044 - Access denied for user 'pracent1'@'localhost' to database 'information_schema' "
So either way there seems to be an issue with user access. Not sure why just the "DEFAULT CHARACTER SET" and "COLLATE" are different on the two.
Are there any other suggestions on how or what to use for the file transfer to ensure that all of the files will actually transfer? Also, are there any ideas as to getting the database to import as well.
Again this is my first time using Drupal so the more instruction on where to go and what to do the better