 | | | MySQL General | | S?ren Neigaard <s.neigaard@(protected) > wrote
> I have a MySQL (mysql-standard-4.0.17-pc-linux-i686) running as master
> where I have attached a slave to for replication. The problem now is Hi
I am really pleased with the new unicode features of MySQL4.1.2 alpha release. I am just a little surprised that there is still only one API call which returns the character set??? (And it retuAll
First let me say I know only the most basic of Java stuff.
I am working with a Java colleague on the development of a data model
(MySQL of course -) and we seem to run into the problem anI am having the same problem that someone else posted about back in
December and I didn 't see any responses for
http //lists.mysql.com/mysql/156346
Specifically I am trying to link with libmy
Does anyone know of a way to use a SELECT statement to get the default value
for a column?
A DESCRIBE tabl_name col_name gives the values but I need it inside a
SELECT.
Thanks.
-Hi
I am using MySQL 4.0.17. When I try to create a foreign key on a field of
the type text I get this error
040609 15 02 31 Error in foreign key constraint of table db_name/tb_name
There
Scott Fletcher wrote
>I read some articles that the use of SQL 's TIMESTAMP in a table is use
>for recording the actual date/time that the row was inserted and for
>row(s) that is/are updatedHello -
I just upgraded my master to 4.0.20 from 3.23.54 (ran the
mysql_fix_privileges script)
My slaves are all 4.0.[16 17 18]
All seems well EXCEPT the Slave_IO_RunninHello
I have had a few systems that began to generate max connection errors. When I
run a processlist there are a lot of the following entries
5899 | unauthenticated user | xx.xx.xx.xx | NULLGreg Macek <it-guy@(protected) > wrote
> I was wondering what happens when you change table types. Does MySQL
> automatically get rid of the old table files?
Yes MyISAM files are deleted. AsAt 02 34 PM 6/9/2004 you wrote
>Hi
>
>I need some help please! I have 60GB of proxy logs to parse and load into
>a mysql database. I 've written a parsing script but I 'm stuck now on how
>to echo $updatequery to screen and see what the sql looks like.
> I am trying to update a table from results generated from a select query
> but can 't seem to get the queries running right. The > > I have a TBL of users and I have created a search screen where you can
type in
> > first or last name and it will retrieve the appropriate records. Here is
the statement
> > "Select * from STIn the last episode (Jun 09) Blake Schroeder said
> I am having a update problem I have a table that has 28 columns they
> are name 1-28. I am able to insert data into the table. When I try to Don Dachner <dachner@(protected) > wrote
> How do I turn on the General log file in version 3.23.52? Can I put an entry in the my.cnf file and reboot?
Yes put the "log " entry in my.cnf and reWebyog has released SQLyog 3.71 & SQLyog Job Agent (
SJA ) v2.0
Some of the major features added in SQLyog 3.71 are -
-- SQLyog Notification Services - This new feature
allows delivery of forSub-select not supported in version you are using.
-----Original Message-----
From Markus K?llander
To mysql@(protected)
Sent 6/9/04 11 25 AM
Subject UPDATE...WHERE ... IN (SELECT...)
"Mark Goldfarb " <Mark@(protected) > wrote
> Hi. Hope someone can help me. I am running MySQL on a NetWare 6.x
> server. I am using Veritas BackupExec. I currently manually copy the
> files befhello-
i am running into trouble compiling on redhat 7.2 (2.4.7-10)
configure and make run without dying - make test however produces the
following output
02 17 35(luna@(protected))/tmp/source/mOn Wed Jun 09 2004 at 01 45 49PM +0100 Marvin Wright wrote
> Hi
>
> We are about to build some new database servers and I have some questions
> which I 'd like some advice on.
>
> The machHow did you install OpenSSL? From source or packages (e.g. debian or rpm).
In
that case you also have to install the dev-Package of OpenSSL
(openssl-dev....)
Sincerly
Oliver
Craig HardingHi
> Is it possible (stable and without data loss -)) to run e.g.
>
> mysql-3.23.40 on Port 3306
>
> and
>
> mysql-4.0.20 on Port 3307
> on the same machine (SuSE Linux with 2.4.4-kernel > Anyway my question is this. If I do a single-statement multi-line insert
> are the auto-increment IDs of the rows inserted guaranteed to be
> sequential? Bear in mind also that I 'm using InnoDB Hello *
a) what could be reason /solution for the following Problem
ERROR 1016 Can 't open file '#sql-407f_f.MRG '. (errno 144)
b) in which directory the below reported intermediate Hi there
just one quick question I didn 't find an answer in the docu
Is it possible (stable and without data loss -)) to run e.g.
mysql-3.23.40 on Port 3306
and
mysql-4.0.20 on May be a full off the filesystem where the relay logbin file is ?
Marc.
-----Message d 'origine-----
De? seho@(protected) [mailto seho@(protected)]
Envoye? mercredi 9 juin 2004 09 46
A? mys
I am having problems installing 4.0.20 (64 bit version) on
Suse 9.1 (64 bit as well).
'mysqld ' and the mysql client segfault on start.
'mysql-max ' appears to be running (but of course the cl-----BEGIN PGP SIGNED MESSAGE-----
Hash SHA1
Hi
MySQL Connector/J 3.1.2 a new version of the Type-IV all-Java JDBC
driver for MySQL has been released.
Version 3.1.2 is a new feature rele
Frank Bax wrote
> At 08 25 PM 6/8/04 Frank Bax wrote
>
> > According to the docs one of the first things I 'm supposed to do is
> > give root a password
> >
> > shell > mysql -u root mysql
MySQL Version 3.23.52 on Red Hat Linux
Trying to establish an ODBC connection to the MySQL server from a windows 2000 server and get the error
"MySQL ODBC Driver ver 03.51.06 "
"Lost Connecti |
|
|
