Hi Daniel,
Actually I've tried the following in the my.ini file:
[mysqld]
default-character-set=big5
[WinMySQLAdmin]
Server=C:/mysql/bin/mysqld-nt.exe
but when I open up the command prompt and enters the mysql monitor, try the
following I got into
something like this:
mysql update table01 set
Hi Paul,
Was the table01 created before you did the new settings and restart the
service?
Because if yes, youhave to recreate the table or rebuild the indexes.
Anyway, I don't really know how chinese double-byte character
representation works. Fortunately the Hungarian language uses the latin
Thanks Daniel,
You've been extremely help already. Thanks a lot! I'll let you know if I
finally manage to get it working.
Thank you once again!
Paul
- Original Message -
From: Daniel Kiss [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, October 30, 2002 4:17 PM
Subject: Re:
Peter,
InnoDB does not allow the index name to be specified in a foreign key
constraint:
The syntax of a foreign key constraint definition in InnoDB:
[CONSTRAINT symbol] FOREIGN KEY (index_col_name, ...)
REFERENCES table_name (index_col_name, ...)
[ON DELETE
Jannie,
- Original Message -
From: Jannie Qu [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, October 29, 2002 10:18 AM
Subject: Create child table question
sql, query, mysql
Hi, all,
I met a problem with creating the following table: pub_user.
-- Parent table
CREATE TABLE
Hi,
To test MySQL I'm migrating a small VB project wich already run with SQLServer2000 to
try ODBC.
I've a problem with two versions of MyODBC (2.50.39 and 3.51.04).
I can connect, make some select... with succes, one update, and my VB program always
crash on an update ! Here is the request,
Hi.
I've got a major filcorruptionissue on my hands. RAID, bad scsi-cables
,Reiserfs for Linux 2.2 and a corrupt backup. That's not a good
combination.
I've managed to salvage a few tables with isamchk, but the most
important tables is missing it's .ISD file. The datafile. The only
files I've
Frederic,
Tuesday, October 29, 2002, 11:49:19 PM, you wrote:
FT What are the possible causes for this error message ?
The possible source of error is the glibc provided by RedHat. Do you use
RedHat? If so, check the mailing list archives, there were a lot of
possible error descriptions during
Hi.
On Tue 2002-10-29 at 16:01:00 -0800, [EMAIL PROTECTED] wrote:
On Tue, Oct 29, 2002 at 03:56:04PM -0800, heath boutwell wrote:
[...]
Load average of 1.5 seems high when we are only averaging 14 queries
per sec (nothing else going crazy running on the box)
procs
Hi!
I am uploading files to a MySQL database. It all works fine for
relatively small files. The biggest I was able to upload was 926K.
However, when I try to upload a 1.3M file I get the following error
message:
Unable to upload file. Error: MySQL server has gone away.
My php.ini settings
Hi all
I have downloaded the latest rpms and added records to HOST,DB,and USER
files in the mysql database.
I am trying to access the database from a web page using a tomcat server
running on the same machine.
I get the following message : Server configuration denies access to data
source.
Am
Hi!
I am uploading files to a MySQL database. It all works fine for
relatively small files. The biggest I was able to upload was 926K.
However, when I try to upload a 1.3M file I get the following error
message:
Unable to upload file. Error: MySQL server has gone away.
My php.ini settings
As promised WAY too long ago, the techniques and tools to create an Apache
/ PHP / MySQL Demo CD are now available. I've made them available for
download, with some documentation, on
http://www.broadowlersystems.co.uk/democd - please feel free to download
and play.
Requires Spoon Installer
Hi,
I would like to know, how can I start a new transaction using InnoDB Tables?
Alexander
mysql, query
___
Yahoo! Encontros
O lugar certo para encontrar a sua alma gêmea.
http://br.encontros.yahoo.com/
Dobrý den,
quarta-feira, 30 de outubro de 2002, 09:40:11, napsal jste:
AB Hi,
AB I would like to know, how can I start a new transaction using InnoDB Tables?
AB Alexander
AB mysql, query
AB ___
AB Yahoo! Encontros
AB O lugar
Greetings,
I would like to know if MySQL allows some way to do
UPDATE SomeTable SET SomeColumn=(SELECT SomeExpression FROM SomeTable,
SomeOtherTable WHERE SomeTable.ForeignKey=SomeOtherTable.PrimaryKey);
Although I had some ideas (like sending SELECT result to a file, deleting
table SomeTable
Kevin Passey wrote:
Hi all
I have downloaded the latest rpms and added records to HOST,DB,and USER
files in the mysql database.
I am trying to access the database from a web page using a tomcat server
running on the same machine.
I get the following message : Server configuration denies
Hi Mark,
Thanks for your response, my problem is that I've done that. It works on a
windows machine running mysql, I've set my Linux machine up the same and it
doesn't work.
The only difference is that I am running MSQL 3.23.51-nt on my windows
machine and the latest rpm's on my Linux machine.
Kevin Passey wrote:
Hi Mark,
Thanks for your response, my problem is that I've done that. It works on a
windows machine running mysql, I've set my Linux machine up the same
and it
doesn't work.
The only difference is that I am running MSQL 3.23.51-nt on my windows
machine and the latest rpm's
How are you connecting your app? DSN, ADO Connection String, DAO, etc...
JFercan
*** sql ***
-Original Message-
From: GAY Samuel [mailto:S.GAY;envergure-conseil.com]
Sent: October 30, 2002 04:47
To: Mail List MySQL (E-mail)
Subject: ODBC problem
Hi,
To test MySQL I'm migrating a
Hi,
I'm having a little trouble.
I've installed mySQL. I've started the service via WinMySQL admin. I was able to
create my databases.
I also installed MySQL-Front and DBTools. The problem is when I startup any of the
tools and try to create a connection I get a MySQL Error -
COnnection
Hi again Mark,
I have completed a re-install from the rpm files MySQL-3.23.53a-1.i386.rpm.
and the client.
I've added in the relevant records to grant myself priv to a database
(marketing) that I have created.
USE mysql;
INSERT INTO host
It's ADODB.
Here is the open code :
[...]
Set sql_connection = New ADODB.Connection
sql_connection.ConnectionTimeout = 10
sql_connection.CommandTimeout = 10
sql_connection.ConnectionString = Data Source=MoniteurReseau
sql_connection.Open
[...]
In my ODBC data source
Here's what I did. Based on the same query (the one you
provided) as below
I executed the following:
select mgrname, pjname from managers, projects, pocs
WHERE pjid = 'x'
AND pocs.pjid = projects.pjid
AND pocs.pmyid = 'x'
AND pocs.altid = 'x'
AND (pocs.pmyid = managers.pmyid OR
I use TINYINT. it stores 0 for false and 1 for true. I tried with enum,
but the communication with MS Access was not happening. In Code you can
treat this as a Boolean and in the UI if you have checkboxes the values of 1
or 0 also work.
HTH.
JFercan
*** sql ***
-Original Message-
Etienne,
Wednesday, October 30, 2002, 1:51:32 PM, you wrote:
ED I would like to know if MySQL allows some way to do
ED UPDATE SomeTable SET SomeColumn=(SELECT SomeExpression FROM SomeTable,
ED SomeOtherTable WHERE SomeTable.ForeignKey=SomeOtherTable.PrimaryKey);
ED Although I had some ideas
Alexander,
Wednesday, October 30, 2002, 1:40:11 PM, you wrote:
AB I would like to know, how can I start a new transaction using InnoDB Tables?
Use BEGIN statement:
http://www.mysql.com/doc/en/COMMIT.html
Don't forget to SET AUTOCOMMIT=0;
--
For technical support contracts, goto
Make sure that Return matching rows is checked in your DSN Configuration.
Also you can try a DSN-Less Connection like
sql_connection.ConnectionString=Driver={MySQL};server=localhost;DB=DBName;U
ID=;PWD=
For MySQL 3.51.04 you have to write Driver={MySQL 3.51.04} for it to work.
HTH
JFernando
For the life of me I can not get mySQL server to start.
Background:
System: Red Hat 8.0
mySQL verion: whatever shipped with 8.0
I think I have read the mysql.com documentation enough to determine either
a. I'm clueless b. I'm clueless or c. all of the above.
I have ran mysql_install_db,
MYTOP reports key eff at 98.30%
+--+---+
| Variable_name| Value |
+--+---+
| Aborted_clients | 58|
| Aborted_connects | 6 |
| Bytes_received | 281234326 |
|
Hello Jason,
just pasting you something what appeared whiles ago...
If you have Redhat, a GLIBC upgrade might have broken
your MySQL installation. (Look in the mailing list archives).
What happens when you telnet to port 3306 on your Linux database server
from the machine Tomcat is running on?
If you stick with 53a let us know what you see. Others that experienced
problems upgrading from .49 reported positive results when trying the 53a
binary.
--- Mark [EMAIL PROTECTED] wrote:
Is this all true? Bummer. :( I just upgraded to 3.23.53 (from .49). I cannot
afford to get these huge
Check the permissions on the files in /var/lib/mysql, they have to be
readable and writable by the user that mysql runs as (usually mysql) if I
recall correctly.
--
Mark P. Hennessy [EMAIL PROTECTED]
On Wed, 30 Oct 2002, Jason Thiesse wrote:
Date:
Jason,
Wednesday, October 30, 2002, 5:15:54 PM, you wrote:
JT For the life of me I can not get mySQL server to start.
JT Background:
JT System: Red Hat 8.0
JT mySQL verion: whatever shipped with 8.0
JT I think I have read the mysql.com documentation enough to determine either
JT a. I'm
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wednesday 30 October 2002 06:06, Jeremy Zawodny wrote:
On Wed, Oct 30, 2002 at 05:56:52AM +0100, Mark wrote:
Is this all true? Bummer. :( I just upgraded to 3.23.53 (from
.49). I cannot afford to get these huge load averages on my news
Hi,
run the safe_mysqld as mysql and not as root. Remove the directories
rm -rf /var/lib/mysql
and create it again as root and then
chown -R mysql.mysql /var/lib/mysql
then as mysql run
mysql_install_db
and again as mysql run
safe_mysqld
Bye.
On Wed, 30 Oct 2002,
On Wed, Oct 30, 2002 at 11:17:44AM +0100, Benjamin Pflugmann wrote:
Hi.
Allow me to disagree. Although most often the symptoms you cite are a
sign that the operation is disk-bound, they are more a sign of
blocking per se, of which the most common cause is disk operation. In
the above case
Dobrý den,
quarta-feira, 30 de outubro de 2002, 13:09:01, napsal jste:
EE Alexander,
EE Wednesday, October 30, 2002, 1:40:11 PM, you wrote:
AB I would like to know, how can I start a new transaction using InnoDB Tables?
EE Use BEGIN statement:
EE http://www.mysql.com/doc/en/COMMIT.html
EE
I used this statement to create a table annotation.
create table annotation
(
user_id int not null NOT NULL,
oai_id varchar(255) NOT NULL,
element varchar(255),
value text,
datestamp varchar(10),
status enum(A, I),
fulltext(value)
);
I then insterted so test data into the
Hi,
we are running mysql 3.23.36 on a redhat 7.1 (intel) server; mysql is installed as RPM.
for some strange reason, the following error appeared in /var/log/msqld.log
over the weekend:
021027 4:02:00 /usr/libexec/mysqld: Binlog closed, cannot RESET MASTER
Status information:
Current locks:
Jason White wrote:
I used this statement to create a table annotation.
create table annotation
(
user_id int not null NOT NULL,
oai_id varchar(255) NOT NULL,
element varchar(255),
value text,
datestamp varchar(10),
status enum(A, I),
fulltext(value)
);
I then
Hi!
I am typing the following at the command line to change the value of a
variable:
mysqld --set-variable max_allowed_packet=1600
And get the following message:
021030 17:08:34 Can't start server: Bind on TCP/IP port: Address
already in use
021030 17:08:34 Do you already have another
How can I do backup of only one DataBase? And How can I do recovery the
data?
I'm working with MySQL ( InnoDB) and I have three DataBase in my TableSpace.
But I would like doing backup of only one.
regards,
Sil
-
Before
Dyego,
BEGIN, not set begin. My understanding is that BEGIN is a synonym for SET
autocommit=0.
PB
-
AB I would like to know, how can I start a new transaction using InnoDB
Tables?
EE Use BEGIN statement:
EE http://www.mysql.com/doc/en/COMMIT.html
EE Don't forget to SET
Mysql
Greetings. I'm doing some tests using innodb for the
first time and last night, during a storm, our
energy system fall, the ups couldn't help. This
happened when we have a substancial number of
connections to the database. When the energy came
back, we realised that the database was
I am typing the following at the command line to change the value of a
variable:
mysqld --set-variable max_allowed_packet=1600
And get the following message:
021030 17:08:34 Can't start server: Bind on TCP/IP port: Address
already in use
021030 17:08:34 Do you already have another
Hey,
Use mysqldump.
See the manual / cli help for how to do it :0
-kees
-Original Message-
From: Silmara [mailto:silmara.sami;uol.com.br]
Sent: Wednesday, October 30, 2002 5:39 PM
To: [EMAIL PROTECTED]
Subject: Backup InnoDB
How can I do backup of only one DataBase? And How
There are two ways to do backups.
1. Backup the files themselves.
2. Use mysqldump to dump the data into a text file which can be read in
by MySQL.
http://www.mysql.com/doc/en/mysqldump.html
We have a database of about 300M it takes 2-3 minutes to do a complete
mysqldump of the data. I would
The info for mysqldump is at:
http://www.mysql.com/doc/en/mysqldump.html
We have a databse of about 300M it takes 2-3 minutes to do a complete
mysqldump of the data. I would recommend, though, saving your larger
tables to a separate file to make the import(if you ever need to do it)
go faster.
From: David Shields [EMAIL PROTECTED]
As promised WAY too long ago, the techniques and tools to create an Apache / PHP /
MySQL Demo CD are now available...
Requires Spoon Installer (included in download), Apache / Mysql / PHP / Visual Basic
6 (blech).
While I appreciate your doing this,
I'm replicating over a local SSH tunnel to a remote machine ... both
MySQL instances have been working fine in the past (and both have their
own binary logs, and only one database is being replicated between the
two). I'm getting this in the error logs:
021030 13:13:25 Slave: connected to
Heath, I once had similar symptoms when my DNS resolving had problems
and all new connections slept for some seconds while they were
waiting for an response. My work-around was to use --skip-name-resolve
until the DNS problem was solved.
Benjamin,
Thanks for the suggestion but the connections
I don't know what I'm doing wrong. I've check the DOC but I can't seem to import a
comma-delimited text file exported from Access into mySQL.
I've created the database, table and fields. WHen I do a Import texfile everything
looks OK via MySQL-Front. My text file contains only commas as
I have a mysql database. Lets say it has a table called maintable with primary
key as main_id. I want to add other tables to the database and use main_id as
foriegn keys in those tables. If I want to start with the last row of the
maintable how can I using a perl script get main_id from the
On Wed, Oct 30, 2002 at 10:20:05AM -0800, heath boutwell wrote:
Heath, I once had similar symptoms when my DNS resolving had problems
and all new connections slept for some seconds while they were
waiting for an response. My work-around was to use --skip-name-resolve
until the DNS problem was
This is what I think.
When Autocommit is set you DO NOT have to enter COMMIT after you update your
DB (Update, Insert Delete), but you will be changing the DB after every
statement, therefore you cannot change your mind after the command is
execute.
Now as for BEGIN, it will begin a Transaction
Hi.
On Wed 2002-10-30 at 10:20:05 -0800, [EMAIL PROTECTED] wrote:
Heath, I once had similar symptoms when my DNS resolving had problems
and all new connections slept for some seconds while they were
waiting for an response. My work-around was to use --skip-name-resolve
until the DNS problem
At 13:20 +0900 10/31/02, Chung Ha-nyung wrote:
Dear,
I'v mailed about this question before and got no complete answer, so
I'm asking
again.
Victoria said that suffix number next to 999 will be 1000 but didn't
mention about the
limit of suffix. I'm wondering whether the suffix number always
58 matches
Mail list logo
