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:

CREATE TABLE `admin_activity` (
`id` int( 11 ) NOT NULL AUTO_INCREMENT ,
`name` varchar( 10 ) NOT NULL default '',
`login` timestamp NOT NULL default '0000-00-00 00:00:00',
`logout` datetime default '0000-00-00 00:00:00',
`reason` varchar( 50 ) NOT NULL default '',
`log_file` text NOT NULL ,
PRIMARY KEY ( `id` )
) ENGINE = MYISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT =66  //line 27

Any help / comment will be greatly appreciated. Thanks.

    CHARSET was addded in mySQL 4.1. in phpMyAdmin's export page to need to set the "SQL export compatibility" setting down to mySQL 3.x or 4.x.

      Hi devinemke,

      How do i set 'SQL export compatibility' ? Is it under phpmyadmin interface? I really appreciate your help regarding this issue. Thank you.

        kcgame wrote:

        How do i set 'SQL export compatibility' ? Is it under phpmyadmin interface?

        yes, as i said above, it is in phpMyAdmin's "export" page. make sure you are using the latest version of phpMyAdmin.

          devinemke wrote:

          yes, as i said above, it is in phpMyAdmin's "export" page. make sure you are using the latest version of phpMyAdmin.

          Thanks, have downloaded the lastest version 2.6.3 xx and managed to export without a problem 😃

          However, 🙁 anyone knows how to set mysql username and password on U*nix via cpanel? The only problem now is that i cannot establish link to the db because of mismatched username and password with those inside my php scripts...

          Further help from anyone will be greatly appreciated.

            Write a Reply...