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 = /opt/OpenSSL/ssl/opens
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:http:
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
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 us
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 |
-
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 Sour
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 ---
Fro
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 i
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 file
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 do
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 nul
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:
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 addi
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
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 the
-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
- 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 o
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
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 back
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
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 Februa
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 replic
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 h
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Thursday 05 February 2004 14:31, [EMAIL PROTECTED] wrote:
> What about if the user enters
> mysql -u -p
MySQL fails to start with the error message "Bad Handshake"
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.2-rc1-SuSE (GNU/Linux)
iD8DBQFAI
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,
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
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 20
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 [mail
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 Sy
What about if the user enters
mysql -u -p
>> 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 PR
-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
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 S
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 ME
-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 re
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
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.
Try using the actual MySQL dump command
mysqldump --B --tables -u --opt -p -h |
mysql -u -p -h
>> Original Message <<
On 2/5/04, 10:46:21 AM, UpFront Technology <[EMAIL PROTECTED]>
wrote regarding migrating mysql database:
> Hello,
> I am trying to copy
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
> 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
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
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
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 P
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 con
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 rep
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 ind
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:
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, w
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
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
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
> di
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
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 don
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 colum
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 --skip-colu
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 wr
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:
> Co
You have attempted to login with out supplying a username. Try logging in
like:
mysql -u -p
>> 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
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, 2
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
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
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
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
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
"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 o
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 se
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
thi
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
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 file.
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 param
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...
...through your Web server. You'll see a page filled
with useful and interesting information like this.
This info tells all
[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 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 performed
> 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 dat
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
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
clause, can only be a real value. Not a functi
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.
http://taxe
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
> >> >> 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
"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
>> >
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
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
> avo
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
pr
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 ex
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
http://www.mysql.com/doc/en/Show_database
84 matches
Mail list logo
