> in which table i set to use Charset (UTF-8).
> But When i use "mysql>mysqldump -u myname -p mypwd telbook>book.txt", all
> string of table friend's c_name will become "?".
Have you tried:
mysqldump --default-character-set=utf8 -u myname -p mypwd telbook>book.txt
If that doesn't work, which
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 "mysql>mysqldump -u myname -p mypwd telbook>book.txt", all strin
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 s
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
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 dekst
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 ri
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 conn
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 multip
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. No
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 see
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 PROT
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 archiv
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
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 o
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 belo
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 wrote
"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. C
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 larg
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 mos
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
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: http://li
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 PROTECTE
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 [EMA
"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
>> 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 int
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 NFL. He is accessing MySQL remote
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 my
>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 r
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 opin
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 00
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 se
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,
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.
Wha
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
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 '%connectio
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 conne
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 ide
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 lanuguage
38 matches
Mail list logo
