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
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
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
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
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
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
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
-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/
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, 2004
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 the
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 using
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
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 in MySQL
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
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
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
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.
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
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.
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
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
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 Hat 7.3 on a HP Netserver LC2000, dual
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
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 than
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=...
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
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=...
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
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
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
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=...
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
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
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
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
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
curious
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
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
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,
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
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
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.
One interesting thing is that I
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:
[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]
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
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:
[EMAIL PROTECTED] wrote:
Did you
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
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
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 to amaze me
-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
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
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
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 amusing MySQL 4.0.11 on a Linux server running RedHat 9.2. I am
trying to createa pair ofInnoDB tables that are related to one
another via a foreign key. I created
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:
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
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
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
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
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
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
-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
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 =
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
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:
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. I
65 matches
Mail list logo