Moving to a new server

**w9dkc** · 1 Feb 2023, 02:44 PM

Yesterday morning I read posts for 3 hours. Last night I read posts for 2 hours. Most of what I read was older posts that appear not to work anymore. I have a cart running on server A for 15 years. I recently updated to 157C. I have over 3000 products fully set up, images, multiple attributes, etc. I need to move the database to the new server B. I have installed 157C on new server B. I have customized the pages that need that. I attempted to import the server A database into server B database and got an error about not authorized. Maybe db user name prefix is too blame. Can someone point me in a direction that will work in 157C?

**swguy** · 1 Feb 2023, 06:54 PM

Be sure the configure.php files on old vs new are identical for the fields starting with DB_.

**mc12345678** · 2 Feb 2023, 12:41 AM

May also help (as discouraging as it may be to read) to identify the steps taken. Thought to ask just about the database transfer, but then realized that any steps along the way may be a cause. Of course the above may resolve the issue as well you will be the one to best identify.

**swguy** · 2 Feb 2023, 01:08 AM

Also please note that there is a canonical answer to the question "how do I move to another server" in the help:

https://docs.zen-cart.com/user/insta...change_hoster/

**OldNGrey** · 2 Feb 2023, 04:22 AM

Originally Posted by w9dkc

I attempted to import the server A database into server B database and got an error about not authorized.

This is a long shot but I assume that you are using Linux. If you are trying to import using mysql -u USERNAME -p DATABASENAME <OLDDATAFILE.gz
try using the --binary-mode switch eg mysql --binary mode -u USERNAME -p DATABASENAME <OLDDATAFILE.gz

If that fails with the "not authorized" error try unzipping the database file first eg

Code:

gunzip OLDDATAFILE.sql.gz

and import the resulting unzipped sql text file.

**w9dkc** · 3 Feb 2023, 09:18 PM

So, I started over. I uploaded version 158 and installed it. Had a few bumps (forgot to use the db prefix and user prefix). I dumped the database except table 3 (Admin). I had already exported the other database leaving out table 3. I imported that. it worked. I then updated the database to 158. Everything works. I then uploaded my product and category images. It worked. Then uploaded my custom templates. It worked.
I checked 4 hours ago and had 11 bots crawling.
Already got some bad news from Bing - "The page contains 'noindex' directive either in a meta tag or HTTP header".
somebody tell me where to look?