Zen Cart Logo
Forums / Installing on a Windows Server / Having problems transferring MySql

Having problems transferring MySql

Views: 8,545

Results 21 to 25 of 25
20 Feb 2013, 1:46 PM
#21
schoolboy avatar

schoolboy

Totally Zenned

Join Date:
Jun 2005
Location:
Cumbria, UK
Posts:
10,327
Plugin Contributions:
0

Having problems transferring MySql

doooomed:

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.

doooomed:

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...

doooomed:

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.

26 Feb 2013, 1:28 PM
#22
doooomed avatar

doooomed

Zen Follower

Join Date:
Jun 2009
Posts:
275
Plugin Contributions:
0

Re: Having problems transferring MySql

Thank you Schoolboy! :clap: Worked like a charm!

14 Apr 2015, 6:03 AM
#23
parafanaylya avatar

parafanaylya

Totally Zenned

Join Date:
Jul 2005
Location:
Hoedspruit
Posts:
470
Plugin Contributions:
1

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.

14 Apr 2015, 8:49 AM
#24
parafanaylya avatar

parafanaylya

Totally Zenned

Join Date:
Jul 2005
Location:
Hoedspruit
Posts:
470
Plugin Contributions:
1

Re: Having problems transferring MySql

Parafanaylya:

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.

15 Apr 2015, 6:05 AM
#25
parafanaylya avatar

parafanaylya

Totally Zenned

Join Date:
Jul 2005
Location:
Hoedspruit
Posts:
470
Plugin Contributions:
1

Re: Having problems transferring MySql

Parafanaylya:

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