1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

Switching Servers, Database Import Problems, Help Appreciated

Discussion in 'MySQL' started by CyberBrian, May 15, 2008.

0
  1. #1
    I'm on the newbie side when I veer from SEO and SEM, so please lend me a hand.

    I used phpmyadmin to dump and import and this is the error I'm getting:

    "#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 '`application_mode_id` int(1) NOT NULL auto_increment,
    `application_mode` varch' at line 1 "

    Here is the code at the beginning of the db, where I'm assuming the problem is...

    CREATE TABLE `application_mode` (
  `application_mode_id` int(1) NOT NULL auto_increment,
  `application_mode` varchar(50) default NULL,
  PRIMARY KEY  (`application_mode_id`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;
    Code (markup):

    Cheers.
     
    CyberBrian, May 15, 2008 IP
  2. royo

    royo Peon

    Messages:
    173
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Are you using a different MySQL version?
     
    royo, May 15, 2008 IP
    CyberBrian likes this.
  3. CyberBrian

    CyberBrian Peon

    Messages:
    129
    Likes Received:
    6
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Yeah, from 2.6.0 to 5.0.45...
     
    CyberBrian, May 15, 2008 IP