Thread: Import Database

Results 1 to 10 of 13

Hybrid View

  1. #1
    Join Date
    Sep 2005
    Posts
    912
    Plugin Contributions
    1

    Default Import Database

    Can i install a fresh install of 1.50 and then import portions of my database including orders and customers from a 1.39 install?

  2. #2
    Join Date
    Jul 2007
    Posts
    2,169
    Plugin Contributions
    16

    Default Re: Import Database

    Quote Originally Posted by CnTGifts View Post
    Can i install a fresh install of 1.50 and then import portions of my database including orders and customers from a 1.39 install?
    Short answer, Yes you can. I did it that way for a client of mine that was running zen cart 1.3.8.
    Last edited by countrycharm; 5 Apr 2012 at 10:45 PM.
    Is your site Upgraded to the current version 1.5.4 Yet?
    zencart-upgrades-website-installation

  3. #3
    Join Date
    Sep 2005
    Posts
    912
    Plugin Contributions
    1

    Default Re: Import Database

    whats the easiest way to go about it?

  4. #4
    Join Date
    Jul 2007
    Posts
    2,169
    Plugin Contributions
    16

    Default Re: Import Database

    Quote Originally Posted by CnTGifts View Post
    whats the easiest way to go about it?
    You go to your v1.3.9 phpMyAdmin database, go to export and export the tables you want to import your zen cart v1.5.0 database. It's not a hard process unless you don't know anything about phpMyAdmin. If you don't know in that case you would hire someone to help you.
    Is your site Upgraded to the current version 1.5.4 Yet?
    zencart-upgrades-website-installation

  5. #5
    Join Date
    Jan 2004
    Posts
    66,446
    Plugin Contributions
    81

    Default Re: Import Database

    NO NO NO NO NO!!!!!!!!!!!!!!!!!!!!!

    If you do that then you will have database tables that have different structures than what the PHP code expects, and will thus run into errors, and then you'll be back here asking for support on how to fix probably the hardest problem to ever sort out.

    Do a COMPLETE backup, and import the COMPLETE database, and upgrade the COMPLETE database using zc_install. That's the smartest, safest, and official way to do an upgrade.

    Clearly if you need to ask the questions you're asking then your knowledge isn't strong enough to handle all the zillion issues that will arise if you cheat in the process. Sorry if you find that statement offensive, but it's a fact, and if you bust everything by doing it the wrong way then it's going to cost you big bucks to get an expert to clean it all up for you.

    There's NO NEED WHATSOEVER to take the shortcuts you're suggesting in your first post. Take the COMPLETE database forward to your new site.

    If you don't understand why I'm saying that, then clearly you absolutely need to NOT take the shortcuts you're talking about.
    .

    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.

  6. #6
    Join Date
    Jul 2007
    Posts
    2,169
    Plugin Contributions
    16

    Default Re: Import Database

    Quote Originally Posted by DrByte View Post
    NO NO NO NO NO!!!!!!!!!!!!!!!!!!!!!

    If you do that then you will have database tables that have different structures than what the PHP code expects, and will thus run into errors, and then you'll be back here asking for support on how to fix probably the hardest problem to ever sort out.

    Do a COMPLETE backup, and import the COMPLETE database, and upgrade the COMPLETE database using zc_install. That's the smartest, safest, and official way to do an upgrade.

    Clearly if you need to ask the questions you're asking then your knowledge isn't strong enough to handle all the zillion issues that will arise if you cheat in the process. Sorry if you find that statement offensive, but it's a fact, and if you bust everything by doing it the wrong way then it's going to cost you big bucks to get an expert to clean it all up for you.

    There's NO NEED WHATSOEVER to take the shortcuts you're suggesting in your first post. Take the COMPLETE database forward to your new site.

    If you don't understand why I'm saying that, then clearly you absolutely need to NOT take the shortcuts you're talking about.
    DrByte I will agree with you that doing a complete backup of your old database is the best way to go about doing things and then using the zc_install, but in some cases that's not completely necessary. Smarter yes but not completely necessary on a fresh install of zen cart v1.5.0. And example would be when you start from scratch and wanting to import your orders and customers from your tables in your old database. That's my 2 cents worth.
    Is your site Upgraded to the current version 1.5.4 Yet?
    zencart-upgrades-website-installation

 

 

Similar Threads

  1. Database Import
    By jballotti in forum Installing on a Linux/Unix Server
    Replies: 2
    Last Post: 4 Sep 2009, 08:08 AM
  2. Import Database ERROR
    By carol in forum Upgrading from 1.3.x to 1.3.9
    Replies: 4
    Last Post: 21 Oct 2007, 11:21 PM
  3. Database import problems
    By Jaden in forum Upgrading from 1.3.x to 1.3.9
    Replies: 8
    Last Post: 24 Jan 2007, 07:32 AM

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