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 https://www.zen-cart.com/tutorials/i...hp?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:

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.