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

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: What is your favorite GUI tool for creating and querying tables in MySQL?

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?

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: Retaining last primary key value

://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]

OT: LAMP appliance for non-profit use

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

Best practices for deleting and restoring records - moving vs flagging

. 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

Re: Query Speed in Terminal vs. PHP

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 multiple tables

Re: Database-design

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 fields of the

Re: Lost Password

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 user id

Re: phpmyadmin screw up

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 was trying to use

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

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 that mysql is in fact relational

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

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 --- XHTML/HTML

corrupted passwd

-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.mysql.com/[EMAIL