Welcome to Geeklog, Anonymous Thursday, March 28 2024 @ 02:53 pm EDT

Geeklog Forums

Error importing mySQL db from Windows server into Linux server...


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
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
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

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
 Quote

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
 Quote

All times are EDT. The time is now 02:53 pm.

  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content