Welcome to Geeklog, Anonymous Thursday, November 28 2024 @ 09:45 pm EST
Geeklog Forums
Error importing mySQL db from Windows server into Linux server...
Error message:
upon running:
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
#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
-- 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
6
6
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
bye, Dirk
7
7
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
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
4
6
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
4
6
Quote
All times are EST. The time is now 09:45 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