|
+--+--+--+-+-++
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]
!
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]
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]
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
For list
Merriman
eTotalHost.com
--
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]
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
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
machine-name-bin.001
machine-name-bin.002
etc
machine-name-bin.index
Some of them are huge! They seem like binary files, but are full
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,
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
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:
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
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,
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)
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)'
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
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, July 12,
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
- Original Message -
From: Kelsey Cummings
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
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 to me like you didn't run mysql_install_db
--
/"\
\ /
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
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
26 matches
Mail list logo