Results 1 to 3 of 3

Threaded View

  1. #2
    Join Date
    Jan 2004
    Posts
    66,419
    Blog Entries
    7
    Plugin Contributions
    81

    Default Re: MySQL database question

    Quote Originally Posted by blakdeth77 View Post
    Is entering a statement to the Install SQL Patches input field and running it going to damage my database? I was suggested this command by another user here and he was unsure if this command would delete the GroupID 0 and cause harm to the original functionality of the web site. Can anyone clue me in as to whether this would cause my site to undergo an "epic failure"?

    Code:
    DELETE FROM `configuration` WHERE `configuration_group_id` = 0;
    Be careful doing that. It might be wise to review which records a SELECT would return (instead of DELETE) and determine why there's a need to remove anything.

    The IMPORTANT question really is WHY are you doing this???????

    Regardless your approach ... BEFORE you EVER do any direct database manipulation, you should ALWAYS do a FULL database BACKUP!!!
    Last edited by DrByte; 4 Mar 2009 at 09:30 PM. Reason: corrected the response, as per Ajeh's input
    .

    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. MySQL Database question
    By silkvixen in forum General Questions
    Replies: 1
    Last Post: 5 Aug 2010, 09:25 PM
  2. HELP NEEDED - MySQL DATABASE QUESTION
    By sgallasch in forum Installing on a Linux/Unix Server
    Replies: 3
    Last Post: 12 Dec 2008, 02:51 PM
  3. Dreaded mYSQL 1064 error when importing MySQL 4 database into MySQL5
    By dml311071 in forum Installing on a Linux/Unix Server
    Replies: 4
    Last Post: 10 Jun 2008, 05:38 AM
  4. find/replace (sub)strings in zen's mysql-DB (mysql syntax question)
    By mypashop in forum Upgrading from 1.3.x to 1.3.9
    Replies: 2
    Last Post: 19 Oct 2007, 02:21 PM
  5. Database - mySQL index question
    By kzutter in forum General Questions
    Replies: 1
    Last Post: 3 Mar 2007, 06:26 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