Results 1 to 6 of 6
  1. #1
    Join Date
    Feb 2008
    Posts
    529
    Plugin Contributions
    0

    Default cleaning up database

    z.c 1.5.5a, many mods

    MY database originated in zc 1.3.7 I've upgraded/updated fairly regularly along the way. Some old, no longer used mods had uninstall scripts and if so I used those. Some did not. Some templates I've tried added things that lingered. I've tried to manually tidy up the db a few times via phpMyAdmin. Screwed up a few times but always backed up first ;o)

    I've been building a new file set, reinstalling all the mods I continue to use, and I want to do a good cleaning on my db as well. The db still works and I've been able to identify and correct the few instances where a lingering old mod mucked up a new mod.

    I've recently installed and played with Easy Populate 4.0.35 on my test site and have more or less got the hang of it.

    I have a few hundred products, not thousands. I plan to alter my categoies a little to facilitate better filtering.

    Am I better to start with a clean db and import my categories and products, or should I keep old database and continue tidy up work ongoing?

  2. #2
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    12,401
    Plugin Contributions
    87

    Default Re: cleaning up database

    Personally, I'd go down the path of tidying up the old database (making regular backups after each clean-up action).

    @swguy created a plugin earlier this year (its name escapes me at this time) that inspects your database and identifies plugins that are configured. That might help.

  3. #3
    Join Date
    Jan 2004
    Posts
    66,364
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: cleaning up database

    Quote Originally Posted by soxophoneplayer View Post
    Am I better to start with a clean db and import my categories and products
    Given that most people break their stores when they try to do that, I recommend doing minor cleanups as needed.

    IMO most likely any remaining cleanup is more of a "perceived need" than an "actual need".
    .

    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.

  4. #4
    Join Date
    Jul 2012
    Posts
    16,719
    Plugin Contributions
    17

    Default Re: cleaning up database

    Quote Originally Posted by lat9 View Post
    Personally, I'd go down the path of tidying up the old database (making regular backups after each clean-up action).

    @swguy created a plugin earlier this year (its name escapes me at this time) that inspects your database and identifies plugins that are configured. That might help.
    Funny isn't it how the almost obvious name can be so easily forgotten (had to look it up myself): Mod List
    ZC Installation/Maintenance Support <- Site
    Contribution for contributions welcome...

  5. #5
    Join Date
    Nov 2005
    Location
    los angeles
    Posts
    2,669
    Plugin Contributions
    9

    Default Re: cleaning up database

    Quote Originally Posted by lat9 View Post
    Personally, I'd go down the path of tidying up the old database (making regular backups after each clean-up action).
    actually, i think it is a better idea to make a backup BEFORE each clean up action. that way if your cleanup causes an error, you can restore the backup as needed.

    good luck!
    author of square Webpay.
    mxWorks has premium plugins. donations: venmo or paypal accepted.
    premium consistent excellent support. available for hire.

  6. #6
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    12,401
    Plugin Contributions
    87

    Default Re: cleaning up database

    Quote Originally Posted by carlwhat View Post
    actually, i think it is a better idea to make a backup BEFORE each clean up action. that way if your cleanup causes an error, you can restore the backup as needed.

    good luck!
    FWIW, I'd assumed (yeah, I know the words that that breaks into!) that the OP had a pre-change backup so that making one after each backup makes it so you don't have to "remember" whether/not you'd made one.

 

 

Similar Threads

  1. Cleaning up
    By Rob905 in forum Templates, Stylesheets, Page Layout
    Replies: 8
    Last Post: 12 Jan 2009, 01:43 PM
  2. Cleaning Customer Database
    By marcopolo in forum Managing Customers and Orders
    Replies: 3
    Last Post: 4 Dec 2008, 03:20 PM
  3. Data cleaning
    By glennnz in forum All Other Contributions/Addons
    Replies: 0
    Last Post: 25 Aug 2008, 03:04 AM
  4. Cleaning up my CSS...
    By Alex Clarke in forum Templates, Stylesheets, Page Layout
    Replies: 2
    Last Post: 28 Sep 2006, 12:01 PM
  5. Cleaning up ne install.
    By daveky in forum Setting Up Categories, Products, Attributes
    Replies: 5
    Last Post: 6 Aug 2006, 02:50 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