Page 1 of 3 123 LastLast
Results 1 to 10 of 28
  1. #1
    Join Date
    Oct 2007
    Location
    MA, USA
    Posts
    385
    Plugin Contributions
    0

    Default Importing Database into new Installation

    Hello,

    I am in the process of changing hosting company's. I have installed Zencart on new server and have imported the database.

    The problem is that when I go to "MYDOMAIN.COM/CART" it does not display any of the catalogue information. Just a blank Zencart Installation.

    When I view the database from phpadmin, all of the data is there but is not displaying.

    I did the exact same thing for another one of my domains and it worked flawlessly with no trouble. What could be the problem with this as this is my most important and largest catalog.

    Thanks so very much for your help.

    Kevin

  2. #2
    Join Date
    Oct 2006
    Posts
    5,477
    Plugin Contributions
    11

    Default Re: Importing Database into new Installation

    Did you change the 2 configure.php files?
    I no longer provide installation support on forum for all my modules. However, if there are real bugs with the modules please feel free to contact me

  3. #3
    Join Date
    Oct 2007
    Location
    MA, USA
    Posts
    385
    Plugin Contributions
    0

    Default Re: Importing Database into new Installation

    Thanks for the quick reply.

    The important thing is that my data is there. I think what might be the problem is that I am stuck in DNS propagation. Long story. I will wait another day or so and try it again.

    I will also check the configure files, thanks for the suggestion and post a reply back once I figured this out with the fix.

    Be in touch soon.

    Thanks again.
    Kevin

  4. #4
    Join Date
    Oct 2006
    Posts
    5,477
    Plugin Contributions
    11

    Default Re: Importing Database into new Installation

    If you need more help, be sure to post your link.
    I no longer provide installation support on forum for all my modules. However, if there are real bugs with the modules please feel free to contact me

  5. #5
    Join Date
    Jan 2004
    Posts
    66,443
    Plugin Contributions
    279

    Default Re: Importing Database into new Installation

    Have you correctly pointed the new install to the new database?
    And have you used the same DB_PREFIX as you had on the old server?

    FAQ on moving from one server to another: https://www.zen-cart.com/tutorials/i...hp?article=100
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

  6. #6
    Join Date
    Oct 2007
    Location
    MA, USA
    Posts
    385
    Plugin Contributions
    0

    Default Re: Importing Database into new Installation

    It is a long story.

    The new Zencart install was automatic via the cpanel. Worked great.

    It automatically names the database which is fine because it is the new name for the database that I would like to use. DB Name is "zc_1"

    I had already imported this data into another Zencart Installation using my own defined database name. DB Name "HHD_STORE"

    I imported "HHD_STORE" DB into "zc_1" DB. The import went smoothly and there wer no error message.

    This is where I get confused. When I view the new "zc_1" DB from phpmyadmin, all of the data is there. Catagories, product info etc etc. However, when I try to access the cart from "MyDomain.com/cart" it shows the Zencart program but none of the data from the database.

    I checked the config files and the DB is "zc_1" I changed it to "HHD_STORE" but nothing happened.

    This is redundent from my first post but maybe clarifies it a bit.

  7. #7
    Join Date
    Jan 2004
    Posts
    66,443
    Plugin Contributions
    279

    Default Re: Importing Database into new Installation

    Please post all the DB_xxxxxx settings from your OLD store and your NEW store here. The password can be skipped.
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

  8. #8
    Join Date
    Oct 2007
    Location
    MA, USA
    Posts
    385
    Plugin Contributions
    0

    Default Re: Importing Database into new Installation

    Quote Originally Posted by DrByte View Post
    Please post all the DB_xxxxxx settings from your OLD store and your NEW store here. The password can be skipped.
    Please excuse my ignorance but I am still a beginner with Zencart.

    Where would I find the DB_xxxxx settings?

  9. #9
    Join Date
    Oct 2007
    Location
    MA, USA
    Posts
    385
    Plugin Contributions
    0

    Default Re: Importing Database into new Installation

    One of the other changes that I made was the path to the cart. The original one is "store" and the new one is "cart". Would this make a difference?

  10. #10
    Join Date
    Jan 2004
    Posts
    66,443
    Plugin Contributions
    279

    Default Re: Importing Database into new Installation

    I was referring to these, from your configure.php files:
    Code:
    // define our database connection
    define('DB_TYPE', '');
    define('DB_PREFIX', '');
    define('DB_SERVER', '');
    define('DB_SERVER_USERNAME', '');
    define('DB_SERVER_PASSWORD', '');
    define('DB_DATABASE', '');
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

 

 
Page 1 of 3 123 LastLast

Similar Threads

  1. v139h Problem Importing SQL database to new database ready for testing Zencart 1.5
    By gillpotsoffun in forum Upgrading to 1.5.x
    Replies: 8
    Last Post: 24 Aug 2015, 11:24 PM
  2. Importing Customers into ZC from Another Database
    By clausont in forum Managing Customers and Orders
    Replies: 2
    Last Post: 22 Dec 2012, 10:21 PM
  3. Error importing old database to the new database
    By wmorris in forum Upgrading to 1.5.x
    Replies: 1
    Last Post: 3 Jan 2012, 08:27 AM
  4. Replies: 4
    Last Post: 15 Oct 2010, 07:18 AM
  5. Help importing data into database...
    By dbunch in forum Currencies & Sales Taxes, VAT, GST, etc.
    Replies: 1
    Last Post: 18 Jan 2007, 11:45 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg