Jochem,
- Original Message -
From: Jochem van Dieten [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Saturday, February 21, 2004 2:10 AM
Subject: Re: InnoDB Hot Backup + MySQL embedded?
Sasha Pachev wrote:
Heikki Tuuri wrote:
C versus object-oriented lanuguages like
Hi,
this discussion is useless, object or procedure is not realy the question.
You need to know how to build a good programm, if you cannot create a good programm,
no matter what language.
The amount of realy bad java-programs (90% i have seen were realy bad) shows,
that it is maybe not a good
Hi,
From: [EMAIL PROTECTED]
Sent: Saturday, February 21, 2004 10:28 AM
win32:
Hello! me just download mysql of windows edition,and me have
installed,on the local macheine me have successed.but me have two
question :
one is :if my tool is PowerBuilder ,how to connect to mysql?
Hello James,
thanks for your answer, but max_connections is set high enough (double
the number of the currently used threads). I think the error would be
Too many connections, wouldn't it?
-Christof
James Kelty wrote:
Check the max_connections variable
Mysql show variables liks
Hello,
Personally, I think it's a matter of choosing the best tool for the job.
For myself and my team, Java is the work horse particularly - suited for
rapid application development and when there is a strong cross platform
requirement. This means that Java tends to dominate our utilities and
George Mathew [EMAIL PROTECTED] wrote:
Seems to be the binary log saves all INSERT statements, even if it is
a duplicate error.
Only successfully executed INSERTs are written to the binary logs.
How could I restore my table using mysqlbinlog if there
are duplicates in the log file.
What
Heikki Tuuri wrote:
From: Jochem van Dieten
Sasha Pachev wrote:
In Java is it easy to write a program that wastes large amounts of
memory, which is worse than a leak. In C, you are full from the start,
and then you leak a drop at a time until you are empty. In Java , you
are empty from the start,
We have a web server where users connect to mysql in scripts, etc., via
the host name localhost. We would also like for them to be able to
manage their databases from their office dekstops with various
utilities. If we grant rights to [EMAIL PROTECTED], they can connect
from the web/mysql
Hi:
I just installed MySql 4.0.18 on a Mac OS/X Powerbook computer running
Panther (Mac OS 10.3). When I try to start the mysqld_safe daemon, I
get the following error:
{/usr/local/mysql/docs}% sudo mysqld_safe
Password:
Starting mysqld daemon with databases from /usr/local/mysql/data
040221
On Sat, 2004-02-21 at 20:39, Franz, Fa. PostDirekt MA wrote:
Hi,
this discussion is useless, object or procedure is not realy the question.
You need to know how to build a good programm, if you cannot create a good programm,
no matter what language.
Originally, I was asking Heikki's opinion
Can anyone tell me whether or not some kind of RAID will improve the
seek/access times during lots of random reads from, say, MyISAM data
files? I *do not care* about improved [sequential] transfer rates; I
want the fastest possible random access.
RAID will only help reduce the average
Enrique Ibarra [EMAIL PROTECTED] wrote:
Hi:
I just installed MySql 4.0.18 on a Mac OS/X Powerbook computer running
Panther (Mac OS 10.3). When I try to start the mysqld_safe daemon, I
get the following error:
{/usr/local/mysql/docs}% sudo mysqld_safe
Password:
Starting mysqld daemon
I am new to most aspects of MySQL administration so I was wondering if
someone can help me figure out what GRANTs I need fora
particularsituation.
I have a userwho needs to be able to run some MySQL scripts that
create and load tables in a database named NFL. He is accessing MySQL remotely
I prefer TCL because on my opinion it is the best of both worlds
( i never had a memleak except with a bad API written in C).
Bad...written in C...was it a SCO library?
Complex tasks should be done from skilled programmers - thats all.
Additionally, complex tasks should be decomposed into
Rhino [EMAIL PROTECTED] wrote:
I am new to most aspects of MySQL administration so I was wondering if someone can
help me figure out what GRANTs I need for a particular situation.
I have a user who needs to be able to run some MySQL scripts that create and load
tables in a database named
Jason Joines [EMAIL PROTECTED] wrote:
We have a web server where users connect to mysql in scripts, etc., via
the host name localhost. We would also like for them to be able to
manage their databases from their office dekstops with various
utilities. If we grant rights to [EMAIL
At 8:21 -0600 2/21/04, Jason Joines wrote:
We have a web server where users connect to mysql in scripts,
etc., via the host name localhost. We would also like for them to
be able to manage their databases from their office dekstops with
various utilities. If we grant rights to [EMAIL
Can I just do a clean shutdown of MySQL, change my configured
innodb_log_file_size, then restart? Or is there more I need
to do to make sure the current log files are flushed to the
data files before changing their size?
Thanks -keith
--
MySQL General Mailing List
For list archives:
Followup questions interspersed below
- Original Message -
From: Egor Egorov [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, February 21, 2004 12:29 PM
Subject: Re: GRANT question
Rhino [EMAIL PROTECTED] wrote:
I am new to most aspects of MySQL administration so I was
At 13:09 -0500 2/21/04, Rhino wrote:
Followup questions interspersed below
- Original Message -
From: Egor Egorov [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, February 21, 2004 12:29 PM
Subject: Re: GRANT question
Rhino [EMAIL PROTECTED] wrote:
I am new to most aspects
I've noticed a 4 times insert speed improvement by moving the MYI index
file of a myisam table to a ramdisk. The MYD file is still on a physical
disk, and I benchmarked the difference between moving just the index
file, or moving both, and it was only a 10% difference in speed. The
table has a
Keith Thompson [EMAIL PROTECTED] wrote:
Can I just do a clean shutdown of MySQL, change my configured
innodb_log_file_size, then restart? Or is there more I need
to do to make sure the current log files are flushed to the
data files before changing their size?
Shutdown MySQL server. Copy old
I would say using C in C++ compiler or C++ itself is best. come see my
http://www.DhakaStockExchangeGame.com , its totally written C++.
My upcoming NYSEGame.com is also using C++. This time I made 4 base
classes to handle the whole thing . Soon I will make those class public.
Pete McNeil
More followups below
- Original Message -
From: Paul DuBois [EMAIL PROTECTED]
To: Rhino [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Saturday, February 21, 2004 1:25 PM
Subject: Re: GRANT question
At 13:09 -0500 2/21/04, Rhino wrote:
Followup questions interspersed below
Anyone using TONS of Query Cache for a high-traffic site?
Our search server is really sweating.
I was about to jump through a LOT of software loops to program
query caching at the app level, when I realized that MySQL had
it built-in already. (We're using newest: 4.0.18)
Seems we've got plenty
At 14:30 -0500 2/21/04, Rhino wrote:
More followups below
1. Why is this happening? The Load Data article says he needs the
File
privilege and I've given it to him. He also has all privileges on the NFL
database. What more do I need to do for him?
FILE is a global level
Thanks, that clears things up pretty well.
By the way, since you're on the documentation team, can you tell me what the
official channels are for making suggestions about the documentation. I
have some ideas about how to make it better
Rhino
--
MySQL General Mailing List
For list
At 14:56 -0500 2/21/04, Rhino wrote:
Thanks, that clears things up pretty well.
By the way, since you're on the documentation team, can you tell me what the
official channels are for making suggestions about the documentation. I
have some ideas about how to make it better
Mail to [EMAIL
After running in production for about seven weeks, our dumps on one of
our BDB tables performed with mysqldump began failing with the message:
'mysqldump: Error 1030: Got error 12 from table handler when dumping
table `reference` at row: 255233'.
Reviewing the error log and the MySQL doc, I
hi!
A == Arunachalam [EMAIL PROTECTED] writes:
A Hai MySQLians!!!
A I have established the Successful Connection to MySQL from COBOL.
A Now from COBOL I can able to query the MySQL and get back the
A result sets using C APIs under MySQL 4.0.17-max both in windows
A and Linux. Note that my
Hi Victoria,
that's exactly what I needed. Works fine.
I know Subselects only from Intrbas/Firebird so far. I know that I can pass
a SELECT to the list of columns of a SELECT if it only returns one result
(one col, one row). So I thought/hoped/imagined/expected I can pass a SELECT
returning
Help, I seem to be running into a problem with replication which up until
now has served us well.
We run mysql servers in pairs, with each server in a pair mastering off the
other. So for example mysql1 masters off mysql2, which masters off mysql1.
Friday morning one server stopped accepting
Paul DuBois wrote:
At 8:21 -0600 2/21/04, Jason Joines wrote:
We have a web server where users connect to mysql in scripts,
etc., via the host name localhost. We would also like for them to be
able to manage their databases from their office dekstops with various
utilities. If we grant
At 18:04 -0600 2/21/04, Jason Joines wrote:
Paul DuBois wrote:
At 8:21 -0600 2/21/04, Jason Joines wrote:
We have a web server where users connect to mysql in scripts,
etc., via the host name localhost. We would also like for them to
be able to manage their databases from their office
I would like to encrypt informaton in MySQL DB using the AES_ENCRYPT
function, but what if someone looks into the log files?
Unfortunately, i cannot prevent access to that computer...
FBR
Hi my nma eis rick and I am new to the above listed
program (linux aswell) and have encounted a problem
which I cannot fix I have DL'd you 1.7.5 static
mysqlgui , unpacked it , When i open the folder and
hit the exe all it does is show me the splash screen
and then in my console it says mysqlgui
I have a table
create table friend(
f_code int(7) not null AUTO_INCREMENT,
c_name varchar(20), //Use to store Chinese Name
e_name varchar(50) //use to store English Name
);
in which table i set to use Charset (UTF-8).
But When i use mysqlmysqldump -u myname -p mypwd telbookbook.txt, all string
in which table i set to use Charset (UTF-8).
But When i use mysqlmysqldump -u myname -p mypwd telbookbook.txt, all
string of table friend's c_name will become ?.
Have you tried:
mysqldump --default-character-set=utf8 -u myname -p mypwd telbookbook.txt
If that doesn't work, which version
38 matches
Mail list logo