Results 1 to 4 of 4
  1. #1

    Default Losing customer info when moving database from test site to live site

    I've followed the tutorial for backing up (from test site) and restoring (to the live site) the database. However when I do this if there are any newly registered customers on the live site, it simply overwrites them. I've googled and poked around here on the forums, and can't find anything easily as to why it's doing this.

    The site has not been upgraded.
    As far as I can tell, everything else is fine.

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

    Default Re: Losing customer info when moving database from test site to live site

    Why are you doing this???

    Normally, the live site Db is applied to your test site during an upgrade once until you get things squared then one more time when you are ready to use the upgraded files - you place the live site down for maintenance & backup the DB apply it to your test site's DB and upgrade the DB only - then move & edit the files and you are done
    Zen-Venom Get Bitten

  3. #3
    Join Date
    Aug 2007
    Location
    Gijón, Asturias, Spain
    Posts
    2,566
    Plugin Contributions
    30

    Default Re: Losing customer info when moving database from test site to live site

    if there are any newly registered customers on the live site, it simply overwrites them
    Yes, that is what will happen. In this process you are not merging but overwriting the live database.
    If you are needing to modify your site database heavily maybe you could build the changes in sql and apply them to it quickly when its down for maintenance (after taking a backup obviously).
    Steve
    github.com/torvista: Spanish Language Pack, Google reCaptcha, Structured Data, Multiple Copy-Move-Delete, Image Checker, BackupMySQL Admin/Auto...

  4. #4

    Default Re: Losing customer info when moving database from test site to live site

    Thanks for the replies :)

 

 

Similar Threads

  1. Database transfer - Local test site to live server
    By Rob from Blossom in forum Setting Up Categories, Products, Attributes
    Replies: 4
    Last Post: 21 Jul 2011, 05:38 AM
  2. Advice on moving test site live
    By daltonkost in forum Upgrading from 1.3.x to 1.3.9
    Replies: 2
    Last Post: 15 Sep 2010, 11:14 AM
  3. Publishing Changes from Test site to live site
    By MyGreyGoose in forum Installing on a Linux/Unix Server
    Replies: 7
    Last Post: 22 Jun 2007, 12:09 AM
  4. Updating 'live' site database from 'development' site
    By earthdoctor in forum General Questions
    Replies: 7
    Last Post: 13 Oct 2006, 01:09 AM

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