Hi Rachel,
I attended the week long training last year and I found it to be very
helpful. Even if you
know the basics this will cover some advanced material and also provide
better ways to
do the things you already know.
Bhavin.
- Original Message -
From: Rachel Rodriguez [EMAIL
First option, I don't think, is possible.
Reg. 2, You can get MAX(Id) before inserting, increment it by 1 in your
script and then Insert 'gcId' as the invoice_id value.
Bhavin.
- Original Message -
From: MySQL List [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, March 30, 2003 7:23
I don't think Validation is possible. Look up ENUM, which is very different,
but just might help you a little.
- Original Message -
From: warm-fusion [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, March 30, 2003 5:25 PM
Subject: Validations
Hi, I'm a newbie to MySQL, and I'm
Specify the location in my.conf or ...create a sym link in /tmp.
- Original Message -
From: Joseph Bannon [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, March 28, 2003 8:50 PM
Subject: mysql.sock
The mysql.sock file is being saved at the location
below
My mistake. my.cnf. It should be in /etc or /var/lib/mysql. If not, you can
create one.
- Original Message -
From: Joseph Bannon [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Friday, March 28, 2003 10:28 PM
Subject: Re: mysql.sock
Specify the location in my.conf or
restart the server with the --skip-grant-tables option and then add users.
- Original Message -
From: Anthon Tagor [EMAIL PROTECTED]
To: Bhavin Vyas [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Monday, March 24, 2003 11:31 PM
Subject: Re: ERROR 1130
Mr. Vyas
But sir, i cannot log
It is probably looking for a socket file that doesn't exist. Check to see if
it does. Also check to see if DB server is running.
Bhavin.
- Original Message -
From: Jose [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, March 15, 2003 3:03 PM
Subject: Warning: mysql_select_db()
In my.cnf you can configure the Data dir path. Else, symlinks might work.
- Original Message -
From: Anirudha Kukreti [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, February 23, 2003 11:36 PM
Subject: MyISAM Database on multiple partitons
hi,
i have MyISAM database on my root
Hi,
I have a table Log described as such:
+--+---+--+-+-+---+
| Field| Type | Null | Key | Default | Extra |
+--+---+--+-+-+---+
| rec | int(1)| YES | | NULL| |
| time | int(10) | |
Hi,
I have a table Log described as such:
+--+---+--+-+-+---+
| Field| Type | Null | Key | Default | Extra |
+--+---+--+-+-+---+
| rec | int(1)| YES | | NULL| |
| time | int(10) | |
Are you sure u have
journoNatOpt.journoid = ''
records?
select count(*) where journoNatOpt.journoid = ''
If not, maybe IS NULL instead of = ''
will help.
- Original Message -
From: David Phipps [EMAIL PROTECTED]
To: MySQL List [EMAIL PROTECTED]
Sent: Monday, February 03, 2003 8:46 AM
I think flush logs should do it.
http://www.mysql.com/doc/en/FLUSH.html
Bhavin.
- Original Message -
From: Matthias Trevarthan [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, January 30, 2003 2:31 PM
Subject: FreeBSD bin-log rotation script
Howdy list,
Does anyone have a
From postings at:
http://www.mysql.com/doc/en/example-AUTO_INCREMENT.html
ALTER TABLE tbl_name AUTO_INCREMENT = 1000
will start your records at 1000
Bhavin.
- Original Message -
From: Mike Doanh Tran [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, January 30, 2003 2:15 PM
Sounds weird. Can you e-mail us a 'mysqldump' of the table defination with
the data?
Thanks,
Bhavin.
- Original Message -
From: Thomas Kvamme [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, January 25, 2003 7:36 AM
Subject: How to speed things up in MySQL ?
Hello,
While
I think it's allowing 'root@localhost' but not '[EMAIL PROTECTED]'. Select *
from user (in mysql db) will show you all the access privileges. Add
'[EMAIL PROTECTED]' to that as a user.
Bhavin.
- Original Message -
From: Bob Lockie [EMAIL PROTECTED]
To: MySQL Mailing List [EMAIL PROTECTED]
You might have to tweak the following a bit for syntax:
SELECT a.name, COUNT(b.id) as votes FROM poll_options as a LEFT JOIN
poll_votes as b ON a.id=b.oid
WHERE b.pid='poll_id' GROUP BY b.oid
Also, you can refer to:
http://www.mysql.com/doc/en/JOIN.html
Bhavin.
- Original Message -
Hi Beogradjanin
As Paul mentioned yesterday, the final column defination does not require a
comma because it is the final defination.
Bhavin.
- Original Message -
From: Beogradjanin [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, January 06, 2003 7:38 PM
Subject: I'm new in Mysql
Hi Prathmesh,
What is the behaviour that you see when you try to LOAD DATA. Any messages?
Regards,
Bhavin.
- Original Message -
From: Prathmesh J. Mahidharia [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, January 06, 2003 11:22 PM
Subject: Load local data infile problem
hello
It might be a permissions problem. Mysql is trying to create a temporary
file to do the ALTER but cannot.
Check for the write permissions/ownership on the data directory.
Regard,
Bhavin.
- Original Message -
From: Nick Stuart [EMAIL PROTECTED]
To: MySQL [EMAIL PROTECTED]
Sent: Wednesday,
I don't think there is a way to do that. Unless some one says there is(and
tells us how to do it), I guess your only option is to write a script to do
that.
Regards,
Bhavin.
- Original Message -
From: Hakkan Lui [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, January 05, 2003 10:12
Check to see the existence/permissions of this file in the data directory.
Regards,
Bhavin.
- Original Message -
From: Jason Steig [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, January 01, 2003 11:43 PM
Subject: host.frm
./myqld: Can't find file : './mysql/host.frm'
You are missing the socket file. Make sure 'mysqld' is up.
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, December 26, 2002 9:57 AM
Subject: failing to connect to /tmp/mysql.sock
I am failing to connect to the mysql database, the error is failing to
I don't think there is since MySql is a db and not so much of a scripting
language. Perl or PHP have functions that could do something like that.
Regards,
Bhavin.
- Original Message -
From: Octavian Rasnita [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, December 26, 2002 5:44 AM
The indexes are probably corrupt, you will need to run 'myisamchk' on the
table.
- Original Message -
From: Jason Hall [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, December 03, 2002 3:04 PM
Subject: Problem doing Select * from table
I am using mysql 3.23.41
The tables are set
ps -wef | grep mysqld should show if the daemon is actually running or not.
Check to make sure. Then,
ls /tmp/mysql.sock
will show you if the mysql file was created or not.
Bhavin.
- Original Message -
From: Jeff Hollingshead [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, December
I am not sure where it my reside but a 'find' for mysqladmin might yeild
something.
Bhavin.
- Original Message -
From: Ken Morley [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, December 03, 2002 4:21 PM
Subject: Problems changing password following installation
I downloaded
Your 'root' password was probably not set hence, you didn't need a password.
Bhavin.
- Original Message -
From: Pikasz Gyorgy [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, October 17, 2002 7:46 AM
Subject: Connecting to mysql
I'm logged in to RedHat Linux as an user and I'd
I am guessing a default value of NULL should do it.
Bhavin.
- Original Message -
From: Chris Kay [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, December 01, 2002 4:54 PM
Subject: Calculation question
I have a few fields in a table that I need to calculate, yesterday I
find out
You can create separate databases (database directories) and then grant
privileges to users on table only within a specific database.
So if you have a separate database (create database name is the syntax to
create a new database), you can do that.
Bhavin.
- Original Message -
From:
possible table corruption. Run myisamchk on the table to check it and then,
if needed, repair it.
Bhavin.
- Original Message -
From: Amit Lonkar [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, November 22, 2002 10:52 PM
Subject: Table Handler Errors
Hi All!
I am using
Make sure that your mysql daemon is running, if not, start it. Also, make
sure the mysql.sock file is present in /var/lib/mysql.
Bhavin.
- Original Message -
From: Stick Dragon [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, November 10, 2002 3:44 PM
Subject: starting Mysql on linux
If this is the first time u r installing mysql, then,
rpm -i mysql.rpm.
If u r updating, then
rpm -u mysqlxxx.rpm should do it.
The binary install is more optimized and hence is the best way to install
mysql, however, rpm's work fine too.
Regards,
Bhavin.
- Original Message -
From:
bin-log in 'needed' for a server to act as a master. This will make the
server log all it's queries for the slave to follow. Don't know of a faster
way.
Regards,
Bhavin.
- Original Message -
From: Vicky Gonzalez [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, September 03, 2002
,
Bhavin.
- Original Message -
From: Vicky Gonzalez [EMAIL PROTECTED]
To: Bhavin Vyas [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Tuesday, September 03, 2002 6:16 PM
Subject: RE: changing a slave to a master in mysql replication
Bhavin Vyas wrote Tuesday, September 03, 2002 9:02 PM in response
You should be able to acheive all of that via a web interface using
PHP-MySql. It will only be a matter of designing the user interface
correctly (eg: check boxes for all categories a book can belong to).
Bhavin.
- Original Message -
From: David Powell (PeakCare QLD) [EMAIL PROTECTED]
Also, see what errors you are getting in mysql hostname.err file
Regards,
Bhavin.
- Original Message -
From: [EMAIL PROTECTED]
To: MySQL List [EMAIL PROTECTED]
Sent: Sunday, August 11, 2002 3:30 AM
Subject: Re: Mysql Problem Query
did you also install the databases that are part of
mysql.sock file doesn't exist in the /var/lib/mysql directory. Stop and
restart mysql server.
Regards,
Bhavin.
- Original Message -
From: samratsam [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, August 10, 2002 4:28 AM
Subject: ERROR 2002: Can't connect to local MySQL server
I am not very sure I understand the questionbut maybe column type 'enum'
is what you are looking for.
- Original Message -
From: david [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, August 10, 2002 9:43 PM
Subject: MySQL database design, one column, 10 entries?
I am
If it is saying that it cannot bind to port 3306, then maybe the port is
still locked by another process, mysqld or otherwise.
netstat -na | grep 3306 should show you that. Kill that process and try
again.
Regards,
Bhavin.
- Original Message -
From: Johannes Ullrich [EMAIL PROTECTED]
To:
If you have 'root' privileges to the server itself, then shutdown mysql and
restart it with --skip-grant-tables. This should allow you to log in as root
without being prompted for a password.
Regards,
Bhavin.
- Original Message -
From: Norris, Joseph [EMAIL PROTECTED]
To: 'Kevin
Yes, LOCAL is when client and server are on different boxes and the file is
LOCAL to the client. You don't need that keyword otherwise.
Regards,
Bhavin.
- Original Message -
From: David Sammons [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, August 08, 2002 10:20 AM
Subject: RE:
Are you using InnoDB type tables? The default table type is MyIsam which
does not support foreign keys.
Regards,
Bhavin.
- Original Message -
From: muad [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, August 03, 2002 5:52 AM
Subject: hey
hope its okey for me too ask you an
SELECT * from hwu_articles WHERE id = '$id' and price is not null and name
is not null and ratings is not null;
Bhavin.
- Original Message -
From: Alex Behrens [EMAIL PROTECTED]
To: MYSQL [EMAIL PROTECTED]
Sent: Friday, August 02, 2002 4:49 PM
Subject: help with a simple query..
Hi
Yes, Install mysql on a local box (same OS as your provider and preferably
the same MySql version), create and populate your tables and then FTP the
files that reside in the mysql data directory. There will be 3 files
associated with each table
.MYD (Data file)
.MYI (Index file)
.frm
Hello,
Is there a way to have DB-A and DB-B such that DB-A is the master and DB-B
is the slave. However, I also want to make DB-B the master and DB-A it's
slave so that if I have to fail over to DB-B then DB-A is automatically
following the changes. It doesn't seem probable that this is possible,
check for ur permissions and ownership on that file.
- Original Message -
From: Bob Lockie [EMAIL PROTECTED]
To: mysql mailing list [EMAIL PROTECTED]
Sent: Tuesday, July 30, 2002 7:49 PM
Subject: error running
I haven't used mysql yet.
How do I fix this error when starting it?
Andrew,
I assume that basedir and datadir are set to the *actual* paths specific to
your install and not 'the_install_path' and 'the _data_path'. If not, you
will need to set those.
Bhavin.
- Original Message -
From: Wheeler, Andrew [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday,
From what little I know of MySql on Windows, it runs as a service and you
can't run multiple services on the same Win Server.
Bhavin.
- Original Message -
From: Paul DuBois [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, July 25, 2002 9:35 AM
Subject: Do you run multiple servers
clarification: can't run multiple instances of the same service on Windows.
- Original Message -
From: Bhavin Vyas [EMAIL PROTECTED]
To: Paul DuBois [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, July 25, 2002 7:07 PM
Subject: Re: Do you run multiple servers on WIndows?
From what
Thanks Mike! Yes, the query is certainly using tmp tables for the longest of
times. I will try and implement the solution you provided and see how it
goes. If I do, I will update you with the results.
Regards,
Bhavin.
- Original Message -
From: mos [EMAIL PROTECTED]
To: Bhavin Vyas
Desmond,
A primary key is needed to maintain a unique identity of each record and
there by help in linking it to other records in other tables. However, we
have certain tables which link one table to another (needed because of
absence of foreign keys in mysql) which don't necessarily have primary
Check you users table under 'mysql' database. This is what controls access.
Here, check the 'hosts' column. Update the old IP/DSN to the new ones and
then do a 'flush privileges' and you should be fine.
If you don't want to update but add a new record that should be fine to.
Do a GRANT . for
Question is, can you connect via the mysql client. This looks like an
authentication issue as opposed to something specific to PHP.
Bhavin.
- Original Message -
From: Ingrid Kast Fuller [EMAIL PROTECTED]
To: chuck amadi [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Wednesday, July 24,
Hello,
I am running mysql in our production environment, which have a few reporting
tables with millions of rows. Certain queries cascade 2 such tables that
have millions of rows and there by, there are extremely slow, sometimes
taking over 10 minutes.
However, we are ok with that since the size
Another grant command for the existing privileges + index privs. should work
Bhavin.
- Original Message -
From: Paul Maine [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, July 24, 2002 5:33 PM
Subject: RE: Grant question
I have an existing mysql user that I wish to add the
create table abc as (select * from xyz1);
insert into abc values (select * from xyz2);
The above 2 commands should do it.
You might need to change them a bit, if so
www.mysql.com/doc should be very helpful.
Regards,
Bhavin.
- Original Message -
From: Ollie Acheson [EMAIL PROTECTED]
To:
yes.
You will need to install a mysql client on your box though.
Then, look up how to grant access to yourself from that server, here:
http://www.mysql.com/doc/G/R/GRANT.html
finally, you will connect as such:
...path/mysql -h remotehostname -u user -ppassword
Bhavin.
- Original Message
I did a select * as such:
mysql select * from Sqs;
+-+-++
| RecordState | Sqs | SqsKey |
+-+-++
| L | unknown | 1 |
+-+-++
1 row in set (0.00 sec)
Then, look at the message that delete from
If you are on the same OS and rsync happens fine, then you should not loose
any data. A more graceful way might be too look into setting up a slave
server which will be in sync with the master.
Regards,
Bhavin.
- Original Message -
From: Charitha [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
How about:
SELECT
event_id, time,
count(DISTINCT time) AS Ranges
FROM
events
GROUP BY
event_id HAVING Ranges 1
- Original Message -
From: Mihail Manolov [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, July 11, 2002 2:58 PM
Subject: Help - query
running the script 'safe_mysqld ' should start the server.
- Original Message -
From: Alex Jarvis [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, July 10, 2002 3:21 PM
Subject: can't connect
So, I had mysql up and running a week ago, but at some point the
system on which it
You might have your socket files in /var/lib/mysql/. Search for the socket
file and create a symlink in the /tmp directory as such:
ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock
Regards,
Bhavin.
- Original Message -
From: Bas Mooyman [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent:
You will need to create my.cnf and turn ON the loggin option.
Bhavin.
- Original Message -
From: Jorge Ceballos [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, July 04, 2002 12:30 PM
Subject: Audit - Log
Hi,
After reading about the audit log
If 'text' is stored in the HTML format in the db, the only solution I can
think of is writing a perl/shell script to parse out the br and recreate
the files without it, that ways, the data in the DB is not disturbed and
Excel should be able to read it to (unless someone knows of a setting in
You can use the InnoDB table type which supports foreign keys.
http://www.mysql.com/doc/S/E/SEC446.html
If you want to use MyIsam table types, the only solution is to send a
specific request to delete records in both the tables.
Regards,
Bhavin.
- Original Message -
From: multivac [EMAIL
Mysql list serve manager,
Could this be a bug in the mysql listserv. Tedd Richards tried to
unsubscribe and I am getting the confirmation e-mail to confirm that I
really want to un-subscribe, when, I haven't emailed an unsubscribe request
in the frist place.
- Original Message -
From:
The default at table creation is 4GB. You can change the default vaule via
an ALTER TABLE. You will need to alter AVG_ROW_LENGTH and MAX_ROWS.
MAX_DATA_LENGTH is the product of the two.
http://www.mysql.com/doc/T/a/Table_size.html
Regards,
Bhavin.
- Original Message -
From: Henry Hank
you will need to give it the password flag and then type in the password
when prompted for one.
mysql -u hasv -p
Regards,
Bhavin.
- Original Message -
From: Hugo Veiga [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, June 30, 2002 9:54 AM
Subject: need you expertise
Hi again,
Are u doing a user@hostname or user@%? The hostname part is needed, % means
from anywhere. A better way to write this to prevent any errors is enclosing
user host in single quotes as such: 'user'@'host'.
Regards,
Bhavin.
- Original Message -
From: Michael Knauf/Niles [EMAIL PROTECTED]
Yes it does.
http://www.mysql.com/doc/R/e/Replication_Implementation.html
- Original Message -
From: Alice [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, June 24, 2002 6:52 PM
Subject: Is mySQL support replication ??
Hi, all,
May i know is mySQL support replication
Yes, MERGE Tables is useful for getting around the file size limit problem.
However, Linux 7.2(Kernel 2.4.x), MySql 3.23.47 supports file sizes greater
than 4GB. Mysql 3.23 by defaul will create tables that can grow only upto 4G
but these can be altered using ALTER TABLE. You willl need to alter
Hi,
My mysql error file (hostname.err) had grown to 11G on Red Hat 7.0, kernel
2.4.3, file system type ext2. As I understand it, file size in Terrabytes
can be supported under this kernel version, however, mysql semi-crashed at
this point, meaning I could not connect to it remotely (I could
Yes, it looks like the permissions are skewed. YOu might just want to do a
chown -R mysql:mysql /usr/local/mysql
The out-of-the-package permissions should be correct, ownership could be the
issue.
Regards,
Bhavin.
- Original Message -
From: Emiliano Marmonti [EMAIL PROTECTED]
To: [EMAIL
Also, if you are doing any 'LOAD DATA INFILE' where the master has access to
the file but the slave does not, then this could happen. On most errors, the
slave stop replicating and slave status will be turned to OFF.
The error file, hostname.err might tell you some thing too.
Regards,
Bhavin.
Does the error file (hostname.err) have any messages?
Regards,
Bhavin.
- Original Message -
From: Cindy [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, June 21, 2002 4:34 PM
Subject: here we go again
mysql_st /usr/local/mysql/bin/mysql -u root -p Text
Enter password:
ERROR
, .bash_profile, .bash_logout files. My shell is bash.
What do I do now?
Hoa
From: Bhavin Vyas [EMAIL PROTECTED]
To: Hoa Doan [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: Re: undefined symbol: _dig_vec
Date: Thu, 13 Jun 2002 16:09:40 -0700
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/lib.
Put
The master information should be present in my.cnf on the slave. What does
your my.cnf look like?
Regards,
Bhavin.
- Original Message -
From: Pierre Baridon [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, June 14, 2002 7:07 AM
Subject: replication
i am trying to setup a slave
Keyvalue.KeyvalueKey=Keyname_Keyvalue.KeyvalueKey AND Keyname_Key' at line 1
Are not supported in 3.23 but supported in 4.x. Is that correct? Any other
options besides writing a script?
Regards,
Bhavin Vyas.
-
Before posting
'status' will show that.
- Original Message -
From: Laura Findley [EMAIL PROTECTED]
To: MySQL List [EMAIL PROTECTED]
Sent: Friday, June 14, 2002 1:44 PM
Subject: MySQL port # ?
Does anyone know how to determine what port MySQL is using?
I need to know the port so that I can use it in
Stop master and slave
remove binary logs (hostname.001, hostname.002...) from master
remove log index (hostname.index) from master
remove master.info from the slave
tar data on master
untar on slave
start master and slave
The directories of where the files reside would depend on the method of
Mysql optimizes the column type while creating the table.
Regards,
Bhavn.
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, June 14, 2002 2:26 PM
Subject: varchar to char ...
Hi guys,
I have a query.I am not sure if this is a bug or a feature (ha ha
well, no, a Char field certainly won't take less space than Varchar but it
helps in optimizing space since mysql can manage space better when it knows
the exact length of the row. Hence, if you delete a record, instead of
leaving a hole on the disk (in Varchar), it will fill it up with another
Subject: Re: undefined symbol: _dig_vec
Thanks for you help so far.
I do have the libodbcinst.so.1. It's located in the directory
/usr/local/lib, but the program doesn't know that. How do I make it see
that libodbcinst.so.1 is in /usr/local/lib?
-Hoa
From: Bhavin Vyas [EMAIL PROTECTED
I guess this is what you want:
SELECT count(*) as syscount FROM events WHERE alert='1' GROUP BY sysid ORDER
BY syscount LIMIT 10;
- Original Message -
From: Jason Lane [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, June 13, 2002 6:54 PM
Subject: How can I get a top ten total
If you are just doing a port scan, that shouldn't be a problem. However, if
you are going to the DB server, you will need to grant at least 'usage'
permissions to user@host via the GRANT statement.
Regards,
Bhavin.
- Original Message -
From: [EMAIL PROTECTED]
To: MySQL [EMAIL PROTECTED]
Are you using FULLTEXT indexes on the search coloumns? They will sort
results according to relevance (depending upon the algorithm, that might not
be what you want).
It will index most of the relevant words in your column (which should be a
TEXT or a VARCHAR field) and then search on those words.
Also, this might help
http://www.mysql.com/doc/F/u/Fulltext_Search.html
- Original Message -
From: Nick Boldt [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, June 12, 2002 12:49 PM
Subject: Sort search results by relevance
I have created a search page which shows all records
if you have the file /usr/local/MyODBC/lib/libmyodbc.so, then do
ldd /usr/local/MyODBC/lib/libmyodbc.so
and see if all the dependencies are satisfied.
Regards,
Bhavin.
- Original Message -
From: Hoa Doan [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, June 12, 2002 11:52 AM
.1 and found it in /usr/local/lib.
What do I do from here?
Hoa
From: Bhavin Vyas [EMAIL PROTECTED]
To: Hoa Doan [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: Re: undefined symbol: _dig_vec
Date: Wed, 12 Jun 2002 18:15:53 -0700
if you have the file /usr/local/MyODBC/lib/libmyodbc.so
Once mysql is installed on the new system, you should be able to copy the
old data directory onto the new and you should be good to go(make sure the
permissions and the ownership are preserved) .
Regards,
Bhavin.
- Original Message -
From: Scott [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
do a
select patient_id,treatment_date from patient_treatment_history order by
treatment_date desc limit 1;
I am not sure but max(treatmen_date) might work too as such:
select patient_id, max(treatment_date) from patient_treatment_history group
by treatment_date;
In your original query the group
You can put it in any directory and then provide the FULL path to the file
in the LOAD command.
Regards,
Bhavin.
- Original Message -
From: Hoa Doan [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, June 09, 2002 12:26 AM
Subject: Re: LOAD DATA LOCAl
Hi,
I've created a mysql
Alter tablemodfiy column command should do it.
Regards,
Bhavin.
- Original Message -
From: Jason Lane [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, June 09, 2002 2:50 PM
Subject: RE: Can I override the auto-increment setting?
I have a mysql table that has the primary
Have you tried .../bin/safe_mysqld start to start the DB first? This is what
will create /tmp/mysql.sock socket file start the DB server. Then you can
use the 'mysql' client for connecting to the DB. Also, if you don't want to
use transactional database, meaning, if you don't want support for
Ah...give up not for we have been using mysql for quite a long time and it
is pretty stable. Try this...
instead of trouble shooting this install and getting it work...
go to www.mysql.com, download an rpm if you are on Red hat linux (or
Mandrake) and do an
rpm -i mysql...rpm and
rpm -i
10, 000 files open at the same time...maybe the OS itself is getting
flustered, you want to make sure that your OS can handle it, on *nix, u can
do a
ulimit -a and see the open files parameter
Beyond that, the system level limit on Linux can be found as
cat /proc/sys/fs/file-max
- Original
96 matches
Mail list logo