Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2008
    Posts
    49
    Plugin Contributions
    0

    Default MySQL Database question

    i have my current active shop running 3.8 but i have recently joined up with a new provider and i have set up the latest ZC on that.
    i have customised it and added products ready for the re-launch but my question is how do i bring over my orders, order history and all customer details without undoing all of my hard work?

    i know i can upload the old db and do the db upgrade but wont that wipe what i have already done as i dont need all of the settings and info

    thanks :)

  2. #2
    Join Date
    Aug 2005
    Location
    Arizona
    Posts
    27,755
    Plugin Contributions
    9

    Default Re: MySQL Database question

    Depending upon what you have "customised" -
    If you have installed modules etc...
    Reserve the configuration table from your new setup
    Do the import of your old DB and upgrade
    Then replace the configuration table

    Also if any addon creates new tables or alters current tables you will want to reserve them also for replacement/insertion
    Zen-Venom Get Bitten

 

 

Similar Threads

  1. MySQL database question
    By blakdeth77 in forum Basic Configuration
    Replies: 2
    Last Post: 4 Mar 2009, 05:54 PM
  2. HELP NEEDED - MySQL DATABASE QUESTION
    By sgallasch in forum Installing on a Linux/Unix Server
    Replies: 3
    Last Post: 12 Dec 2008, 02:51 PM
  3. Dreaded mYSQL 1064 error when importing MySQL 4 database into MySQL5
    By dml311071 in forum Installing on a Linux/Unix Server
    Replies: 4
    Last Post: 10 Jun 2008, 05:38 AM
  4. find/replace (sub)strings in zen's mysql-DB (mysql syntax question)
    By mypashop in forum Upgrading from 1.3.x to 1.3.9
    Replies: 2
    Last Post: 19 Oct 2007, 02:21 PM
  5. Database - mySQL index question
    By kzutter in forum General Questions
    Replies: 1
    Last Post: 3 Mar 2007, 06:26 PM

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