Importing data

[ConwayMJ]

I have a similar need but would like to know how to do it myself as it seems like a relatively easy process. I have read the FAQs and other information from this site and other but I still cannot seem to figure out what I am doing wrong.

I am running the latest version of Zen Cart, fresh install and so far no addons have been added (I actually scrapped my last cart because I was being reckless with addons and not backing my stuff up...) All I have done was added a template that does not affect database files.

I had gotten some considerable amount of work done with the site before it went up in flames (I do not feel like getting into it..). I figured that to save some time, I could backup my database and drop select pieces of it. I did not know which options to select to get an easy-to-drop .sql file so I just went with something (I do not remember what). I then opened up the file and started eliminating all of the information that I did not want to include (most of which were entries that I knew was going to be loaded with a fresh install and blank data tables) I cleaned it up a bit so now my .sql file has a series of data insert commands...

I am using 'REPLACE' commands just in case there are database entries that would add a primary key that was already used (so it overrides it instead). I have gone through and made sure the alterations as made by the addons were deleted. The link below is to my database with ONLY NON-SENSITIVE information being shown:

2monkey.com/fairydus_zc1.sql

The error I am receiving the following message when I try to upload the .sql files:

#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 '"INSERT INTO `zen_banners` (`banners_id`, `banners_title`, `banners_url`, `banne' at line 1

I removed the " ` " (backwards apostrophe?) to see if that would work but to no avail.

What is the proper syntax to use?

[ConwayMJ]

idk if this will help you help me, but here is some additional info:

PHP Version: 5.2.17

Database: MySQL 5.0.91

Server Host: Site5

Been working on this for WAAY too long :\

[kuroi]

[moderator comment]

Your posts have been moved to their own thread. Hijacking somebody else's thread before their issue has been resolved is not appreciated in this forum, especially when your topic has such a tenuous link to the original.

[ConwayMJ]

[moderator comment]

Your posts have been moved to their own thread. Hijacking somebody else's thread before their issue has been resolved is not appreciated in this forum, especially when your topic has such a tenuous link to the original.

My bad, I figured that since he was looking for contracted work that he should do so in the 'Commercial Help Wanted' section. As such, I thought my question was more relevant to his question than his own question since he is not seeming like he'll wants support for it, rather to have somebody else do it. But I digress...

I'm new to forum posting, where do I go to get to where my link was moved to?

[ConwayMJ]

My bad, I figured that since he was looking for contracted work that he should do so in the 'Commercial Help Wanted' section. As such, I thought my question was more relevant to his question than his own question since he is not seeming like he'll wants support for it, rather to have somebody else do it. But I digress...

I'm new to forum posting, where do I go to get to where my link was moved to?

Never mind, I figured it out...

[ConwayMJ]

Never mind, I figured it out...

To clarify, I figured it out where it got moved to, but I am still having problems with this. Any help would be great. I tried looking up syntax rules in Google and nothing seems to work. If somebody could just show me how the table data replacement function would work using one of the replacement commands in the .sql, that would be uber awesome and I could just replicate the process for the 30 others I need to do... this is so frustrating!