I built a site on my home comp, and works 100% on everything. When I tried to export the DB structure to the server, it threw an error. Here's what phpMyAdmin exported:
Code: Select all
CREATE TABLE `comments` (
`id` int(8) NOT NULL auto_increment,
`username` varchar(30) NOT NULL default '',
`re` varchar(50) NOT NULL default '',
`service` int(8) NOT NULL default '0',
`quality` int(8) NOT NULL default '0',
`reliability` int(8) NOT NULL default '0',
`recommend` int(8) NOT NULL default '0',
`comment` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`,`re`),
KEY `username` (`username`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;Code: Select all
#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 CHARSET=latin1 AUTO_INCREMENT=1' at line 12