MyBB Community Forums

1) I used PhpMyAdmin to backup the database
2) I upload that database to the new host (Godaddy )
3) It gives me an error saying that:

-- phpMyAdmin SQL Dump
-- version 2.6.4-pl2
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Apr 18, 2006 at 07:43 PM
-- Server version: 4.1.18
-- PHP Version: 4.3.11
-- 
-- Database: `XXXXXXXXXXXX`
-- 
CREATE DATABASE `XXXXXXXXXXXX` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;

MySQL said: Documentation
#1064 - You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci' at line 

I tried some other things (Like removing that line) and got

MySQL said: Documentation
#1044 - Access denied for user: 'myusernameishere@%' to database 'XXXXXXXX' 

I assume it's because Godaddy is strict with their databases. Any workarounds? Godaddy refuses to help me...

Please remove the "DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci" parts and try again:

CREATE DATABASE `XXXXXXXXXXXX`;

Alright, I've gotten it to upload with some trickey, and everything seems to be intact, however when I try to post, I get MYSQL errors (Post ID in the address bar is 0) and the admin panel won't let me login