Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2016
    Location
    London
    Posts
    258
    Plugin Contributions
    0

    Default How do I install the sql from my old site to my new one?

    How do I install the sql from my old site to my new one?

    I did this in a terminal
    bash-5.0$ mysql -u root -p zencart < sqllocal.sql
    Enter password:

    entered password and it appeared to accept it but the store has not changed.

    Is there another way to enter the sql?

  2. #2
    Join Date
    Jan 2004
    Posts
    66,373
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: How do I install the sql from my old site to my new one?

    Assuming your sqllocal.sql actually contains a proper export of the so-called "old" database, chances are the data *is* indeed now in the "new" database. If it's not "recognized" then perhaps your "old" and "new" use different table-prefixes (see DB_PREFIX in each site's /includes/configure.php file), so Zen Cart doesn't know anything about the data you just added because it's still looking at the other set of tables in the database.

    The online documentation has several articles about taking backups, using phpMyAdmin, upgrading sites, importing data, checking prefixes, troubleshooting when data doesn't show, etc. https://docs.zen-cart.com
    .

    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.

 

 

Similar Threads

  1. v139h deleting old site and building new one
    By abctech123 in forum Upgrading to 1.5.x
    Replies: 3
    Last Post: 2 Apr 2018, 12:36 PM
  2. v151 htaccess redirect from old subdirectory site to new subdomain site
    By Millie63 in forum General Questions
    Replies: 5
    Last Post: 29 May 2014, 10:31 PM
  3. v138a how to move db from old version to new one.
    By tony_sar in forum General Questions
    Replies: 4
    Last Post: 3 Jan 2014, 08:53 PM
  4. Copying background from old site to new one
    By clay2299 in forum Templates, Stylesheets, Page Layout
    Replies: 4
    Last Post: 30 Jul 2010, 12:48 AM
  5. Replies: 7
    Last Post: 13 Nov 2009, 08:09 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