Trouble importing data

[isaacr25]

Here's a link to the file:

*** snip ***

[DrByte]

Access denied.

[isaacr25]

Try this... its the code in a text file:

**** snip ****

[DrByte]

I have no idea why it's doing that.

You have a few options:

a) Since you have no customers in your database other than the default test account, you could just delete that customer via the admin and then re-export the database.

b) You could edit the .sql file and add two single quotes between those two commas. But that is only a bandage masking the real root problem ... which I don't know the cause of.

c) Many of your fields are being exported as hexadecimal data, suggesting that they're being seen as binary fields, but the structure of the tables doesn't have them set to be binary. Thus, it's odd that it's converting a lot of data to hex format. This suggests to me that something's wrong with your server configuration or with phpMyAdmin on your server, such that it's operating wrongly.
This is borne out in the fact that it should not be leaving that company field blank like that.

In short, I don't know the cause of your problem. All I can suggest are some workarounds. It would be more prudent for you to talk to your hosting company about why it's behaving like it is ... that's their job to fix.

NOTE: If you can't get good backups and/or cannot restore your backups ... then you don't have a reliable environment. And, if your environment isn't reliable, it doesn't make sense to run a business there. Maybe another host might be a requirement ...

[isaacr25]

I tried your option a to see what would happen... truncated the Address Book table, exported, and attempted to re-import. Now I get errors pointing to the banners table:

There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem

ERROR: Unknown Punctuation String @ 978
STR: ://
SQL:

--
-- Dumping data for table `banners`
--

and more...............

[DrByte]

Are these the options you're choosing for export?
https://www.zen-cart.com/tutorials/i...hp?article=103

[isaacr25]

Yes... I'm using those options.

[DrByte]

Time to talk to your hosting company

[isaacr25]

So, the issue is that the data export is dropping fields? Please clarify. What if I enter the missing fields in phpMyAdmin?

[DrByte]

So, the issue is that the data export is dropping fields?

It's dropping data for some fields. I'm not sure I see any pattern to it.

What if I enter the missing fields in phpMyAdmin?

It's not missing fields. It's skipping their data during exporting.