Posted on: 02/22/05 11:24am
By: etegration
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
Error importing mySQL db from Windows server into Linux server
Posted on: 02/24/05 02:14pm
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
Error importing mySQL db from Windows server into Linux server
Posted on: 02/24/05 10:40pm
By: etegration
[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[/QUOTE]
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.
Error importing mySQL db from Windows server into Linux server
Posted on: 12/17/05 01:03am
By: Anonymous (Saturn)
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
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