That's probably what's breaking the content of your file.
Thread: MYSQL Import Error
Results 1 to 9 of 9
Hybrid View
-
29 Dec 2009, 10:12 AM #1
Sensei
- Join Date
- Jan 2004
- Posts
- 66,446
- Plugin Contributions
- 81
Re: MYSQL Import Error
.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole
Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.
-
29 Dec 2009, 05:56 PM #2
New Zenner
- Join Date
- Dec 2009
- Posts
- 31
- Plugin Contributions
- 0
Re: MYSQL Import Error
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 ?
-
29 Dec 2009, 06:00 PM #3
Sensei
- Join Date
- Jan 2004
- Posts
- 66,446
- Plugin Contributions
- 81
Re: MYSQL Import Error
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..
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole
Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.
Similar Threads
-
Import Datafeed to MySQL database?
By kirei in forum Setting Up Categories, Products, AttributesReplies: 2Last Post: 27 Nov 2009, 10:09 PM -
MySQL database import error
By xikan in forum Installing on a Linux/Unix ServerReplies: 1Last Post: 24 Aug 2009, 02:39 AM -
Unable to import MYSQL database
By 1just4help in forum Installing on a Windows ServerReplies: 25Last Post: 2 Jun 2009, 06:29 PM -
Error after MySQL Import
By paults in forum Installing on a Linux/Unix ServerReplies: 4Last Post: 27 May 2007, 05:22 AM -
Import Categories Description Mysql
By cjsmiff in forum Basic ConfigurationReplies: 2Last Post: 16 Apr 2007, 01:26 AM
