How are you importing the dump into mysql? Importing by piping the dump
file to mysql may broke some chars due to shell.
Have you tried this: (with in mysql client)
SET NAMES UTF8; SET CHARACTER SET UTF8
source /pathto/dump.sql
Cheers,
--Ravi
Sean O'Hara wrote:
Hi All,
I've been googling
Hi,
I have a question about Mysql C library function mysql_close. If my
program doesn't invoke mysql_close before exiting, is there any side
effect?
I don't know whether this is the proper list I should send email for this
topic. If I should send my email to another topic, which list is
Hi,
Yes Aborted connects will start increasing than the connections.
Thanks Regards
Dilipkumar
- Original Message -
From: ��?��╁�� [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Wednesday, August 02, 2006 11:34 AM
Subject: One question about mysql_close
Hi,
I have a question
Hi,
Though I understand very well that it has been discussed lots of time
before but I don't have time to browse through the previous archives
and dig out the stuff I need. So, guys, I would be thankful if you
could give me your valuable advice that I need right now.
I just need to know
On Wednesday 02 August 2006 09:28, Asif Lodhi wrote:
Hi,
Though I understand very well that it has been discussed lots of time
before but I don't have time to browse through the previous archives
and dig out the stuff I need. So, guys, I would be thankful if you
could give me your valuable
I have a problem about the performance of federated engine. The mysql5.0
reference manual says that the FEDERATED tables do not work with the query
cache, aren't they? How about the query cache used by the federated engine in
the mysql5.1?
If the query cache cann't be used with the
How does the federated engine table work when the query statement include a
join substatement, it joins a local table with innodb engine and a federated
table. How does the server deal with the query substatement like this?
I have a question about the query against to the federated engine tables.
As the following example:
select Id,name from e01_system.category
Note: the e01_system.category is a federated table.
I select only tow fields from the federated table category with the above
sql
Hi Dilipkumar,
I checked the output of show slave status, and memorize;
RELAY_MASTER_LOG_FILE, and EXEC_MASTER_LOG_POS.
Then,
change master to
master_log_file='xx,
master_log_pos=xx;
However, still I get the same error message.
Umm.
Kenji
On 8/2/06, Dilipkumar [EMAIL PROTECTED]
Hi,
First reset slave and then change master to script run it.
Thanks Regards
Dilipkumar
- Original Message -
From: Kenji HIROHAMA [EMAIL PROTECTED]
To: Dilipkumar [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Sent: Wednesday, August 02, 2006 3:29 PM
Subject: Re: Relay Log Lost on
Hi,
I am developing a VB6 app with a MySQL-5.0.22/WinXP backend. I have
skimmed the Stored Procedures/Triggers docs and it looks like I can
define custom error-names or number - though I have also seen the
Handlers in the same doc.
The question is: Can I get the error-codes or error-names
Have you checked out MyConnector/NET and the MySqlException class?
-Original Message-
From: Asif Lodhi [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 02, 2006 6:17 AM
To: mysql@lists.mysql.com
Subject: Database Return Errors
Hi,
I am developing a VB6 app with a MySQL-5.0.22/WinXP
Hello there
I just finished installing mysql 5 on my linux server and I reset the root
password as an initial post-install setting.
now that i try to connnect from other machines in the network I always get a
message similar to the following:
C:\Documents and Settings\msentissimysql -u root -h
They are user defined properties.
-Original Message-
From: Jay Pipes [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 01, 2006 8:11 PM
To: Robert DiFalco
Cc: mysql@lists.mysql.com
Subject: Re: Query Help for Loosely Couple Properties
On Tue, 2006-08-01 at 16:23 -0700, Robert DiFalco
Simo Sentissi schrieb:
Hello there
I just finished installing mysql 5 on my linux server and I reset the root
password as an initial post-install setting.
now that i try to connnect from other machines in the network I always get a
message similar to the following:
C:\Documents and
Hi ALL
I am getting the below error
[EMAIL PROTECTED] drupal]# mysqldump --tab=/usr/local/drupal/drupalbckup/ --opt
drupal
mysqldump: Got error: 1: Can't create/write to file
'/usr/local/drupal/drupalbckup/access.txt' (Errcode: 13) when
executing 'SELECT INTO OUTFILE'
Thanks and Regards
I am getting the below error
[EMAIL PROTECTED] drupal]# mysqldump --tab=/usr/local/drupal/drupalbckup/ --opt
drupal
mysqldump: Got error: 1: Can't create/write to file
'/usr/local/drupal/drupalbckup/access.txt' (Errcode: 13) when
executing 'SELECT INTO OUTFILE'
Change the owner of that
Hello folks.
How do I determine what is the safest value that I can set for
max_connections in my.cnf? The default value of 100 is proving to be a
shortfall during some cases of peak hour traffic.
Could you point me to a resource available if any?
1. Our server is RHEL 3, 2*3.00 GHz, 4GB
Thanks Ravi. That definitely did help.
However, the scenario that I wish to monitor is when there are a lot of
sleeping threads, it is peak-hour, and the number of threads is dangerously
near to the max_connections value. Hence, I would want to log similar
information as described in the blog,
[EMAIL PROTECTED] drupal]# mysqldump --tab=/usr/local/drupal/drupalbckup/
--opt
drupal
mysqldump: Got error: 1: Can't create/write to file
'/usr/local/drupal/drupalbckup/access.txt' (Errcode: 13) when
executing 'SELECT INTO OUTFILE'
Change the owner of that directory so the mysql server
Dear MySQL,
I am getting an unexpected crash in MySQL 5.1.6, with nothing written to
the log.
This happens with InnoDB tables and an Foreign Key error.
Tables are something like:
CREATE TABLE tax (
`type` varchar(8) NOT NULL,
PRIMARY KEY (`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
MySQL,
After thinking hard on the subject, I realise the server in question was
running a data set from an InnoDB HotBackup. (Which is on trial so I
have no support.)
The source machine is a PowerPC IBM. The crashing server is an Intel
Pentium. The difference being that one is
Tripp, YMMV, but I'm a firm believer that keeping things as simple as
possible pays big dividends.
I believe the advice to spread out IO tasks among different disks is
good advice, when dealing with direct-attached disks you deal with
directly (i.e. not part of a RAID). The setup and
http://downloads.mysql.com/archives.php?p=mysql-5.0
On 8/1/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
n http://dev.mysql.com/downloads/
Look for older releases
Thanks but I want an older _build_ of the 5.0 release, not an older
release.
--
MySQL General Mailing List
For list archives:
I have two tables:
MEMBERS:
MEM_ID
...
GROUPS:
GRO_ID:
...
And one joiner
MEM_GRO:
MEM_ID, GRO_ID
I want to print out a list like this
GROUP_NAME, NUMBER_OF_MEMBERS
Even when the number of members is 0, how do I do that?
--
MySQL General Mailing List
For list archives:
--On August 2, 2006 5:25:51 PM +0800 wangxu [EMAIL PROTECTED] wrote:
I have a problem about the performance of federated engine. The
mysql5.0 reference manual says that the FEDERATED tables do not work with
the query cache, aren't they? How about the query cache used by the
federated
I'd recommend RAID 10 - with 4 disks instead of 2, you'll roughly
double performance over RAID 1, both for reading and writing.
You might also look at 6 disks - 4 73's in RAID 10 for your data, plus
2 smaller, slower less expensive disks in RAID 1 (18 gb or 36 gb
maybe) for your boot disks.
As
Though I understand very well that it has been discussed lots of time
before but I don't have time to browse through the previous archives
and dig out the stuff I need. So, guys, I would be thankful if you
could give me your valuable advice that I need right now.
I just need to know
I have two databases that effect each other when triggers get excecuted.
There is a schedules database that updates registration database. The
problem I have is with the enrolled, attended, waitlisted, completed,
cancelled, etc. booleans values. The registration db has triggers on it that
enforce
You know this might be a little bit more convincing if you gave the name of the
product and a little bit more personal reason why you recommended it other than
check out brand x product I vote this is spam.
-Original Message-
From: itguy321 [mailto:[EMAIL PROTECTED]
Sent: Wednesday,
Mee too.
John Meyer [EMAIL PROTECTED] escreveu na mensagem
news:[EMAIL PROTECTED]@gmail.com...
You know this might be a little bit more convincing if you gave the name of
the product and a little bit more personal reason why you recommended it
other than check out brand x product I vote this
I'm not sure why you split out track, track is really kind of an attribute of a song. Especially since you have artist and album
with the song. Wouldn't album be the same as cd title? I'm not quite getting the logic of your schema.
It would have been helpful if you provided your current query.
hi...
i have a tbl
fooTBL
name
parentID
ID
so a name can have might have a parentID, as well as an ID. 'name's are
associated with other 'name's via the parentID. in other words, if a name's
parentID == a name's ID, name1 is the parent of name2.
ie
nameparentID
I've dealt with this in terms of Books and Titles. Those two are separate:
one title can have many book editions published in it. Also, you can have a
book with multiple titles (anthology, for instance).
I suppose it is possible for album not to be the same as cd title,
particularly if you have
itguy321 wrote:
(garbage snipped)
http://www.ecora.com/ecora/products/documentor.asp
Full original spam source at end, for the benefit of our CCs.
Reports sent, omitting the MySQL hosts obviously. Ignoring the bogus
yahoo address, the actual sender and the spamvertised host have been
Bruce,
my question, how can i come up with a sql query that will list all the
children (and children's children...) of a top level item?
This is an edge list tree model, ID being the child node, parentID being
the parent node, the row denoting the edge between ID and parentID.
Unless you
hi peter...
tried to get to the link...saw that it's 'localhost'!!
what's the real/actual url...
-bruce
-Original Message-
From: Peter Brawley [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 02, 2006 2:15 PM
To: [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Subject: Re: logic/db
RAID 10 = good choice.
I've worked a lot more with MyISAM, where OPTIMIZE TABLE does lock it
for the duration. I note that for InnoDB, OPTIMIZE TABLE is mapped to
ALTER TABLE, and so I expect it will be locked for the duration as
well. Perhaps someone else can confirm - all my InnoDB tables
select g.GROUP_NAME, count(mg.MEM_ID) as NUMBER_OF_MEMBERS from GROUPS g
left join MEM_GRO mg using(GRO_ID) group by g.GRO_ID
John Meyer wrote:
I have two tables:
MEMBERS:
MEM_ID
...
GROUPS:
GRO_ID:
...
And one joiner
MEM_GRO:
MEM_ID, GRO_ID
I want to print out a list like this
Yeah, I just figured it out ten minutes ago, one of those stupid little
oversites on my part.
-Original Message-
From: Martin Jespersen [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 02, 2006 3:40 PM
To: John Meyer
Cc: mysql@lists.mysql.com
Subject: Re: Doing a join
select
Bruce
tried to get to the link...saw that it's 'localhost'!!
Sorry! http://www.artfulsoftware.com/mysqlbook/sampler/mysqled1ch20.html
PB
-
bruce wrote:
hi peter...
tried to get to the link...saw that it's 'localhost'!!
what's the real/actual url...
-bruce
-Original
Hi!
I'm getting a lot of pushback on using mysql for full-text searching on over
30,000,000 documents. It's starting to slow down when using more than 10-15
keywords. Is there an alternative anyone is using?
I don't want to replace the database, but I do need to speed up the keyword
search.
hi..
i have FC3, with 4.1.13, i also have FC4 with 4.1.20. however, i can't seem
to find 5.0.x RPMs for FC3/4. do i have to go ahead and build this from
source for the FC3/4 boxes that i have...
thanks
-bruce
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
Rob Munsch,
I am a member of the Nabble project. This is regarding a bad post by user
itguy321.
Just want to explain a few things. Nabble is a free mailing list
archive/gateway that works like Gmane. Users can browse, search, and post
via Nabble's web interface and the post will be forwarded
On Tue, 2006-08-01 at 16:23 -0700, Robert DiFalco wrote:
The question is, how do I query this? Say I want all records from table
T whose COLOR property value is ORANGE.
The only thing I can come up with (and I'm no SQL expert and this looks
wrong to me) is the following:
SELECT *
FROM T
On Wed, 2006-08-02 at 11:13 -0600, John Meyer wrote:
I have two tables:
MEMBERS:
MEM_ID
...
GROUPS:
GRO_ID:
...
And one joiner
MEM_GRO:
MEM_ID, GRO_ID
I want to print out a list like this
GROUP_NAME, NUMBER_OF_MEMBERS
Even when the number of members is 0, how do I do
You can tune the fulltext search in a few ways using the config, try
read up on the various server variables that has to do with fulltext
indexing. Other than that there is always the option of upgrading the
hardware :)
[EMAIL PROTECTED] wrote:
Hi!
I'm getting a lot of pushback on using
Sorry, but that's how I was normally trained to use SQL and to name
variables. I know netiquette, it's just how I was trained on the system.
-Original Message-
From: Jay Pipes [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 02, 2006 11:35 AM
To: John Meyer
Cc: mysql@lists.mysql.com
Hi,
up to now my idea of how MySQL uses indexes was, that when I have a WHERE
clause with several fields and I have an index on each field, MySQL chooses
one index (from which it thinks that it will return the fewest rows when
matched again the condition) and uses this index to select a couple of
It depends what you need and how your data looks.
Say you have a table with 4 columns:
col1 has 1000 dictinct values
col2 has 1 dictinct values
col3 has 100 dictinct values
col4 has 10 dictinct values
In this case:
select col1,col2 from tbl where col1=... and col2=...
Having a single
Forgive the mess I present you, this is a strangely done site with a even
stranger structure and methodology that I am trying to work with.
The basic idea is one website has multiple websites in it. So if you place
an order with website A, orders_A is where the data is stored, if you place
an
At 05:27 PM 8/2/2006, you wrote:
Hi!
I'm getting a lot of pushback on using mysql for full-text searching on
over 30,000,000 documents. It's starting to slow down when using more than
10-15 keywords. Is there an alternative anyone is using?
I don't want to replace the database, but I do
Yes, I did so...
I will check the other configuration.
Thanks,
Kenji
On 8/2/06, Dilipkumar [EMAIL PROTECTED] wrote:
Hi,
First reset slave and then change master to script run it.
Thanks Regards
Dilipkumar
- Original Message -
From: Kenji HIROHAMA [EMAIL PROTECTED]
To: Dilipkumar
just to clarify to Brent, the songs lists the original artist and album. the
CD table is for the information for a NEW mix CD. that CD contains the
tracks listed in the tracks table, which point back to the individual songs.
the reason the tracks are not listed in the songs table, is because they
Back with another registration db question:
Have a convention database which tracks people as they register all year
long; the actual convention is held in October. I've got a fairly simple
query which shows how many people registered in each calendar month--useful
to compare to prior year
Barry
It would make life easier if I could also show a column
with the cumulative count for each month.
Set @cum - 0;
Select
Monthname(DatePaid) Month,
Year(DatePaid) Year,
Count(*) as Registrations,
Extract(Year_Month from DatePaid) AS Monindex,
@cum := @cum + Count(*) AS 'Year
At 11:10 PM 8/2/2006, Peter Brawley wrote:
Barry
It would make life easier if I could also show a column
with the cumulative count for each month.
Set @cum - 0;
Select
Monthname(DatePaid) Month,
Year(DatePaid) Year,
Count(*) as Registrations,
Extract(Year_Month from DatePaid)
Hi ALL
I have taken backup of http://mydomain.com/?q=admin/database through
drupal 4.6.3 by selecting all tables and it asked me to save as
backup.sql.
Now when i run
[EMAIL PROTECTED] root]# mysql -u kaushal -h bdc31096e.in.office.aol.com -p
drupal /home/kaushal/drupal/backup.sql
Enter
Looks like drupal had an error when doing the backup - mysql is
complaining over the fact that your backup.sql file contains a html
formated fatal error message.
Kaushal Shriyan wrote:
Hi ALL
I have taken backup of http://mydomain.com/?q=admin/database through
drupal 4.6.3 by selecting all
59 matches
Mail list logo
