From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: SUPPORT PLEASE - Error while running mysql_install_db
>Description:
After installing successfully mysql in my sun solaris - sparc machine,
while i am trying to run the script "mysql_install_db"
system has given the following error m
I don't think there is a limit.
Just as long as your harddisk can contain the data there should be no
problem.
Remco
- Original Message -
From: "chandra shekar" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, May 07, 2002 5:21 AM
Subject: Maximum number of rows in the table
Thanks Alexander,
It is really a good solution.
But a small problem again.
When I drop a user1_db database, mysql does not allow me to drop it and
throw a error
[root@myserver mysql]# mysqladmin drop user1_db -u root -p
Enter password:
Dropping the database is potentially a very bad thing to do.
Hello,
i have 2 tables,
one:
++---+
| id | descr |
++---+
| 1 | fir |
| 2 | two |
| 3 | fre |
| 4 | fou |
++---+
two:
++--+
| id | data |
++--+
| 1 | a|
| 1 | b|
| 1 | c|
| 1 | d|
++--+
SELECT one.descr, COUNT(two.
Just a guess, but how about an ampersand?
Connection c =
DriverManager.getConnection("jdbc:mysql://localhost/dbName?user=username&pas
sword=password");
George
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, May 07, 2002 5:11 AM
Subject: JDBC connect
Hello,
I think Mr. Carlson requires to output all the dates between two given dates.
This can be done with defined variables and an auxiliary table, the
requirement
being that it should have at least as many rows as there are days between the
dates and to directly give the number of days betwee
Hello,
I've been struggling with this for two weeks, I can't seem to find the answer
wherever I look whether in the core mysql book or the documentation on what
variables, if any go between parameters(user and password) as in:
Connection c =
DriverManager.getConnection("jdbc:mysql://localhost/d
Oh forgot to ask in the last post, how are you setting the password in the
first place? Are you using a grant statement or inserting values into the
table. I reckon the former is better (and safer) but if you're doing the
later the you need to "flush privliges" after any changes so that mysql
Hi
I have a (probably fairly simple newbie question:
Using a select statement (via DBI) I get some details from a table and
at the same time have a row count of how many rows are returned (to be
displayed at the website).
A query like
select count(nation) AS nation, name, nat
hi,
Which header file or library i need to include for strmov ? i have
mysql v3 and i have included mysqlclient library. But it still tells
undefined reference.
Thanx in advance
Chirag
-
Before posting, please check:
h
I am guessing this is a pretty basic question...
There must be a better way for me to do this, but I'm still too new at this
to know what it is. I've gone through some JOIN tutorials and the
documentation, but I don't think I'm quite getting it.
(Using MySQL v3.23.38) I have three tables: my_cl
See that line that says accept any user (%) from any host (%) with password
null. There's your answer. It's a default entry that should be removed (I
think there's stuff in the securing mysql section of the manual about
this).
cheers
noel
On Tuesday, May 07, 2002 1:28 PM, Brandon Metcalf
On Mon, May 06, 2002 at 07:56:10AM +, Alexander Skwar wrote:
> Hi!
>
> As you can see below, SpamAssassin tags messages from the MySQL list as
> spam. The main reason that this happens, is:
>
> SPAM: Hit! (3.5 points) URI: URL of page called "unsubscribe"
Well, you can add local rules to
Okay, I'm obviously missing something here. Even though the
submit_write user has a password set according to the SELECT output
below, I can't use that password or any password to login as this user.
Only a null password is accepted. The first attempt I enter the correct
password; no go. The se
Hi MySql gurus,
We are using MySql for our database support in our project. It is
a multiserver environment. We are using a single table to store
info abt objects of each server. We want to know what is the
maximum number of rows that the MySql supports for a table.
In our case when the number of
Under normal operating conditions our v3.23.47 MySql db server handles about
60 queries per second using 50 threads or less. The host is a dual processor
700MHz Intel machine running the 2.2.14-5.0smp Linux kernel with 256M of
RAM.
Here's the problem: during spikes of activity where about 90-100
On Mon, 06 May 2002 12:56:52 -0400
Gurhan Ozen <[EMAIL PROTECTED]> wrote:
> Hi,
> Change the max_connections variable's value to a higher value. By default it
> is set to 100. You can see what yours is set to with SHOW VARIABLES command.
> See:
>
> http://www.mysql.com/doc/T/o/Too_many_connectio
I am running mysql on solaris. This is a binary release. However, now I
would like to start my server with the innodb functionality. But I can't
start my server working for this.
I am not able to run the ./configure --with-innodb
I dont know how and where innodb_data_file_path should be specif
> Gregg,
> Monday, May 06, 2002, 6:57:55 PM, you wrote:
>
> GG> Upon reading into the user variables section of the mysql manual, I
decided
> GG> to make my life easier inside several of my queries by specifying some
user
> GG> variables. Note that I'm trying to have everything inside the select
>
SELECT FORMAT(yourvalue,2)
- Original Message -
From: "Graeme B. Davis" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, May 06, 2002 10:16 PM
Subject: formatting currency in mysql
> Does anyone have a quick tip on how to format a float/numeric in the
> following currency form
At 15:44 -0500 5/6/02, Jay Blanchard wrote:
>[snip]
>>Then I attempt to query;mysql> select count(*) from tblCross1;
>>ERROR 1016: Can't open file: 'tblCross1.MRG'. (errno: 143)
>>perror 143
>>143 = Conflicting table definition between MERGE and mapped table
>>
>>Can anyone help with this?
>
>Drop
Hi,
I've installed MySQL through the entropy.ch installer. Everything works fine
in the command line utillity but when I try to connect a php script i get
this error message:
Host 'localhost.127.in-addr.arpa' is not allowed to connect to this MySQL
server
I have tried various times to correc t
Hi,
I using Macromedia UltraDev to develop my dynamic web site and would like
to
use mySQL as the RDBMS. My hosting service folks are telling me that I
should only update my database on their server via update transactions.
They
say this is for security reasons. UltraDev provides many good t
[snip]
>Then I attempt to query;mysql> select count(*) from tblCross1;
>ERROR 1016: Can't open file: 'tblCross1.MRG'. (errno: 143)
>perror 143
>143 = Conflicting table definition between MERGE and mapped table
>
>Can anyone help with this?
Drop the MERGE table, then try creating it with all the c
At 15:29 -0500 5/6/02, Jay Blanchard wrote:
>I have these two tables;
>mysql> describe tblClass11;
>+--+---+--+-+-++
>| Field| Type | Null | Key | Default | Extra |
>+--+---+--+-+-
Sergei, here:
RH7.2/2.4.9-31/Dual P-III 866MHz/MySQL4.0.2
A snapshot from a live database, sorry, couldn't prepare a more detailed
example:
--
select tdate, left(header,125) from archivel where match (header) against
('"donald rumsfeld"' in boolean mode);
==> 188 rows in set (0.
I have these two tables;
mysql> describe tblClass11;
+--+---+--+-+-++
| Field| Type | Null | Key | Default | Extra |
+--+---+--+-+-++
| ID | int(11)
Does anyone have a quick tip on how to format a float/numeric in the
following currency format with a query?
$xx,xxx.xx
Thanks!
Graeme
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
[snip]
> If you have MySQL 4, you can use a UNION.
> Otherwise you'll need a second table, because what you want is not
> a join, but a concatenation of result sets.
> [snip]
>
> Don't have 4.0 yet, probably going to wait until a production release
comes
> out. So if I need a second table I will h
Thanks Don, Gurhan, Peter!
uhg. I am sure I searched the docs first. *sigh*
-Original Message-
From: Don Vu [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 06, 2002 3:19 PM
To: Gurhan Ozen; Luc Foisy; MYSQL-List (E-mail)
Subject: RE: Two database servers, same physical server
more detail
more detail on this can be found here
http://www.mysql.com/doc/M/u/Multiple_servers.html
-Original Message-
From: Gurhan Ozen [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 06, 2002 3:10 PM
To: Luc Foisy; MYSQL-List (E-mail)
Subject: RE: Two database servers, same physical server
Hi,
To
Hi
If the databases are not too big, and are on the same machine, you could
just copy the directory with the databases in.
If you need to restore the database just copy it back.
I think this is OK, though you might want to stop mysql to "lock" the
database.
I have only done this a couple of ti
On 6 May 2002, at 7:56, Alexander Skwar wrote:
> As you can see below, SpamAssassin tags messages from the MySQL list as
> spam. The main reason that this happens, is:
>
> SPAM: Hit! (3.5 points) URI: URL of page called "unsubscribe"
It seems to me that that's a problem with SpamAssassin, not
Hi,
To run multiple mysqld servers, you at least have to specify a different
port number, different socket file path, different pid and error log file to
get it started. Different mysqld servers may point to the same database.
To do this, just define the necessary information for your new mysql
Hi,
I using Macromedia UltraDev to develop my dynamic web site and would like to
use mySQL as the RDBMS. My hosting service folks are telling me that I
should only update my database on their server via update transactions. They
say this is for security reasons. UltraDev provides many good tools
At 12:56 PM 5/6/2002, you wrote:
>We are designing an application that needs to use
>a relational database to hold quite a large amount
>of data.
>
>In particular there is one table that has about 33
>fields, 18 indexes, and 120 bytes per record.
>Additionally, we are going to need to add about 2
On 6 May 2002, at 13:06, Jay Blanchard wrote:
> [snip]
> If you have MySQL 4, you can use a UNION.
> Otherwise you'll need a second table, because what you want is not
> a join, but a concatenation of result sets.
> [snip]
>
> Don't have 4.0 yet, probably going to wait until a production release
To the originator of this thread:
While what you are asking is possible, Id like to put my two cents in and
ask you please not to do it.
If this is a production database, you have no idea how helpful it will be
for you to know by those missing pk numbers that something was deleted
manually fr
Over here, we're doing an average of 95 queries per second (that's about
8 mill daily), on a Pentium III @ 900MHz with 768MB of ram. We're
working with smaller data sets, than 30 million records, tho. I imagine
that you could do well with a high end intel system, or a medium-end Sun
box.
A d
[snip]
If you have MySQL 4, you can use a UNION.
Otherwise you'll need a second table, because what you want is not
a join, but a concatenation of result sets.
[snip]
Don't have 4.0 yet, probably going to wait until a production release comes
out. So if I need a second table I will have to do tha
Wow,
Quick response... You guys ( gals) are Great !!
All files /var/lib/CRdb/* (Database Directory) are 777 (CHMOD)
and ownership mysql
All files /var/lib/mysql/mysql/* are 777 as well.
hmm. ( Very Puzzled )
Also the file #sql-6c4_a.frm in the error message does not exist.
>Failed t
We are designing an application that needs to use
a relational database to hold quite a large amount
of data.
In particular there is one table that has about 33
fields, 18 indexes, and 120 bytes per record.
Additionally, we are going to need to add about 2
million records per day to the table, de
I've been trying to import text files into MySQL, but I can't get it to
work. I'm new to MySQL and am still getting familiar with it, so
perhaps I'm missing something. I'm using the LOAD DATA LOCAL command
but I keep getting error 1148 "The used command is not allowed with this
MySQL version."
If you have MySQL 4, you can use a UNION.
Otherwise you'll need a second table, because what you want is not
a join, but a concatenation of result sets.
At 12:47 -0500 5/6/02, Jay Blanchard wrote:
>Here is a puzzler for SQL jockies on a Monday afternoon. I have 2 tables,
>each with what may or ma
Here is a puzzler for SQL jockies on a Monday afternoon. I have 2 tables,
each with what may or may not be a unique range of dates;
tblDate1
+++
| field1 | rDate |
+++
| 1 | 2002-03-01 |
| 2 | 2002-03-03 |
| 3 | 2002-03-05 |
| 4 | 2
Hi!
On May 06, Vadim P. wrote:
> Hi,
>
> It's not quite clear from the manual, but it appears that queries with
> FULLTEXT search patterns like this:
>
> MATCH (some_text_field) AGAINST ('("red pepper") ("green bean")')
>
> don't produce the result desired, that is, multiple ".." elements are
Check your permissions and fileowners one more time. You definitely have
permissions problem.. Make sure that all the datafiles are owned by mysql.
Gurhan
-Original Message-
From: Marko Palikko [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 13, 2002 1:00 PM
To: [EMAIL PROTECTED]
Subject: C
Has someone done this before? What things do I have to take into
consideration
The following are things I know that may be issues
reading mysql.sock
reading my.cnf
database directory ( there is a parameter for command line operation )
I would suppose I would have to create a dual instance of the
Hello All,
I have created a MySQL database on Linux Mandrake 8.0, all is well.
I can add fields / tables ok.
I moved the contents of the database directory and the mysql directory to
another system (Same OS & MySQL). I can access the database but can not add
fields.
>Failed to save field : S
Hi!
I have great trouble compiling MySQLGUI 1.7.5:
Missing headers:
FL/Enumerations.H FL/filename.H FL/fl_ask.H FL/Fl_Bitmap.H Fl/Fl_Box.H
FL/Fl_Box.H FL/Fl_Browser.H FL/Fl_Button.H FL/Fl_Check_Button.H
FL/Fl_Choice.H FL/Fl_Dial.H FL/Fl_Double_Window.H Fl/fl_draw.H
FL/fl_draw.H FL/fl_file_choo
Hi,
Change the max_connections variable's value to a higher value. By default it
is set to 100. You can see what yours is set to with SHOW VARIABLES command.
See:
http://www.mysql.com/doc/T/o/Too_many_connections.html
http://www.mysql.com/doc/S/H/SHOW_VARIABLES.html
Gurhan
-Original Messag
Get rid of percentage signs in your keyword...
See: http://www.mysql.com/doc/F/u/Fulltext_Search.html
Gurhan
-Original Message-
From: Shehryar Shafiq [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 06, 2002 12:46 PM
To: [EMAIL PROTECTED]
Subject: please help: search database - code attach
Hi..
Rewrite it as:
WHERE MATCH (some_text_field) AGAINST ('"red pepper"' IN BOOLEAN MODE) AND
MATCH (some_text_field) AGAINST ("green bean"' IN BOOLEAN MODE);
Gurhan
-Original Message-
From: Vadim P. [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 06, 2002 12:07 PM
To: [EMAIL PROTECTED]
S
MySQL keeps locking up (I get a "Too many connections" error.)
Is there a way that I can increase the number of connections that MySQL
will take?
SQL and Query
David McInnis
-
Before posting, please check:
http://www.mysql
Hi,
I have a table of jobs.
I would like user to search the jobs on three columns:
description,
location,
type,
on the search page, i have one text field, and one
drop down menu. the search field will be used for
keywords against the description and location columns.
the drop down will
Gregg,
Monday, May 06, 2002, 6:57:55 PM, you wrote:
GG> Upon reading into the user variables section of the mysql manual, I decided
GG> to make my life easier inside several of my queries by specifying some user
GG> variables. Note that I'm trying to have everything inside the select
GG> statemen
-Original Message-
From: Peter Lovatt [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 06, 2002 12:09 PM
To: Yvon Darang; [EMAIL PROTECTED]
Subject: RE: Newbie Question
Hi
If you are developing for a Windows desktop, MyODBC with Access, Paradox or
Delphi all workm, from experience.
If yo
Hi Carsten,
I've tried Mysql++ and SQLAPI.
I am asking if someone out there know about other best tools in C++ for
Mysql on linux.
Thanks,
Hisseine
- Original Message -
From: "Carsten Gehling" <[EMAIL PROTECTED]>
To: "Hisseine Dj." <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday
Dennis,
Monday, May 06, 2002, 4:51:50 PM, you wrote:
D> I have tried almost everything and nothing works.
D> The problem is, I have a server with different MySQL databases from
D> different people.
D> User 1 should not access database 2 and user 2 should not access database 1.
D> What is the e
Hi
If you are developing for a Windows desktop, MyODBC with Access, Paradox or
Delphi all workm, from experience.
If you are developing for Linux desktop, then not sure, but perhaps others
have experience
Peter
---
Excellence in internet and open
Of course, I forgot to mention 'IN BOOLEAN MODE'.
...
MATCH (some_text_field) AGAINST ('("red pepper") ("green bean")' IN BOOLEAN
MODE)
...
>
"Vadim P." wrote:
>
> Hi,
>
> It's not quite clear from the manual, but it appears that queries with
> FULLTEXT search patterns like this:
>
> MATCH
Greetings,
Upon reading into the user variables section of the mysql manual, I decided
to make my life easier inside several of my queries by specifying some user
variables. Note that I'm trying to have everything inside the select
statement - Primarily because I'm simply passing it through to my
Hi,
It's not quite clear from the manual, but it appears that queries with
FULLTEXT search patterns like this:
MATCH (some_text_field) AGAINST ('("red pepper") ("green bean")')
don't produce the result desired, that is, multiple ".." elements are not
allowed, with or without parentheses...
Cou
Hi,
I'm using MySQL4.0.1-alpha under linux and want to use my own udfs. I
tried to get working the udf_example and followed the MySQL manual.
Compiling the file and using the CREATE FUNCTION command didn't succeed.
I got the following error messages:
gcc -shared -o udf_example.so -rdynamic udf_e
Hi,
The long awaited version 1.0.13 is now available for downloading. The list
of changes and new features is too long, so I will give you a short
description of what we changed:
- New relationship editor ( now it can handle add new, update and delete and
shows the SQL statement as an example)
-
I have before me what seems to be a very daunting task to someone with my
limited SQL knowledge. I'm upgrading our ad server which runs on MySQL
3.22.32 to a newer machine and MySQL 3.23.39. Right now there are 16GB worth
of databases that need to be transferred over, and the old server lacks
eno
You can download MySQL++ from www.mysql.com
- Carsten
> -Oprindelig meddelelse-
> Fra: Hisseine Dj. [mailto:[EMAIL PROTECTED]]
> Sendt: 6. maj 2002 17:24
> Til: [EMAIL PROTECTED]
> Emne: C++ API for Mysql
>
>
> Hello,
>
> Can someone tell me if there is an C++ API that works smooth with
Hello,
Can someone tell me if there is an C++ API that works smooth with MYSQL on
linux.
So far I was trying msql++ and SQLAPI++.
SQLAPI++ seems to be good by there are problems when runing the program.
My system is Redhat 7.2 and Mysql 3.23.49
Thanks,
Hisseine
-
Hello,
Can someone tell me if there is an C++ API that works smooth with MYSQL on
linux.
So far I was trying msql++ and SQLAPI++.
SQLAPI++ seems to be good by there are problems when runing the program.
My system is Redhat 7.2 and Mysql 3.23.49
Thanks,
Hisseine
--
GRANT ALL PRIVILEGES ON databasename.* TO user IDENTIFIED BY 'password';
http://www.mysql.com/doc/G/R/GRANT.html
Gurhan
-Original Message-
From: Dennis [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 06, 2002 9:52 AM
To: [EMAIL PROTECTED]
Subject: Every user can access the databases
I h
You could use Kylix from Borland. It's a RAD tool - it's actually Delphi
ported to Linux.
- Carsten
> -Oprindelig meddelelse-
> Fra: Yvon Darang [mailto:[EMAIL PROTECTED]]
> Sendt: 6. maj 2002 15:31
> Til: [EMAIL PROTECTED]
> Emne: Newbie Question
>
>
> Hi everybody,
> Let's say I do not
Hi everybody,
Let's say I do not want to use any microsoft tool on my PC. Is it possible
to develop a desktop application using MySQL as database server without
having to program in C or C++ to access and display the Data?
My question probably should be: If not ODBC, what desktop database
applica
Hi!
On May 06, Gurhan Ozen wrote:
>Is there anyway to see what bugs have been reported for fulltext search
> in 4.0.1 alpha ? I know that Jeremy Zawodny has mentioned that a few bugs
> were found in fulltext search in 4.0.1 , but didn't tell what they were.
> I have installed 4.0.1 and ran
[snip]
The problem is, I have a server with different MySQL databases from
different people.
User 1 should not access database 2 and user 2 should not access database 1.
What is the easiest way to prevent user 1 to access database 2. I can't get
it right.
[/snip]
http://www.mysql.com/doc/G/R/GR
HI,
Praful Saijare wrote:
>Hi all,
> How do I go about applying user quota on mysql databases, so that I =
>can keep track of the disk space used by all the databases users.
>
>I am using RH linux 7.0 =20
>Mysql 3.23.40 installed on /var/lib/mysql/
>quota-2.00pre3-7 applied on /home partation
Hi!
Can I turn on logging of all SQL-Commands send by one particular client on
the server side? Turning on logging for all clients seems to be possible.
Does it work for one client only too?
--
Thomas
-
Before posting, plea
Nick,
Monday, May 06, 2002, 3:58:34 PM, you wrote:
NW> * and then Egor Egorov declared
>> "Access denied" error occurs when you have no required privileges to
>> connect to the MySQL server. You gave incomplete error message and I
>> can't give you detailed answer. Please, check the following
Hi Donna,
Donna Robinson wrote:
>Hi Jeremy,
>
>On Sunday 05 May 2002 5:52 am, Jeremy Zawodny wrote:
>
>>REGEXP queries don't use indexes. Change the:
>> REGEXP "^A"
>>to
>> LIKE "A%"
>>and it'll use the index and give you a nice speed boost.
>>
>
>which indeed it did! I checked the manual (yet
I have tried almost everything and nothing works.
The problem is, I have a server with different MySQL databases from
different people.
User 1 should not access database 2 and user 2 should not access database 1.
What is the easiest way to prevent user 1 to access database 2. I can't get
it rig
Is there anyway to see what bugs have been reported for fulltext search
in 4.0.1 alpha ? I know that Jeremy Zawodny has mentioned that a few bugs
were found in fulltext search in 4.0.1 , but didn't tell what they were.
I have installed 4.0.1 and ran it as second mysqld in my web server,
mainl
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
* and then Gurhan Ozen declared
> Make sure that the user + host combination you are giving has privileges
> in the MySQL server you are trying to connect. You may wanna check user
> table in the mysql database.
Well, there must be privileges
Make sure that the user + host combination you are giving has privileges
in the MySQL server you are trying to connect. You may wanna check user
table in the mysql database.
Gurhan
-Original Message-
From: Nick Wilson [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 06, 2002 6:30 AM
To: [E
You can use perror to see what that error code is>
perror 28
Error code 28: No space left on device
Seems like you ran out of space?
Gurhan
-Original Message-
From: Scott Raley [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 06, 2002 8:44 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED
Have you checked the network connection? You should be running at
full-duplex so you don't get collisions. But more importantly, make sure you
aren't getting errors on the line. A poor crimp or pinched wire could really
slow things down, especially if you try running at 100MB.
Try copying a single
Balteo,
MySQL/InnoDB-3.23.50 for Windows is available for download at
http://www.mysql.com/downloads/mysql-3.23-pre.html. The 'prerelease' status
only concerns Linux, where a new glibc and a new compiler are tested. For
other platforms this is a normal stable release.
For the InnoDB changelog se
{snip]
When I try and insert a string into an integer field, instead of throwing
an error MySQL accepts the insert and set that field's value to zero (I
assume default value). I am using the php mysql module by the way (not
PEAR). I would like to get an error when I insert the wrong data type in
When I try and insert a string into an integer field, instead of throwing
an error MySQL accepts the insert and set that field's value to zero (I
assume default value). I am using the php mysql module by the way (not
PEAR). I would like to get an error when I insert the wrong data type into
Hello,
Tim Carlson wrote:
>Hello,
>
>Newbie SQL person here. I am hoping to be able to do the
>following. Given two dates, I would like to display all of the days
>between them.
>
>So if I had the dates 2002-02-08 and 2002-02-12, I would like to have
>MySQL spit back
>
>2002-02-08
>2002-02-09
>20
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
* and then Egor Egorov declared
> "Access denied" error occurs when you have no required privileges to
> connect to the MySQL server. You gave incomplete error message and I
> can't give you detailed answer. Please, check the following
> link, yo
I'm using DBTools Table Manager to make table changes in Mysql 3.23... I'm
trying to add an auto_increment ID field to 2 tables that already have data in
them.. 1 table worked fine, the other table I get "Got Error 28 from Table
Handler"
can anyone tell me why I get this?
TIA
--
Doron,
Monday, May 06, 2002, 3:44:02 AM, you wrote:
D> I got the above error when inserting a row into a heap table on linux
D> mySQL version 3.23.49a from the Java JDBC driver. This is not reproduceable
D> on a win32 DB. This does not appear to be space related as it failed after
D> only abo
Sven,
Saturday, May 04, 2002, 4:52:00 PM, you wrote:
SB> The mySQL DB I have to rebuild was only one big table. Afer developing a
SB> new DB design for it, I ran into the problem of transfering the data
SB> from the old to the new database.
SB> I need to split up the records and insert them int
Nick,
Monday, May 06, 2002, 1:30:22 PM, you wrote:
NW> Hi all, I'm getting intermittent 'Access denied' errors when running a
NW> php script to admin a mysql db. I've looked in the manual but cannot
NW> work out why I can connect in some parts of the script and not in others
NW> Perhaps there
Phil,
Monday, May 06, 2002, 1:42:28 PM, you wrote:
PD> I've just installed MySQL 3.23.49 on Mac OS X.1.4. The installation went fine
(into /usr/local/) but now I'm having what I believe is a common permission problem.
When trying to add a database I
PD> get the following error:
PD> [localhost:
Praful,
Monday, May 06, 2002, 2:41:54 PM, you wrote:
PS>How do I go about applying user quota on mysql databases, so that I =
PS> can keep track of the disk space used by all the databases users.
PS> I am using RH linux 7.0 =20
PS> Mysql 3.23.40 installed on /var/lib/mysql/
PS> quota-2.00pr
Jack,
Monday, May 06, 2002, 7:40:08 AM, you wrote:
J> Two Question :
J> 1.
J> I know that the 'LOAD DATA' command loads a bulk of data into a table, but
J> what happen if i only want to load the data into specifc fields on a table
J> instead of whole table.
J> eg.
J> Let say i had a file with 3
Samuel,
Monday, May 06, 2002, 1:55:44 PM, you wrote:
SM> REALFROM: "Samuel Mendelowski" <[EMAIL PROTECTED]>
SM> HOUR: 2002050614
SM> The file hostname.err description:
SM>mysqld started
SM>/usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13)
SM>mysql ended
SM> The
Hi,
Neil Bobstone wrote:
>Hi,
>
>I Have compile Mysql 3.23.49 with : --enable-local-infile
>
>
>
>But when I want to use LOAD DATA LOCAL its says : The used command is
>not allowed with this MySQL version
>
--enable-local-infile affects client library libmysqlclient
Can you check if client l
[snip]
iduser | dtaccess
---
10 | '2000-10-02'
3 | '2000-12-04'
4 | '2000-10-09'
3 | '2000-12-04'
5 | '2001-02-10'
10 | '2001-03-01'
10
Hi all,
How do I go about applying user quota on mysql databases, so that I =
can keep track of the disk space used by all the databases users.
I am using RH linux 7.0 =20
Mysql 3.23.40 installed on /var/lib/mysql/
quota-2.00pre3-7 applied on /home partation
Thanks in advance
Praful
--
1 - 100 of 112 matches
Mail list logo
