Hello
I am executing show index from tablename to get index
information. The following columns are returned ...
Table Non_unique Key_name Seq_in_index
Column_name Collation Cardinality Sub_part Packed
NullIndex_type Comment
In the docs at
Michael Satterwhite [EMAIL PROTECTED] wrote:
I've reinstalled MySQL 4.1. I'm trying to start the server (mysqld_safe), but
it fails to start. The log file shows the message:
/usr/sbin/mysqld-max: Fatal error: Can't find messagefile
'/share/mysql/english/errmsg.sys'
The files exists, but
Alan,
Now I'd love to know why I can't upgrade :)
You can upgrade to version 4.0.17 ;)
It seems you hit the bug that was introduced in 4.0.16, and fixed in 4.0.17.
Look at this: http://www.mysql.com/doc/en/News-4.0.17.html
Fixed optimizer bug, introduced in 4.0.16, when REF access plan was
Adam,
I've got to create a table that has the following:
CREATE TABLE access (
query VARCHAR(255) NOT NULL,
INDEX (query)
);
and mysql is telling that the max bytes allowed is 500 for key length.
The docs say I can change this by recompiling, which I would like to
avoid having
Mike Anderson [EMAIL PROTECTED] wrote:
Hallo,
I am in the process of setting up a simple replication and have a
question that I can't figure out from the docs.
I have 2 servers, N1 is a test machine and hosts 2 databases live and
test. N1 is a slave to N2 which is a production machine and
Martijn Tonies [EMAIL PROTECTED] wrote:
When creating a stored procedure, what must I do to
create a procedure/function in a specific database?
I created a function hello like in the example, but
afterwards, I cannot create it from another database
connection.
Currently you
Column 'db' in the table 'proc' isn't used yet. It's for future use.
Thank you for your answer. Can I expect procedures/functions
to be database specific in the future? Or will they stay server-wide?
IMO, they should be db specific :-)
Yes, you can. In a future they will be
Hi --
I'm still relatively new to MySql.
I'm using InnoDB tables and foreign keys.
When I set up the databases, I recall assigning
a few large fixed-size files to the InnoDB engine for
data (and I think) logs.
I've been adding data to my databases daily and wish
to know how full they are, and
In a table definition, how do I get a date field to be
assigned as DEFAULT the current date?
I tried:
dateField DATE DEFAULT CURDATE()
but that gives me syntax errors
Help?
__
Do you Yahoo!?
Yahoo! Finance: Get your refund fast by filing online.
Hi,
In a table definition, how do I get a date field to be
assigned as DEFAULT the current date?
I tried:
dateField DATE DEFAULT CURDATE()
but that gives me syntax errors
Help?
According to the documentation for the DEFAULT value
clause, value can only be a real value. Not a
you can use TIMESTAMP data type, which have default NOW()
- Original Message -
From: Riaan Oberholzer [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, February 05, 2004 12:38 PM
Subject: [Q] setting DATE field with default NOW value?
In a table definition, how do I get a date
you can use TIMESTAMP data type, which have default NOW()
Not exactly.
1) TIMESTAMP also updates when you update the row, unless
you set the column value to its current value.
2) not in maxdb mode.
http://www.mysql.com/doc/en/DATETIME.html
In a table definition, how do I get a date
I recently installed MySQL on my computer and finally
figured out how to create tables (using a trial
version of EMS MySQL Manager).
Today, I used a tutorial at
http://paul.ecommerce.hct.ac.ae/tutorials/dwmx-php/dwmxphp.htm
which helped me connect Dreamweaver to a MySQL
database. I also
[EMAIL PROTECTED] wrote:
Hi,
Is it posssible to specific the max file size allowed for mysql database?
Only for the InnoDB datafile you can specify max size with MySQL startup option.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by
I was perusing a MySQL tutorial at
http://hotwired.lycos.com/webmonkey/99/21/index2a_page5.html?tw=programming
when I read the following:
Save and view this script...
html
body
?php
phpinfo();
?
/body
/html
...through your Web server. You'll see a page filled
with useful and interesting
At 02:13 5/2/2004, Ananth Raghuraman wrote:
Hi,
Thanks for the info!
I am already able to debug the server startup.
I would like it to stop
at someother point, perhaps a point where a SELECT statement is executed
for example..
In this case you can start your debug server (mysqld.exe) with
the
I am having problems with making a connection between my website and
the MySQL db on a different server. I have tried both hand coding and
using the MyOLEDB application for MySQL. What am I doing wrong? If you
think this looks a little strange, it is because it is a dreamweaver
connection
Hello,
I have a mysql database in which I run from a machine where I am
developing. I would like to take the contents of a specific database (plus
all tables) and copy all to another box (not networked). Could someone
point me out to the specifics of what I need to do, or where in the docs
this
Dear all,
Normally one would replicate from 1 master server, onto several slave
servers. However, my situation is quite different, and I have found
myself unable to figure out a way to solve it. I very much hope you can
help me with this matter. All replies are appreciated.
In short, I want
Scott Purcell [EMAIL PROTECTED] wrote:
I have a mysql database in which I run from a machine where I am
developing. I would like to take the contents of a specific database
(plus all tables) and copy all to another box (not networked). Could
someone point me out to the specifics of what I
Have you run a check/analyze on the table in question? The table will
need to be repaired before you proceed.
Original Message
On 2/4/04, 11:11:12 PM, Devios McShady [EMAIL PROTECTED] wrote regarding
index failing on large database - any ideas why?:
I have a database with one 17GB table
Hi all,
Is any one met with the error while connecting to MySQL Server
*Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)*
if so pleass let me know the remedy to resolve this error.
I don't have the user named ODBC in my mysql Database.
my configuration is:
Windows 2000
Tofu Optimist wrote:
When I set up the databases, I recall assigning
a few large fixed-size files to the InnoDB engine for
data (and I think) logs.
I've been adding data to my databases daily and wish
to know how full they are,
Use this command:
show table status from database_name like
Try something similar to this:
ConStr = Provider=MSDASQL;DRIVER=MYSQL ODBC 3.51
DRIVER;SERVER=ABC;DATABASE=MYDATABASE;UID=root
Gilbert Wu
[EMAIL PROTECTED]
http://www.sabrefund.com
Sabre Fund Management Limited
Windsor House
55 St James's Street
London SW1A 1LA
Tel +44 20 7316 2820
Each time it fails, I've successfully run the repair table command.
On Thu, 05 Feb 2004 14:38:34 GMT
[EMAIL PROTECTED] wrote:
Have you run a check/analyze on the table in question? The table will
need to be repaired before you proceed.
Original Message
On 2/4/04, 11:11:12 PM, Devios
The ISP do have the driver installed and they also know what they are
talking about. The problem is they won't talk to me because I am not
the reseller (ie their customer). The reseller I have used knows
nothing about MySQL - he knows everything else but MySQL.
Mat
On Thursday, February 5,
You have attempted to login with out supplying a username. Try logging in
like:
mysql -uusername -ppassword
Original Message
On 2/5/04, 8:38:13 AM, Arunachalam [EMAIL PROTECTED] wrote regarding
Access denied for user: '[EMAIL PROTECTED]' (Using password: YES):
Hi all,
Is any one met
Is the MyODBC driver installed on the Webserver? Without it, you will
still encounter this error message.
Original Message
On 2/5/04, 9:05:51 AM, Gilbert Wu [EMAIL PROTECTED] wrote
regarding RE: Need DSN less help:
Try something similar to this:
ConStr = Provider=MSDASQL;DRIVER=MYSQL
The IN and NOT IN searches (sub-queries) are not optimized in MySQL
yet. You may find doing a JOIN or LEFT JOIN and filtering out NULL
entries to be faster. I don't know where you getting your ids not to
match from, so I can't really give you a good example.
On Feb 4, 2004, at 11:04 PM, Mark
Scott Haneda wrote:
on 02/04/2004 02:23 AM, Bernd Tannenbaum at [EMAIL PROTECTED]
wrote:
2 possible ways to go:
Feed a Textfile with your statement in the db:
PATH/mysql db /sql_scripts/sql_statements_as_textfile --password=pass
Give command directly In the shell-script:
PATH/mysql
If you update the row with NULL for the TIMESTAMP field it will enter
the current date and time.
On Feb 5, 2004, at 7:18 AM, Martijn Tonies wrote:
you can use TIMESTAMP data type, which have default NOW()
Not exactly.
1) TIMESTAMP also updates when you update the row, unless
you set the
Arunachalam wrote:
Hi all,
Is any one met with the error while connecting to MySQL Server
*Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)*
OK, you tried to log into mysql as [EMAIL PROTECTED], using a password.
if so pleass let me know the remedy to resolve this error.
I
I got the following error on a perl script:
Duplicate entry '273' for key 1
I googled for it and found a thread telling me to DROP the table and re
CREATE it. So I did, and my script is working fine. My question: why
did this happen, why did dropping and recreating work, and what can I do
On Thursday 05 February 2004 15:50, Daniel R. Anderson wrote:
I got the following error on a perl script:
Duplicate entry '273' for key 1
I googled for it and found a thread telling me to DROP the table and re
CREATE it. So I did, and my script is working fine. My question: why
did this
At 15:50 + 2/5/04, Daniel R. Anderson wrote:
I got the following error on a perl script:
Duplicate entry '273' for key 1
It means you tried to set the value of the column corresponding to key
one to 273, and there was already a record that had that value.
I googled for it and found a thread
Paul DuBois wrote:
At 15:50 + 2/5/04, Daniel R. Anderson wrote:
I got the following error on a perl script:
Duplicate entry '273' for key 1
It means you tried to set the value of the column corresponding to key
one to 273, and there was already a record that had that value.
I googled for
Hi!
On Feb 05, Daniel R. Anderson wrote:
I got the following error on a perl script:
Duplicate entry '273' for key 1
I googled for it and found a thread telling me to DROP the table and re
CREATE it. So I did, and my script is working fine. My question: why
did this happen, why did
Hallo,
I am having trouble setting up replication. After sorting out most
things I get a connection from the slave to the master, but then a
mysql_errorno=1236. Here is an extract of the system log:
This is mentioned in the create table section:
http://www.mysql.com/doc/en/CREATE_TABLE.html
Original Message
On 2/5/04, 1:58:43 AM, Karam Chand [EMAIL PROTECTED] wrote
regarding Result returned by show index from...:
Hello
I am executing show index from tablename to get index
Is the server Id for your slave setup? What does the my.cnf for the slave
look like?
Original Message
On 2/5/04, 10:17:11 AM, [EMAIL PROTECTED] wrote regarding replication:
slave returns a 1236 error_code.:
Hallo,
I am having trouble setting up replication. After sorting out most
Hello,
I am trying to copy the mysql database to a new MySQL server. I have
tried the mysql dump method:
dump data into a file mysql2.sql
move file to the new server
execute:
mysql -u root -p -e source mysql2.sql mysql -on the new server
I
this occures when you ommit the user name, MYSQL C API uses user ODBC as
default when you ommit or enter empty string as
user name when calling mysql_real_connect()
- Original Message -
From: Arunachalam [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, February 05, 2004 3:38 PM
I have just started to use PHPMy Admin in the last hour or so. How do I
upload the data and structure to a remote server. I have done a
mysqldump and have tried to upload it but I keep getting an error.
I create a statement in a window, browse to a file to upload it and
submit the form. I wait
Hello
OK? Got it.
So the structure of columns returned by SHOW INDEX has
changed after 4.0.2 and it has remained same after
that.
Karam
--- [EMAIL PROTECTED] wrote:
This is mentioned in the create table section:
http://www.mysql.com/doc/en/CREATE_TABLE.html
Original Message
On
I have just started to use PHPMy Admin in the last hour or
so. How do I
upload the data and structure to a remote server. I have done a
mysqldump and have tried to upload it but I keep getting an error.
I create a statement in a window, browse to a file to upload it and
submit the
i have an issue with my.cfg. I am trying to change the value of
wait_timeout. it's default value is
28800., my install is 4.0.15. As i understand it, the my.cfg file needs
to be in /etc dir. the entry i have in it is
set wait_timeout = 60;
that did nothing, i tried wait_timeout = 60
Try using the actual MySQL dump command
mysqldump --Bdatabase --tablesoptional -uusername --opt -ppassword -hhost |
mysql -uusername -ppassword -hhost
Original Message
On 2/5/04, 10:46:21 AM, UpFront Technology [EMAIL PROTECTED]
wrote regarding migrating mysql database:
Hello,
I
Not sure if you mistype but the file is called my.cnf not my.cfg
Original Message
On 2/5/04, 11:31:43 AM, dan orlic [EMAIL PROTECTED] wrote regarding
issue with my.cfg:
i have an issue with my.cfg. I am trying to change the value of
wait_timeout. it's default value is
28800., my
Can you ping the master from the slave?
What do you have in the master.info file?
Original Message
On 2/5/04, 12:19:29 PM, [EMAIL PROTECTED] wrote regarding Re: replication:
slave returns a 1236 error_code.:
Since you asked ..
here is the my.cnf from the slave:
I Think it is ok:
In
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
OK, I've got my server running again on 4.1. I'm having a grant problem,
though (I have run the script to fix the privilege tables).
If I enable a user without a password, he can connect to the databases fine.
If I add a password to the user, he
Was the user created under MySQL 4.1 or a previous version? How are you
connecting? MySQL monitor, ODBC, JDBC, etc. ?
Original Message
On 2/5/04, 1:40:20 PM, Michael Satterwhite [EMAIL PROTECTED] wrote
regarding Bad handshake:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
OK, I've got
I need some help with this. Here is the information from the MySql manual.
IF search_condition THEN statement(s)
[ELSEIF search_condition THEN statement(s)]
...
[ELSE statement(s)]
END IF
IF implements a basic conditional construct. If the search_condition
evaluates to true, the corresponding
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Thursday 05 February 2004 14:14, [EMAIL PROTECTED] wrote:
Was the user created under MySQL 4.1 or a previous version? How are you
connecting? MySQL monitor, ODBC, JDBC, etc. ?
The user was created under 4.1.
The user is at the machine running
What about if the user enters
mysql -uusername -ppassword
Original Message
On 2/5/04, 2:22:29 PM, Michael Satterwhite [EMAIL PROTECTED] wrote
regarding Re: Bad handshake:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Thursday 05 February 2004 14:14, [EMAIL PROTECTED] wrote:
Was
Folks,
I want to change the database dir to a new dir. When I change the
my.cnf and add
[mysqld]
datadir=\data
Do I have to do anyting to the mysql and test databases? This is a
fresh install rpm install.
Patrick Fowler
Unix Admin/database Admin
Wynit, Inc.
6847 Ellicott Drive
East
Yes, you have to move the mysql and test databases - only one directory
for all files.
Shut down mysqld
Modify the my.cnf
Move the data files
Start up mysqld
You might want to check the /etc/init.d/mysqld file - the path is hard
coded there.
-Original Message-
From: Patrick Fowler
Hi all,
I have had a new mysql db set up and I noticed that the creator has basically given
all fields attributes of longtext, except of course the date fields and some
numerical fields. The longtext fields show up as memo when I try and view the data
in a gui tool etc.
The database has 200
The short answer is `yes`. Your fields should match the data that they
will hold. It sounds like the creator is accustomed to using tools such
as MS Access where the `Text` field is a common catch all datatype.
Original Message
On 2/5/04, 3:45:57 PM, Adam Staunton [EMAIL PROTECTED] wrote
well this is what the deal is... I have a client/server application and
the server connects to mysql
via torque, an open source software project, they are jdbc connections.
Here is the problem: If the applications is left up, let's say,
over night, and the client tries to access the database,
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Thursday 05 February 2004 14:31, [EMAIL PROTECTED] wrote:
What about if the user enters
mysql -uusername -ppassword
MySQL fails to start with the error message Bad Handshake
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.2-rc1-SuSE
wow, nice product. Pretty easy to use and install - I like it.
I know enough about SQL and databases to just about break any flavor of them
I put my hand on ;-). A couple of pointers would be great.
I'm creating a handfull of tables that will inter-depend on eachother, using
it within php. I
Using MySQL 4 on Windows 2000, sp 4. version = 4.0.17-nt-log
I recently installed this and finding that a large number of files
are being created that are named something like this:
myDomain-relay-bin.026
I guess this is a replication log file? I have not specified in the
cnf file that
What version is the MySQL client? Is the user logging on remotely?
Original Message
On 2/5/04, 4:22:37 PM, Michael Satterwhite [EMAIL PROTECTED] wrote
regarding Re: Bad handshake:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Thursday 05 February 2004 14:31, [EMAIL PROTECTED] wrote:
You should be handling the timeout connection in your code. You will be
looking for a SQLState of `08S01`. Once you have captured this your can
attempt to reconnect to the database.
Original Message
On 2/5/04, 4:21:36 PM, dan orlic [EMAIL PROTECTED] wrote regarding
maintaining connects to
Is there any best-practices wisdom on what is the most preferable
method of backing up moderately (~10-20,000 record) MySQL 4
databases? A mysql dump to store records as text, the format provided
by the BACKUP sql command, or some other method? I am not asking
about replication, rotating
Some answers within your message.
I would suggest you to browse the reference manual.
Bernard
On Thursday 05 February 2004 17:27, /dev/null wrote:
wow, nice product. Pretty easy to use and install - I like it.
I know enough about SQL and databases to just about break any flavor of
them I
- Original Message -
From: /dev/null [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, February 05, 2004 11:27 PM
Subject: New to MySQL
wow, nice product. Pretty easy to use and install - I like it.
I know enough about SQL and databases to just about break any flavor of
them
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Thursday 05 February 2004 16:52, [EMAIL PROTECTED] wrote:
What version is the MySQL client? Is the user logging on remotely?
4.1.0-0 on the client.
The user is logging on on the machine running MySQL. I'll check out remote
login after I have it
I have a Java application that is connecting to a MySQL database
via JDBC (Connector/J 3.0.10 connecting to MySQL 4.0.17 server).
I would like to implement a time-limit on certain queries (all
SELECTs) and kill the query if it exceeds a given limit. Is there
a convenient way to do this?
Maybe
on 02/05/2004 07:29 AM, Michael Stassen at [EMAIL PROTECTED]
wrote:
Also, you need the FILE privilege to SELECT INTO OUTFILE.
Alternatively, you could simply redirect output to a file.
mysql dbname -e SELECT serial FROM serials /path/to/outfile
In this case, the file is written by the
Michael Stassen wrote:
Philip Walden wrote:
Michael Stassen wrote:
You need supp_cd to be first in an index. Try
ALTER TABLE hpi_supp_agmt ADD INDEX supp_ind (supp_cd);
then try to add your foreign key constraint again.
Michael
Looks like that does not work. BTW this does work (without
Mark,
You're killing me because I can't visualize the source tables. A query
like this is bread and butter, it shouldn't take to long to execute.
Give me a better idea of the table structure and relationships between
them. I try to help.
Regards,
Adam
On Feb 4, 2004, at 11:04 PM, Mark wrote:
I've been unable to find any information on this issue so I'm not quite
sure if it's a bug or a new restriction. In either case I think it's a bug
due to it's inconsistency with itself.
create table foo (id int not null default -1)
does not work
create table foo (id int not
Philip Walden wrote:
Michael Stassen wrote:
Philip Walden wrote:
Michael Stassen wrote:
You need supp_cd to be first in an index. Try
ALTER TABLE hpi_supp_agmt ADD INDEX supp_ind (supp_cd);
then try to add your foreign key constraint again.
Michael
Looks like that does not work. BTW this
Hello
I am going thru the source code of MySQL client.
I am not able to understand in general how MySQL is
handling unicode characters. All the function take
(char*) as arguments?
Is it expecting all the data to be UTF8-encoded and
before executing the queries (i was looking into the
batch
Scott Haneda wrote:
on 02/05/2004 07:29 AM, Michael Stassen at [EMAIL PROTECTED]
wrote:
Also, you need the FILE privilege to SELECT INTO OUTFILE.
Alternatively, you could simply redirect output to a file.
mysql dbname -e SELECT serial FROM serials /path/to/outfile
In this case, the file is
Is the server-id of slave different from that of master?
Check this.
both the serverid's must be different..
Regards
T.Nagendra Prasad
Professional Services
OSI Technologies
__
-- Original Message ---
Thank you very much, I will definitely try this out!!
-Original Message-
From: Miguel Angel Solorzano [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 05, 2004 8:04 PM
To: Ananth Raghuraman; Miguel Angel Solorzano
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: Debugging MySql
Sorry for the obscurity. Although I'm not new to MySQL, I'm new to the
list.
MOVIES
---
| id | title | year |
---
| 1083 | Star Wars | 1977 |
---
SUBCATS
---
| movie | subcategory |
I have installed MyODBC 3.51 and created the DSN for my Database.
I want to clarify that;
If the User name I have given is could not be resolved by mysal_real_connect,
then it automatically establish the connection to the server using
[EMAIL PROTECTED] - right
If so, Is there need to have the
try to use the myisamchk to check/repair MyISAM tables
Pablo Pragana wrote:
I hope you can help me with this:
Incorrect information in file: './sarara/searchindex.frm'
Error
consulta SQL :
SHOW KEYS FROM `searchindex`
MySQL ha dicho:
#1033 - Incorrect information in file:
I have one table named Category under that all values contains Books
How can i make all Books into Stocks?
Im not familiar with the command
-- -
Louie Miranda
http://www.axishift.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Hi buddies, i need some help with Mysql Openssl.
I compiled sucessfully Mysql with the option openssl and i had created new
CA permission. Every is fine at the moment, but when i look mysql status i
see SSL: not in used.
I check, /etc/my.cnf
[mysqld]
ssl
ssl-ca =
83 matches
Mail list logo