Woe is me! I created a lovely site and then blew it all moving to a new server. I did an FTP back up of all files and dumped the database using phpmyadmin on my desktop. Can I get it back on the new server? No
I am stuck getting the database back up and running. I am using godaddy and created a new datase using the hosting tools. I am then going back into phpmyadmin and using import. The problem is, I think, that I dumped both the "information schema" and the database into .sql file so I when I import I get the error message
information_schema DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
#1044 - Access denied for user 'red1228904594900'@'%' to database 'information_schema'
I think I need to go back to first principles with mysql - HELP!