Hi
do you mean that InnoDB have no table-size limit?
Thanks.
|-Original Message-
|From: Tobias Asplund [mailto:[EMAIL PROTECTED]
|Sent: Friday, October 17, 2003 6:04 PM
|To: nm
|Cc: [EMAIL PROTECTED]
|Subject: Re: mysql max
|
|
|
|It depends on your filesystem's and OS's max-size of a
Hi Jo,
Well, that UPDATE query doesn't look like it's *changing* the value of
the columns with the UNIQUE index. Are you sure there's no unique index
on the columns that ARE being updated? e.g. is id_token_data_01 key 1?
(See if it's the first row returned by SHOW INDEX FROM
dspam_token_data.)
Hi!
If you vanna free environment:
nb-means netbeans
j2sdk-nb
http://java.sun.com/webapps/download/Display
nbuser-group
Everything depends, what do you want to do? Web-application? If so, you have
to download other things, like WSDP 1.2.-that contains tag libraries JSTL and
Java Server
Hey Matt -
thanks for sharing some thoughts!
Yes, you're right about not changing the values of the columns with the
UNIQUE index ( which kind of makes it even stranger of course :)
The output of show index and check table is here:
http://f1mail.forumone.com/mysql/
Check table looks ok as
do you mean that InnoDB have no table-size limit?
if size is that important to you get an 64-Bit system an should be able
to go for Terrabytes without Raid an MERGE.
Greetings
Stephan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Does anyone know of similar site for Perl and MySQL ?
On Friday, Oct 17, 2003, at 23:10 Europe/Brussels, Boaz Yahav wrote:
Hello
Just wanted to let anyone interested that after almost 6 years,
http://www.weberdev.com
now has a new brother (sister?) site called http://www.weberblog.com.
This new
At 8:25 +0200 10/18/03, nm wrote:
Hi
do you mean that InnoDB have no table-size limit?
Thanks.
The InnoDB tablespace size limit is 64 TB. All InnoDB tables are
stored within the tablespace, so this is also the individual
table size limit.
http://www.innodb.com/ibman.html#InnoDB_restrictions
--
Hi,
The update command only attempts to update non-key values for a wide
range of tokens, which is why I can't fathom why it's failing. The key
fields are uid and token, but we are only trying to update spam_hits,
innocent_hits, and last_hit.
Very odd.
On Sat, 2003-10-18 at 03:38, Joakim Ryden
I have a little question
I have a big table ( a lot of fields) whitout keys
In order to got a list sorted by the time of insertion
I build a sequential acces with this syntax
SELECT * FROM table WHERE NUMERO='248' ;
It's was perfect
But now I woulf like got this list with inverse order
Sure
Dear sirs,
I have mysql 4.01 installed on my pc (not source,only binary)on win98 (I tried in win
XP too).I downloaded myodbc source (3.51)and tryed compiled release with nmake (using
makefile included in source)but aving a link error unresolved esternal _aulldvrm in
mysqlclient (same message
Thank you very much Paul, that is exactly what I need, but
FOREIGN_KEY_CHECKS = 0 is a feature of MySQL/InnoDB-3.23.52 and
unfortunatelly my current version is 3.23.51. I can not upgrade to version
4.0 if I do not have a reliable backup of my current version.
Do you have any other sugestion?
* dorilys
I have a little question
I have a big table ( a lot of fields) whitout keys
In order to got a list sorted by the time of insertion
I build a sequential acces with this syntax
SELECT * FROM table WHERE NUMERO='248' ;
It's was perfect
No, you were just lucky. That syntax will give
At 16:13 + 10/18/03, MartÌn Lahittette wrote:
Thank you very much Paul, that is exactly what I
need, but FOREIGN_KEY_CHECKS = 0 is a feature of
MySQL/InnoDB-3.23.52 and unfortunatelly my
current version is 3.23.51. I can not upgrade to
version 4.0 if I do not have a reliable backup
of my
Have anybody ever set up MS Access as a frontend to mysql?
the dB is an already established mysql db running on linux
I don't want to convert it, just use access to get to it.
I have followed the recipe at
http://www.washington.edu/computing/web/publishing/mysql-access.html
I can see the tables
There are many tools in the contributions section to manipulate a mysql
database without the need to resort to Access and odbc. What do you need to
do?
Pat...
- Original Message -
From: Colleen Dick [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Saturday, October 18, 2003 11:42 AM
I have the complete Red Hat 9 rpm database installed but I guess I just
don't know how to query it. What provides libcrypto and libssl?
Particularly the versions required by MySQL (libcrypto.0.9.6 and
libssl.0.9.6)? I have both files on my system but they are version
0.9.7. and MySQL doesn't
Hi List
I'm having trouble start a slave. All seems to be configured well as per
show slave status, I issue a
mysql slave start;
Query OK, 0 rows affected (0.00 sec)
and nothing happens, show slave status sill says slave is not running.
Any insght??
Thanks
mike
--
MySQL General Mailing
At 14:11 -0400 10/18/03, DePhillips, Michael P wrote:
Hi List
I'm having trouble start a slave. All seems to be configured well as per
show slave status, I issue a
mysql slave start;
Query OK, 0 rows affected (0.00 sec)
and nothing happens, show slave status sill says slave is not running.
Any
Hi,
I have trouble to connect from a remote host to the mysql-server.
On localhost works all right.
But when I want to establish a connection with
pre
mysql --host=server --user=com75778 --database=com75778 --pass
Enter password:
ERROR 2013: Lost connection to MySQL server during query
/pre
from
I have a very basic newbie question that, despite
multiple searches, I have been unable to find an
answer to. How is ISAM pronounced? Is it:
1. eye-sam (As in I dont like green eggs and ham,
Sam I am.)
2. is-am
3. I-S-A-M (with the individual letters spoken out
like most acronyms)
I
Hi Jim,
As far as I know: eye-sam my-eye-sam. At least that's how I pronounce
them. :-)
Matt
- Original Message -
From: Jim Mathews
Sent: Saturday, October 18, 2003 3:44 PM
Subject: Pronunciation of ISAM table name
I have a very basic newbie question that, despite
multiple
Yes, you are right. I am upgrading to MySQL 4.0, but I can not do it if I do
not have a backup of my current database. If something goes wrong, I need to
be sure that I am able to restore the database to its current state. Maybe I
need two types of backup, one to move my databases to version
Hi
- Original Message -
From: Matt W [EMAIL PROTECTED]
To: Jim Mathews [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Saturday, October 18, 2003 10:18 PM
Subject: Re: Pronunciation of ISAM table name
Hi Jim,
As far as I know: eye-sam my-eye-sam. At least that's how I pronounce
them.
At 21:45 + 10/18/03, Martín Lahittette wrote:
Yes, you are right. I am upgrading to MySQL 4.0,
but I can not do it if I do not have a backup of
my current database. If something goes wrong, I
need to be sure that I am able to restore the
database to its current state. Maybe I need two
Hi there
I have a problem with starting mysqld. I tried to
install mysql-4.1 on my debian, but when i want to
start mysql daemon it failes. I generated bug report.
my.cnf and mysql also attached.
Thanks in advance
-
SEND-PR: -*- send-pr -*-
Martin,
Shut down your 3.23 server.
Make a binary copy of the data.
Install 4.0
Upgrade your privileges with the 4.0 script.
Start 4.0 server.
That's it, right?
Worked for me...
When doing backups I always do a full recursive backup of the entire mysql
data directory. This way I know that I'm
I recently downloaded MySQL v3.23 on my Windows 2000 laptop. When I try to
create a database at the mysql prompt, I get the message Error 1044:
Access denied for user '@localhost' to database xx. I originally
assigned a username and password when I first ran the WinMySQL admin 1.4
tool. I
Hi,
If your table has a primary key or unique integer key you can order
descending using the keyword _ROWID like this:
SELECT * FROM table WHERE NUMERO='248' ORDER BY _ROWID DESC;
I just tried your solution but unfortunately I got an error
My table have no key
In fact my problem
On Saturday 18 October 2003 03:07 pm, Hamid Nouri wrote:
Hi there
I have a problem with starting mysqld. I tried to
install mysql-4.1 on my debian, but when i want to
start mysql daemon it failes. I generated bug report.
my.cnf and mysql also attached.
[...]
Umm.. What's the error?
--Jo
I just installed 4.0.15 on an iBook running Mac OS X 10.2.6. I started
the daemon using bin/mysqld_safe, and then tried to initialize the root
password as instructed. The first,
bin/mysqladmin -u root password **
ran apparently successfully. When I tried to execute the second:
Mikael Fridh wrote:
Martin,
Shut down your 3.23 server.
Make a binary copy of the data.
Install 4.0
Upgrade your privileges with the 4.0 script.
Start 4.0 server.
That's it, right?
Worked for me...
When doing backups I always do a full recursive backup of the entire mysql
data directory. This
31 matches
Mail list logo