Hi,
1.First generate un encrypted certificates. This can be done by using
an Open SSL library. The instructions are available at
http://www.mysql.com/doc/en/Secure_Create_Certs.html
Note: Here un encrypted certificates means certificates that are not
protected by any password. When MySQL
Alaios [EMAIL PROTECTED] wrote:
Hi i have just installed the mysql_client
and i am trying to remotely connect to the database of
the other pc so i gave the following command
mysqlshow -h 192.168.64.12 -u [EMAIL PROTECTED]
mysqlshow: Host 'akroneiro' is not allowed to connect
to this M
This
Hi, everyone,
As said in documentation, there is no need to build MySQL with
-rdynamic: If you want to use an UDF that needs to access symbols from
mysqld (like the methaphone example in `sql/udf_example.cc' that uses
default_charset_info), you must link the program with -rdynamic (see man
We used to have a fair amount of data in InnoDB.
Had a few crashes from power failures at a crappy hosting provider.
Everytime the InnoDB engine seemed to detect the crashes and read up its
logfiles and recover.
I've never tried any manual InnoDB recovery / data extraction. Are there
methods?
Luis Lebron [EMAIL PROTECTED] wrote:
I am try to copy a couple of fields from one table to another. Here is my
query
Insert into users_test (firstName, lastName) Select firstName, lastName from
users;
The users table has 1,263 rows. However, only 1 row is inserted into
users_test.
Hi All,
Is there a possibility that a certain query that is executing in mysql
by application is not visible by a show processlist command. As
happened in my database a query was taking number of CPU cycles but when
seen through the show processlist command nothing was displayed.
shasan
--
Hi all,
I would like to know who develops and how to obtain libmysql.dll, and is there any
Object Pascal header file for this library, or I have to make my own?
Thanks,
niel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Jeff McKeon [EMAIL PROTECTED] wrote:
Is is possible to do a select query with a left join from a real table
to a temporary table?
Yes.
I'm trying it but keep getting unkown table
'tablename' in field list error.
Show us you query.
Don't forget that temporary table is visible only for the
Sohail Hasan [EMAIL PROTECTED] wrote:
Is there a possibility that a certain query that is executing in mysql
by application is not visible by a show processlist command. As
happened in my database a query was taking number of CPU cycles but when
seen through the show processlist command
I currently use the excellent mysqlfront which is sadly no longer
supported.
I've tried mysqlcc but it seems non-intuitive, and missing loads of
features. It also has a problem working with old versions of mysql
3.23.47
Or have I missed something, does anyone recommend mysqlcc???
zzapper
--
Quick question I haven't found in the docs.
I have a column with unicode (utf8 or ucs2) character set.
How can I use a national collation on it? (upper(), lower(), sort order)
None of the examples in the docs work... :(
--
MySQL General Mailing List
For list archives:
Roger,
Your help was fantastic. It seems that it goes better. At the end I achieve
some result but not all I need.
The explain select says as follows:
EXPLAIN Select FASE.PR_Date_Visita_2, CE.CE_Centro, CE.CE_Domicilio,
CE.CE_CP, CE.CE_Poblacion, CE.CE_Capital, CE.CE_PROV,
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi all,
I am currently getting the following error on one of the mysql servers
im looking after and wonder if anybody knows what specifically it
relates to.
Error in accept: Too many open files
Im currently running MySQL version '4.0.14' under
Following errors we've got by restarting mysqld
031114 10:26:51 mysqld started
InnoDB: Fatal error: cannot read from file. OS error number 17.
031114 10:26:56 InnoDB: Assertion failure in thread 1024 in file os0file.c line 1329
InnoDB: We intentionally generate a memory trap.
InnoDB: Send a
Following errors we've got by restarting mysqld
031114 10:26:51 mysqld started
InnoDB: Fatal error: cannot read from file. OS error number 17.
031114 10:26:56 InnoDB: Assertion failure in thread 1024 in file os0file.c line 1329
InnoDB: We intentionally generate a memory trap.
InnoDB: Send a
I set a 2-way replication with 2 servers
One is accessed and used for both select and updates. The other one is
backup
set to work through a failover software.. if the first server is down.
So the backup server can easily update the other server when it comes up
again.
Do you see any collision
Try SQLyog at www.sqlyog.com
It is pretty good, and full of interesting features.
Bye
I currently use the excellent mysqlfront which is sadly no longer
supported.
I've tried mysqlcc but it seems non-intuitive, and missing loads of
features. It also has a problem working with old versions
Hi, im using this script to show the query results, basically it shows
multiple results in multiple pages, when more than one result are found it
shows the first one and on the bottom of the pages it shows the number of
pages that remains, but fot some strange reason when you click on the first
I am using Innodb Tables but I Like to run this database without
creating any logfiles.
Is there a way that Mysql doesn't create any logfiles at all . I can
recover from a master system so this database can or is allowed to loose
the data
Hi, im using this script to show the query results, basically it shows
multiple results in multiple pages, when more than one result are found it
shows the first one and on the bottom of the pages it shows the number of
pages that remains, but fot some strange reason when you click on the first
or
Margrit,
fix the problem that leads to OS error number 17.
What does perror tell you about it?
Regards,
Frank.
Margrit Lottmann schrieb:
Following errors we've got by restarting mysqld
031114 10:26:51 mysqld started
InnoDB: Fatal error: cannot read from file. OS error number 17.
Am Friday 14 November 2003 14:51 schrieb nm:
I set a 2-way replication with 2 servers
One is accessed and used for both select and updates. The other one is
backup
set to work through a failover software.. if the first server is down.
So the backup server can easily update the other server
Why do you refuse to accept my messages.
I urgently need to send our bug report.
--
Mit freundlichen Gruessen
M.Lottmann
Otto - von - Guericke Universitaet __ __ _ _ __
Magdeburg / / / / / __ \__ // | / /
Margrit Lottmann [EMAIL PROTECTED] wrote:
Why do you refuse to accept my messages.
I urgently need to send our bug report.
Post bug reports to the bug databse:
http://bugs.mysql.com/
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored
I have a table called journal with the following fields
ID = auto INT
Date = DATE
Order = INT
Entry = TEXT
The table stores journal entries and saves the date that the entry was
entered on. The Order just ells me what order the entries were entered
if there is more than one entry per
Fernando [EMAIL PROTECTED] wrote:
In version 3.23.57 when i do a rollback i get this error message and the changes are
not undone, why?
This is what i typed: (NOTE: 'insert.sql' insert a row correctly in an InnoDB table)
mysql SET AUTOCOMMIT=0;
Query OK, 0 rows affected (0.00 sec)
Margrit,
your disk or file system is probably broken:
InnoDB: Fatal error: cannot read from file. OS error number 17.
17 EEXIST File exists
The error number does not make sense in a file read. Strange.
You cannot remove ib_logfiles from an InnoDB installation. They are as
important as ibdata
Subquerys don't become available until 4.1 Version 3.X does not support
them
From Mysql.com
For MySQL versions prior to 4.1, most subqueries can be successfully
rewritten using joins and and other methods. See section 6.4.2.11 Rewriting
Subqueries for Earlier MySQL Versions.
Also, if they
do a show status like 'open_files'
and a show variables like 'open_files_limit'
-Original Message-
From: William Bailey [mailto:[EMAIL PROTECTED]
Sent: Friday, November 14, 2003 6:56 AM
To: [EMAIL PROTECTED]
Subject: Please help. MySQL Error.
-BEGIN PGP SIGNED MESSAGE-
Hash:
Can you post the error message you are getting?
-Original Message-
From: Quique Luna [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 13, 2003 4:33 PM
To: [EMAIL PROTECTED]
Subject: Inserting Colons in a Table
Hi,
I'm trying to load some data into a MySql table, but some of the
Matt W wrote:
I guess you'll have to see if it's fixed in the next release (4.0.17).
Any clue as to when 4.0.17 will be released?
Joe
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Can anyone tell me how to structure a query to utilize a subparted index on Innodb?
Haven't found any info on web search. Have an index (AGENT(4),SEARCH_NAME) that works
on the select but breaks on the ORDER BY (using filesort).
To get it to use the index I have to issue something like:
I've seen this question posted in various forms on the web, but not in
such a way that I have found helpful. I have a column of data in the
following format name.xx.yy where the x's and y's represent numbers.
When selected by mySQL, the column is sorted in an odd way, given by the
following
I'm creating a database application for a phone directory for my church.
People are very concerned about security and would like to run the
application locally. Is it possible to distribute a local version of a
MySQL database without having to install MySQL on the local machine? Or
is there
On Fri, Nov 14, 2003 at 03:18:49PM -0500, David M. Doggette wrote:
I'm creating a database application for a phone directory for my church.
People are very concerned about security and would like to run the
application locally. Is it possible to distribute a local version of a
How is having a
You could try this:
ORDER BY
SUBSTRING_INDEX(TheColumn,'.',1),
SUBSTRING_INDEX(SUBSTRING_INDEX(TheColumn,'.',-2),'.',1)+0,
SUBSTRING_INDEX(TheColumn,'.',-1)+0
It is quite slow though, If possible, I'd suggest splitting that one column
into 3 separate columns. You woudl save space (not
I'm thinking about an addressbook database. I would like an opinion on
my table layout (I still consider myself a mysql newbie):
table user
uid
username
timestamp
table secret
uid
secret
timestamp
table people
pid
uid
firstname
lastname
birthday
timestamp
table address
aid
pid
address
city
* Elisenda
[...]
The explain select says as follows:
[...]
I re-formatted the query and the EXPLAIN output for readability:
Select FASE.PR_Date_Visita_2, CE.CE_Centro, CE.CE_Domicilio, CE.CE_CP,
CE.CE_Poblacion, CE.CE_Capital, CE.CE_PROV, CE.CE_CCAA,
CA.CA_Horario,
PP.PP_Contacto,
Finally, if anyone has or knows of a good phone directory already.
Please point me in the right direction.
Have you considered LDAP? Run it over SSL with TLS - should calm any
security concerns. Outlook (and most any other mail agent for that
matter) can hook into it for address book
* Neil Watson
I'm thinking about an addressbook database. I would like an opinion on
my table layout (I still consider myself a mysql newbie):
table user
uid
username
timestamp
table secret
uid
secret
timestamp
You don't mention keys? Why do you want to split the user table? A
From: Hanon Sinay [EMAIL PROTECTED]
Date: Friday Nov 14, 2003 12:24:44 PM America/Los_Angeles
Subject: Unable to open and run mysqladmin Mac Os X
File Edit Options Buffers Tools Help
SEND-PR: -*- send-pr -*-
SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as
SEND-PR: will
* Colleen Dick
This stumped them in PHPbuilder...
I have a table lets call it moms
each row in the moms table can have many kids,
and some kids have 1 mom. I have a kid table
and I have a mxk map table to relate them.
what I want to do is select all the moms and for each mom I want a
C
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
A HUGE THANK YOU
I had almost given up doing this in a query, it works!
I knew there had to be something like this, just couldn't quite
snag it most of my queries are pedestrian to say the least.
It may be inefficient --and I see why it is-- but would it not be less
so for the dbms to do
It looks nice. Too bad it's not Linux, yet. Hopefully in 2004.
-Marc
On Fri, 2003-11-14 at 08:51, Daniel Kiss wrote:
Try SQLyog at www.sqlyog.com
It is pretty good, and full of interesting features.
I currently use the excellent mysqlfront which is sadly no longer
supported.
I've
My configuration:
I am using 4.0.16 compiled with the following configure command on
RedHat Linux 9.0:
CFLAGS=-O3 CXX=gcc CXXFLAGS=-O3 -felide-constructors
-fno-exceptions -fno-rtti ./configure --prefix=/usr/local/mysql-4.0.16
--enable-assembler --with-mysqld-ldflags=-all-static
I have
46 matches
Mail list logo