02/22/05 11:24am  
Status: offline

etegration

Forum User
Full Member
Registered: 02/20/02
Posts: 179
full
Error message:

#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=utf8mb4' at line 23


upon running:

SQL-query:

-- phpMyAdmin SQL Dump
-- version 2.6.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Feb 22, 2005 at 08:29 PM
-- Server version: 4.1.9
-- PHP Version: 5.0.3
--
-- Database: `geeklog1`
--
-- --------------------------------------------------------
--
-- Table structure for table `gl_access`
--
CREATE TABLE `gl_access` (

`acc_ft_id` mediumint( 8 ) NOT NULL default '0',
`acc_grp_id` mediumint( 8 ) NOT NULL default '0',
PRIMARY KEY ( `acc_ft_id` , `acc_grp_id` )
) ENGINE = MYISAM DEFAULT CHARSET = latin1


Error returned form phpmyadmin, why so? Different mySQL versions? Both will be running same GL 1.3.11
http://www.etegration.com.sg
http://www.itcow.com
http://www.ministryofhosting.com
 02/24/05 02:14pm  
Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Haven't seen that one before, but since it doesn't seem to like the "DEFAULT CHARSET=utf8mb4" bit, I'd suggest you take those out of the backup file and try again. Shouldn't cause any problems, unless your using a non-western language on your site.

bye, Dirk
 02/24/05 10:40pm  
Status: offline

etegration

Forum User
Full Member
Registered: 02/20/02
Posts: 179
Quote by Dirk: Haven't seen that one before, but since it doesn't seem to like the "DEFAULT CHARSET=utf8mb4" bit, I'd suggest you take those out of the backup file and try again. Shouldn't cause any problems, unless your using a non-western language on your site.

bye, Dirk


It was phpMyAdmin.

I am using the latest phpmyadmin and mySQL on my home server (windows 2003), dump out the GL database then reimported it back into my hosting company's phpmyadmin/ mySQL which is of older versions.

Before dumping, use "Compatibility mySQL 4" (or something like that) then export and re-import it back and it'll work.
http://www.etegration.com.sg
http://www.itcow.com
http://www.ministryofhosting.com
 12/17/05 01:03am  

Saturn

Anonymous

etegration YOU ARE THE MAN!

I came across 30 sites with same error (just in my case different line) and all sugestions didn't got me nowhere

Text Formatted Code
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=utf8mb4'
 


and only exporting and using "SQL export compatibility:" "MYSQL40"
fixed the problem importing with no errors

new server: MySQL version 4.1.13-standard
old server: MySQL version 4.0.25-standard