Page 3 of 3 FirstFirst 123
Results 21 to 25 of 25
  1. #21
    Join Date
    Jun 2005
    Location
    Cumbria, UK
    Posts
    10,262
    Plugin Contributions
    3

    Default Re: Having problems transferring MySql

    Quote Originally Posted by doooomed View Post
    No Worries, I'm not touching the original site. I misspoke earlier, I have a database apparently as the site is functional but it shows no products or customer info/orders.
    As I said... the first thing you should see after creating a CLONE site, is a site that is absolutely identical in every way to your ORIGINAL site.

    Afterall, the new site is an exact COPY.

    If you are not seeing an IDENTICAL SITE (identical in EVERY WAY - including customers, products, orders, ezpages...) then you have not made the CLONE correctly.


    Quote Originally Posted by doooomed View Post
    Just for my information, if I had a fresh install and made no changes at all except for pointing the config pages to an existing database, would that work or would other changes need to be made? I ask this because I have all my overrides and such neatly tucked away and I could easy get a fresh install turned into a functional store in a fairly short amount of time.
    Many customisations that site owners put in place over the months and years are a COMBINATION of code changes AND database changes. For example, when you add a CUSTOM template, the "instruction" to load that template and all of its settings (eg: sideboxes) are stored in the database.

    So if you do a "fresh install", then link that to another database, there will be inconsistencies... How will the "fresh install" cope with trying to apply a template, when the custom files for that template are not there - but the settings in the database are instructing the system to apply that template...

    Quote Originally Posted by doooomed View Post
    If not I am going to go ahead and re-do everything you laid out for me to see if I can find where I messed up.
    Just remember to NOT TOUCH the original files, or tamper with the original database.
    19 years a Zencart User

  2. #22
    Join Date
    Jun 2009
    Posts
    275
    Plugin Contributions
    0

    Default Re: Having problems transferring MySql

    Thank you Schoolboy! Worked like a charm!

  3. #23
    Join Date
    Jul 2005
    Location
    Hoedspruit
    Posts
    528
    Plugin Contributions
    2

    Default Re: Having problems transferring MySql

    Identical sites, but my issue is not the copying, rather the version.

    My site: Fresh ZC 1.5.4 installed using CPanel & Installation.

    Copied database as per sequence above. All copied data shows in the new database.

    Changed the configure.php file to point to the original database username and password, and this is where I think my problem lies.
    Last edited by Parafanaylya; 14 Apr 2015 at 07:07 AM.

  4. #24
    Join Date
    Jul 2005
    Location
    Hoedspruit
    Posts
    528
    Plugin Contributions
    2

    Default Re: Having problems transferring MySql

    Quote Originally Posted by Parafanaylya View Post
    Identical sites, but my issue is not the copying, rather the version.

    My site: Fresh ZC 1.5.4 installed using CPanel & Installation.

    Copied database as per sequence above. All copied data shows in the new database.

    Changed the configure.php file to point to the original database username and password, and this is where I think my problem lies.
    Posted before completing my issue.

    When the changes have been made to the configure.php files, the database no longer reflects any product.

  5. #25
    Join Date
    Jul 2005
    Location
    Hoedspruit
    Posts
    528
    Plugin Contributions
    2

    Default Re: Having problems transferring MySql

    Quote Originally Posted by Parafanaylya View Post
    Posted before completing my issue.

    When the changes have been made to the configure.php files, the database no longer reflects any product.
    Moving my please help me to here

 

 
Page 3 of 3 FirstFirst 123

Similar Threads

  1. v150 Problems transferring databases
    By digipete in forum Upgrading to 1.5.x
    Replies: 1
    Last Post: 27 Jul 2012, 07:34 AM
  2. Problems Transferring Zencart to New Website
    By brianj_hill in forum Installing on a Linux/Unix Server
    Replies: 1
    Last Post: 30 Apr 2010, 06:10 PM
  3. Problems with manually upgrading MySQL 4 to MySQL 5
    By 2004g35 in forum Installing on a Linux/Unix Server
    Replies: 0
    Last Post: 29 Oct 2009, 02:15 AM
  4. Transferring a non-mySQL database
    By flickfan51 in forum General Questions
    Replies: 1
    Last Post: 26 Jul 2007, 05:50 PM

Bookmarks

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
Zen-Cart, Internet Selling Services, Klamath Falls, OR