Ansi Sql Database Import Problems
| User, date | Message |
|---|---|
|
Written by tlandmann
2 years ago Category: Import/Export 5 posts since Thu, 23 Dec 10 |
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. |