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 m
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 is the syntax to
create a new database), you can do that.
Bhavin.
- Original Message -
From: "Alice Ta
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 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
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
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, Dec
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 download
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
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:4
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
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 1
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 Mys
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
> he
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: Wedn
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='' GROUP BY b.oid
Also, you can refer to:
http://www.mysql.com/doc/en/JOIN.html
Bhavin.
- Original Message -
From: "
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 PROT
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,
>
> Whi
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 F
>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
S
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
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) | |
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
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()
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:
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
>
> /var/lib/
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.
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 'gc' as the invoice_id value.
Bhavin.
- Original Message -
From: "MySQL List" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, March 30, 2003 7:
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'
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 PROTECT
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 Me
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 m
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 pri
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 ro
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 mysq..clie
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 by
No other way that I know of, renaming the files via a script looks like the
best option, and should be pretty safe too.
Regards,
Bhavin.
- Original Message -
From: "Luc Foisy" <[EMAIL PROTECTED]>
To: "MYSQL-List (E-mail)" <[EMAIL PROTECTED]>
Sent: Monday, June 10, 2002 1:11 PM
Subject: I
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 'flush privileges' from the mysql prompt. That should solve the
problem.
Regards,
Bhavin.
- Original Message -
From: "slz" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, June 11, 2002 6:11 PM
Subject: about default privileges
hi:
I have finish install the mysql in my w
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 PROTECT
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 rec
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
.so.1 => /usr/lib
> etc...
>
> I did a find on libodbcinst.so.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]
> >Subje
nt: Thursday, June 13, 2002 11:34 AM
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.
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
the .profile file. I have
> the .bashrc, .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: u
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
;Keyvalue WHERE
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.
'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
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
ins
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
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
rec
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:
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: <[EM
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.
---
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
A
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 connec
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
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: <[EM
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 agai
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 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
Excel w
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" <[EMA
Selecting each column (instead of *) and then assigning an alias to
designerID from one of the tables (select designerID as GDID..) might
work.
Regards,
Bhavin.
- Original Message -
From: "Wilbert Enserink" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, July 04, 2002 7:38
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: T
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
> (http://lists.mysql.com
In most cases, your current approach should work. However, the best way to
ensure that everything would work is to import/export since that way you
have text data which you import into any DB/version/OS. However, that would
take longer.
If you have absoultely the same environment on all the comput
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 wh
Via mysql, you are trying to do a distinct 'field1'. So any field1
duplicates will be removed. Where as in the Linux sort only entire row
duplicates will be removed meaning 'field1field2'. They would return the
same number of records only if you selected field1 only and then sorted it
via the
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 sug
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 PROTECTE
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 gi
http://www.mysql.com/doc/G/R/GRANT.html
- Original Message -
From: "Matt" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, July 18, 2002 4:42 PM
Subject: Host IP is not allowed to connect this MySQL server
> Hello, I am trying to connect to a remote MySQL server of mine and I
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]>
T
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
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, Ju
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 o
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
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: Thur
>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 se
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:
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]>
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
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
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 (schema/descr
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..
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
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]>
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 Be
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:
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 serve
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 a
Also, see what errors you are getting in mysql .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 the
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]>
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: "P
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, 20
1 - 100 of 103 matches
Mail list logo
