Results 1 to 5 of 5
  1. #1
    Join Date
    Jul 2011
    Posts
    3
    Plugin Contributions
    0

    Default Database transfer - Local test site to live server

    Hi,
    I am using v1.3.8a because I'm using the Japanese language pack and have a test sever on my local machine, where I have inputted all my products and tested them to see how they look, after lots of adjustments, I would like to know how to move this data to a fresh install of Zen cart on my live server. If this is possible I would like to then have one install on my test sever and one on the live server, where I can then update the live server each time I make an edit. Can I export the whole database with all the customizations to the live server or even just the new products, keeping both the same. This would be handy to know as it takes forever to try things out on the live server with my slow internet connection.

    p.s. Thanks to you all for your knowledge inputs, you have helped me so much, so far, keep up the good work, I hope I can do the same back.

  2. #2
    Join Date
    Jan 2010
    Location
    Australia
    Posts
    239
    Plugin Contributions
    1

    Default Re: Database transfer - Local test site to live server

    if you only want to transfer the products and categories with description easy populate will do this for you.

    If you want complete database changeover then depends wat you use. if you are using cPanel then you would be able to export complete sql from local and export to your live sql server..

  3. #3
    Join Date
    Jul 2011
    Posts
    3
    Plugin Contributions
    0

    Default Re: Database transfer - Local test site to live server

    Hi thanks for your answer. It's good to know that it's possible. If I change the whole database, do I need to update any files, e.g. configuration.php and also can I send the whole of my local setup to the live server without needing to run the setup on the live server. Thanks.

  4. #4
    Join Date
    Jan 2004
    Posts
    66,350
    Blog Entries
    7
    Plugin Contributions
    271

    Default Re: Database transfer - Local test site to live server

    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

  5. #5
    Join Date
    Jul 2011
    Posts
    3
    Plugin Contributions
    0

    Default Re: Database transfer - Local test site to live server

    Thanks for the great help, I feel a bit embarrassed that I could not find the answer myself, I did look though. Cheers that's made me happy, I'll give it a try.

 

 

Similar Threads

  1. v151 Losing customer info when moving database from test site to live site
    By FunkyPapa in forum General Questions
    Replies: 3
    Last Post: 7 Oct 2013, 01:11 PM
  2. Backing up site and installing local test server with MAMP
    By thebigkick in forum Installing on a Windows Server
    Replies: 2
    Last Post: 27 Jan 2012, 05:34 PM
  3. Update local copy and then transfer to live server
    By fawad123 in forum General Questions
    Replies: 9
    Last Post: 24 Apr 2010, 12:43 PM
  4. Error cloning live site on local server
    By ckosloff in forum Upgrading from 1.3.x to 1.3.9
    Replies: 5
    Last Post: 6 May 2008, 08:29 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