Ansi Sql Database Import Problems

[expired user #5404]'s profile image [expired user #5404] posted 13 years ago in Import/Export Permalink

unfortunately we exported our database with the ansi sql standard. Mysql import results in a 1064 error because all the ` are " now!
An import with Heidisql 4.0 seems not possible, because it take 7 hours just to do 13000 queries! Our database requires about 131000 entrys. With Heidi 6 I get the same error as with mysql.

# HeidiSQL Dump
#
# --------------------------------------------------------
# Host: 127.0.0.1
# Database: test
# Server version: 4.0.26-debug
# Server OS: Win32
# Target compatibility: ANSI SQL
# HeidiSQL version: 4.0
# Date/time: 2010-12-22 23:06:50
# --------------------------------------------------------

/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='ANSI,NO_BACKSLASH_ESCAPES';*/
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;*/

Does anyone know how to import that database with mysql or have some workaround?

Thanks a lot!

Please login to leave a reply, or register at first.