I'm fairly sure that the ONLY limitation is the size of the table files, adn
those depend on the OS.
http://www.mysql.com/doc/en/Table_size.html
Chris
-Original Message-
From: Andres Montiel [mailto:[EMAIL PROTECTED]
Sent: Monday, December 22, 2003 9:57 PM
To: [EMAIL PROTECTED]
Subject:
Hello I need help
MySQL 3.23.47 running on localhost linux
I want to create an Test Instance. Based on my Production Instance.
My Batch (it has work for month)
head prax2test.sh
time mysqldump -u transfer -ptransfer timesheet timesheet.temp
echo drop database timetest; timetest.sql
echo
Hi,
Sorry for not responding more promptly.
To remove a index you can use a command like this one
ALTER TABLE tbl_klanten DROP INDEX klant_id;
or using phpMyAdmin - just click on the delete link next to the index.
Anyway as I told you before I don't think this is causing the problem - the
Teresa A Narvaez [EMAIL PROTECTED] wrote:
We run MYSQL 3.22.30 on a TRU64 alpha server(4.0F). Our scripts found
corruption on one of our tables. The script tried to automatically clear
the corruption but failed. Then we cleared the corruption by manually
running isamchk -r.Everything
Kirti S. Bajwa [EMAIL PROTECTED] wrote:
Hello List:
Please point to what am I doing wrong:
I am trying to install MySQL on top of RH9. I am following steps outlined
MySQL official documentation from Section 2.3.1 titled Quick Source
Installation Overview. These are the steps I have
Hi mysql-list,
1.
my installation:
[EMAIL PROTECTED]:~ uname -a
Linux rosetta 2.4.19-4GB #1 Fri Sep 13 13:14:56 UTC 2002 i686 unknown
[EMAIL PROTECTED]:~
mysql show global variables like version;
+---++
| Variable_name | Value |
Plinio Conti [EMAIL PROTECTED] wrote:
The manual page at http://www.mysql.com/doc/en/SHOW_GRANTS.html
says:
To list grants for the current session one may use CURRENT_USER() function
But if I run
SELECT SHOW GRANTS FOR CURRENT_USER();
I get syntax error (Error 1064).
While if I
The MacOS X package installer runs mysql_install_db itself, I've
chown-ed and chgrp-ed the relavent files (even though the installer did
that as well) and everything because I thought it was a permissions
problem.
However, I did wipe it and install mySQL 4.0.17, which works fine, so
it
Hi,
I'm looking for prepared statement support in MySQL 4.0. I know it exists in
4.1 but 4.1 seems to be stuck in Alpha for forever. I looked at the
documentation that came with the latest release and it seems to be for 4.1.
Furthermore, I couldn't find a reference to MYSQL_BIND in the header
Thanks.
I think your help is what I needed is highly appreciated.
Kirti
-Original Message-
From: Egor Egorov [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 23, 2003 4:22 AM
To: [EMAIL PROTECTED]
Subject: Re: What am I doing wronga
Kirti S. Bajwa [EMAIL PROTECTED] wrote:
Hello
On Tue, Dec 23, 2003 at 02:20:50PM +0200, Yosef Teitz wrote:
Hi,
I'm looking for prepared statement support in MySQL 4.0. I know it exists in
4.1 but 4.1 seems to be stuck in Alpha for forever. I looked at the
documentation that came with the latest release and it seems to be for 4.1.
On Tue, Dec 23, 2003 at 12:57:23AM -0500, Andres Montiel wrote:
I was informed that MySQL has a 100,000,000 row limit. Is this true?
No.
Jeremy
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
[EMAIL PROTECTED] | http://jeremy.zawodny.com/
--
MySQL General Mailing List
I am on 4.0.17 does it really matter how I start the
server? whether I use /bin/safe_mysqld or
/bin/mysqld_safe?
Thanks.
__
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
http://antispam.yahoo.com/whatsnewfree
--
MySQL General Mailing List
I am on 4.0.17 does it really matter how I start the
server? whether I use /bin/safe_mysqld or
/bin/mysqld_safe?
safe_mysqld is a link to mysqld_safe, so no, it doesn't matter.
mack /
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Jeremy writes: Please give 4.1 a try.
Ah, yes - 4.1. I actually did quite a bit of testing on 4.1 alpha in
July/August which is one of the reasons why we like MySQL, but I'm not sure
that my management wants an alpha version in their production system.
Which leads me to the next question for the
Will and Michael,
Thanks very much for the the replies. This works well.
Is it possible to use this syntax and search for cases
where they have two different kinds of equipment? Say
an Ultra 5 and a HP Plotter?
TIA, DB
SELECT User_Account FROM Users AS a, Device_Name from Devices AS b
WHERE
Yes,
I can do it with a middle tier,
but currently my app is a simple 2-tier
and introducing a middle-tier just to do
that looks excessive...
On Sun, 21 Dec 2003 18:40:40 -0330
jamie murray [EMAIL PROTECTED] wrote:
What about creating a flat file on the middle tier from the database system
Sorry,
I was not using any SELCT in my queries,
it's just an error typing the email
I confirm:
SHOW GRANTS FOR CURRENT_USER();
does not work,
while that query is exaclty what you expect to do reading mysql manual.
On Tue, 23 Dec 2003 12:47:11 +0200
Egor Egorov [EMAIL PROTECTED] wrote:
Plinio
Plinio Conti [EMAIL PROTECTED] wrote:
Sorry,
I was not using any SELCT in my queries,
it's just an error typing the email
I confirm:
SHOW GRANTS FOR CURRENT_USER();
does not work,
while that query is exaclty what you expect to do reading mysql manual.
It means that you can use
To be honest, the fact I can't get it with only one query but I have to do:
1) SELECT CURRENT_USER();
2) SHOW GRANTS FOR valueExtractedByPreviousQuery;
is a little thing compared with work remaing to get usefull information:
I have to parse the strings returned by query 2, handle the wildcards,
I'm trying to figure out how to combine these two tables. I have..
t1
date accidentInfo cost
t2
date upgradeInfo whereUpgraded Salesman cost
I want to combine the two in a way to reference each piece of data such as
t1.accidentInfo,t2upgradeInfo and so on, but I need the resultset to be
Data Boy wrote:
Will and Michael,
Thanks very much for the the replies. This works well.
Is it possible to use this syntax and search for cases
where they have two different kinds of equipment? Say
an Ultra 5 and a HP Plotter?
TIA, DB
SELECT User_Account FROM Users AS a, Device_Name from
_
Tired of slow downloads? Compare online deals from your local high-speed
providers now. https://broadband.msn.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
I'm trying to figure out how to combine these two tables. I have..
t1
date accidentInfo cost
t2
date upgradeInfo whereUpgraded Salesman cost
I want to combine the two in a way to reference each piece of data such as
t1.accidentInfo,t2upgradeInfo and so on, but I need the resultset to be
The mysql list sent this back to me, so I'm resending. My apologies to
anyone who ends up getting it twice.
Data Boy wrote:
Will and Michael,
Thanks very much for the the replies. This works well.
Is it possible to use this syntax and search for cases
where they have two different kinds of
Hi, I am a beginner in using database. And I
appreciate your support and help.
When we first create a table,
1. is it possible to create a column that identifies
each record that is to be inserted?
2. If we can create this IDENTITY column, how do we
create it? Do we set a maximum to the
Michael Bacarella [EMAIL PROTECTED] wrote:
We're running MySQL 3.23.56 w/ InnoDB on Red Hat Linux 8.0,
compiled natively with bundled gcc:
# gcc -v
Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/3.2/specs
Configured with: ../configure --prefix=/usr --mandir=/usr/share/man
Plinio,
Hence my suggestion for use of a flat file. The file can be located on the
db server middle tier wherever it doesnt matter.
The important part is that you control what goes in the file and its done
ahead of time not when an enduser presses a button.
What about creating tables the users can
Hi,
I think what you need is an auto increment (primary key) column. When a
record is inserted, it will automatically generate the next number in the
sequence. Being a primary key, the column must be unique (i.e no two rows
can be the same), so you can identify a specify record in the table.
At 0:57 -0500 12/23/03, Andres Montiel wrote:
I was informed that MySQL has a 100,000,000 row limit. Is this true? We
were planning to use MySQL for an inventory system. However, our current
data (rows) for 1 year for one area is already 8.8 million. We want to
place data for 5 years for 7 areas.
Hi,
I am currently working on a web application(USING JSP AND JAVA) that uses
microsoft sql server 7.0 as the database.
I have decided to use MySql4.0 as the database. I have been able to
successfully create
the database schema in mysql and it is
the same as the ms sql server 7.0 database.
At 17:43 + 12/22/03, Dale Goolcharan wrote:
Hi,
I am currently working on a web application(USING JSP AND JAVA) that
uses microsoft sql server 7.0 as the database.
I have decided to use MySql4.0 as the database. I have been able to
successfully create
the database schema in mysql and it is
j,
how you have set
innodb_thread_concurrency
and
innodb_log_file_size
in my.cnf?
I was able to repeat the assertion failure by setting the log file size to
only 8 MB, and setting concurrency to 500. I changed now InnoDB so that it
no longer asserts, but calls exit(1). It prints the
I have a folder with all of the files from a database that the server shot craps
(database is used for phpBB). I now have another server up and running with phpBB
setup and a database with the same name.
My question is, is there any way to merge the information into the new database? We
had
hi gang
Got a wee bit of a problem with MySQL...
Running Distrib 4.0.14, for Win95/Win98 on i32 ... on Windows XP Pro SP1 ...
as long as I keep the default setup, with no password on the root user and
nothing modder in 'user' at all, I can access the DB. But as soon as I try
adding a user or
First let me state that this is not a question where a valid answer is to
SET FOREIGN_KEY_CHECKS=0... (no, its not *that* question..)
I have noticed that mysqldump includes the database name in foreign key
specifications within CREATE TABLEs. This is causing a bit of grief as I
would like to
I have a table which maintains a list of categories and has a field called
catID. This field is a one-to-many relationship with another table.
What I want to do is remove any empty categories - aka: remove any
categories which aren't used in the second table.
I thought MySQL at least partially
At 15:46 +0100 12/23/03, Plinio Conti wrote:
Sorry,
I was not using any SELCT in my queries,
it's just an error typing the email
I confirm:
SHOW GRANTS FOR CURRENT_USER();
does not work,
while that query is exaclty what you expect to do reading mysql manual.
I agree, one might easily come to that
I am using 3.23.58 (server and client) on FreeBSD 5.2-RC1 and all of what
I am about to describe is being performed locally.
When importing dumped data (with something like mysql dbname
dbname.dump) the import is being performed at ~60 queries a second. This
is MUCH slower than when I was
Hi Jeremy,
- Original Message -
From: Jeremy Zawodny
Sent: Monday, December 22, 2003 2:20 PM
Subject: Re: Benefits of MAX_ROWS and AVG_ROW_LENGTH
On Fri, Dec 19, 2003 at 06:40:17PM -0600, Matt W wrote:
Hi Mark,
I'll tell you what I know. :-)
First, AVG_ROW_LENGTH is only
Mark Matthews wrote :
Gilles Magnier wrote:
[snip]
I think having identical error code for unsuported exception and bad
parameter error is a bit confusing, for me at least ...
Thanks for any help,
These definitely look like typos. After the holidays, I will look into a
fix for these using
Hi Mark,
Maybe you intentionally only replied to me (instead of the list too),
but I'm sending this to the list also so others can follow the
discussion. :-)
I never know how much I have to explain things for a person's knowledge
level, but it sounds like you understand what's going on very
actually ,mysql only return 17000 records if that means mysql select has
max record limit?
_
MSN Messenger: http://messenger.msn.com/cn
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
I have found that by dumping with --extended-insert, the subsequent import
is MUCH faster. Of course it only issues 450 odd queries for the data set
instead of ~200k...
-mike
[EMAIL PROTECTED]
12/23/03 05:02 PM
To
[EMAIL PROTECTED]
cc
Subject
Strange performance problem importing
I don't believe this. I'm going to write a script to disprove this theory
right now..
Cheers,
Andrew
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Tuesday 23 December 2003 20:08
To: Andres Montiel; [EMAIL PROTECTED]
Subject: Re: 100,000,000 row limit?
At 0:57
I don't believe this. I'm going to write a script to disprove this theory
right now..
We have a lot more than 100,000,000 more than that in a single MyISAM
table at work:
mysql select count(*) from probe_result;
+---+
| count(*) |
+---+
| 302045414 |
+---+
1 row in
Paul DuBois wrote:
At 15:46 +0100 12/23/03, Plinio Conti wrote:
Sorry,
I was not using any SELECT in my queries,
it's just an error typing the email
I confirm:
SHOW GRANTS FOR CURRENT_USER();
does not work,
while that query is exactly what you expect to do reading mysql manual.
I agree, one
47 matches
Mail list logo