Problem importing SQL file

[xavioremu]

Alright, here goes...

Im moving my zen cart to a new host. Ive carefully followed all the directions listed on http://tutorials.zen-cart.com/index.php?article=100 (to the best of my knowledge..) but every time I keep hitting a road block. I may be doing something wrong, but Im no pro at this which is why I came here .

Basically everything runs smooth until I get to the point where I need to import my SQL db. I have to use SSH to import it because the file is too large for phpmyadmin. Every time I try to import the file, I get this error:

ERROR 1064 (42000) at line 1: 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 '' at line 1

I've tried using compatibility mode when exporting the file, tried importing the file on a mySQL 4 and 5 dbs (my host lets me choose which to use, the host the sites current at uses a version of 4), and I'm just not sure what the problem might be. I downloaded a program to make looking at the SQL file easier (then say, using notepad, lol), but tbh I had no real idea what I was looking for or looking at once I went to that line.

Any ideas?

[tino.schlegel]

You can post line 1 of your exported sql file?

Maybe you can have a look for youself and see what is wrong with the exported file. Did you export a compressed file?

[xavioremu]

Unless Im mistaken...this is all line 1 says (being viewed via ultraedit):

-- phpMyAdmin SQL Dump

I have exported it as gzip, and also just as a uncompressed SQL file, but got he same results when trying to import it. Also both files have the same line 1..if as I said Im referring to the correct thing.


==============


Well..just as I was saying this..lol..I imported the file again as an uncompressed SQL file (rather then being gzipped) and it actually worked. Im sure ive done it before without success. I dunno, lol.

[xavioremu]

Now im having another problem that I had before.

So I finished all the steps in the guide, however my site doesn't look quite right. It shows our logo, one of our featured products, and thats about it. If I click on 'All Products' it lists 1 - 10 (of 70), however it should be more like 'of 1400'.

To make things easier, Ill just show you the differences:

Current Website: www.atlanticglassetching.com
New Host: http://s301575491.onlinehome.us/zentest/

I tried getting in to the admin section to see if I needed to manually fix anything there, however the login / pass isnt working, and neither is the password reset.

[canopy]

Are there any differences in table prefixes (e.g. 'zen_') you used between the two sites? If that is the case, you will need to adjust the following line in the 2 x configure.php files for your new site:

PHP Code:

define('DB_PREFIX', 'xxxxx'); 


[xavioremu]

Thats already setup correctly since I setup a new install (same version) of zencart and saved the config files making sure not to replace them with the files from the old site.

[xavioremu]

Slight change, I was able to get in to the admin area by using this guide : http://tutorials.zen-cart.com/index.php?article=2

As you can also see on the website its not correctly listing the products or categories. Theres 1 featured product and it almost seems like thats the only thing thats showing up correctly ><. Is there any chance these problems are related to the fact that I imported the SQL db in to a MySQL 5 db rather then a 4 (as it came from a 4)? Im not sure what else might be causing these problems.

[xavioremu]

Sorry for all the posts...doesnt look like I can edit my posts here.

Anyway, tried switching to a MySQL 4 db in the meantime and there were no changes so far. Anyone have any other ideas? Thanks for all the help thus far :)

[xavioremu]

Is there any other files that link the db information to the files on your site? No products are found on the zen cart setup on the new host even though the config files are setup correctly and SQL file imported in to the db its setup for. Anyone know anything else that might cause this? I cant think of anything else to try

[fajmp]

sorry to ######## in but I'm having the same problem as you...and can't find the answer.
I'm thinking of deleting all my customers and starting fresh but am scared to death to do it in case everything blows up or something.
I have customers that can sign in and some that can't with the error showing up. All because I changed websites...if I had known.
Did you ever solve it...it doesn't seem like it from your posts. No one answered my inquiries either for some reason. Perhaps it's simple and under my nose, but I'm a a loss.