database size

Hi, I would like to ask about the size that can be handled by mysql. How big if I use innoDB? How big with myISAM? __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

Re: database size

Eko Budiharto wrote: Hi, I would like to ask about the size that can be handled by mysql. How big if I use innoDB? How big with myISAM? Quoting from the manual 65536 terabytes http://dev.mysql.com/doc/refman/5.0/en/table-size.html Try 5 minutes of searching the manual next

Access denied

Hi ALL I am faced with a issue of creating database , The issue is I am able to enter to the MySQL Server with the password, but when i try to create database I get Access Denied Below are the details [EMAIL PROTECTED] root]# mysql -u root -p Enter password: Welcome to the MySQL monitor.

Re: Access denied

Hi, Please check the data directory where u have started your mysql has permission ( mysql:mysql ) U would have started your ur mysql ar root user and when u create a database which has no permission as (mysql) in data directory. This might help you out. Kaushal Shriyan wrote: Hi ALL I am

Re: Access denied

On 6/9/06, Dilipkumar [EMAIL PROTECTED] wrote: Hi, Please check the data directory where u have started your mysql has permission ( mysql:mysql ) U would have started your ur mysql ar root user and when u create a database which has no permission as (mysql) in data directory. This might help

Fwd: help for setting mysql server

Craven K. LepotaSchool of ComputingUniversity of South Africa[EMAIL PROTECTED](012) 429-6653 --- This message (and attachments) is subject to restrictions and a disclaimer. Please refer to

How to backup and restore

Hello, This is my first message, I'm an absolute beginner in Mysql. I did a defaul t installation of version 3.23.58 on RH Linux AS3.0. I want to be a able to do a backup and a restore. The user's manual says: 5.9.2.1 Backup Policy The following command makes a full backup . . : mysqldump

Re: How to backup and restore

Ben Burford wrote: Hello, Do I need to delete the table 'Indian'?? Try --add_drop-table option man mysqldump -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: How to backup and restore

Hi Eugene, Good to hear from you. Should I use this on the creation or the restore? A s in: mysqldump --verbose --add_drop-table --all-databases backup_06082006.sql or mysql --add_drop-table backup_06082006.sql or maybe mysql --add_drop-table backup_06082006.sql or maybe something

Re: Question on full text search scores, different content same score

Mark Steudel wrote: I was doing a full text search and had a question on why two different entries got the same score: Here is my select statement SELECT id, pubyear, MATCH ( title ) AGAINST ( 'Nursing home federal requirements, guidelines to surveyors, and survey protocols (MLM)' ) AS

Re: OR isn't optimised

Hi again Taras - Clearly, I was off the mark - sorry! What if you remove the straight_join specification and let MySQL's JOIN optimizer do its own thing? Dan Taras D wrote: Sorry everyone, forgot to put in my setup detail! SQL version: 5.0.22-community-nt Windows 2000 Professional 5.0,

Re: Access denied

Kaushal Shriyan schrieb: Hi ALL I am faced with a issue of creating database , The issue is I am able to enter to the MySQL Server with the password, but when i try to create database I get Access Denied Below are the details [EMAIL PROTECTED] root]# mysql -u root -p Enter password: Welcome

Re: How to backup and restore

On 6/9/06, Ben Burford [EMAIL PROTECTED] wrote: Hello, This is my first message, I'm an absolute beginner in Mysql. I did a defaul t installation of version 3.23.58 on RH Linux AS3.0. I want to be a able to do a backup and a restore. The user's manual says: 5.9.2.1 Backup Policy The

Re: How to backup and restore

mysqldump --verbose --add_drop-table --all-databases backup_06082006.sql or mysql --add_drop-table backup_06082006.sql or maybe mysql --add_drop-table backup_06082006.sql mysqldump --opt... This will add DROP TABLE .. IF EXISTS to a dump. -- MySQL General Mailing List For list

Re: How To Pronounce MySQL

On Thursday 08 June 2006 05:30 am, Jesse wrote: This may be a really stupid question, but I hate looking stupid if I can avoid it. :-) I have been using Microsoft SQL Server for a while, and I'm now trying to switch all our applications over to use MySQL. Microsoft SQL Server is pronounced

Re: Importing 3Gb File

Hi Ian, I am trying to import a 3.2Gb sql dump file back into my sql server (4.1.12) and im coming across the following error: mysql: Out of memory (Needed 178723240 bytes) mysql: Out of memory (Needed 178719144 bytes) That error message comes from some single place trying to allocate 178MB

Re: How To Pronounce MySQL

On Fri, 9 Jun 2006, Chris White wrote: On Thursday 08 June 2006 05:30 am, Jesse wrote: This may be a really stupid question, but I hate looking stupid if I can avoid it. :-) I have been using Microsoft SQL Server for a while, and I'm now trying to switch all our applications over to use

Why would a SELECT COUNT(*)... WHERE... take way way longer than SELECT COUNT(primary_key)... WHERE... ?

Hi everybody, MySQL 5.0.21 running on RedHat EL4, 2GHz CPU, 2,5GB RAM, RAID5/128MB RAM. At one point I had to issue the following query on a 1.8GB 42mil records table: SELECT COUNT(*) FROM geoRecord WHERE geoRecord.geolatitude IS NOT NULL ; As it took forever to complete (I mean more than

Re: How To Pronounce MySQL

On 6/9/06, Duane Hill [EMAIL PROTECTED] wrote: On Fri, 9 Jun 2006, Chris White wrote: On Thursday 08 June 2006 05:30 am, Jesse wrote: This may be a really stupid question, but I hate looking stupid if I can avoid it. :-) I have been using Microsoft SQL Server for a while, and I'm now

Re: How To Pronounce MySQL

On Friday 09 June 2006 09:56 am, Daniel da Veiga wrote: 1) The person will not understand you (and you'll look like an idiot) Find a different person 2) The person will infer what you mean even you saying it wrong (and you'll look even more like an idiot) That's what clubs/bats/spoons are

Re: Importing 3Gb File

At 10:20 AM 6/8/2006, you wrote: Hi, I am trying to import a 3.2Gb sql dump file back into my sql server (4.1.12) and im coming across the following error: mysql: Out of memory (Needed 178723240 bytes) mysql: Out of memory (Needed 178719144 bytes) That error comes up after about 30 minutes

RE: Importing 3Gb File

At 10:20 AM 6/8/2006, you wrote: Hi, I am trying to import a 3.2Gb sql dump file back into my sql server (4.1.12) and im coming across the following error: mysql: Out of memory (Needed 178723240 bytes) mysql: Out of memory (Needed 178719144 bytes) That error comes up after about 30

RE: How To Pronounce MySQL

Um, did anyone actually answer Jesse's question? -Original Message- From: Daniel da Veiga [mailto:[EMAIL PROTECTED] Sent: Friday, June 09, 2006 12:57 PM To: mysql@lists.mysql.com Subject: Re: How To Pronounce MySQL On 6/9/06, Duane Hill [EMAIL PROTECTED] wrote: On Fri, 9 Jun 2006,

Re: How To Pronounce MySQL

On Friday 09 June 2006 11:27 am, Samuel C Flores wrote: Um, did anyone actually answer Jesse's question? Um, did you read the all the threads? If you'll notice the first message by Jimmy Guerrero pretty much answers it, all he did was quote the MySQL site. -- Chris White PHP

Two approaches, which one is better ?

Hello, I am facing some problems to identify the advantages or disadvantages of the use of INDEXes (a.k.a. VIEWS in other DBMS environments, please correct me if am wrong), this is the scenario: I have a logging system that retrieves the username and password to grant access to the user, this

RE: Two approaches, which one is better ?

[snip] I am facing some problems to identify the advantages or disadvantages of the use of INDEXes (a.k.a. VIEWS in other DBMS environments, please correct me if am wrong), this is the scenario: [/snip] index != view AFAIK An index on a column or columns is a method for the database to keep

Books on MySQL 5

As always, thanks ahead of time for all responses. The company I work for is currently looking at getting literature on MySQL 5, more specifically, what's different in new MySQL features from the SQL standard. By this I mean things such as Stored Procedures, Foreign Keys, and anything else I

.TMD files

Hello, Can someone point me to the docs that explain what the .TMD files are? We are using MySQL 5.0.22 under RH FC3. We have a massive table of the size ~100Gb. It already has a couple of indexes. We are adding a new index on the first 8 character of a column: alter table CAT add index(des(8))

RE: Books on MySQL 5

Hello, You might want to check out Guy Harrison's book on SP's. http://www.amazon.com/gp/product/0596100892/102-8915813-3282553?v=glancen=2 83155 Thanks, Jimmy Guerrero Sr Product Manager MySQL, Inc -Original Message- From: Chris White [mailto:[EMAIL PROTECTED] Sent: Friday,

Re: How To Pronounce MySQL

the real pronuntiatios is.. MAIESEKUELE spanish, spanish... the rest is a dream... when I start up the system, it say... wellcome.. I'm the best...my name is MAIESEKUELE and I'm free oh yea... I want to f... me to MS SQLServer.. ohhh yeh Melvin Zamora escribió: Or you

Re: How To Pronounce MySQL

Somebody needs to lay off the drugs. LOL Gabriel Mahiques wrote: the real pronuntiatios is.. MAIESEKUELE spanish, spanish... the rest is a dream... when I start up the system, it say... wellcome.. I'm the best...my name is MAIESEKUELE and I'm free oh yea... I want to f... me to

Question about full text score

Apologize if this is a dup message: I was doing a full text search and had a question on why two different entries got the same score: Here is my select statement SELECT id, pubyear, MATCH ( title ) AGAINST ( 'Nursing home federal requirements, guidelines to surveyors, and survey protocols

Stored Procedures and DECLARE weirdness

Hello all and thanks again for any responses. I'm hoping this is something really basic I'm not seeing. I have MySQL 5.0.22-log, and I'm having a weird time creating a basic stored procedure. I get this far: mysql CREATE PROCEDURE getRootId (IN company_id INT) - BEGIN - DECLARE

Re: Stored Procedures and DECLARE weirdness

Hello all and thanks again for any responses. I'm hoping this is something really basic I'm not seeing. I have MySQL 5.0.22-log, and I'm having a weird time creating a basic stored procedure. I get this far: mysql CREATE PROCEDURE getRootId (IN company_id INT) - BEGIN - DECLARE

Re: Stored Procedures and DECLARE weirdness

On Friday 09 June 2006 02:31 pm, Paul DuBois wrote: When you use the mysql client, you must redefine the statement delimiter during definition of a stored routine (or trigger or event) that uses compound statement syntax with multiple statements making up the body of the routine. See the

Re: Two approaches, which one is better ?

Thanks I overlooked the topic about VIEWS on the MySQL manual, your response was very useful. Thank you again for your time and response. On 6/9/06, Jay Blanchard [EMAIL PROTECTED] wrote: [snip] I am facing some problems to identify the advantages or disadvantages of the use of INDEXes

Re: Books on MySQL 5

Well I have the book you mentioned below - it is VERY good IMHO. Goes into alot of detail on how to design tables the right way. Covers normalisation and optimisation techniques for the server itself. These guys really know what they are talking about. I also have Beginning PHP MySQL 5, by

RE: Question on full text search scores, different content same score

Is there a way to escape the parenthesis? -Original Message- From: Gerald L. Clark [mailto:[EMAIL PROTECTED] Sent: Friday, June 09, 2006 6:18 AM To: Mark Steudel Cc: mysql@lists.mysql.com Subject: Re: Question on full text search scores, different content same score Mark Steudel wrote: