Best practices for deleting and restoring records - moving vs flagging

2005-08-11 Thread Saqib Ali
. However if we just flag the record as deleted the restoring is quite easy. Any thoughts/ideas ? -- In Peace, Saqib Ali http://www.xml-dev.com/blog/ Consensus is good, but informed dictatorship is better. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

OT: LAMP appliance for non-profit use

2006-12-07 Thread Saqib Ali
Hello All, I know this is little bit off-topic but I think users of this group can give good advice on this topic. We have a in-house built application using MySQL + PHP + Apache. It is essentially a elaborate collection of online forms that will be used for managing school scholarship in the 3r

Re: Retaining last primary key value

2006-12-08 Thread Saqib Ali
http://lists.mysql.com/[EMAIL PROTECTED] -- Saqib Ali, CISSP, ISSAP http://www.full-disk-encryption.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: What is your favorite GUI tool for creating and querying tables in MySQL?

2006-12-21 Thread Saqib Ali
sqlyog is pretty nice: http://www.webyog.com/ saqib http://www.full-disk-encryption.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: What is your favorite GUI tool for creating and querying tables in MySQL?

2006-12-21 Thread Saqib Ali
and also http://fabforce.net/dbdesigner4/ sorry for 2 seperate emails. saqib http://www.full-disk-encryption.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: What to do if a table is supposed to get > 3GB data per day?

2006-12-27 Thread Saqib Ali
wow 30GB is a lot of data. Do let us know what kind of hardware / OS you are using. In the past I have worked with larger tables then these, but I was using Objectivity DB running on UltraSPARC 64bit architecture. -- Saqib Ali, CISSP, ISSAP http://www.full-disk-encryption.net -- MySQL General

Re: Query Speed in Terminal vs. PHP

2004-03-02 Thread Saqib Ali
Is index defined on all of your tables? Saqib Ali - http://validate.sf.net < (X)HTML / DocBook Validator and Transformer On Tue, 2 Mar 2004, Chris Fowler wrote: > I have a query that is admittedly inefficient in that it is doing > multiple OR clauses and joining multip

corrupted passwd

2003-09-29 Thread Saqib Ali
-skip-grant-tables Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root! Any ideas? Saqib Ali - http://www.xml-dev.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.m

Re: Is MySQL Relational? (was: Foreigner keys in MySQL?)

2003-10-28 Thread Saqib Ali
a question... is any DB that complies to the "Relational Algebra" a "Relational DB"??? Saqib Ali - http://validate.sourceforge.net <--- XHTML/HTML/DocBook Validator On Tue, 28 Oct 2003 [EMAIL PROTECTED] wrote: > > I tend to agree with the past two posts tha

RE: Is MySQL Relational? (was: Foreigner keys in MySQL?)

2003-10-28 Thread Saqib Ali
so funtions that can be performed by relation algebra are a subset of the functions performed by a relational database? however isn't it required for a relational database to perform all the functions of relation algebra? Saqib Ali - http://validate.sourceforge.net <--- XH

Re: Lost Password

2003-11-04 Thread Saqib Ali
you can always reset the mysql root passwd http://www.mysql.com/doc/en/Resetting_permissions.html Saqib Ali - http://validate.sf.net <--- XHTML/HTML/DocBook Validator On Tue, 4 Nov 2003, Carol Andrejak wrote: > Hello Listers, > > I have a problem in that I cannot find my

Re: phpmyadmin screw up

2003-11-04 Thread Saqib Ali
seems like you set the mysql root passwd which is the right thing to do. now should connect as follows: # /usr/local/mysql/bin/mysql -u root -p Saqib Ali - http://validate.sf.net <--- XHTML/HTML/DocBook Validator On Tue, 4 Nov 2003, joffrey leevy wrote: > Hi all: > > I w

Re: Database-design

2003-11-11 Thread Saqib Ali
you need to normalize your database structure, and create an ER diagram based on that. On Tue, 11 Nov 2003, Meli Meli wrote: > > I have a table with following structure: > > Id > first quarter > second quarter > third quarter > last quarter > year > month > week > day > > On an entry not all fie