Trouble importing data

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

Let me rephrase: what if I enter values for the fields? And how would you explain the fact that the exported data threw errors during the import even after truncating the address book table? Thanks.

isaacr25:

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

Let me rephrase: what if I enter values for the fields?You could try that for the address-book data.
isaacr25:

And how would you explain the fact that the exported data threw errors during the import even after truncating the address book table?Because it crashed later on your banners table ... seemingly for potentially similar reasons.

Why don't you try using the admin plugin for doing mysql backups and see if it generates a better backup?
http://www.zen-cart.com/index.php?main_page=product_contrib_info&cPath=40_41&products_id=81

Here is the banners error:

#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 'Cart, 'http://www.zen-cart.com', banners/zencart_468_60_02.gif, Wide-Banners, ''' at line 2

Is there no option to restore the database? I dread calling the hosting company since I know I will get a run-around before anything is found.

isaacr25:

Is there no option to restore the database?Yes -- with a working phpMyAdmin tool.
Or with the admin backup/restore plugin I mentioned in my last post.
Or with various other MySQL management tools you could purchase.

Your problem is that the tool intended to do the job isn't working properly. And the only one who can fix it is your hosting company, unless you try using alternate tools as suggested.

isaacr25:

I dread calling the hosting company since I know I will get a run-around before anything is found.Are you saying that you've had this problem for a couple days now, and even though we've been telling you to talk to your hosting company, you still haven't?

If they're that bad, find another.

I tried using the backup plugin tool, and when I imported the data into the new server, I got the following error. We also realized that the first server is running mySQL 5.0.24, and the destination server is running 4.1.21.

SQL query:

-- MySQL dump 10.10

-- Host: localhost Database: miramweb_jos

-- Server version 5.0.24
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;

MySQL said:

#1065 - Query was empty

isaacr25:

We also realized that the first server is running mySQL 5.0.24, and the destination server is running 4.1.21.> MySQL said:

#1065 - Query was emptyVersion compatibility issues often create "query was empty" responses ... mostly because some of the query commands used don't exist in the older version you're trying to restore onto.

DrByte:

Version compatibility issues often create "query was empty" responses ... mostly because some of the query commands used don't exist in the older version you're trying to restore onto.

Makes sense. I'm looking at other hosts since Network Solutions won't change their db version from 4.1. My current version is 5.0.24. Do you think that migrating to db version 5.0.45 would be an issue? Thanks.

Migrating from 5.0.x to 5.0.x should be easier than downgrading would be.

Talk to your new host (or prospective new hosts) about whether they'll assist you in the data-migration process. Many of the hosts on the hosting link at the top of this page will be glad to help you.