Gleb Paharenko wrote:
Hello.
Use skip-innodb, this should prevent MySQL from InnoDB initialization.
Remigiusz Soko$owski [EMAIL PROTECTED] wrote:
Hello!
Do You know if myISAM-specific settings have any impact on database
performance,
if the only MyISAM database is
Hi,
I have mysql 4.1.12 started with the default charset 'koi8r' and I have
the following problem: when connecting from PHP, the default
results and connection charsets become latin1, so all not-latin characters
get lost (they are displayed as ?). Of cause, if I explicitely set these
Hi all,
sometimes life would be easier with a more general 'REPLACE' function
available. That's when I find mysqlf dumping a database, editing with sed
and reloading.
My feature request: a string editing function similar to sed's
s/regexp/replacement/ command to work on the contents of CHAR,
Hi,
I've read the whole
chapter 10 but I
haven't found any
instructions on how
to setup a UTF-8
database...
Is there any guide
on how to setup this
?
Thanks for any help
Regards
Roberto
Gleb Paharenko
[EMAIL PROTECTED]
wrote:
Hello.
First read:
Dear Guys,
I have been stucked in loading file using load data local infile command.
At first it is loading a null value on my first record followed with
one record from my input file. The rest are ignored and i've been
receiving lots of warnings.
I tried converting the text file into a csv
Hello,
If got a simple sessions table basically holds a session id and datetime
field for last modification also a session type, so I can have several
records with the same session id, with different types and different
modification time. I want to get the latest modified record for any given
We stumbled upon the following 'feature' of MySQL:
If, for example user 'x' has a database called 'user_data' he is able to
create a table called user2data and so on without create privileges.
It looks like the underscore is used as some kind of wildcard, now is the
question: is this correct
Hi!
I'm a hosting provider with several thousands of Mysql Databases under 4.0
version. I'm specially worried about TIMESTAMP format changes you did in
4.1. I'll have to update database server soon to have my systems updated.
I think that if i update my server version thousands of tables
Hi!
I'm a hosting provider with several thousands of Mysql Databases under 4.0
version. I'm specially worried about TIMESTAMP format changes you did in
4.1. I'll have to update database server soon to have my systems updated.
I think that if i update my server version thousands of tables
Dear Friends,
Iam trying to install MySQL 4.1.x in Windows 2003
Server, and on error occurs when installation try a
start de service. The service does not start and
installation don't finish.
I Try install and reinstall many times and all fail
My WIndows is a 2003 Server SP1
I Need a
Try adding max(session_modified).
SELECT *,max(session_modified) AS LastMod FROM translines GROUP BY
session_id ORDER BY session_modified DESC
On Jun 29, 2005, at 8:00 AM, Lee Denny wrote:
Hello,
If got a simple sessions table basically holds a session id and
datetime
field for last
Carlos J Souza wrote:
Dear Friends,
Iam trying to install MySQL 4.1.x in Windows 2003
Server, and on error occurs when installation try a
start de service. The service does not start and
installation don't finish.
I Try install and reinstall many times and all fail
My WIndows is a 2003
There may well be a way to do what you want but I'd like to make a brief
point then let other people with more time give you the answer you want.
Simply put, GROUP BY is NOT intended to give you a specific record out of a
group the way that you are trying to do. It's job is to do SUMMARIZATION of
Carlos J Souza wrote:
The error as follows:
when installation is try to finish, the install try a start de new service MYSQL
4 and does not success
I try the install and reinstall many times and nothing.
Regards
On Wed, 29 Jun 2005 08:39:51 -0400, JamesDR wrote:
Carlos J Souza wrote:
Hi,
I'll tell you what did my provider (http://www.claranet.fr ) to
upgrade from 3.23 to 4.1.
They setup a new server with new hardware and a clean new 4.1.11 on
it. Then I have available the old 3.23 and the new 4.1. They let me
the choice on which server, the DB are created. So the customer has
That I'd love to have a regex_replace available in MySQL !!
2005/6/29, Thomas Spahni [EMAIL PROTECTED]:
Hi all,
sometimes life would be easier with a more general 'REPLACE' function
available. That's when I find mysqlf dumping a database, editing with sed
and reloading.
My feature
Description:
050628 17:29:14 mysqld started
050628 17:29:14 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
050628
I need in depth information on the character set used by MySQL including
invisible/escape characters/codes. Is there online documentation that I
can read on this? Thanks.
- Asad
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Lee Denny [EMAIL PROTECTED] wrote on 06/29/2005 08:00:49 AM:
Hello,
If got a simple sessions table basically holds a session id and datetime
field for last modification also a session type, so I can have several
records with the same session id, with different types and different
Your syslog8.txt file has two problems:
1. The first field, log_date, is in m/d/ format. It will not be
converted by MySQL automatically. It needs to be in -mm-dd format.
For this reason, all records will have the default value of '-00-00'
for that field.
2. The primary key
Can I vote for just enabling FULL regex support? Let's get it all working
(pattern matches (already done), substring replaces, pattern extraction,
everything else...).
Shawn
Pooly [EMAIL PROTECTED] wrote on 06/29/2005 09:31:24 AM:
That I'd love to have a regex_replace available in MySQL !!
Hi Carlos,
My suggestion for this problem is, just uninstall the
MySQL Server and manually delete all the corresponding
files, restart the system once (not a must, but it's a
advisable), then u install the MySQL, hope now it'll
definitely work.
This is happening because of mis-configuration b/w
I recall seeing this feature discussed on Bugtraq a few weeks ago.
IIRC there are updated MySQL versions that fix this bug. What version
of MySQL are you running?
-Original Message-
From: Jeroen Bosch [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 29, 2005 6:59 AM
To:
Hello.
to file '/var/run/mysqld/mysqld.pid' (Errcode: 2)
MySQL tries to create mysqld.pid in /var/run/mysqld ('d' at the end) not
in /var/run/mysql directory.
Description:
050628 17:29:14 mysqld started
050628 17:29:14 InnoDB: Database was not shut down normally!
Hello.
This page contains information about escape characters:
http://dev.mysql.com/doc/mysql/en/string-syntax.html
The general information about character set could be found at:
http://dev.mysql.com/doc/mysql/en/charset.html
Asad Habib [EMAIL PROTECTED] wrote:
I need in depth
Hello.
If you want to setup such kind of database you could put
all necessary variables to your configuration file, then restart
the server and create a new database. For example:
[mysqld]
default_character_set=utf8
[client]
default_character_set=utf8
Check with
Hello.
Very often similar error occurs when you didn't remove
service from previous MySQL installation. See:
http://dev.mysql.com/doc/mysql/en/windows-troubleshooting.html
Carlos J Souza [EMAIL PROTECTED] wrote:
Dear Friends,
=A0
Iam trying to install MySQL 4.1.x in Windows
Privet.
As I know, PHP usually takes the character set from the server.
Please send part of your configuration file related to character sets.
Varshavchick Alexander [EMAIL PROTECTED] wrote:
Hi,
I have mysql 4.1.12 started with the default charset 'koi8r' and I have
the
Hello.
Could you give a test case? For example I've done these steps, and user
u1 couldn't create tables in other databases.
grant all privileges on `user\_data`.* to 'u1'@'localhost' identified by
'u1';
grant select on user2data.* to [EMAIL PROTECTED];
Then I've logged in as u1.
This is not a bug. Mysql uses _ as the single-character wildcard, and % as
the multi-character wildcard in pattern matches. This is clearly explained in
the manual http://dev.mysql.com/doc/mysql/en/grant.html:
Note: the '_' and '%' wildcards are allowed when specifying database
names in
Hi everybody, i would like to find benchmarks whose work with mysql-max.
I tested osdb 0.14 (http://osdb.sourceforge.net/). But i search other
benchmarks to have others results. I work on mysql-cluster. If you know
some of them please send me an email to [EMAIL PROTECTED]
cordially,
Etienne
Just so. What I was referring to were these reports:
http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=285276
http://cve.mitre.org/cgi-bin/cvename.cgi?name=CAN-2004-0957
As documented, this is clearly a feature, and not a bug.
-Original Message-
From: Michael Stassen [mailto:[EMAIL
On Tue, Jun 28, 2005 at 10:37:43PM -0700, mike wrote:
I'm compiling my mysql server from source.
I have started noticing this as of 4.1.10 - in fact, I was running
4.1.12 and it's changed the LinuxThreads detection (since LT does not
exist on amd64) - and 4.1.12 kept locking up after only a
Hello,
Please excuse me if this has been posted in the wrong spot.
I'm storing historical information in a MySQL database and am using the date
field formatted in -MM-DD.
For the most part, the data entered is correct and uses the full -MM-DD
format, however, I've got numerous dates
On 6/29/05, me you wrote:
For the most part, the data entered is correct and uses the full -MM-DD
format, however, I've got numerous dates that are incomplete. For example:
an event happened in 1967, but the exact month and day are not known. I've
been storing that data, in other forms,
It's probably much faster to do this in perl, since the use of @row
means MySQL can't use its query cache.
--
Jamie McCarthy
http://mccarthy.vg/
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
671 Did not find any old versions with SELECT cJobTitle FROM jobtitlecount
WHERE fkJobPosting = 209689 AND dtSnapShot = '2005-06-26', attempt to insert
one: INSERT INTO jobtitlecount (fkJobPosting, dtSnapShot, cJobTitle) VALUES
(209689,'2005-06-26',1)
671 Did not find any old versions with SELECT
Siegfried Heintze [EMAIL PROTECTED] wrote on 06/29/2005 03:09:28
PM:
671 Did not find any old versions with SELECT cJobTitle FROM
jobtitlecount
WHERE fkJobPosting = 209689 AND dtSnapShot = '2005-06-26', attempt to
insert
one: INSERT INTO jobtitlecount (fkJobPosting, dtSnapShot, cJobTitle)
Sorry, I accidentally pasted some garbage at the beginning of that last
email message. Here is what I intended:
I first check to see if the record exists:
SELECT cJobTitle FROM jobtitlecount WHERE fkJobPosting = 209689 AND
dtSnapShot = '2005-06-26'
When I don't find an entry, I try an insert:
Michael,
You are very correct - I renamed those fields and boom
- it started working like magic, thank you so much.
I have another question - the database in question
that got crashed had mysql root password but the guys
I took over from forgot the password and didn't do any
mysql dump. So, I
Thanks for deciphering that terrible message, Shawn. I accidentally must
have hit the paste key too many times.
Anyway, here is my new insert statement:
INSERT INTO jobtitlecount (fkJobPosting, dtSnapShot, cJobTitle) VALUES
(211584,'2005-06-26',2) ON DUPLICATE KEY UPDATE cJobTitle=2
Hi,
Are you using MySQL-4.1 ? (ON DUPLICATE KEY syntax has been introduced
in 4.1)
Regards,
Jocelyn
Siegfried Heintze wrote:
Thanks for deciphering that terrible message, Shawn. I accidentally must
have hit the paste key too many times.
Anyway, here is my new insert statement:
INSERT
Alla-amin wrote:
Michael,
You are very correct - I renamed those fields and boom
- it started working like magic, thank you so much.
I have another question - the database in question
that got crashed had mysql root password but the guys
I took over from forgot the password and didn't do any
Siegfried Heintze wrote:
Sorry, I accidentally pasted some garbage at the beginning of that last
email message. Here is what I intended:
I first check to see if the record exists:
SELECT cJobTitle FROM jobtitlecount WHERE fkJobPosting = 209689 AND
dtSnapShot = '2005-06-26'
When I don't find
44 matches
Mail list logo
