MYSQL Import Error

[infowire]

Hi, i am moving ZenCart from one server to another and i have the exported mysql database and when i try and import in phpmyadmin i get the following error:


Error

SQL query:

# HeidiSQL Dump
#
# --------------------------------------------------------
# Host: 67.225.243.221
# Database: dressup_zencart
# Server version: 5.0.85-community
# Server OS: pc-linux-gnu
# Target compatibility: ANSI SQL
# HeidiSQL version: 4.0
# Date/time: 2009-12-21 14:29:45
# --------------------------------------------------------
/*!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;*/#
# Database structure for database 'dressup_zencart'
#
CREATE DATABASE /*!32312 IF NOT EXISTS*/ "dressup_zencart"/*!40100 DEFAULT CHARACTER SET latin1 */;

MySQL said: Documentation
#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 'SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;*/

#' at line 14

[Vger]

Disable that line with a # in front of it:

#!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;

and also disable this one, which creates the database (you create the db in phpMyAdmin before you import into it):

#CREATE DATABASE /*!32312 IF NOT EXISTS*/ "dressup_zencart"/*!40100 DEFAULT CHARACTER SET latin1 */;

Vger

[infowire]

Then i get this:

Error

SQL query:

# HeidiSQL Dump
#
# --------------------------------------------------------
# Host: 67.225.243.221
# Database: dressup_zencart
# Server version: 5.0.85-community
# Server OS: pc-linux-gnu
# Target compatibility: ANSI SQL
# HeidiSQL version: 4.0
# Date/time: 2009-12-21 14:29:45
# --------------------------------------------------------
#/*!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;*/
#
# Database structure for database 'dressup_zencart'
#
#CREATE DATABASE /*!32312 IF NOT EXISTS*/ "dressup_zencart" /*!40100 DEFAULT CHARACTER SET latin1 */;
USE "dressup_zencart";

MySQL said: Documentation
#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 '"dressup_zencart"' at line 23






I have dressup_zencart database created... idk why it would error

[infowire]

and if i comment that out i get more error:



Error

SQL query:

# HeidiSQL Dump # # -------------------------------------------------------- # Host: 67.225.243.221 # Database: dressup_zencart # Server version: 5.0.85-community # Server OS: pc-linux-gnu # Target compatibility: ANSI SQL # HeidiSQL version: 4.0 # Date/time: 2009-12-21 14:29:45 # -------------------------------------------------------- #/*!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;*/ # # Database structure for database 'dressup_zencart' # #CREATE DATABASE /*!32312 IF NOT EXISTS*/ "dressup_zencart" /*!40100 DEFAULT CHARACTER SET latin1 */; #USE "dressup_zencart"; # # Table structure for table 'zen_address_book' # CREATE TABLE /*!32312 IF NOT EXISTS*/ "zen_address_book" ( "address_book_id" int(11) NOT NULL auto_increment[...]

MySQL said: Documentation
#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 '"zen_address_book" (
"address_book_id" int(11) NOT NULL auto_increment,
"c' at line 30

[DrByte]

1. You can't use "CREATE DATABASE" or "USE" statements in an import via phpMyAdmin.
And, if you create your backup/export using the instructions mentioned in our FAQ articles ( https://www.zen-cart.com/tutorials/i...hp?article=103 ) then the export won't even include those statements.

2. You appear to be editing the file with a tool that changes the line-endings of the text in the file, and thus you're getting all the content confused. Just look at the difference between what you posted last and the post before it.
You need a reliable text editor. Perhaps the free Notepad++ (http://notepad-plus.sf.net) might be a wise choice.

[infowire]

i been using notepad.

[DrByte]

That's probably what's breaking the content of your file.

[infowire]

the sql file was exported using phpmyadmin according to the guy who owns the other server just like the tutorial says. Why would notepad break the file ?

[DrByte]

1. Using the tutorial I mentioned, if one actually follows it exactly, does an export of the specified database, not all databases in the account, and thus the CREATE DATABASE and USE statements will not be added to the exported file.

2. Notepad, being a MS windoze native app, commonly damages files. It's a well known fact that Notepad is ill-suited for working with files used on webservers, especially if the server runs the more suitable linux operating system.
The free Notepad++ application is much better suited to working with web files, and has the added benefit of giving you line numbers and syntax highlighting to quickly spot self-generated errors before they become problems.