| 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]
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 *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" <[
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
28 matches
Mail list logo
