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

    Default Re: Having problems transferring MySql

    It's relatively straightforward, but great care needs to be taken in phpMyAdmin... mistakes are not forgiven...

    First step is to create a new MySQL database in your C-Panel admin area.

    I trust you know how to do this? Most C-Panel interfaces have a video tutorial for this.

    Even so, you can create a NEW database - call it " zentwo " if you like... it does not matter what you call it.

    Then ASSIGN the current USER to that new database, and give the user all privileges.

    ...

    Now you have a NEW, (but empty) database, called zentwo . It will have a USER with all privileges.

    --------------------------------

    Now, go back to C-Panel MAIN SCREEN, scroll down to database management icons and click phpMyAdmin.

    When you get to phpMyAdmin main screen it will load a LEFT MENU and a RIGHT FRAME.

    In the LEFT MENU you will see all current databases, of which the following should be there:

    youraccount_zc1
    youraccount_zentwo

    (where "youraccount" is your host account prefix)

    Click on the original database --- zc1 database to open it. The screen will refresh and show the tables down the left column and the structure in the right frame.

    At the TOP of the right frame is a menu. Click the OPERATIONS link.

    You will see this:
    Click image for larger version. 

Name:	dbasecopy.jpg 
Views:	121 
Size:	47.1 KB 
ID:	11968

    When you have filled in as shown, click GO.

    A new (identical) database will be create inside "zentwo ".

    NOW, you copy your FILES to a sub folder.

    You then edit the CONFIGURE.PHP FILES to point the copied system to the NEW database !!! (This is very important).
    19 years a Zencart User

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

    Default Re: Having problems transferring MySql

    I'll check right into that...Thank you!

  3. #13
    Join Date
    Jun 2009
    Posts
    275
    Plugin Contributions
    0

    Default Re: Having problems transferring MySql

    Okay, I follow everything up until "NOW, you copy your FILES to a sub folder." Which files do I copy to a sub folder? Where does the sub folder go? Thanks!

  4. #14
    Join Date
    Jun 2005
    Location
    Cumbria, UK
    Posts
    10,262
    Plugin Contributions
    3

    Default Re: Having problems transferring MySql

    OK... so you have a DUPLICATE DATABASE (with a different name - but it is an identical COPY of your original database).

    Now, you need to make a DUPLICATE of all the zencart FILES.

    (You do not perform an upgrade on a LIVE SITE... you need a full COPY of the site, and the upgrade is done on the COPY).

    If you wait a few minutes, I will post some diagrams.
    19 years a Zencart User

  5. #15
    Join Date
    Jun 2005
    Location
    Cumbria, UK
    Posts
    10,262
    Plugin Contributions
    3

    Default Re: Having problems transferring MySql

    Your MAIN ROOT FOLDER will look like this:

    Click image for larger version. 

Name:	upgr1.jpg 
Views:	113 
Size:	18.2 KB 
ID:	11969

    Create a NEW FOLDER - mine is called zen_upgrade.

    Click image for larger version. 

Name:	upgr2.jpg 
Views:	135 
Size:	20.4 KB 
ID:	11970

    COPY all your zencart files and folders INTO this zen_upgrade folder. You now have a COPY of your files in a sub-folder called zen_upgrade.

    Click image for larger version. 

Name:	upgr3.jpg 
Views:	106 
Size:	49.6 KB 
ID:	11971

    NOW YOU NEED TO EDIT THE CONFIGURE.PHP FILES...

    The important areas are:

    define('DIR_WS_CATALOG', '/zen_upgrade/');
    define('DIR_WS_HTTPS_CATALOG', '/zen_upgrade/');

    and places like this:

    define('DIR_FS_CATALOG', '/home/youracct/public_html/zen_upgrade/');

    And the DATABASE SETTINGS

    // define our database connection
    define('DB_TYPE', 'mysql');
    define('DB_PREFIX', '');
    define('DB_CHARSET', 'utf8');
    define('DB_SERVER', 'localhost');
    define('DB_SERVER_USERNAME', 'youraccount_username');
    define('DB_SERVER_PASSWORD', '}&^*7867TYt');
    define('DB_DATABASE', 'youraccount_zentwo');



    In other words GET THE PATH RIGHT... TO THE DIFFERENT FOLDER...

    Wherever you need to place the PATH, make sure you put the new foldername in that path...
    19 years a Zencart User

  6. #16
    Join Date
    Jun 2009
    Posts
    275
    Plugin Contributions
    0

    Default Re: Having problems transferring MySql

    Okay! I have all that done but... I am still showing no products or customer/order records in the new store. I triple checked everything you told me...any idea? Thanks!!!

  7. #17
    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
    Okay! I have all that done but... I am still showing no products or customer/order records in the new store. I triple checked everything you told me...any idea? Thanks!!!
    You should be seeing two identical websites for:

    http://www.your-website.com

    and

    http://www.your-website.com/zen_upgrade

    If you are not seeing identical sites, you have not followed procedures correctly.
    19 years a Zencart User

  8. #18
    Join Date
    Jun 2009
    Posts
    275
    Plugin Contributions
    0

    Default Re: Having problems transferring MySql

    I have no doubt that I did something wrong I'm curious about something before I go ahead and try again. I have a store I built from scratch that has been basically finished minus the database. I changed the config files to point to my current/copied database. Should that have worked? When I did that my template switched back to default but I was able to change it back and everything looks the same but again no database...?

  9. #19
    Join Date
    Jun 2005
    Location
    Cumbria, UK
    Posts
    10,262
    Plugin Contributions
    3

    Default Re: Having problems transferring MySql

    I fear you are too "uncertain" of how the whole structure hangs together. You say you have "no database"... If this were the case, the site would simply not function at all.

    A working zencart store has:

    1. Code Files
    2. A MySQL Database

    The two work hand-in-glove . There might not be any CONTENT in a database, but there is still a database... Zencart will simply NOT FUNCTION if the files and an associated database are not fully linked to each other.

    ----------------------------------------------------------------------------

    Now...

    You wish to UPGRADE.

    To do this safely, the upgrade needs to happen on a COPY of the site.

    SO...

    You need a COPY OF ALL THE FILES
    You need a COPY OF THE DATABASE

    When you have these COPIES, you adjust the configure.php files of the COPIED VERSION to point the copy to the new database.

    You should NOT BE MAKING ADJUSTMENTS to the ORIGINAL SITE, so do not tinker with the ORIGINAL CONFIGURE.PHP FILES...

    You do not want to be touching that stuff...

    You work ONLY in the copied stuff.

    If you are not getting an identical site showing (in every respect) on your two URL paths, then perhaps it's time to call in some help.

    Whatever you do, do not tinker with the original site !
    19 years a Zencart User

  10. #20
    Join Date
    Jun 2009
    Posts
    275
    Plugin Contributions
    0

    Default Re: Having problems transferring MySql

    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.

    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.

    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.

    Thank you for your help and patience!

 

 
Page 2 of 3 FirstFirst 123 LastLast

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