Results 1 to 8 of 8
  1. #1
    Join Date
    Nov 2009
    Location
    Maldives
    Posts
    22
    Plugin Contributions
    0

    Default I want to use old database with new install

    I am trying to install a fresh install of zen-cart v150. After installing, I want to change the new database to my old database which has lots of products and customers and other data. When I import the old database to the new one, I cant see the data in old database in the new site. I dont know much about databases but I can see the database tables prefixes different, for e.g. new database table has "xyz_admin" while the old database table has zen_admin". Could it be the problem the site not showing old data once old copy is imported.
    All I need is use the old database with the new install. Pls help.
    TRYING to TRY the TRUTH... http://www.hadhiyaa.com/shop

  2. #2
    Join Date
    Jan 2007
    Location
    Australia
    Posts
    6,167
    Plugin Contributions
    7

    Default Re: I want to use old database with new install

    Quote Originally Posted by geel View Post
    All I need is use the old database with the new install. Pls help.
    I'd advice against going the export/import route.

    When you have the new install all up and running you should be able to edit the two configure.php files to point to the *old* database, then just run the DB update scripts.

    As usual, make a backup of your database(s) before making any changes.

    Cheers
    Rod

  3. #3
    Join Date
    Nov 2009
    Location
    Maldives
    Posts
    22
    Plugin Contributions
    0

    Default Re: I want to use old database with new install

    thanks for the quick reply. I am trying as you suggested but I dont know how to run the database update script.
    TRYING to TRY the TRUTH... http://www.hadhiyaa.com/shop

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

    Default Re: I want to use old database with new install

    I dont know how to run the database update script
    Run zc_install and you should be presented with "update database only"
    Zen-Venom Get Bitten

  5. #5
    Join Date
    Nov 2009
    Location
    Maldives
    Posts
    22
    Plugin Contributions
    0

    Default Re: I want to use old database with new install

    thanks for the reply.
    I edited the configure file and then uploaded it. Now it seems the site is not connecting the database. Also, since I installed zencart through simple scripts, I cant see, run zen-cart option anywhere.
    TRYING to TRY the TRUTH... http://www.hadhiyaa.com/shop

  6. #6
    Join Date
    Jun 2005
    Location
    Cumbria, UK
    Posts
    10,262
    Plugin Contributions
    3

    Default Re: I want to use old database with new install

    Quote Originally Posted by geel View Post
    thanks for the reply.
    I edited the configure file and then uploaded it. Now it seems the site is not connecting the database. Also, since I installed zencart through simple scripts, I cant see, run zen-cart option anywhere.
    Using these "one-click install" processes is not advised. In your case the install will auto-create a dbase name, a dbase user and dbase user-password, and will append these to the configure.php files. (So at least you have a visible reference to what the auto-install has named these components.)

    If you are "not connecting to the database" it can only be a case of:

    1. The NAME of the database in the configure.php files is not correct.

    1. The USERNAME for the database in the configure.php files is not correct.

    1. The USERNAME-PASSWORD for the database in the configure.php files is not correct.

    If you have made a COPY of the database (with a different name) and are now trying to point the site to that new database, then the same "rules" apply.

    The USER in the database must also have ALL PERMISSIONS to administer the database. This is a stage in the C-PANEL database creation function, and cannot be missed.
    19 years a Zencart User

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

    Default Re: I want to use old database with new install

    Also, since I installed zencart through simple scripts, I cant see, run zen-cart option anywhere.
    Go to the home page here and download a fresh distribution of ZenCart 1.5.0
    Expand it on your PC and FTP the zc_install folder to your server
    Zen-Venom Get Bitten

  8. #8
    Join Date
    Jun 2005
    Location
    Cumbria, UK
    Posts
    10,262
    Plugin Contributions
    3

    Default Re: I want to use old database with new install

    Hey Geel... howcome you get to live in paradise (Maldives)?

    I am really envious of you !
    19 years a Zencart User

 

 

Similar Threads

  1. v151 Use current database with new install of ZC1.5.1
    By laurelsstitchery in forum General Questions
    Replies: 4
    Last Post: 22 Jan 2014, 02:10 PM
  2. v138a Trying to use old DB with fresh install
    By cheapmanuals in forum Upgrading to 1.5.x
    Replies: 4
    Last Post: 2 Jul 2012, 11:36 AM
  3. Replies: 3
    Last Post: 11 Mar 2011, 10:56 AM
  4. install zen cart with old database
    By chadkan in forum General Questions
    Replies: 2
    Last Post: 20 Oct 2009, 12:21 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