Hi
At 15:48 09/04/2001 -0400, David Loszewski wrote:
>is it recommended to install mysql by rpm or tar?
I really does not matter, but the beauty of using rpms is that removal and
update are automatic
>dave
>
>-
>Before postin
nevermind...found it...ifnull()
thanks anyway!
Kris Gonzalez wrote:
> i remember coming across the mysql equivalent of the oracle nvl()
> function which will substitute in the case of a returned null value,
but
> i can't seem to locate the command now...anyone know what it is?
>
> thanks!
-
Hi,
I want to import in my DB in MySql a data. Everyting data is ok
but for date format ( yy/mm/dd ) this I have in .csv format when I
importI see that -00-00 in all date fields
Any help is realy apreciate
Regards
Dan
i remember coming across the mysql equivalent of the oracle nvl()
function which will substitute in the case of a returned null value, but
i can't seem to locate the command now...anyone know what it is?
thanks!
-
Before postin
I Want to Install mysql in solaris8 intel x86
but i can't pass configure,i have installed gcc ,glibc ,automake ,autoconf
[root@solaris8 mysql-3.23.36]#
./configure --prefix=/usr/local/mysql --with-mysqld-user=mysql --with-charse
t=gbk --with-extra-charsets=all
loading cache ./config.cache
checking
Make a table in your database called ID
Create table ID (ID bigint auto_increment not null,
lockedBy varchar(10) null};
Then write code in your favorite language that:
Checks to see if the record is locked by another user. if so, loop.
Updates the record with a unique session id
I've made a query and got a good result like these:
mysql> select bid, number, title from t_board
mysql> where bid = 'test' and number = floor(rand()*100)+1;
+--++---+
| bid | number | title |
+--++---+
| test |
Hi everybody,
I'm new to MySQL and I'm trying to figure out a way of
automatically generating a sequence of unique id numbers
in many tables. I need to get new id's at any time
and possibly from different connections. As I understand,
AUTO_INCREMENT does this, but the sequence it generates
is
As of now (9/4) there is no binary distribution for Mysql with built-in BDB
support right?
Can I expect that to happen by ?
. Christian Dechery (lemming)
. http://www.tanamesa.com.br
. Gaita-L Owner / Web Developer
-
Mario,
import java.sql.*;
// Only need to do this once when the program starts
try {
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
} catch (Exception DriverEx) {
}
try {
String dbc="jdbc:mysql://mysql.server.net/databasename";
String dbu="databaseuser";
String dbp="passw
I have set up an Excel Spreadsheet and an Access database
and wish to convert tthem to mysql.
How can I do this?
--
contact:
Dave Yadallee NetLine 2000 The Edmonton Internet Service Company
[EMAIL PROTECTED] http://www.nl2k.ab.ca
990-3244
--
¹è¼ÒÁ¤ wrote:
> Hi... I'm Bae So Jeong, a web-programmer at Digital Chosun.
>
> Would you help me for MySql? ^^:
>
> I will develop some web-sites by Japanese, Chinese, English etc.
> These sites will service at one server, one O/S.
>
> Many reference sites say:
> "Japanese site will servi
I have a hard drive dedicated to mp3 files that are stored in the
following format: /mp3/artist/album/song1.mp3. What is the best way to
add these file names to a database. I have been adding a few via a web
interface but can only do one at a time which is not going to work. I
also tried just l
I know this is slightly off-topic but it's related to changing the
number of file descriptors on FreeBSD:
-
FreeBSD
by Torsten Sturm
How do I check my maximum filedescriptors?
Do sysctl -a and look for the value of kern.maxfilesp
Looks like you're running out of the file descriptor to handle the
connection etc.
I'm not really a FreeBSD person but here's what I've found on this
site:
http://ircache.nlanr.net/Polygraph/Tips/FreeBSD-3.3/
Try increasing max file descriptors in /sys/conf/param.c
#define MAXFILES (16384)
This
Running mysql 3.22.32-log on Apache virtual server (FreeBSD)
I can restart my mysql daemon with ./bin/safe_mysqld - but it
only runs for a few hours before dying. Following hints from
both the manual and the list, I've tried several things...
I've deleted my mysql database and manually re-ins
On 4/9/01 4:36 PM, "Cory Whitesell" <[EMAIL PROTECTED]> wrote:
> I have been happily using a program I developed that uses mysql to store
> technical support articles that I ancounter regularily. A new person is
> starting work here tomorrow, so suddenly, I need this to work over the
> network. T
I have been happily using a program I developed that uses mysql to store technical
support articles that I ancounter regularily. A new person is starting work here
tomorrow, so suddenly, I need this to work over the network. The touble is, when I try
to connect from the other workstation, I get
Hi!
> "loschert" == loschert <[EMAIL PROTECTED]> writes:
>> Description:
loschert> Attempting to delete all records in a table containing NULL values in a
loschert> UNIQUE KEY field does not work as expected. Only a single record is deleted,
loschert> presumably because the server thinks
On Tue, 10 Apr 2001 01:05:47 +0200, Sergei Golubchik <[EMAIL PROTECTED]> wrote:
Ok, I kind of thought that might be it, but wasn't sure.
Thanks for you assistance.
>>> Then how come I keep getting these results when setting a test table. Am I
>>> missing something here??
>>>
>>> Create the
Hi!
On Apr 09, MikeBlezien wrote:
> On Mon, 9 Apr 2001 23:16:21 +0200, Sergei Golubchik <[EMAIL PROTECTED]> wrote:
>
> Then how come I keep getting these results when setting a test table. Am I
> missing something here??
>
> Create the table:
> DROP TABLE IF EXISTS bus_search;
> CREATE TABLE
On 09-Apr-2001 Eric Fitzgerald wrote:
> Since MATCH is evaluated AFTER the where, you need to use HAVING
> SELECT
> url,newwebsites.description,newwebsites.title,newwebsites.catid,category.ful
> lname,MATCH
> newwebsites.description AGAINST ('aliens') as GOO from newwebsites,category
> LEFT
> JOI
Similar problems on FreeBSD 4.2-RELEASE.
Dedicated Mysql server is pinning the CPU, under a load of 500+ queries
per second. Memory is not exausted, and Disk usage is 0.
Just the CPU is pinned.
[EMAIL PROTECTED] wrote:
>
> >Description:
> mysql uses 99% cpu and becomes extremely unrespo
>Fortunately, these were only test databases so there won't be much
>loss. My question is in the future, is there a recommended way of backing
>up the databases that will not cause any errors?
I'm using mysqldump to create backups.. but that's on linux, I'm not sure
about windooz version. Pr
On Mon, 9 Apr 2001 23:16:21 +0200, Sergei Golubchik <[EMAIL PROTECTED]> wrote:
Then how come I keep getting these results when setting a test table. Am I
missing something here??
Create the table:
DROP TABLE IF EXISTS bus_search;
CREATE TABLE bus_search (
bus_id int(8),
title varchar(200),
Unfortunately, you're using MySQL on a Microsoft product, and you've probably
run into one of those issues where Redmond decided what's best for you (changing
the 'case' of the filenames).
BUT, in both the Microsoft and UNIX realm of products, 'packaging' files (on
UNIX using 'tar' and 'gzip',
Hi,
You can't use aliases in a where, but you can in a HAVING clause.
Regards
Quentin
-Original Message-
From: Brad Barnett [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, 10 April 2001 8:44 a.m.
To: [EMAIL PROTECTED]
Subject: Strange queries
SELECT
url,newwebsites.description,newwebsites.
I've seen what's probably the same thing under 4.2-STABLE.
The poll() system call returns 1 but there's no corresponding
file handle marked in the data structures that were passed to poll().
(It could be a mysqld bug if they're asking to poll() for certain kinds
of events but then not checking f
Uh, before you take his head off, consider that most people using MySQL are
not in a position to build MySQL themselves (or trust whatever comes out of
"./configure --whatever_options; make").
And the default binary distribution does not include BDB or InnoBase for any
platform (that's coming soo
subject: [EMAIL PROTECTED]
Remite: Guillermo Guzman Ramirez
Ibague - Colombia - Sur America
Would you please help to repair/Corrige an error that
occured with mySQL and Delphi;
The error is like this ; error 127 from table
handler
We noticed that the table, which we do SELECT is out
of ord
Hello,
I have jsut installed mysql,DBI etc on my linux 7.0 box. I got this error
first thing trying to change the root password. I do NOT have a file
libmysqlclient.so.9 but i DO have a file libmysqlclient.so.10. how did this
get out of sync and how can I repair this install?
Thanks,
Gim
--
I have experienced the same problems on a dual processor machine running
4.2-STABLE and mysql 3.23.36 from the ports tree.
regards,
Lars Andersson
At 16:03 2001-04-09 -0400, Andrew Schmidt wrote:
>Have you tried this under a 'stable' version of freebsd?
>
>In FreeBSD 4.2 beta, mysql would cra
Since MATCH is evaluated AFTER the where, you need to use HAVING
SELECT
url,newwebsites.description,newwebsites.title,newwebsites.catid,category.ful
lname,MATCH
newwebsites.description AGAINST ('aliens') as GOO from newwebsites,category
LEFT
JOIN userrestrictions ON userrestrictions.name REGEXP
'[
Hi!
I have tested a bit today.
Various logfiles are at :
http://www.dassic.dk/~jfn/mysql/
I found that after compiling with full debugging, I got the error that one
of the my.cnf parameters was too little and should be increased on the
server.
The default is 1 MB. I tried to increase it to 16 M
Unfortunately I am using 3.22.32. Does this mean I am out of luck with
this query.
Peter Schwenk wrote:
>
> If you are using version 3.23.x of MySQL, there is a LIMIT clause that you can use
> to just update up to a certain number of records, so you could add 'LIMIT 1' to the
> UPDATE command t
Hi,
I am doing a select from to tables which are join'ed, I cannot determine
automatically which table a column belongs to:-
I have tried both these selects:-
SELECT * FROM staff, staffsubjectTitles WHERE staff.id = 11 AND
staffsubjectTitles.staff_id = 11
SELECT staff.*, staffsubjectTitles.*
Hi!
On Apr 09, MikeBlezien wrote:
> I posted a couple problems regarding the use of the FULLTEXT indexing and a
> search query problem, but never got any responses. So maybe some one may shed
> some lite on setting up a table with the FULLTEXT index.
>
> I've read thru the MySQL docs on this and
Hello,
I have a box running Win2k and MySQL 3.23.36, I had made a backup of all my
databases/tables to CD-ROM last week. When I tried to access them again
from the CD-ROM, I noticed that all file names had been altered to be
displayed in uppercase and now they will not function in the php scr
hi.
according to this:
http://www.mysql.com/documentation/mysql/bychapter/manual_Installing.html
the binary is recommended for linux.
if you know what you're doing, or want support for wacky options, compile
your own.
instructions for both options are on the above page as well.
hth.
-ravi.
---
.deb :)
Jeff Levy
Software Design
Meta-Craft Creations
On Mon, 9 Apr 2001, David Loszewski wrote:
> is it recommended to install mysql by rpm or tar?
>
> dave
>
> -
> Before posting, please check:
>http://www.mysql.com/manu
SELECT
url,newwebsites.description,newwebsites.title,newwebsites.catid,category.fullname,MATCH
newwebsites.description AGAINST ('aliens') as GOO from newwebsites,category LEFT
JOIN userrestrictions ON userrestrictions.name REGEXP
'[[:<:]]username|GLOBALAUTHADMIN[[:>:]]' AND
newwebsites.catid=user
is it recommended to install mysql by rpm or tar?
dave
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[E
You can update the "first" row by adding LIMIT 1 to your update query.
If the rows are identical, "first" vs. "third" doesn't matter. If it
does matter,
you should probably add a unique, tiebreaking field (sequence or
DateTime, if
you can assure there will never be 2 identical records inserted per
>
> database,sql,query
>
What causes:
010409 15:47:42 Slave: Failed reading log event, reconnecting to retry, log 'FIRST'
position 4
010409 15:47:42 Slave: reconnected to master
'[EMAIL PROTECTED]:3306',replication resumed in log 'FIRST' at position 4
010409 15:47:42 Error reading p
Your table has no primary key.
You have a badly malformed database.
How can you tell one transaction from another?
You have debit and credit amounts with no timestamp or account
identifier.
Add an autoincrement id field as a primary key. Then you can update
based on that key.
Richard Reina wrote
delete from db where date="2001-04-09" and CR_amount=300.00
insert into from db (date, DB_amount, CR_amount) values ("2001-04-09", NULL,
300.00);
insert into from db (date, DB_amount, CR_amount) values ("2001-04-09", NULL,
350.00);
would change the 3rd to 350.00 credit.
Unfortunately, there is n
On 4/9/01 10:12 AM, "Burke Patrick" <[EMAIL PROTECTED]> wrote:
> Hi Lindsay,
>
> maybe you can help me?
>
> I am trying to give a user SELECT access to just one table in my database.
> If I don't give him SELECT privileges in the mysql.user table or mysql.db
> table, he cannot even login to the
>ISM file. I opened them with notepad. Now my scripts will not
>execute. The ISD file says that it was modified today. All 3 icons have
>changed to the notepad icon, although this is not necessarily the most
>unbearable part of the whole thing. Are they lost forever? Can they be
>made
Have you tried this under a 'stable' version of freebsd?
In FreeBSD 4.2 beta, mysql would crash with user locks. Not mysql's fault.
now, I understand RC's are generally stable; but I would still make sure
that this bug doesn't show up in a stable os.
regards,
-- Andrew
- Original Message
DateDB_amount CR_amount
2001-04-09 NULL300.00
2001-04-09 NULL750.00
2001-04-09 NULL300.00
Anyone know how can I do a query that will update the third record
without updating the first?
--
On Mon, 9 Apr 2001 [EMAIL PROTECTED] wrote:
I have the same problem under FreeBSD-4.2 STABLE
sometimes it work fin 1week, but sometimes 1 day.
> >Description:
> mysql uses 99% cpu and becomes extremely unresponsive under high load
>
> >How-To-Repeat:
> send about 300 simultaneous visitors to www.c
Hello.
On Mon, Apr 09, 2001 at 01:05:01PM -0400, [EMAIL PROTECTED] wrote:
> On 9 Apr 2001 [EMAIL PROTECTED] wrote:
>
> > >Description:
> >
> > Attempting to delete all records in a table containing NULL values in a
> > UNIQUE KEY field does not work as expected. Only a single record is deleted
It depends on what version of MySQL you are running. MyISAM tables will
move across platforms fine, but ISAM tables will not. You could always
choose the failsafe and use mysqldump to dump the contents of your
database into a file, and then use that to reload the contents on the new
machine.
John
is it recommended to install mysql by rpm or tar?
dave
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[E
>Description:
mysql uses 99% cpu and becomes extremely unresponsive under high load
>How-To-Repeat:
send about 300 simultaneous visitors to www.chicagobusiness.com and tell them to click
around.
>Fix:
restart mysql. this usally helps, at least for a few minutes. sometimes it climbs
back to
We will be moving our MySql databases from a Winnt server to a linux server. Can I
just copy the data files from one machine to the other? If not then how should I do
it?
Mat Murdock
Your mouse has moved. Windows must be restarted for the change to take
effect. Reboot no
On Mon, 9 Apr 2001, Matt Loschert wrote:
Sorry for jumping in ...
> > another NULL Mysql will not complain about it cause Null!=Null whereas
> > it would complain if you had inserted a '1' and tried to insert
> > another '1'.
> >
> > Clear as mud?
> Your explanation makes sense, but it see
"Ashley M. Kirchner" wrote:
>
> Okay, I'm about to rip my hair out trying to figure this out, and I
> thought before I start looking for a gun, maybe I should ask..
>
> I need someone to explain the 'mysql' database to me. I've tried
> reading about it, tried different settings, but I'm
On Mon, Apr 09, 2001 at 02:01:55PM -0400, Jim Ziegler wrote:
> >
> > database,sql,query
> >
>
> load table from master
> does not work for me. I get the error message
> ERROR 1189: Net error reading from master
> what can cause this?
> both the master and the slave are version
> 3.23.3
I have a db I made with mysql/php/apache. I was copying my script files to a floppy
disc. I figured I'd also back up the data itself so I wouldn't have to re-enter it
all. I went into C:\mysql\data\testTrack and, being an inquisitive fellow, I decided
to have a look in the 3 files there - an F
We're looking for a DBA (MySQL). We've been without a DBA to date and have gotten to
the point where we need one.
Please respond to [EMAIL PROTECTED] for more details.
Thanks.
EQ-
I haven't checked the manual yet, but I'd guess that the 'query' abilities of
versions "3.22.32" and "3.23.33" are slightly different
It's generally not a good idea to have different versions (or different 'revs') of
the program on the 'development' and 'production' systems... (you'll have
>
> database,sql,query
>
load table from master
does not work for me. I get the error message
ERROR 1189: Net error reading from master
what can cause this?
both the master and the slave are version
3.23.33-log
--
[EMAIL PROTECTED] (Jim Ziegler)
---
Hi,
I goot this error when I type "make" apache after installating
(mysql-3.23.36-pc-linux-gnu-i686.tar.gz) configurating it with php
4.0.4pr1 on RedHat 7.0, the problème as seen bellow seems to be related
to libmysqlclient.a(my_compress.o) but I don't know what to do. I'm
following exactly the
[EMAIL PROTECTED] writes:
> >Description:
>
> Attempting to delete all records in a table containing NULL values in a
> UNIQUE KEY field does not work as expected. Only a single record is deleted,
> presumably because the server thinks that the table will only have one record
> with a NULL
On Mon, 9 Apr 2001, Thalis A. Kalfigopoulos wrote:
> This is perfectly normal from Mysql's part. What you call a uniq_id in
> the table where you don't declare it as a unique key is merely another
> int field and a table scan will be performed to actually find ALL the
> occurences of the value yo
Hi,
I work on the big web site of the gouvernative statistical agency of
Italy (www.istat.it).
Recently, I have built a db to collect data from the web (it's like a
census simulation...) with mySQL.
Making my querys,I had a little difficult, not so big for me, but that
can interest you.
On a deve
There's some good documentation (a lot of it in the form of 'warnings') on
security aspects of the "mysql" database.
http://mysql.com/documentation/mysql/bychapter/manual_Privilege_system.html#Privilege_system
But, here's some quick notes:
Anyone who has 'modify' permissions to the "mysql"
I'd like to use MySql with Java (under Linux) bu I can't be able to do that:
how can I do?
Thank you in advance, Mario.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
On 9 Apr 2001 [EMAIL PROTECTED] wrote:
> >Description:
>
> Attempting to delete all records in a table containing NULL values in a
> UNIQUE KEY field does not work as expected. Only a single record is deleted,
> presumably because the server thinks that the table will only have one record
> wit
I posted a couple problems regarding the use of the FULLTEXT indexing and a
search query problem, but never got any responses. So maybe some one may shed
some lite on setting up a table with the FULLTEXT index.
I've read thru the MySQL docs on this and it's not real clear. When setting up a
table
"Thalis A. Kalfigopoulos" wrote:
> I haven't read Mysql's authorization mechanism from Paul's book, but from the
>Oreilly book and it was pretty comprehensive and intuitive. I suggest you borrow that
>book from your local library or buy it.
Ya, it's already on its way...(the book that is).
Ashley,
Are you using the GRANT statement?
That is the easiest way to get it right.
Read up on the GRANT SQL statement. Look at the examples...
Using regular inserts into the mysql database, can cause improper input into
the tables, which can (from personal experience) cause mysqld to not run.
I haven't read Mysql's authorization mechanism from Paul's book, but from the Oreilly
book and it was pretty comprehensive and intuitive. I suggest you borrow that book
from your local library or buy it.
To try to write here about how it works would be a waste of time for both of us. It is
rath
Look at the following pages in the manual:
http://www.mysql.com/doc/M/i/Missing_Transactions.html
http://www.mysql.com/doc/T/a/Table_types.html
-- Rodney
Gerald Clark wrote:
> Marco Baldacchini wrote:
> >
> > MySql support transactions?
> > The OLE-DB provider support transactions?
> > Call th
Check with your hosting company. My guess is that they handle the initial MySQL
setup for you. Very few companies will allow you to install the software on
their servers.
-- Rodney
Anoop k gupta wrote:
> Hi everybody,
>
> I am new to MySQL.
> I have Linux server through my hosting company.
>
>Description:
Attempting to delete all records in a table containing NULL values in a
UNIQUE KEY field does not work as expected. Only a single record is deleted,
presumably because the server thinks that the table will only have one record
with a NULL value in it (as it is in a UNIQUE field).
Okay, I'm about to rip my hair out trying to figure this out, and I
thought before I start looking for a gun, maybe I should ask..
I need someone to explain the 'mysql' database to me. I've tried
reading about it, tried different settings, but I'm lost. So far I've
just been adding use
On Sun, Apr 08, 2001 at 12:22:32PM -0500, Rodrigo Zerlotti wrote:
>
> >Description:
> INSTALL-BIN file has errors:
>
> shell> chown -R mysql /usr/local/mysql/var
>
> it should be
>
> chown -R mysql /usr/local/mysql/data
>
> instead "var"
Thanks, Rodrigo. I have fixed it now.
Tim
-
I would think it is because you don't have all of the development tools in place.
also the path to mysql must be ok.
On Sat, 07 Apr 2001 17:56:41 +0200, B. van Ouwerkerk wrote:
>At 17:25 7-4-01 +0200, com2 wrote:
>>hi everybody we get this err mex when we run:
>>./configure --prefix=7usr/loc
>I am new to MySQL.
>I have Linux server through my hosting company.
>I want to install MySQL on server.
>I need your help in this regard how I can install the same on my remote
>server?
Read:
- this lists archive before sending questions
- www.devshed.com
- many many other websites.. you can f
hello
RE: Linux (Intel libc6 systems) [pc-linux-gnu-i686]
downloaded the above file. nad am trying to get it going ! i have read the
readme files but not much help there !
uncompressed it and untarred the sql ! what is it i do next ! please if it
is not
too much help how do i get it goin
On Mon, 9 Apr 2001, Sinisa Milivojevic wrote:
The problem still exists on gcc 2.95.3 (I was part way through installing
this when I recieved your mail - I can try 2.95.2 if you think that would
be usefull)
The new information captured from mysqlbug is as follows
Server version 3.23.36
it seems to be working after i type safe_mysqld --log
but i get this message when i try to run mysql , i try creating a database
using mysqladmin but the same socket thing comes into it !
my error message
mysql admin connection to localhost failed
error can't connect to local mysql server th
On Sunday 08 April 2001 12:59, Kamil Yildirim wrote:
> --- Sasha Pachev <[EMAIL PROTECTED]> wrote:
> > On Saturday 07 April 2001 17:59, Kamil Yildirim
> > wrote:
> > > Hi
> > >
> > > I have a problem with SQL UPDATE statement within
> > a
> > > Java programm which establish a connection to a
> >
"Thalis A. Kalfigopoulos" wrote:
>
> I sent that reply about this 1 WEEK Back.
> Look up safe_show_databases and skip_show_databases in
>http://www.mysql.com/doc/S/H/SHOW_VARIABLES.html
>
> regards,
> thalis
>
> On Mon, 9 Apr 2001, Fabien Salvi wrote:
>
> > Hello, is it possible to prevent us
Hi everybody,
I am new to MySQL.
I have Linux server through my hosting company.
I want to install MySQL on server.
I need your help in this regard how I can install the same on my remote server?
Thanks in advannce.
Anoop
_
Chat with your fr
#--That is a binary tarball.
#--If you want to compile it, download the source.
What you mean with tarball? It´s supposed just to uncompress it and it
should work?
the page must be :
http://www.avukatpro.com/mysql.html
but i really don't know this is included as my signature and
this page contains mysql and visual basic samples.
not included about silent install yet.
Regards.
Yusuf INCEKARA
- Original Message -
From: John Steele <[EMAIL PROTECTED
I sent that reply about this 1 WEEK Back.
Look up safe_show_databases and skip_show_databases in
http://www.mysql.com/doc/S/H/SHOW_VARIABLES.html
regards,
thalis
On Mon, 9 Apr 2001, Fabien Salvi wrote:
> Hello, is it possible to prevent users from seing other databases than
> the one there a
Try putting a line in your my.cnf that contains:
safe-show-database
This will only allow the user to see databases that they have permissions
for
You can optionally use skip-show-database, which will not allow the
command at all.
John Barton
Unix Systems Administrator
Primary Networks, Inc.
[EMAI
Hello, is it possible to prevent users from seing other databases than
the one there are using ?
I thought it was possible using priveleges and "Select_priv", but It
doesn't work...
I am using 3.23.33
Thanks in advance for your help...
-
Fabien SALVI Centre de Ressources Inform
>> Description:
oliver> After several sig 11 I compliled a --with-debug version and enabled
oliver> debugging and logging. Mysqld crashed shortly after starting without
oliver> trace (!) and then immediatly crashed again after restart.
oliver> /sw/pkg/mysqldebug/
On Mon, Apr 09, 2001 at 03:48:43PM +0200, Niklas Rudemo wrote:
> I'm trying to select into outfile to a file that already exist.
> This has been discussed before, I know, but the solution suggested
> results in an SQL-error, as shown below. So what's the real solution?
Select your rows into a tem
That is a binary tarball.
If you want to compile it, download the source.
[EMAIL PROTECTED] wrote:
>
> hi i downloaded Linux (Intel libc6 systems) [pc-linux-gnu-i686] i have
> uncompressed it and untarred it onto a PC. but i cannot find the necessary
> make and make install files to compile and
hi i downloaded Linux (Intel libc6 systems) [pc-linux-gnu-i686] i have
uncompressed it and untarred it onto a PC. but i cannot find the necessary
make and make install files to compile and run sql ! why is that ?
machine i am running on is P166, 64mb ram using red hat linux 7.
thanks i hope you
Hi!
> "Peter" == Peter Zaitsev <[EMAIL PROTECTED]> writes:
Peter> It's a pity what mysql misses something like PROFILE call for the
Peter> query so I could check how much time is spent for different phases of
Peter> query execution.
MW> Any suggestions for the output for this?
Peter> W
THe manual recommends restarting the server with --skip-grants.
Fix your user table, and flush privileges to reload the grant tables.
Bob Dushok wrote:
>
> I've made a stupid error. While logged in as root I was deleting
> records from the user table. Someone was talking to me while I was
> en
To eliminate DNS problems, put each machine in the others /etc/hosts
file.
MCA Department PESIT wrote:
>
> Hi there,
>the master is running on 192.168.1.2 and the slave on 192.168.1.5 , yes,
> the master is running. the user name and password are correct. actually i
> dont think it gets to t
Could please let me know whether Mysql database can be used with QNX
realtime 4.25? If so which version? What are the terms for commercial
licensing? Can I get a trial version. I appreciate your help
Thanks
Lekha Das
-
Before
1 - 100 of 130 matches
Mail list logo
