I have MySQL ver. 4.0.18 binarys for windows installation. I just finished installing mysqld-max-nt as a service on a WinXP box yesterday afternoon. Using the MySQL Administrator client/utility GUI, I configured the anonymous and root Users, then added a superuser level account for myself.
Hello:
We are using MySQL database on a FreeBSD server. The problem we are facing
is sometimes the MySQL server is automatically shutting down. There is no
error logged on the server. The entry in the log file "mysite.com.err" shows:
040213 11:28:59 /usr/local/mysql-3.23.49/libexec/mysqld: Norm
Hi,
My DB server has 2 GB RAM, and 5 x 36 GB HDD in RAID 5. How can I tune
inno_db_data_file_path for best performance? Is it better to split up the
data, or just use 1 very big autoextend data?
Thank you,
Batara
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To u
Just to clarify a bit more (perhaps...), I
already have:
#!/usr/bin/perl
use DBI;
=
and
=
$dbh = DBI->connect
("DBI:mysql:host=localhost;database=my_db",
"my_id", "my_password",
{PrintError => 0, RaiseError => 1});
=
preceding the
$guestbookreal =
"/home/flute/usedflutes-www/n
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Carlos Proal wrote:
> Hi Mark et al,
> do you have any clue of when this bug is going to be fixed ? i saw at
> the bug system that it is a "non-critical" low priority bug, but i think
> this is major issue that most people using at least java & mysql
Thanks for the reply.
So InnoDB (and even MyISAM) use transactions (expected with InnoDB) and
slaves track their position in the binary log files as they are reading them
in so as not to violate any constraints?
David
- Original Message -
From: "Chris Nolan" <[EMAIL PROTECTED]>
To: "David
Wow! Thanks Rhino.
Yes, I already have http://www.usedflutes.com
running on MySQL (the INSERT statements I just
post manually using phpMyAdmin and they load fine
that way). However, I'd like to bypass the "copy
& paste" step for entering ads and if possible,
have them go/execute directly into my
Hi Mark et al,
do you have any clue of when this bug is going to be fixed ? i saw at the
bug system that it is a "non-critical" low priority bug, but i think this is
major issue that most people using at least java & mysql require for some
applications.
Bug #2654 JDBC Exception: "Column 'colu
Hi David,
David Griffiths wrote:
From reading the docs, a binary log is an efficient representation of all
data-modifying SQL that is run on the master database. I was unable to
figure out what happens if a slave is interrupted while in the middle of
processing a binary log.
When a binary log is
The Perl script I use is currently writing the
form results ($guestbookreal) to an html page
(http://usedflutes.com/new_listings_publish.html):
For example,
INSERT INTO `mysql_db` (`Title`, `Email`, `City`,
`State`, `Country`, `URL`, `Date`, `Description`,
`rid`, `dt_create`, `publish` ) VALUES (
>From reading the docs, a binary log is an efficient representation of all
data-modifying SQL that is run on the master database. I was unable to
figure out what happens if a slave is interrupted while in the middle of
processing a binary log.
When a binary log is applied to a slave database, what
might be as simple as putting a space after your closing parenthesis on
the create table statement.
either that, or your mysql install somehow doesn't have innodb table
support. have you edited your my.cnf file and enabled the innodb
parameters, specifically log and data files?
Rhino wrote:
I'
I'm new to MySQL but I have extensive experience with DB2 so I'm getting
quite confused about how MySQL is supposed to work.
I am using MySQL 4.0.11 on a Linux server running RedHat 9.2. I am
trying to create a pair of InnoDB tables that are related to one
another via a foreign key. I creat
I have inherited several mysql v4x servers. All but one of them works
as expected with /root/.my.cnf files.
That last server is driving me nuts ;> I have RTFM, and I do not find
this particular problem anywhere. Pointers to TFM are welcome.
# mysql -h localhost -u root
ERROR 1045: Access
Arnoldus,
you should add
log-bin
to the [mysqld] section of my.cnf, so that mysqld writes the binlog. Please
see the MySQL online manual about this option.
Best regards,
Heikki Tuuri
Innobase Oy
http://www.innodb.com
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
MySQL Connector/J 3.1.1, a new version of the Type-IV all-Java JDBC
driver for MySQL has been released.
Version 3.1.1 is a new feature release for the ALPHA tree that is
suitable for use with either MySQL-4.1 or MySQL-5.0.
It is now available in
Chris,
- Original Message -
From: "Chris Nolan" <[EMAIL PROTECTED]>
To: "Heikki Tuuri" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, February 12, 2004 2:26 PM
Subject: Re: InnoDB Hot Backup + MySQL embedded?
> Dear Heikki,
>
> Thanks for the quick response! It never ceases
Hello-
Is there a way to change the default mysql encoding to be something else,
say UTF-16LE at the session level?
As always, thanks!
__
David Perron
Sales Professional Services Consultant
P: 212-624-9600 ext. 221
C: 917-678-2081
>Description:
I'm using Mysql with SSL. It has been working perfectly until today
and now I have an "ERROR 2026: SSL connection error" when I try to
connect to Mysql.
I do not understand why, my SSL certificat is valid until 8 jan 2005.
What does
Here are the instructions for doing a stack trace.
http://www.mysql.com/doc/en/Using_stack_trace.html
>> Original Message <<
On 2/13/04, 2:24:30 PM, Jacob Friis Larsen "(Eksperten" "admin)"
<[EMAIL PROTECTED]> wrote regarding Re: MySQL 4.0 crashed; Please help:
Mike Mapsnac said:
> Have some questions about Order By:
>
> Can a mysql query be order by more than one field?
>
> If this two queries will give different result or not?
> #1 select * from t1 Order by id, username;
> #2 select * from t2 Order by id
>
>
[EMAIL PROTECTED] wrote:
Did you perform a stack trace?
No, how do I do that?
/Jacob
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Is this a legitimate variable? It seems like it'd be useful, but when I tried it (on
4.0.12-nt and 4.0.17-nt) it didn't work. Anybody know what's going on?
Brad
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.c
Would you mind posting your cnf. This may be a syntactical error.
>> Original Message <<
On 2/13/04, 2:08:40 PM, <[EMAIL PROTECTED]> wrote regarding RE: FW:
Installation issue on SuSE 9.0 Pro box:
> Yes, there are spaces/tabs before and after the equal sign.
Have some questions about Order By:
Can a mysql query be order by more than one field?
If this two queries will give different result or not?
#1 select * from t1 Order by id, username;
#2 select * from t2 Order by id
_
Choose now fr
In the last episode (Feb 13), John Griffin said:
> Can anyone tell where to find documentation on myisam_ftdump? I would
> like to know what myisam_ftdump is and how it differs from mysqldump.
It is a tool to dump the contents of a fulltext index. Mainly useful
for debugging.
Use: ft_dump
-d
Please for ward to the appropriate party.
I have attached a gcc 3.3 patch for MySQL++ 1.7.9 which may be applied
following the gcc 3.0, 3.2, and 3.2.2 patches provided on the MySQL
website. I have only used this patch on Mandrake 9.2, which comes
standard with gcc 3.3.1.
If you have questions, f
Yes, there are spaces/tabs before and after the equal sign.
One interesting thing is that I uncommented the lines in the stock .cnf
files for the bdb options and the error moved to the first of the bdb
options. That would indicate to me that it's in the datadir line, but I
can't see an error ther
Oh Jeeze- why didn't I think of removing this. When I upgraded the default
is to have these two as 'Y', however, for some reason, that means that show
databases shows all databases despite no permissions. That doesn't seem
logical on one hand (if they don't have permissions to the database nor
Just a guess but do you any space between the key and value?
innodb_data_home_dir = /var/data/mysql
Original Message dated 2/13/04, 1:21:26 PM
Author: <[EMAIL PROTECTED]>
Re: FW: Installation issue on SuSE 9.0 Pro box:
I was curious if anyone has experienced this same error and even more
curiou
Hi
As Greg mentioned, the options that are disabled for remote servers need
access to the underlying system where the server run (file system, process
control etc). There are plans for supporting those in remote servers, but
that is still under development.
Cheers,
--
Alfredo Kojima, GUI Develo
Daniel J. Conlon wrote:
Hi,
When executing this query through the 'mysql' command line utility, the
result is returned from the database server immediately and the database
server does not create a temporary file.
(SELECT
domains.domain,accounts.owner,accounts.type,accounts.server,accounts.win
In the last few days I've been doing some prototyping on mysql 4.1.1
(mainly because I want fulltext indexes against utf-8 data).
I have a table, artists_search_A, in which I want to load ~100K records.
My load process will routinely load 14783 records successfully. After
14783 inserts, any i
Title: FW: Installation issue on SuSE 9.0 Pro box
I was curious if anyone has experienced this same error and even more curious to see if anyone might offer some advice.
Thanks!
Dave
-Original Message-
From: David Christensen [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 1
I was reading the manual for Hot Backup for InnoDB and i was missing one
fundamental thing in the doc and that is setting the log-bin
The document only speaks about
The my.cnf files must contain the following parameter values:
innodb_data_home_dir=...
innodb_data_file_path=...
innodb_log_group
Hi, I am experiencing strange behavior from a TIMESTAMP column in an
InnoDB table on my MySQL 4.0.16 server. Specifically, it fails to
select certain rows by this column. The table is defined as:
CREATE TABLE log (
s_id int(11) not null,
p_id int(11) not null,
action enum
Hi,
When executing this query through the 'mysql' command line utility, the
result is returned from the database server immediately and the database
server does not create a temporary file.
(SELECT
domains.domain,accounts.owner,accounts.type,accounts.server,accounts.win
server,zone_records.record
Thanks for the information.
I also think it's a great tool.
Iago.
-Mensaje original-
De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Enviado el: viernes, 13 de febrero de 2004 14:30
Para: [EMAIL PROTECTED]
Asunto: RE: MySQL Administrator certain options only valid at localhost
A proba
I was reading the manual for Hot Backup for InnoDB and i was missing one
fundamental thing in the doc and that is
setting the log-bin
The document only speaks about
The my.cnf files must contain the following parameter values:
innodb_data_home_dir=...
innodb_data_file_path=...
innodb_log_group
My first question would be, "Why is this column is TIMESTAMP?". It
seems to me that if its purpose is to store the subscription start date,
it should be of type DATE. Usually, you use a TIMESTAMP column to
automatically keep track of the last updated time for a row.
Either way (DATE or TIMEST
Title: Message
I was reading the
manual for Hot Backup for InnoDB and i was missing one fundamental thing in the
doc and that is
setting the
log-bin
The document only
speaks about
The my.cnf files must contain the following parameter values:innodb_data_home_dir=...
innodb_data_file_path=.
On 12 Feb 2004 at 22:57, Bill Easton wrote:
> You can use + 1 instead of + interval 1 second, but it may give
> different results some day if MySQL changes the precision of
> timestamp.
Actually, that won't work in all cases. If the current timestamp is
20040213114859, then adding 1 (rather tha
Andrew Iles wrote:
Is this the true behavior or does it just appear to work this way? And if
so, is there any way to force MySQL to automatically save data to disk in a
way that is chronologically correct? This would make it much easier for me
to recover from an unexpected crash.
What os/vers
Did you perform a stack trace?
>> Original Message <<
On 2/13/04, 2:36:42 AM, Jacob Friis Larsen "[Eksperten" "admin]"
<[EMAIL PROTECTED]> wrote regarding MySQL 4.0 crashed; Please help:
> Can someone help me find out what caused this crash?
> My system is a Red
Am I able to add 365 days to an already existing TIMESTAMP on a
subscription service? If so I was going to use a form on a web page to
update it and in the insert statement use Now() + INTERVAL 365 DAY but
after some consideration, this would be wrong.
This would cause a problem if a current su
Hi,
Can anyone tell where to find documentation on myisam_ftdump? I would like to know
what myisam_ftdump is and how it differs from mysqldump.
John
-Original Message-
From: Lenz Grimmer [mailto:[EMAIL PROTECTED]
Sent: Friday, February 13, 2004 4:42 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL P
Hi!
InnoDB is a MySQL table type which provides transactions, row-level locking,
foreign key constraints, and a non-free hot backup tool for backing up
InnoDB tables.
InnoDB is included in all MySQL-4.0, 4.1, and 5.0 downloads, and also in the
MySQL Pro commercial, non-GPL MySQL license.
Release
Linus Nikander wrote:
Whilst trying to figure out why one of my queries wasn't working I ran into
the following phenomenon which I'd be grateful if someone could explain.
(I'm running mySQL 4.0.17 on a win2003 server, querying using the 0.9.4
mysql control center)
The following query returns the
A probable reason is that these are in startup files and hence the interface
needs file system access.
AFAIAA There are plans to have dynamic settings that can be changed at
runtime, but these are still plans.
No idea on the rest of it thou.
Neat tool, and looks great! Like the backup tools. T
Whilst trying to figure out why one of my queries wasn't working I ran into
the following phenomenon which I'd be grateful if someone could explain.
(I'm running mySQL 4.0.17 on a win2003 server, querying using the 0.9.4
mysql control center)
The following query returns the expected result
SELECT
Hi.
I've downloaded MySql Administrator 1.0.1a alpha for Windows and tried it.
It has options only enabled if MySQL Admnistrator is connected to localhost.
I'm connected as root to other host (which is Linux). For example the
Startup Variables. Some of these options are the most interesting opti
I've seen a number of references to the "Too many columns" error, but I'm
encountering something that appears to be different.
Basically, I'm trying to change a single column in a table (that has 20
columns) from VARCHAR(255) to ENUM(...) where the enum list contains about
900 entries, each a str
Marty Ray <[EMAIL PROTECTED]> wrote:
> Brace yourself for another beginner question...
>
> When I try to use the SHOW command (logged in as root) , I get an error:
>
> mysql> show databases;
> ERROR:
> No query specified
>
What version of MySQL do you use? What OS?
There is a bug on Mac OS X i
Schmuck, Michael wrote:
I've got a big problem. My MySQL server has yesterday lost data since 20th
january.
Yesterday at about 14 o'clock we resartet the demon on our bsd server since
september 03. I belive the deamon
didn't wrote the data into the files. At the restart of the database he
loade
"Mike Miller" <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I believe I've done everything from the book and have been fighting with
> the same problem for about 6 hours thus far.
>
> I just upgraded from MySQL 3.23.56 to 4.0.17. In the old system, I
> prevented show databases from ordinary users us
Jonas Lind?n <[EMAIL PROTECTED]> wrote:
> Hello, can the new version of mysql 5 do reversed indexes?
>
> CREATE INDEX table ON (name(10) DESC);
>
> In manual it is described to be a fortcoming feature but and to be ignored in
> present version.
Currently it does nothing. Indexes are stored in
I solved!! The dbfile was a sequence of sql commnds, so the command to
import that file was
mysql dbname < dbfile
after creating dbname. My job chair is saved (maybe)!
- Original Message -
From: "michele digioia" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, February 13, 200
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
MySQL 4.0.18, a new version of the popular Open Source/Free Software
Database Management System, has been released. It is now available in
source and binary form for a number of platforms from our download pages
at http://www.mysql.com/downloads/
Michael,
check all your connectivity settings (host and port) of all of the
software that you use (backup scripts for example) especially if you
connect via tcp/ip instead of via sockets.
Check the error log, too.
Did you move something on January, 20th (database)?
From our own experiences it s
Hello, can the new version of mysql 5 do reversed indexes?
CREATE INDEX table ON (name(10) DESC);
In manual it is described to be a fortcoming feature but and to be ignored in present
version.
regards
/Jonas
Matt Mastrangelo <[EMAIL PROTECTED]> wrote:
>
> Here is the create statement and the resulting table:
>
> mysql> create table test(
>-> myblob longblob) default charset latin1 default collate
> latin1_general_cs;
> Query OK, 0 rows affected (0.08 sec)
>
> mysql> show create table test \G
>
Reading a hint in the net I created a dbfile with mysqldump on the source pc
(WinXP):
mysqldump dbfile > mysqldbname
Now I have to take this file and create the database in the dest pc (Linux).
I should use mysqladmin (is it true?) but what's the right command?
Thanks
Mic.
--
MySQL General
Can someone help me find out what caused this crash?
My system is a Red Hat 7.3 on a HP Netserver LC2000, dual PIII 800mhz
with 2.5G ram. 3 disks in raid 5.
The MySQL database is 4.0.17
040212 19:27:36 read_const: Got error 126 when reading table
./exp4/sql_cache
Number of processes running n
Greetings All,
If you are interested in attending the conference in person (or
virtually), please read on.
First, in addition to our regularly scheduled conference sessions, we
are going to be having about a dozen training sessions.
The sessions will let small groups of attendees (about 10 per
Hi.
I've noticed that when a server running MySQL crashes and comes back to
life, the MyISAM tables typically need to be repaired to account for the
fact that they were not flushed when the server went down.
However, I've also noticed that when the database is recovered from a crash,
the tables
65 matches
Mail list logo
