er, it is the best thing
around. The license allows multiple installs, but you are only
allowed to run one at a time. This is a nice convenience. It also
supports many databases besides MySQL. Again, expensive but worth it
in terms of productivity.
-Joe
--
MySQL General Mailing List
| NULL||
| country | varchar(40) | YES | | NULL||
| rowid| int(11) unsigned | NO | PRI | NULL| auto_increment |
+--+--+--+-+-++
Server version 5.0.22
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
qldump is for?
There is no such option to mysqldump in version 4.1.11.
Todd Merriman
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
prised!
Our solution, restore the dating by putting the version 3 isam file
into the version 4 directory.
Todd Merriman
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysql> select bademail.email from bademail,noemail where bademail.email <>
noemail.email;
bademail has about 30,000 rows and noemail has 13,000.
This, by the way, does a good job of bringing your system to its knees!
Todd Merriman
mailist @ toolz.com
--
MySQL General Mailing List
Todd Merriman
eTotalHost.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
hours 6 min 50 sec
Threads: 1 Questions: 3103 Slow queries: 89 Opens: 352 Flush tables:
1 Open
>C compiler:gcc (GCC) 3.3
>C++ compiler: gcc (GCC) 3.3
>Environment:
System: SunOS f10212-06.adc1.level3.com 5.8 Generic_108528-22 sun4u
sparc SUNW,U
Architecture: sun4
--
MySQL
set-variable= sort_buffer=8M
[mysqlhotcopy]
interactive-timeout
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I have a user who has permissions for a single database. The user wants to
be able to add/delete users for the database. Can this be done?
Thanks
GNH
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
n Thu, Dec 05, 2002 at 08:54:29PM -0200, Felipe Moreno - MAILING LISTS
wrote:
>
> Well, could you explain the behave of ORDER BY DATE,COD?
Just try it (it will order by date, then cod).
What I think you want is (as I originally said, but briefly):
create temporary table top10 select * from .
ten dates). So,
>what I really need ia an way to make a select without any "data" from the
>DB. I tried to use de LAST_INDEX() function to do this but I didn't go
>anywhere. Any ideas???
-Mensagem original-
De: Michael T. Babcock [mailto:[EMAIL PROTECTED]]
Enviada em: quinta-feira,
: SQL Select Idea
On Wed, Dec 04, 2002 at 08:55:51AM -0200, Felipe Moreno - MAILING LISTS
wrote:
>Well, the SQL Query you requested is exatcly the one I'm asking! :-)
No; I want to know what you intended for those 10 dates to do. The LIMIT
query
worked, as posted by someone else, w
what I'm doing above using only ONE select.
Any tips?
Best Regards,
Felipe
-Mensagem original-
De: Michael T. Babcock [mailto:[EMAIL PROTECTED]]
Enviada em: quarta-feira, 4 de dezembro de 2002 02:06
Para: [EMAIL PROTECTED]
Assunto: Re: RES: SQL Select Idea
On Tue, Dec 03, 2002 at
zembro de 2002 01:03
Para: Felipe Moreno - MAILING LISTS
Assunto: Re: RES: SQL Select Idea
Felipe -
Maybe you could...
(1) Put the first result set into a temp table, on which you could execute
subsequent queries, or
(2) Use php to construct an array of the result rows, and then use php's
arra
---Mensagem original-
De: Jim Esten [mailto:[EMAIL PROTECTED]]
Enviada em: terça-feira, 3 de dezembro de 2002 17:40
Para: 'Felipe Moreno - MAILING LISTS'; [EMAIL PROTECTED]
Assunto: RE: SQL Select Idea
Something on the order of...
SELECT * FROM processo_arquivos ORDER BY DATE DESC LIMIT
Hi List Users,
I want to know if anyone has any idea on how can I do the SQL command
below to archive a result.
I have one table called processo_arquivos that have a filed called DATE
and another FIELD called COD (primary key). I want to select the last TEN
(10) dates from the Database, but
Hi List Users,
I want to know if anyone has any idea on how can I do the SQL command
below to archive a result.
I have one table called processo_arquivos that have a filed called DATE
and another FIELD called COD (primary key). I want to select the last TEN
(10) dates from the Database, but
Hi,
Using MySQL, perl and DBI, is there a way to test to see if a table is
locked (as in "LOCK table..."). We batch process our updates every 3
hours or so (it's not a set schedule though, it depends when a certain level
of new updates is reached), and our main tables are locked during this t
I have found to do a LOAD DATA LOCAL INFILE is no longer possible
using perl-DBI, even though local-infile=1 is in the [mysql], [mysqld],
and [client] sections of my.cnf.
I am not sure what prompted the engineering powers-that-be to
change the default for this version, 3.23.49, of mysql, but it
Hi,
I have a big problem with last_insert_id() query.
I am adding records to a table with about half a million records in it. The
insert takes well under a second. I then call last_insert_id as I need to
make a link to another table.
The last_insert_id takes around 2 minutes!!! Yes *minutes*
Hi,
In my mysql .err file I get a lot of the following error...
"Aborted connection 121031 to db: ..connection details... (Got an error
reading communication packets)"
What does this mean, and is it bad, and what do I do about it?
Any help appreciated.
Howard
-
Hi,
In my mysql .err file I get a lot of the following error...
"Aborted connection 121031 to db: ..connection details... (Got an error
reading communication packets)"
What does this mean, and is it bad, and what do I do about it?
Any help appreciated.
Howard
-
Sounds as though you haven't got Perl installed, or more particularly the
DBI modules for MySql. If you on Linux, almost certainly to be found on your
Linux CDs.
HM
Suresh R. Soni writes:
> Hi All,
>
> I am getting following error msg when I try to install
> MySQL using rpm -i My*
>
>
Hi,
I my mysql server database directory (that is the directory that holds the
.err and .pid files) so strange files have apeared. They look line
-bin.001
-bin.002
etc
-bin.index
Some of them are huge! They seem like binary files, but are full readable
SQL commands that could be f
Hi,
Thanks I DID read the documentation.
BUT there documentation gives no information about how to choose values
for these settings. There are no clues at all. What are good values, and/or
what is the effect on performance etc. of the values?
Howard
Egor Egorov writes:
> mysql,
>
You have written the following:
I have a mysql database table that is currently 1.5G in size with well over
a
million records. It is running on a twin pentium 3 1G processor machine with
SuSE Linux version 1.4.
Recently inserts have become VERY slow (several seconds). As I am adding
around
I have a very large mysql table (1.5G) and so will need to implement the
table
RAID option soon.
How do I pick the CHUNKSIZE and number of chunks values?
Howard
-
Before posting, please check:
http://www.mysql.com/ma
Hello,
I am trying to build a drop down list using php and mysql. Does anyone
have any examples of this?
Regards,
Adrian
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql
Hello,
I am attempting to add the ROOT user as a MYSQL administrator using the
following syntax:
mysqladmin -u root password 12345
and I recieve the following error:
mysqladmin: connect to server at 'localhost' failed error: 'Access denied
for user: 'root@localhost' (Using password: YES)'
an
With basedir and datadir=/var/lib/mysql the error is:
011001 16:16:42 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13)
With basedir=/var/lib/mysql and datadir not set:
/usr/libexec/mysqld: Can't change dir to '/var/lib/mysql/var/' (Errcode: 2)
011001 16:18:23 Aborting
011001
Hi all,
We want to set up a user in mysql and allow him to send his queries to our
database from his server. (PHP)
The data in our database contains our other customers' as well as the guy
who wants to directly access it. We would like to check his queries before
send it to the database.
For
Hi Andy,
Try to kill the process first, then restart mysql server. Hope that helps.
Thanks,
Xi Jiang
ITSportsNet Technical Support
- Original Message -
From: "Andy De Paoli" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, Jul
I think you can check this link
http://www.mysql.com/documentation/mysql/bychapter/
- Original Message -
From: "Joe Taraba" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, July 04, 2001 1:47 PM
Subject: Replication, update log, mysqldump???
> Hi;
>
> I'm trying to learn M
I move from MDB to mySQL, I got a question concern how to create a auto digital number
field in mysql table,
create table namelist ( name char(60), ID auto, date date());
Hi, everybody here,
Anybody can help with
telnet to Linux and login to mySQL, show information about current mysql
setting,
create new DB, and table?
Since, I am using MSSQL under NT platform, it is pretty much different..
Thanks lot
Amy
Hi, everybody here,
Anybody can help with
telnet to Linux and login to mySQL, show information about current mysql
setting,
create new DB, and table?
Since, I am using MSSQL under NT platform, it is pretty much different..
Thanks lot
Amy
- Original Message -
From: "Kelsey Cummings" <[
What sort of support for transactions and table/record locking is there in MySQL right
now? I had heard that only table locking was supported, and limited support for
transactions.
Aaron
-
Before posting, please check:
h
I had an errcode 28, so redirected the tmpdir to my /home directory. Now
I'm getting another error. I don't know if this is Linux or MySQL??
mysql> select count(*),state from import_talents group by state;
ERROR 3: Error writing file '/home/tempspace/MYfZExbS' (Errcode: 122)
Error 122 tells me
I looked through the mailing list archive for an answer to this, but I can't
find a way around this problem.
I have a table with about 225,000 records. I kept getting an out of disk
space error when running this query:
mysql> select count(*),state from import_talents group by state;
Hi all,
Here are two tables I'm working with. I apologize if you
are not using a monospaced font and they are messed up.
This is used by a gradebook program. When a professor adds an assignment to
a class he teaches, it inserts the information about the assignment into the
assignments table,
Hi Warren,
What I personally would do is simply include some sort of 'ID' field. In
other words, each question would have a unique ID. Question 1's ID would be
1, Question 2's ID would be 2, etc. Or however you wanted to number them.
You could even set this up as an auto_increment and have t
Hi all,
Does anyone know if mod_auth_mysql is still under active development, and if
so, where can I find current information on it? I have searched the list
archives here and indeed turned up 254 instances of people having problems
with mod_auth_mysql. From the sounds of it, it doesn't look
DELETE FROM tableName;
Jiang
- Original Message -
From: "Crystal D. Silver" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, February 13, 2001 3:01 PM
Subject: help please?
> Hi,
>
> My host gives me a MySQL database, and I've had no trouble getting
purchased
> cgi scripts to
I did.. I tried everything...
[root@cents /usr/local/mysql]# chmod -R 0777 var
[root@cents /usr/local/mysql]# llm
total 2.1M
drwxr-sr-x 12 mysqlmysql1.0k Feb 10 00:12 .
drwxr-sr-x 26 root root 1.0k Jan 28 00:59 ..
drwxr-sr-x 2 mysqlmysql1.0k Feb 9 23:48 bi
Yes I tried that too... Same stupid stuff happening
clay bond writes:
>
>
> On Fri, 9 Feb 2001, Mailing List Address wrote:
>
>> Help!
>> [ ... ]
>> 6 rows in set (0.00 sec)
>> (The output should be mysql and test.)
>
> Looks
Help!
I just installed the most recent release and the only thing I'm getting
is...
mysql> show databases;
+--+
| Database |
+--+
| |
| |
| |
| |
| |
| |
+--+
6 rows in set (0.00 sec)
(The output should be mysql and tes
Hi all,
recently i realize that i have a dream: collectign all the web logs
of my 4 web servers to a single db, in real time, to let th eusers make
analisys on it.THe bad thign was the necessity to have a db capable of do
not slowly down the apache.I found a little contrib opn th epgsql di
47 matches
Mail list logo
