Data base merging

21 Feb 2013, 03:45

#1

Zen Follower

Join Date:: Nov 2005
Posts:: 153
Plugin Contributions:: 0

Data base merging

My host moved my site to a new server. The ver 1.3.9h I had did not work on the newer php version they have using php ver 5.3.14. So I decided to install a fresh zen cart and start from scratch. However, I would like to retain my customers, products, emails ect. I am not sure what to extract from the old data base and what format to, (txt,cvs, sql ect) to insert it into the new database. Can you point me to a direction or help?
It is:
•Server: Localhost via UNIX socket
•Server version: 5.5.25a-cll
•Protocol version: 10
•MySQL charset: UTF-8 Unicode (utf8)
Web server
•sw-cp-server/1.0.0
•MySQL client version: 5.1.59
PHP version 5.3.14

21 Feb 2013, 03:56

#2

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,506
Plugin Contributions:: 173

Re: Data base merging

What specific reason prevents you from simply restoring the backup and continuing with that, thus losing nothing?

21 Feb 2013, 11:05

#3

sparktronic

Zen Follower

Join Date:: Nov 2005
Posts:: 153
Plugin Contributions:: 0

Re: Data base merging

I wasn't sure I could do that being the old cart was 1.3.9h and the new is 1.5.1. The old cart database is named cat1 and the new is named rlaw_cartzen. That was the only reason. This will be the first time I am doing this also and am a little green when it come to data bases and MySQL.

21 Feb 2013, 11:42

#4

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,506
Plugin Contributions:: 173

Re: Data base merging

When changing from one server to another, one should always use the *same* version of Zen Cart.
Then if an upgrade is also desired, do that afterward. (Or do the upgrade beforehand).

Else you run into this exact symptom.

21 Feb 2013, 11:45

#5

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,506
Plugin Contributions:: 173

Re: Data base merging

So:
1. Install v1.3.9 to "someplace".
2. Restore your 1.3.9 data to that "someplace"'s database.
3. Test that it can show the store.
4. Install v1.5.1 to that same "someplace"
5. Run zc_install and choose "database upgrade"
6. Test that it can show the store.

Now you'll have a v1.5.1 database ready to be used on your v1.5.1 site, and it will contain all the customer/etc data that you didn't want to lose, instead of the blank database you've got now.

23 Feb 2013, 04:45

#6

sparktronic

Zen Follower

Join Date:: Nov 2005
Posts:: 153
Plugin Contributions:: 0

Re: Data base merging

I read a thread that says 1.3.9 and higher are compatible with php 5.3 but what about php 5.5. My host just upgraded to 5.5.25 and now I get a blank page and these errors:
/var/www/vhosts/rochesterlaw.org/httpdocs/store/includes/classes/db/mysql/query_factory.php on line 406
[Wed Feb 20 21:37:46 2013] [error] [client 66.66.232.57] PHP Deprecated: Function ereg() is deprecated in /var/www/vhosts/rochesterlaw.org/httpdocs/store/includes/classes/db/mysql/query_factory.php on line 406
[Wed Feb 20 21:37:46 2013] [error] [client 66.66.232.57] PHP Fatal error: Cannot redeclare date_diff() in

23 Feb 2013, 05:01

#7

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,506
Plugin Contributions:: 173

Re: Data base merging

sparktronic:
I read a thread that says 1.3.9 and higher are compatible with php 5.3 but what about php 5.5. [B]My host just upgraded to 5.5.25[/B]

Impossible, since PHP 5.4.12 is the latest as of today, and PHP 5.5.0 Alpha5 is only in experimental stages: http://php.net/archive/2013.php
Maybe you're talking about MySQL instead?

sparktronic:

[Wed Feb 20 21:37:46 2013] [error] [client 66.66.232.57] PHP Deprecated: Function ereg() is deprecated in /var/www/vhosts/rochesterlaw.org/httpdocs/store/includes/classes/db/mysql/query_factory.php on line 406
[Wed Feb 20 21:37:46 2013] [error] [client 66.66.232.57] PHP Fatal error: Cannot redeclare date_diff() in

Those are EXACTLY the kinds of symptoms that v1.3.8a or older will exhibit when using PHP 5.2 or newer. And exactly why you now need to do an emergency upgrade.

23 Feb 2013, 05:27

#8

sparktronic

Zen Follower

Join Date:: Nov 2005
Posts:: 153
Plugin Contributions:: 0

Re: Data base merging

Sorry, I did a phpinfo check and it is showing me 5.3.14. I did get the cart to work by replacing the classes/db/msql/ files in that folder and the function/ folder in the main directory, but I am getting a HTTP 500 error when trying to go to my admin folder. ?

23 Feb 2013, 05:30

#9

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,506
Plugin Contributions:: 173

Re: Data base merging

sparktronic:
Sorry, I did a phpinfo check and it is showing me 5.3.14. I did get the cart to work by replacing the classes/db/msql/ files in that folder and the function/ folder in the main directory, but I am getting a HTTP 500 error when trying to go to my admin folder. ?

You said "by replacing the ... files".
With what?
Have you actually done an upgrade, or are you just blindly swapping random files out hoping that'll magically fix all the problems?

I'm not meaning to be rude. Sorry if I sound abrupt. But this is serious stuff.

23 Feb 2013, 05:39

#10

sparktronic

Zen Follower

Join Date:: Nov 2005
Posts:: 153
Plugin Contributions:: 0

Re: Data base merging

I have over written the files in the 1.3.9h with new 1.3.9h in the folders that my log says were depreciated. I did the same in the admin folder which was renamed to something else in original install. That started working to except when I go to look at the order I see my orders but when I go to a specific one it is blank.

23 Feb 2013, 06:38

#11

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,506
Plugin Contributions:: 173

Re: Data base merging

sparktronic:
but when I go to a specific one it is blank.

Look at the myDebug-xxxxxx.log files: http://www.zen-cart.com/content.php?124-blank-page