Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1057
  • Last Modified:

can't import .sql file into mysql (wrong syntax)

I'm sending an exported MySQL sql file to a colleague of mine so he can work on the same database structure. Unfortunately, he keeps getting this error:

#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 'TYPE=MyISAM  AUTO_INCREMENT=3' at line 15


I'm sure it has something to do with the encoding, but don't know what to change.

Some more info about my colleague's Mysql version:

Server: Localhost via UNIX socket
Server version: 5.5.9
Protocol version: 10
User: root@localhost
MySQL charset: UTF-8 Unicode (utf8)
Web server

Apache/2.2.17 (Unix) mod_ssl/2.2.17 OpenSSL/0.9.8r DAV/2 PHP/5.3.6
MySQL client version: 5.5.9
PHP extension: mysql



Attached you'll find the upper part of the .sql export file.
-- phpMyAdmin SQL Dump
-- version 2.10.1
-- http://www.phpmyadmin.net
-- 
-- Host: mysql-006.openminds.be:3306
-- Generated: 25 Sept 2011 at 12:08
-- Server version: 5.1.49
-- PHP version: 5.2.6-3


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

-- 
-- Database: `d1s_cms`
-- 
CREATE DATABASE `d1s_cms` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE d1s_cms;

-- --------------------------------------------------------

-- 
-- Tabel structuur voor tabel `wp_d90_commentmeta`
-- 

CREATE TABLE `wp_d90_commentmeta` (
  `meta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `comment_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `meta_key` varchar(255) DEFAULT NULL,
  `meta_value` longtext,
  PRIMARY KEY (`meta_id`),
  KEY `comment_id` (`comment_id`),
  KEY `meta_key` (`meta_key`)
) TYPE=MyISAM  AUTO_INCREMENT=3 ;

Open in new window

0
digital1stein
Asked:
digital1stein
  • 2
1 Solution
 
digital1steinAuthor Commented:
FYI: my Mysql version is
mysql  Ver 14.14 Distrib 5.1.49, for Win32 (ia32)
0
 
azserrataCommented:
Hi!

About the storage engine, try ENGINE=xxxx instead of TYPE=xxxxx.

Cheers
David
0
 
digital1steinAuthor Commented:
It worked! Thanks.
0

Featured Post

Ask an Anonymous Question!

Don't feel intimidated by what you don't know. Ask your question anonymously. It's easy! Learn more and upgrade.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now