Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2007
    Posts
    151
    Plugin Contributions
    0

    help question Intact Database upgrade

    Is it possible if a database is intact to do a fresh install with the latest version if the older version is no longer accessible?

    Is it possible to connect two Zen Cart shopping carts to one database at the same time?

    Are any database files(orders, products info, etc.) accessible via FTP?
    http://www.SullivanVitamins.com

    America's Favorite Vitamin Source & Irish Shop

  2. #2
    Join Date
    Dec 2009
    Location
    Pinner
    Posts
    230
    Plugin Contributions
    1

    Default Re: Intact Database upgrade

    It depends very much on how much access you have to the server. MySQL stores the entire database under a folder normally in /var/lib/mysql and then you could physically do a straight copy if you have ftp access.

    Another way to do it it to install phpMyAdmin on the original server and use the export feature which would dump all of the data, and then install it on the new server and use the import feature.

    A lot of this is easier if you have "shell access" like SSH on both servers, then you can use mysqldump, it may be possible to do the following, create a PHP page on the original server and visit it with your browser:

    PHP Code:
    <?php

    exec
    ('mysqldump -uUSERNAME -pPASSWORD DATABASE-NAME > db_dump.txt');

    print 
    "finished";
    You get the db_dump file from the server via ftp (you may have to create it and give it write permissions for the program to work) then on the new server you do

    PHP Code:
    <?php

    exec
    ('mysql -uUSERNAME -pPASSWORD DATABASE-NAME < db_dump.txt');

    print 
    "finished";
    Notice that the Uppercase text is for you to enter, and that the direction of the arrows is important. It won't give you any feedback until the txt files are created but then I am guessing the database is quite large and you don't want to be displaying 80 megabytes of data into your web browser and crashing it ! It doesn't matter what you name the files but you should remove them afterwards.

    Oh and db_dump will be in the same folder where you put the file you visit with your web browser.

 

 

Similar Threads

  1. v154 Can't upgrade database doing upgrade from 1.5.1 to 1.5.4
    By blueskyhigh in forum Upgrading to 1.5.x
    Replies: 2
    Last Post: 2 Apr 2015, 01:38 PM
  2. Replies: 4
    Last Post: 5 Dec 2012, 01:45 AM
  3. Uh oh! Upgrade Keeps Only Database Intact
    By IronMac in forum Upgrading from 1.3.x to 1.3.9
    Replies: 5
    Last Post: 11 Oct 2008, 12:23 AM
  4. upgrade cfg files or database upgrade???
    By waghelak in forum Upgrading from 1.3.x to 1.3.9
    Replies: 2
    Last Post: 11 Sep 2006, 02:28 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