On Fri, 8 Jun 2001, Peter Kok wrote:
Hi,
Your mail is misleading
>
> I know it how to do it now
>
> First remove all rpm eg: php, apache and mysql
You need not remove all rpms - just remove php
> then download tarball from php, apache and mysql
download just php sources
> php4.0.5
I am trying to give MySQL a string and then compare it to a column.
For example, say I have the string: "helloworld", and I have a
table with one column ("keyword"), and three records: "low", "324", "kda".
I want to select the records that are found in the string (in this
case, I want it to retur
Not sure what the "load data local infile" thing is, but I always
load text files from the command line like this (on Red Hat linux):
% mysql -u some_guy -p some_db < /full/path/to/file.txt
>I'm a new user, working through the tutorial provided in the MySQL
>documentation (chapter 9). I'm tryi
I'm a new user, working through the tutorial provided in the MySQL documentation
(chapter 9). I'm trying to load the data from the pet.txt file into the pet table
using the specified command: mysql> load data local infile "pet.txt" into table pet;
I get the following:
ERROR:
File 'pet.txt' no
Sorry about this questions but why would you want to run two copies of
mysqld when it is capable of hosting as many different databases as
you need? Even if you needed two databases with the same name you
could still just create two different MySQL users for it.
Thanks,
Neil
On Sat, 9 Jun 2001
database,sql,query
On Fri, 8 Jun 2001, Gabriele Bartolini wrote:
>
> >magic_quotes_gpc = On ; magic quotes for
> >incoming GET/POST/Cookie data
>
> And, what about: magic_quotes_runtime ?
Off.
Adrian
--
Hello All:
I have two mysqld runnning in ports: 3307 & 3308 respectively. I started the
second one by using 'mysqld_multi start 2'. whereas mysqld running on
port 3307 is the default mysqld started at the boot time.
when i issue command such as:
mysql -u root -p (it connects to my new mysqld r
At 21:38 08/06/2001 -0500, Adam Clauss wrote:
Hi,
If you are compiling a console application without the support
of MFC add the #include line, otherwise when using
MFC during the wizard process, check the support for sockets.
Regards,
Miguel
>I am using VC++ 6 on Win2K.
>What is the exact proc
I don't have source for glibc, so i executed this
statement 'localedef -i en_US -f ISO-8859-1 en_US'
But it still gives me that error!
...Rohit
- Original Message -
From: James Barwick <[EMAIL PROTECTED]>
To: Rohit Peyyeti <[EMAIL PROTECTED]>
Sent: Saturday, June 09, 2001 12:29 AM
Sub
This was a problem originally submitted on msql-mysql-modules:
Under Darwin 1.3.3/PPC G4, using mysql built from mysql-3.23.36+, the perl module
DBD-mysql-2.0901 (and previous versions of DBD::mysql do this as well) returns 0 for
$dbh->{'mysql_insertid'} (return LAST_INSERT_ID from a database
Let me see if I understood your question:
"select * from tablename a, tablename2 b where a.account='BILL' and
a.account=b.account"
It's tow tables or just one table?
because if it's just one table just do "select * from tablename where
account='BILL'"
see you,
Augusto
On Sat, 9 Jun 2001, Jai
Hi
How do I perform this query using one operation?
SELECT * FROM tablename WHERE account = (select account from tablename
where name='BILL');
What I want is to lists all entries who's account is the same with 'BILL'.
Thus far, what I know is to extract the account of 'BILL' and then
perform an
>Description:
I was installing MySQL on my Red Hat 7.1 server; I tried both the RPM and the
tar.gz format. No matter what, though, I don't have mysqladmin or safe_mysqld files
anywhere. I imagine that there are several other things missing as well. Note that
when I try to run make with
Jeremy:
Looks like I might have to eat my words a little. Not entirely on the running
of MySQL in a jail, but, perhaps that too, in time.
The application started as a knowledge-base, billing application.
The piece I'm concerned with now involves an implementation using
.profile/.bash_profile m
I am using VC++ 6 on Win2K.
What is the exact process I need to go through to set this up to use it?
I compiled the original project in the root directory. I then setup one of my
programs to include the as the example had. I also have the lib file
included to link in the project settings. Bu
I've used a rule of thumb that I was told ages ago when working on other
databases that inserting records into a non-indexed table is faster
generally than inserting records into an identical but indexed table.
I realize that this statement is probably an antiquated guideline.and
I'd like to
> Hello all,
>
> does anyone have any feedback whether there is any difference in the
> efficiency of the following query on a fairly large dataset
>
> 1. select * from tbl
This will be the slowest.
> 2 select count(*) from tbl
This will be very fast since MySQL is optimized for it (the number
Try it =P (just don't forget the WHERE clause)
If you want to make your query easier to write, use aliases:
SELECT d1t1.field1, d2t1.field1, d2t2.field2 FROM database1.table1 AS d1t1,
database2.table1 AS d2t1, database2.table2 AS d2t2 WHERE d1t1.id = d2t1.id
AND d2t1.id = d2t2.id
> Can I do que
> Is there a common cause to the following problem?:
>
> mysql> select parent_referral from referral;
> ERROR 1030: Got error 127 from table handler
chris@mirage:~$ perror 127
Error code 127: Unknown error: 127
127 = Record-file is crashed
chris@mirage:~$
> Our system is running 3.22.23b and we
Hi all
I know it how to do it now
First remove all rpm eg: php, apache and mysql
then download tarball from php, apache and mysql
php4.0.5 new version
apache-.1.3.19
mysql-3.22.32-pc-linux-gnu-i686.tar.gz (I found that it doesn't work on
new version)
tar zxvf all the above
and
I've installed mysql 3.23.38 from source on redhat 7.0 (apache 1.3.39 and
PHP 4.0.5 also installed from source). The PHP and the apache are running
fine, and I can view database tables using "MysqlAdmin" from a web browser,
but if I run mysql from the command line, I get the following error "mysql
Hi, All.
I have a problem to run a script in mysqlmanager.
I have file generated with mysqldump with the data definition of my
database, but
the error show is (You have an error in your SQL syntax near ';).
Has anyone encountered this problem .
Thanks.
==
You really shouldn't be using SELECT *. Try SELECT S1.sitename AS
FirstSiteName, S2.sitename AS SecondSiteName, etc etc etc.
> Ok, I've answered my own question but now have another.
>
> How do I reference the sitename for the 3 sites?
> sitename returns the last sitename for all 3 I tried S1.sit
Never run isamchk with the server running.
Joan Vidal wrote:
> I can't believe MySQL is behaviouring that way and giving that kind of errors.
> I've tried MySQL versions 3.23.33 and 3.22.27 both in Solaris and RedHat linux,
> all with the same results.
>
> Can anyone please help?
>
> Thx in ad
Look in the manual about the ENCODE/DECODE functions.
j- k-
On Friday 08 June 2001 10:28, you wrote:
> Hello all,
>
> I have some questions about password encryption. I want to make some sort
> of encryption method that disables a human to read the password, but does
> allow my (php) scr
Hi all,
I got my java connection working but now I need to export a MS Access
database to mysql database.
Does anyone knows the fastest way to do it
My main question is:
Is there a way to export the table structures and data at same time? Or do I
have to create the tables structures and
I tried this query:
Update phone inner join tmpphone on phone.empno = tmpphone.empno
set
phone.lname = tmpphone.lname,
phone.fname = tmpphone.fname
and it didn't work.
This works in MSAccess.
Is this syntax (or something like it) supported by MySQL??
-
Hi, Mysql guys:
I have problem to install mysql into my DEC-AlphaServer 800 which run
DEC-osf4.0d. I downloaded mysql source file: mysql-3.22.30-dec-osf4.0f-
alphaev6.tar.gz, after run #./configure, then #make, it show the
problems, although I try command #make install, the error message is
sh
I got it working
Thanks anyway
Siomara
>From: "Siomara Pantarotto" <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED]
>Subject: connect MYSQL via java
>Date: Fri, 08 Jun 2001 14:31:26 -0300
>
>Hi all ,
>
>I got a critical situation to solve and I wonder if you can help me on
>that. I promise to be ve
Yes Im running RegHat 6.2 I downloaded the RPM's off the mysql website.
Mike
-Original Message-
From: Larry Hotchkiss [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 08, 2001 11:22 AM
To: 'Mike Jimenez'
Subject: RE: What am I missing?
what OS ya running? RH? Are the RPM's ya used from the
Hello all,
I have some questions about password encryption. I want to make some sort of
encryption method that disables a human to read the password, but does allow my (php)
script to convert the encoded password to a human-readable password, the member
originally entered and the member enters
I am trying to use a fulltext search to searh a database of varchars and
text objects on version 3.23.23.
my query is "select id, price, manufacturer, shortdesc, partnumber,
MATCH (shortdesc) AGAINST ('digital') AS score from product LIMIT 0,15"
.
all of my fields return corret values, but score
Did you try EXPLAIN query? That might give you some hints as to why it is
taking so long. That might point you in the right direction.
j- k-
On Friday 08 June 2001 08:28, Paul Wilkinson wrote:
> Hi,
> I DESPERATELY need help!
> This motor does't seem to have a gas pedal.. It takes a f
Is there a common cause to the following problem?:
mysql> select parent_referral from referral;
ERROR 1030: Got error 127 from table handler
I can run a describe on the table and I can sucessfully run:
select count(*) from referral
but if I try to actually query the data in the table I get
I can't believe MySQL is behaviouring that way and giving that kind of errors.
I've tried MySQL versions 3.23.33 and 3.22.27 both in Solaris and RedHat linux,
all with the same results.
Can anyone please help?
Thx in advance,
Joan
The tests consists in:
* creating a table,
* to insert 2 reg
Can I do query like this:
Select Database1.table1.field1, database2.table1.field1, database2.table2.field2 FROM
database1.table1, database2.table1, database2.table2
François Boucher
[EMAIL PROTECTED]
Hi all ,
I got a critical situation to solve and I wonder if you can help me on
that. I promise to be very specific on my questions once I know what need to
be done, except that instead of Oracle I got to connect mySQL via java.
The first questions are:
1) Do I need to download a driver, and
This is what it says now when I run mysqld_multi start 2:
perl: warning: Setting locale failed.
perl: warning: Please check that your locale settings:
LANGUAGE = (unset),
LC_ALL = (unset),
LANG = "en_US"
are supported and installed on your system.
perl: warning: Fallin
Ok, I've emailed
[EMAIL PROTECTED]
three times, and I'm still not off the SQL database list. What's going
on? Am I
doing something wrong? How do I get off this list? If there's a
moderator out there, could (s)he please take me off the list?
Thanks
--
Yeah I tried to install that to but it would not compile. It wanted lib
files that were not there? It seems as though the RPM version does not
install them? But on another server I have that has MYSQL compiled from
source the lib files were present?
These are the files I'm talking about
/usr/local
Can anyone describe me the architecture of mysql operation ??
I know it starts with a script, that manages the child process, and if child
dies, it's replaced by a new one.
I have several mysqld processes working simultaneously.
How do they comunicate with each other ? Do they read concurrently
Perhaps you need the MySQL-DBI-perl-bin RPM (?).
Is there such a thing?
On Fri, 8 Jun 2001, Mike Jimenez wrote:
> Perl is already installed installed on the server.
> Mike
>
>> You don't need MySQL-bench-3.23.38-1.i386.rpm to run mysql but if you
>> still want to use it, you need to install per
On Fri, 8 Jun 2001, technical Support wrote:
> Hello All,
>
> I have tried the settings as suggested in this FORUM like using htmlentities
> etc... however, my pound sign in the database is displayed as: ú
Are you seeing this stuff from the standard Windows telnet client?
If so get yourself a be
Hi,
is there a way I can assign quota to database users, so they want be able to use
all of my disk size? Ideally I would like to assign quota to each user
individually.
Is it possible at all?
Rafal
--
_/_/ _/_/_/ - Rafał Jank [EMAIL PROTECTED] -
_/ _/ _/ _/ _/
On Fri, 8 Jun 2001, Rolf Hopkins wrote:
> What you wrote here and what you wrote below are not the same
>
> update vusers set name="Adrian D'Costa" where id=3;
>
> update vusers set name='Adrian D\'Costa' where id=3;
>
> will both work. Look up the section on escaping special characters in the
I donwloaded the mysql 3.23.38 binary for AIX 4.3.3 and installed an IBM rs6000
workstation. When I try to start mysql server with safe_mysqld, I got following error
message:
>
Start MySQL server deamon
exec(): 0509-036 Cannot load program /usr/local/mysql/bin/my_print_defaults be
I have installed mysql-3.23.38-hp-hpux10.20-hppa1.1 on an hpux10.20 Unix
machine. However, I cannot get the mysqld executable to run. I get an
error that looks like this:
# ./bin/safe_mysqld --skip-grant --user=mysql
Starting mysqld daemon with databases from /usr/local/mysql/data
./bin/safe_my
Thanks for the answer, but I guess it brings up another question: I was
planning to keep the connection open while the app is running, which could
be a long period of time, and the same issue could occur during that period.
Is it better to open and close the connection for every query I run?
Hi,
> Are there any issues with user variables ( SET @variable:=) overflowing
> memory on the server?
> At any one
> time I wouldn't need most of them, but I don't see any way of
> removing them
> once set. Might this be an issue, or is there some garbage collection
> and/or memory limit on the
Perl is already installed installed on the server.
Mike
-Original Message-
From: Rolf Hopkins [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 07, 2001 7:17 PM
To: Mike Jimenez; Mysql
Subject: Re: What am I missing?
You don't need MySQL-bench-3.23.38-1.i386.rpm to run mysql but if you st
Hi,
I DESPERATELY need help!
This motor does't seem to have a gas pedal.. It takes a full 4+ seconds to
run! Only ~500 rows in table. I chopped a lot of group by ordering, etc
off.
SELECT d.DigIDsKey,d.Title,d.ValueEnglish,d.URL
FROM DigIDs AS d
WHERE d.DigIDsKey IN(22, 27, 84, 164, 272, 289, 5
The explain result (product of rows) is less than 200,000. I'll include it here, but
I don't know if it's readable or not:
++++---+-+--+---+--
Hello all,
does anyone have any feedback whether there is any difference in the
efficiency of the following query on a fairly large dataset
1. select * from tbl
2 select count(*) from tbl
3. select field1,field2,field3 from tbl
TIA
Chris Penning
CSM Systems Inc.
Edmonton, AB
T5J 3S9, Canada
Hello All,
I have tried the settings as suggested in this FORUM like using htmlentities
etc... however, my pound sign in the database is displayed as: ú
Any more tips help etc...
> -Original Message-
> From: technical Support [mailto:[EMAIL PROTECTED]]
> Sent: 07 June 2001 21:53
> To: [
Hi all,
Is there any reason why I can't do something like any of the following?
SET @blah := SHOW VARIABLES LIKE 'server_id';
SHOW @blah := VARIABLES LIKE 'server_id';
It doesn't seem to work no matter which combinations of syntax I try.
Is setting user variables only supported via the SET and
Dear Sir,
AFAICS your query does a FULL join of tables "badge_history, badge,
badgests, department, area" AND an additional LEFT JOIN. Even with indexes
the product may be too big for large tables. What says EXPLAIN SELECT?
Thomas Spahni
On Thu, 7 Jun 2001 [EMAIL PROTECTED] wrote:
> Dear Sirs
Hey there. I got it working quickly but there were a few issues I
wanted to mention about using a binary distribution.
First off:
The file /usr/local/mysql/libexec/mysqld doesn't exist or is not
executable
The binary distribution puts mysqld into bin/ not libexec/, so you'd
think mysql.
[EMAIL PROTECTED] writes:
> Hello, I need some help to solve a problem starting mysql . I have installed all the
>files in a specific directory, and modify basedir, datadir et pid_file in the file :
>support-files/mysql.server. Running the daemon is OK but when i try to start mysql i
> have the
[EMAIL PROTECTED] writes:
> >Description:
> I receive the following error when running scripts/mysql_install_db
>
> Error is :-
> Preparing db table
> Preparing host table
> Preparing user table
> Preparing func table
> Preparing tables_priv table
> Preparing columns_priv
On 08-Jun-01, Super-User said something totally profound about Fail to compile on
Solaris 8 Intel that made me ponder...
S> Hi,
S>
S> I keep running into the following error trying to compile (running
S> ./configure) mysql -3.23.38 on Solaris 8 x86:
S>
S> "checking return type of sprintf... co
Hi,
> > > So where does mysql get its salt from? Is it a random salt?
> This confused the hell our of me for around an hour!
> > You should look MySQL manual not C crypt manpage ;). And yes, this is
> > random salt and makes life little bit more secure.
> Ok, so you can obtain a random result (
Rob Sedman writes:
> I am trying to install mySQL on my Solaris 2.5.1 system. I have downloaded
> the latest binary and followed the instructions as best I understand them
> (not being very familiar with UNIX systems). I have not used the default
> directory (/usr/local/mysql).
>
> I have not f
Hello, I need some help to solve a problem starting mysql . I have installed all the
files in a specific directory, and modify basedir, datadir et pid_file in the file :
support-files/mysql.server. Running the daemon is OK but when i try to start mysql i
have the following message : error 2002
Road Runner writes:
> i am unable to execute the configure command as part of the mysql
> installation.
>
> if i execute this statement using 'configure" found in
> /usr/doc/libtool-1.3.5/demo/:
>
> [root /mysql-3.21.33c-pc-linux-gnu-i686]#
> /usr/doc/libtool-1.3.5/demo/configure
> --prefix=/usr
I am trying to install mySQL on my Solaris 2.5.1 system. I have downloaded
the latest binary and followed the instructions as best I understand them
(not being very familiar with UNIX systems). I have not used the default
directory (/usr/local/mysql).
I have not found a solution for the followi
Thierry Coopman writes:
> At 16:10 +0300 07-06-2001, Sinisa Milivojevic wrote:
>
> Is there a way to tune MySQL for a lot of updates? most performance
> tunings consider selects not updates.
> Since the table is in memory, I guess HDD speed is not a factor (on a
> SunFire280R those are FCAL dis
- Original Message -
From: "Adrian D'Costa" <[EMAIL PROTECTED]>
To: "Rolf Hopkins" <[EMAIL PROTECTED]>
Cc: "Mysql Mailing List" <[EMAIL PROTECTED]>
Sent: Friday, June 08, 2001 17:47
Subject: Re: php/mysql question
> On Fri, 8 Jun 2001, Rolf Hopkins wrote:
>
> >
> > - Original Messag
On Fri, 8 Jun 2001, Rolf Hopkins wrote:
>
> - Original Message -
> From: "Adrian D'Costa" <[EMAIL PROTECTED]>
> To: "Mysql Mailing List" <[EMAIL PROTECTED]>
> Sent: Friday, June 08, 2001 13:59
> Subject: php/mysql question
>
>
> > Hi,
> >
> > I am not sure whether this relates to this
On Fri, 8 Jun 2001, Gabriele Bartolini wrote:
>
> >$tname =urldecode($name);
> >$tname1 = stripslashes($tname1);
> >$updtStmt = "update vusers set orgname='$tname1' where id=$tid";
>
> It all depends on these 2 variables settings:
>
> magic_quotes_gpc= On
> magic_quotes_runtime=
Hi ,
I downloaded the mentioned tarball and when I ran configure on my machine,
these were the messages which were shown on screen and it failed.
---
#./configure
loading cache ./config.cache
checking host s
Just use the password() function, which will return a nice 16-byte 1-way encrypted
string.
On Fri, 08 Jun 2001 00:04:18 -0700
Richard Ellerbrock <[EMAIL PROTECTED]> wrote:
> Ok, so you can obtain a random result (thought that was what random()
> was for), but still cannot understand how this co
Hi,
I keep running into the following error trying to compile (running
./configure) mysql -3.23.38 on Solaris 8 x86:
"checking return type of sprintf... configure: error: can not run test
program while cross compiling"
I'm using gcc 2.95.3.
Has anyone compiled succesfully on sol8 x86 and is w
SEND-PR: -*- send-pr -*-
SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as
SEND-PR: will all comments (text enclosed in `<' and `>').
SEND-PR:
From: root
To: [EMAIL PROTECTED]
Subject: [50 character or so descriptive subject here (for reference)]
>Description:
I rec
>Description:
I receive the following error when running scripts/mysql_install_db
Error is :-
Preparing db table
Preparing host table
Preparing user table
Preparing func table
Preparing tables_priv table
Preparing columns_priv table
Installing all prepared tables
0
Did you add user to your database with the SQL GRANT statement?
Neil
On Thu, 7 Jun 2001, Martin wrote:
> Warning: MySQL Connection Failed: Access denied for user:
>'[EMAIL PROTECTED]' (Using password: YES) in setup.php on line 92
>
> I am sure that all information is correct as far D
On Fri, 8 Jun 2001, Udayavani Udayavani wrote:
> It has a table called "table1" this table has no records.
>
> But due to this table we are losing the 16 MB of space in our quota.
>
> I think its due to these files :
> Can we minimise the space accquired by "table1.ISD" by any means?
>
> What
Jeremy
So what your pointing out is I am seeing several threads
generated by mysqld...
But that does not answer as to why the rpm installation
start with one thread??
Both installations which I compiled from source start
with multiple threads.. ( diffrent machines Caldera 2.3)
Sa
On Thu, Jun 07, 2001 at 08:23:03AM -0400, R Talbot wrote:
> Please explain why I get multiple Daemon process
> when I start mysql.server..Such as
>
> 1075 pts/0S 0:00 sh /usr/local/mysql/bin/safe_mysqld
> --user=root --pid
> 1093 pts/0SN 0:00 /usr/local/mysql/libexec/mysqld
> -
On Thu, Jun 07, 2001 at 02:05:57PM -0500, Aaron Williamson wrote:
>
> I'm sure this has been beat into the ground here, but I've nowhere
> else to turn.
Whenever you're sure that a question has been asked many times before,
it's best to check the documentation and the mailing list
archives. We're
On Thu, Jun 07, 2001 at 06:43:01PM +, [EMAIL PROTECTED] wrote:
> Dear Sirs,
>
> We have a very large database (badge_history has > 4,000,000 rows)
> and the explain for our query looks like this:
Like what?
> By using indexes for a query, the product of the row estimates from
> an explain s
Did you try the following code
$updtStmt = "update vusers set orgname=\"$tname1\" where id=$tid";
Should do the job.
Regards
P. Miquet
- Original Message -
From: "Adrian D'Costa" <[EMAIL PROTECTED]>
To: "Mysql Mailing List" <[EMAIL PROTECTED]>
Sent: Friday, June 08, 2001 7:59 AM
Subject
> >The Linux kernel is 2.2.13 and has been installed from a Mandrake
> >distribution. This is also the source of Apache, PHP 3 and MySQL. The
> >distribution puts files in non-standard places so I am wondering if the
> >solution to my problem is to find the right base directory to use in the
>
Hi,
I am not sure whether this relates to this list or the (not working) php
list.
For simplicity: I have a form that displays data from a table. I will
take just one field that displays a name
This allow a user to update the changes when the submit button is pressed.
On the next php file I
Please explain why I get multiple Daemon process
when I start mysql.server..Such as
1075 pts/0S 0:00 sh /usr/local/mysql/bin/safe_mysqld
--user=root --pid
1093 pts/0SN 0:00 /usr/local/mysql/libexec/mysqld
--basedir=/usr/local/
1095 pts/0SN 0:00 /usr/local/mysql/libexec
If you use perl or php you didnot need odbc to connect MySQL. There are
built-in function to do this for you and of course it fast.
SF
At 14:19 7/6/2001 +0500, Muhammad Asif wrote:
>I want to use MySQL in web based
>applications. Can u tell what other way i can go except ODBC
>if i have to que
Thanks Ansgar for your answer. What I missed concerning my question, is that
I need to be able to get informations from MySQL and integrate them into a
Mac App Quark XPress, using a specific plugin for Photo Composition, If I
really understood what I was as to do.
I wonder how phpMyAdmin would let
On Fri, Jun 08, 2001 at 12:43:16AM +0100, Jorge Oliveira wrote:
> Hi,
>
> I have two tables in my database:
>
> #TB1
> ID_tb1 (auto-incremented)
> ID_tb2
> name
> address
>
> #TB2
> ID_tb2 (auto-incremented)
> method
> status
>
> I need to run a query that inserts values into #TB
If you use Delphi or VB, VC, there are some API program that let you access
MySQL direct. Not worry about ODBC.
Sommai Fongnamthip
At 01:00 7/6/2001 -0700, Van wrote:
>Muhammad Asif wrote:
> >
> > i have a table with 1 records in MS Access and
> > MySQL with no index in either database.
>
hi,
We have a mysql database called "database1".
It has a table called "table1" this table has no records.
But due to this table we are losing the 16 MB of space in our quota.
I think its due to these files :
Files Space
1)table1.frm 8 KB
2)tab
Sounds like you have a problem with the .frm file. Try checking the
permission of xref.txt.frm or some part of that. Try making sure it
is set to the proper owner with read and write permissions (usually
mysql or mysqladmin is the owner).
Best of luck
Ken
>"> ./configure --with-mysql=/usr/bin --with-apxs --enable-track-vars
Ciao,
sorry but I just joined this mailing list, so I am not aware of any
previous messages.
/usr/bin ?
Why in that directory?
Can I please get to know how did you install MySQL? By RPM?
Please try these 2 find comma
Ok, so you can obtain a random result (thought that was what random()
was for), but still cannot understand how this could be usefull. I use
encrypt to store password info in a database, but how do you compare the
user entered password with the one in the database if the results vary
the whole tim
At 7:16 PM +0200 6/7/01, Sean O'Keeffe wrote:
>hi there,
>i've got a problem which someone might be able to help me with.
>i'm importing text files into a database in mysql using mysqlimport :
> /users/mysql/bin/mysqlimport -u * databasename *.txt
>however i'm getting the following error a
Hello All,
When I insert data submitted via a web page into mySQL, the pound (£)
symbol gets converted to something like &8916.
I am using PHP and Apache on the Server side.
Has anyone else encountered this strange problem?
*
- Original Message -
From: "Adrian D'Costa" <[EMAIL PROTECTED]>
To: "Mysql Mailing List" <[EMAIL PROTECTED]>
Sent: Friday, June 08, 2001 13:59
Subject: php/mysql question
> Hi,
>
> I am not sure whether this relates to this list or the (not working) php
> list.
>
> For simplicity: I ha
On Thu, Jun 07, 2001 at 07:36:54PM -0400, R Talbot wrote:
> Jeremy
>
> So what your pointing out is I am seeing several threads
> generated by mysqld...
Yes.
> But that does not answer as to why the rpm installation
> start with one thread??
>
> Both installations which I compiled
>/mysqladmin: connect to server at 'localhost' failed
>error: 'Access denied for user: 'root@localhost' (Using password: YES)'
Ciao Michela,
unless you changed the 'user' table contents, you could easily connect
to every db as root without providing any password. What's the command line
y
I was sent e-mail to ask about update SQL, but the mailing list return this
to me. Why?
SF
At 09:58 7/6/2001 +, you wrote:
>Your message cannot be posted because it appears to be either spam or
>simply off topic to our filter. To bypass the filter you must include
>one of the following wor
On 07-Jun-01, Jason Bradley Nance said something totally profound about libwrap
problems (compiling) and config questions that made me ponder...
JBN> Hello everyone.
JBN> I have hit a snag trying to compile mysql 3.23.38. After running
JBN> this configure command:
[snip]
JBN> If I don't
Strange. I've never had any problems with the RPMs
- Original Message -
From: "Duane Douglas" <[EMAIL PROTECTED]>
To: "Rolf Hopkins" <[EMAIL PROTECTED]>
Cc: "Patrick Malone" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, June 07, 2001 21:59
Subject: Re: Rookie admin needs insta
1 - 100 of 105 matches
Mail list logo
