SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    Internet Business Optimizer KCgame's Avatar
    Join Date
    Mar 2005
    Location
    Singapore
    Posts
    928
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Question Errors in MySQL DB uploading via phpMyadmin

    HI all,

    I'm facing a critical problem here...I'm using MySQL 4.1.7 and myphpadmin 2.6.0-pl3 on my PC (xammp). I am converting my database to .sql via phpmyadmin and upload to the server.

    However, there are errors that tell me to check version number etc....How can i overcome this? The server is using:

    MySQL 4.0.22
    phpmyadmin 2.6.1-pl2

    Is it a must to match these two versions when uploading of .sql is concern?

    The current error is:

    #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=66' at line 27

    and line 27:

    PHP Code:
    CREATE TABLE `admin_activity` (
    `
    idint11 NOT NULL AUTO_INCREMENT ,
    `
    namevarchar10 NOT NULL default '',
    `
    logintimestamp NOT NULL default '0000-00-00 00:00:00',
    `
    logoutdatetime default '0000-00-00 00:00:00',
    `
    reasonvarchar50 NOT NULL default '',
    `
    log_filetext NOT NULL ,
    PRIMARY KEY ( `id` )
    ENGINE MYISAM DEFAULT CHARSET latin1 AUTO_INCREMENT =66  //line 27 
    Any help / comment will be greatly appreciated. Thanks.

  2. #2
    SitePoint Evangelist
    Join Date
    Apr 2005
    Location
    Moscow, Russia
    Posts
    557
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    #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=66' at line 27
    Hi, check SQL errors, need help thread for the similar problem and please let us know if that helped

  3. #3
    Internet Business Optimizer KCgame's Avatar
    Join Date
    Mar 2005
    Location
    Singapore
    Posts
    928
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by Tangerine_Dream
    Hi, check SQL errors, need help thread for the similar problem and please let us know if that helped
    Hi Tangerine_Dream,

    I've just managed to solve the problem by upgrading myphpadmin so as to export as mysql ver 4.0.xx in order to fit into my server's version. Thank you.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •