Hello there,
I have an issue where upon system (YellowDogLinux v2.2) reboot or halt,
if the mysqld is running i get the message that shutting down mysql:
FAILED
Has anyone experienced this? Or can someone perhaps help me understand
what is going on?
Sincerely,
Danny
--
I understand what test% might mean, but don't know what test\_% means.
Following is from a fresh MySQL install ...
mysql> use mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> select *
[filter-fodder: sql, query]
Hi,
I am having trouble finding differences.
Table1 holds the current data, and Table2 holds the updates.
I need to query the two and find ONLY the rows showing the current+updates.
Table1:
TABLE dttunes (
id smallint(5) unsigned NOT NULL auto_increment,
danceid sma
Hello there,
I have an issue where upon system (YellowDogLinux v2.2) reboot or halt,
if the mysqld is running i get the message that shutting down mysql:
FAILED
Has anyone experienced this? Or can someone perhaps help me understand
what is going on?
Sincerely,
Danny
--
At 17:38 -0700 5/10/02, Jeremy Zawodny wrote:
>On Fri, May 10, 2002 at 08:32:17PM -0400, Amer Neely wrote:
>> > I use Perl, Php, mysql for my applications. I have a great manual for php
>> > for mysql processes. But i do not know any manual for perl yet. Does
>> > anyone know any manual about f
On Fri, May 10, 2002 at 08:32:17PM -0400, Amer Neely wrote:
> > I use Perl, Php, mysql for my applications. I have a great manual for php
> > for mysql processes. But i do not know any manual for perl yet. Does
> > anyone know any manual about for perl-mysql? Better if would be .chm
> > version. T
> is there a way to delete a column from a table, without droping the
> whole table?
Yep!
ALTER TABLE DROP [COLUMN] col_name
http://www.mysql.com/doc/A/L/ALTER_TABLE.html
> If not is can I get sql to replicate the command to re create the table?
Yep!
mysqldump -qd -u
http://www.mysql.com
> I use Perl, Php, mysql for my applications. I have a great manual for php
> for mysql processes. But i do not know any manual for perl yet. Does
> anyone know any manual about for perl-mysql? Better if would be .chm
> version. Thanks.
>
> -Onder
Not online, but the book "MySQL and Perl for the
I'm curious if anyone has any recommendations for storing large
multi-layered raster data within mysql beyond simply using blobs or text
fields.
Although not a GIS application; the idea is similar. We are simply
modeling 3D surfaces. Queries on the actual mapping structure stored
within the ra
is there a way to delete a column from a table, without droping the whole
table?
If not is can I get sql to replicate the command to re create the table?
and if I can't do that how can I transfer information to a dummy table while
I create the table I want?
PS, I only have command line access
On Fri, May 10, 2002 at 05:33:32PM -0600, Matthew Walker wrote:
> I have to say that I disagree. It would be a very good idea to
> recompile the kernel, to get rid of all the fancy sound and graphics
> options. The smaller your kernel, the better. Also, you might want
> to look at the Preemptive
I have to say that I disagree. It would be a very good idea to recompile
the kernel, to get rid of all the fancy sound and graphics options. The
smaller your kernel, the better. Also, you might want to look at the
Preemptive patch for the kernel, to help improve performance further.
Matthew Walke
At 12:06 +0100 5/9/02, Sandeep Murphy wrote:
>Hi,
>
>What appears to be the problem with the fwg query:
>
>select code,date from multimedia_header where rubrica=87 and now() >
>'08-03-2002 13:10:53' and date IS NOT NULL
>
>The records returned includes those earlier than 08-03-2002 13:10:53 too.
- Original Message -
From: "Andrew Kuebler" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, May 10, 2002 8:22 PM
Subject: Loading new setting without restarting the server
> I never see mysql memory usage go any higher than 12-13 meg of memory
> usage no matter how much strain
I have checked my file size in my data dir and can't find any files
close to 2GB even looking in subdirs.
Does this mean that my problem is most likely corruption or could it
still be "file too large".
Augey
Augey Mikus wrote:
> when running
> select count(distinct value) from table;
>
I suppose the i could always remove the unique constraint once the alter
statement has removed the duplicates.
ok
Paul DuBois wrote:
> At 18:13 -0400 5/10/02, Augey Mikus wrote:
>
>> so i suppose an automatic delete of every duplicate record is out of
>> the question :-)
>
>
> Sounds like you
At 18:13 -0400 5/10/02, Augey Mikus wrote:
>so i suppose an automatic delete of every duplicate record is out of
>the question :-)
Sounds like you're trying to have it both ways.
>
>Paul DuBois wrote:
>
>>At 18:00 -0400 5/10/02, Augey Mikus wrote:
>>
>>>is there a way for me to do it in a mysql
At 14:59 -0500 5/9/02, Bob Ryan wrote:
>I think you have to use a forward slash in your path instead of a backslash.
>C:/ as opposed to C:\
>
>even in windows operating environments I believe you need to use /.
That's correct. Or you can use doubled backslashes, but "/" is preferred.
>
>-Or
so i suppose an automatic delete of every duplicate record is out of the
question :-)
Paul DuBois wrote:
> At 18:00 -0400 5/10/02, Augey Mikus wrote:
>
>> is there a way for me to do it in a mysql delete statement? just out
>> of curiosity, for instance, if i wanted to add duplicates later fo
On Thu, May 09, 2002 at 09:21:12AM -0400, Darrell A. Sullivan, II wrote:
>
> I am considering porting our applications that currently use an
> in-house database schema to MySQL. I need to setup a test system to
> try this out and I am needing a few pointers.
Excellent.
> First, what type of proc
thanks :-)
Paul DuBois wrote:
> At 18:00 -0400 5/10/02, Augey Mikus wrote:
>
>> is there a way for me to do it in a mysql delete statement? just out
>> of curiosity, for instance, if i wanted to add duplicates later for
>> whatever reason.
>
>
> Okay, let's suppose you have 3947 instances o
On Fri, May 10, 2002 at 04:51:15PM +0200, Christophe Demange wrote:
> Hello,
>
> I have a question:
>
> We want to real-time synchronize a MySQL database part with a
> distant database. We have a central database containing all the
> data. This database must share several parts (records) with t
At 18:00 -0400 5/10/02, Augey Mikus wrote:
>is there a way for me to do it in a mysql delete statement? just
>out of curiosity, for instance, if i wanted to add duplicates later
>for whatever reason.
Okay, let's suppose you have 3947 instances of "abc".
You can use LIMIT for this:
DELETE FROM
is there a way for me to do it in a mysql delete statement? just out of
curiosity, for instance, if i wanted to add duplicates later for
whatever reason.
Paul DuBois wrote:
> At 17:54 -0400 5/10/02, Augey Mikus wrote:
>
>> what i meant is deleting duplicate occurences of records of a certain
At 17:54 -0400 5/10/02, Augey Mikus wrote:
>what i meant is deleting duplicate occurences of records of a
>certain field. ...sorry...
Ah.
One thing you can do is add a unique index on that field with
ALTER IGNORE TABLE tbl_name ADD UNIQUE (col_name)
or
ALTER IGNORE TABLE tbl_name ADD PRIMARY KE
when running
select count(distinct value) from table;
on a table with more than 19 million records i got the error:
got error 27 from table handler (or something like that)
i looked up the error in mysql perror which gave me "file too large"
does this have to do with my file size in linux or
what i meant is deleting duplicate occurences of records of a certain
field. ...sorry...
Paul DuBois wrote:
> At 17:16 -0400 5/10/02, Augey Mikus wrote:
>
>> what is the simplest way to delete duplicate occurences of a specific
>> field in mysql?
>>
>> thanks,
>>
>> augey
>
>
> Your question
I've had simmilar problems.
I had something like this...
String blah = myResultSet.getString("BLAHBLAH");
if(!myResultSet.wasNull()){
if(blah.equals("something)){ ...boom nullPointer exception
I'm not sure why the null value wasn't caught by wasNull(). Anyway I
worked around it by adding an if(b
At 14:29 +0200 5/10/02, Stian Skjelstad wrote:
>Hi
>
>I don't know if this is of any interrest etc, but atleast it is a small
>little issue from the big, big world.
This is easily solved by using mysql_connect() rather than
mysql_pconnect(). Then the connection won't stay open if
the script dies
At 8:17 -0700 5/10/02, Lalit Nagpal wrote:
>through a servlet i insert my form data into my table
>(primary key is auto-incremented) and then i throw
>another query which is
>select last_insert_id() from mytable limit 1
>through my .executeQuery method. when i ask
>for the data through
>.getString
mysqladmin variables
*
* Cal Evans
* Journeyman Programmer
* Techno-Mage
* http://www.calevans.com
*
-Original Message-
From: Edilson Vasconcelos de Melo Junior
[mailto:[EMAIL PROTECTED]]
Sent: Friday, May 10, 2002 4:04 PM
To: Paul DuBois; MYSQL
Subject: RES: Innodb
Hi,
The server i
At 17:16 -0400 5/10/02, Augey Mikus wrote:
>what is the simplest way to delete duplicate occurences of a
>specific field in mysql?
>
>thanks,
>
>augey
Your question is a bit ambiguous. You could do this by using ALTER
TABLE to remove the column itself from the table, for example, but
I'm guessi
what is the simplest way to delete duplicate occurences of a specific
field in mysql?
thanks,
augey
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the l
Hi,
The server is not mine :( How do i know if the source was compiled
with --with-innodb option?
Thank u very much,
Edilson.
-Mensagem original-
De: Paul DuBois [mailto:[EMAIL PROTECTED]]
Enviada em: sexta-feira, 10 de maio de 2002 17:47
Para: Edilson Vasconcelos de Melo Junior; MYSQL
At 20:45 + 5/10/02, John Doe wrote:
>ok I have (for now) three tables all with the same ID, however I want
>to be able to change the ID if I need to. But I don't want to do it
>with 3 statements (ie, update table01 set id=2 where id=3;update
>table02 set id=2 where id=3;update table03 set id=
At 13:59 -0500 5/10/02, Steve Buehler wrote:
>At 01:22 PM 5/10/2002, Paul DuBois wrote:
>>At 13:11 -0500 5/10/02, Steve Buehler wrote:
>>>I have found that I can NOT do this:
>>>$null = "NULL" or even $null = NULL than put that into a statement
>>>like this:
>>>UPDATE games SET game_id = '$null';
The real answer, yes. It has a limit of several GB, depending on your OS.
It can take a huge string containing MBytes of BLOB data.
Just for grins, I loaded several MB of image data this way just to prove to
myself that you could do it.
The practical answer is then pretty much no. (Probably wo
At 15:08 -0400 5/10/02, Andrew Hazen wrote:
>Hi Folks,
>
>Can I do the following:
>
>LOAD DATA INFILE 'persondata.txt'
> INTO TABLE persondata p, jobdata j (p.lname,j.jobtitle,...);
No.
You could extract the columns you need from the file for each table
into two separate files, then run tw
At 17:26 -0300 5/10/02, Edilson Vasconcelos de Melo Junior wrote:
>Hi,
>
>What versions of mysql support innodb tables? What about 3.23.45 or 3.23.47?
Both versions, but only if you
- Compile from source using the --with-innodb option when you configure MySQL
- Use a -max distribution, if you use
ok I have (for now) three tables all with the same ID, however I want
to be able to change the ID if I need to. But I don't want to do it
with 3 statements (ie, update table01 set id=2 where id=3;update
table02 set id=2 where id=3;update table03 set id=2 where id=3) what I
would rather have is a
Hi,
Using the C API, does the sql parameter in the mysql_query function a length
limit?
Thank u very much,
Edilson.
Edilson Vasconcelos de Melo Junior
www.jrsoftwares.com.br
[EMAIL PROTECTED]
Fone: (19) 3256-3577
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http
Hi,
What versions of mysql support innodb tables? What about 3.23.45 or 3.23.47?
Thank u very much,
Edilson.
Edilson Vasconcelos de Melo Junior
www.jrsoftwares.com.br
[EMAIL PROTECTED]
Fone: (19) 3256-3577
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.
[snip]
I am beginning to learn mysql.
How to add a column to table in mysql database.
Thanks
Tang
[/snip]
http://www.mysql.com/doc/A/L/ALTER_TABLE.html
-
Before posting, please check:
http://www.mysql.com/manual.php (the
sql, query
>
> > 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 words in your message:
> >
> > sql,query
> >
> > If you just reply to this message, and include the entire text
Mysql problem
Regards.
--Azhar Khan
On Fri, 10 May 2002 [EMAIL PROTECTED] 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 words in your message:
>
> sql,query
>
> If y
Hi Folks,
Can I do the following:
LOAD DATA INFILE 'persondata.txt'
INTO TABLE persondata p, jobdata j (p.lname,j.jobtitle,...);
Mysql the spam filter.
Andrew Hazen, O.C.P.
E-Commerce Developer
Jatech Solutions Inc.
www.jatech.ca
Specializing in OSCOMMERCE applications and PHP/MySQL prog
Look up the ALTER TABLE statement.
On Friday 10 May 2002 12:52 pm, Tang Ngo wrote:
> I am beginning to learn mysql.
> How to add a column to table in mysql database.
> Thanks
> Tang
-
Before posting, please check:
http://www.
At 01:22 PM 5/10/2002, Paul DuBois wrote:
>At 13:11 -0500 5/10/02, Steve Buehler wrote:
>>I have found that I can NOT do this:
>>$null = "NULL" or even $null = NULL than put that into a statement like this:
>>UPDATE games SET game_id = '$null';
>>can't do it like this either
>>UPDATE games SET gam
I am beginning to learn mysql.
How to add a column to table in mysql database.
Thanks
Tang
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
On Fri, May 10, 2002 at 02:22:18PM -0400, Andrew Kuebler wrote:
> Is there another way to load the new settings without taking the
> server down?
Not yet. There's talk of that happening in a future release of MySQL
(4.x maybe?).
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo
On Fri, May 10, 2002 at 10:23:30AM +0100, Raymond Brighenti wrote:
> Hi,
>
> Trying to get replication going between to W2K machines and getting the
> following errors in the Slave log file.
>
> MySql: ready for connections
> 020509 18:58:52 Slave thread: error connecting to master:Can't connec
At 14:22 -0400 5/10/02, Andrew Kuebler wrote:
>I've made a few config changes (examples below) in the my.ini except the
>server constantly utilizes 66 meg of memory total (Including OS) and I
>never see mysql memory usage go any higher than 12-13 meg of memory
>usage no matter how much strain I pu
On Wed, May 08, 2002 at 10:12:10AM -0400, adam nelson wrote:
>
> I am not having any troubles on 4.5 using plain mysql. Our
> transaction is lower than some (but certainly higher than others) at
> 4 queries/sec avg.
It seems to be unrelated to load. I've seen this happen on a relatively
lightly
At 13:11 -0500 5/10/02, Steve Buehler wrote:
>I have found that I can NOT do this:
>$null = "NULL" or even $null = NULL than put that into a statement like this:
>UPDATE games SET game_id = '$null';
>can't do it like this either
>UPDATE games SET game_id = $null;
>I have to do it like this:
>UPDAT
I've made a few config changes (examples below) in the my.ini except the
server constantly utilizes 66 meg of memory total (Including OS) and I
never see mysql memory usage go any higher than 12-13 meg of memory
usage no matter how much strain I put on the machine. I do not believe
these new setti
On Fri, May 10, 2002 at 10:12:15AM +0100, ritu singla wrote:
> Hi!!
>
> I used BACKUP TABLE command to take the backup of a
> table...but when i say
> RESTORE TABLE, i get the following ::
>
>
> mysql> restore table rs from '/tmp';
> +---+-+--+--+
> |
Basic Question
I'm programmatically open a dataset using this select statement
- SELECT SOD_TAG_DET.*, TAG_MSTR.TAG_NUM
FROM SOD_TAG_DET, TAG_MSTR
WHERE (SOD_TAG_DET.TAG_ID = TAG_MSTR.TAG_ID) AND
(SOD_TAG_DET.SODMstrID = 20)
ORDER BY TAG_MSTR.TAG_NUM
however when
I have found that I can NOT do this:
$null = "NULL" or even $null = NULL than put that into a statement like this:
UPDATE games SET game_id = '$null';
can't do it like this either
UPDATE games SET game_id = $null;
I have to do it like this:
UPDATE games SET game_id = NULL;
NO QUOTES of any kind.
Hello,
I develop threaded mysql client in c++ that uses connection
pool.
The program coredumps during vio_read (called from my_net_read).
I'm using libmysqlclient_r and keep all rules from "How to make
threaded client" section. Thread-pool is implemented with
CommonC++ class Thread.
my_thr
On Fri, May 10, 2002 at 12:55:39PM +0200, Mark wrote:
> How dangerous is OPTIMIZE TABLE?
>
> I have been reading through the FAQ, and came to the section on OPTIMIZE
> TABLE.
>
> http://www.mysql.com/doc/O/P/OPTIMIZE_TABLE.html
>
> That has my interest, as my MySQL XOVER database will expire
>
On Thu, May 09, 2002 at 11:18:35AM -0400, Ken Menzel wrote:
>
> Gunnar, This sounds very interesting! I will have to try this and
> see if I cannot aggravate the problem with large cache values.
> Thank you for sharing this information. Jeremy I hope you will
> share something if you can reprodu
I created a table with a field define as NULL, however when I insert
values NULL , Mysql puts 0 instead of nothing ,
I don't understand why I have this trouble ,
Thanks
-
Before posting, please check:
http://www.mysql.c
raphael k wrote :
>
> I created a table with a field define as NULL, however when I insert
> values NULL , Mysql puts 0 instead of nothing ,
>
> I don't understand why I have this trouble ,
>
>
>
> Thanks
>
Hi,
If you don't show us your query, it will be hard to help you ...
Regards
--
Jo
Hey guys,
did you spot this problem?
mysql> select truncate(199.20,2);
++
| truncate(199.20,2) |
++
| 199.19 |
++
1 row in set (0.00 sec)
Bug?
Mihail Manolov
Government Liquidation, LLC
202 467 6868 x.227
[EMAIL PROTECTED
I created a table with a field define as NULL, however when I insert
values NULL , Mysql puts 0 instead of nothing ,
I don't understand why I have this trouble ,
Thanks
-
Before posting, please check:
http://www.mysql
- Original Message -
From: "Paul DuBois" <[EMAIL PROTECTED]>
To: "Mark" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, May 10, 2002 6:09 PM
Subject: Re: Qoute
> >$group is a newsgroup name; all queries go fine, except one that has
> >a dash in it. I have tried quoting $group, lik
At 16:52 + 5/10/02, [EMAIL PROTECTED] wrote:
>Well... This seems to be a typical tricky-goute-on-qoute thing...
>I recommend you to test your query in mysql client directly
>(if you havn't already done that).
There really are no tricky quote-on-quote things, except when people
try to mess aro
Well... This seems to be a typical tricky-goute-on-qoute thing...
I recommend you to test your query in mysql client directly
(if you havn't already done that).
And THEN take the battle with perls quoting mechanism...
Another tip is to just print the query before executing
so You can see exact
"crashke" <[EMAIL PROTECTED]> writes:
> Hi Vadim, I don't know but have you read the instructions on the
> Mysql-website?
gcc 2.96RH is a known good and stable compiler, no matter what FUD the
site might claim. The below looks like broken code, plain and simple:
Lack of declarations.
--
Trond
Mark,
Thursday, May 09, 2002, 7:31:28 PM, you wrote:
MS> I am trying to grant rights to a new db to a new user.
MS> I am issuing the following commands (with obvious substitutions):
MS> mysql> GRANT ALL
MS> -> ON dbname.*
MS> -> TO username@localhost
MS> -> IDENTIFIED BY 'password
Maybe I'm misreading what you did, but $dbh->quote($group) adds the single
quotes around the string, so using it followed by "...WHERE
newsgroup='$group'" gets you
WHERE newsgroup=''name.of.group''
Also, your example sets $newsgroup using quote, but uses $group in the
query, which is a problem
Hi,
I'm trying to compile mysql 3.23.49 on a compaq DS10 box running
Tru64 Unix 5.1 . The binary for ev6 doesn't seem to work on this
architecture (Alpha 21264 processor) and so I'm compiling using
the compaq c and c++ compilers (v6.2) from source.
Compaq 'make' doesn't work so I'm using 'GNU m
- Original Message -
From: "Jay Blanchard" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, May 10, 2002 6:01 PM
Subject: RE: Qoute
> Have you tried double-quotes? '"$group"' ?
> Jay
I do not see how that can be done; when I do that, Perl complains of a dozen
of syntax errors b
At 17:49 +0200 5/10/02, Mark wrote:
> > This is too weird; I can quote until I see blew in the face, but I cannot
>> seem to make MySQL understand that the name 'group-name' is valid to
>> select. It keeps blabbing "You have an error in your SQL syntax". I mean,
>> what is the purpose of its o
- Original Message -
From: "Philip Molter" <[EMAIL PROTECTED]>
To: "Mark" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, May 10, 2002 6:01 PM
Subject: Re: Qoute
> Try:
>
> $sth = $dbh->prepare( 'SELECT expiration FROM newsgroups WHERE
> newsgroup=?' );
> $sth->execute( $
On Fri, May 10, 2002 at 05:49:12PM +0200, Mark wrote:
: > This is too weird; I can quote until I see blew in the face, but I cannot
: > seem to make MySQL understand that the name 'group-name' is valid to
: > select. It keeps blabbing "You have an error in your SQL syntax". I mean,
: > what is the
[snip]
$sth = $dbh -> prepare ("SELECT expiration from newsgroups WHERE
newsgroup='$group'");
$sth -> execute;
$group is a newsgroup name; all queries go fine, except one that has a dash
in it. I have tried quoting $group, like:
$newsgroup = $dbh -> quote ($group);
$group, btw, where it goes wr
> This is too weird; I can quote until I see blew in the face, but I cannot
> seem to make MySQL understand that the name 'group-name' is valid to
> select. It keeps blabbing "You have an error in your SQL syntax". I mean,
> what is the purpose of its own quote function if it can not even quote
>
At 17:26 +0200 5/10/02, Mark wrote:
>This is too weird; I can quote until I see blew in the face, but I cannot
>seem to make MySQL understand that the name 'group-name' is valid to select.
>It keeps blabbing "You have an error in your SQL syntax". I mean, what is
>the purpose of its own quote func
Hi see perldoc DBI and perldoc DBD::mysql
(search.cpan.org)
Onder Hazaroglu wrote:
>
> I use Perl, Php, mysql for my applications. I have a great manual for php
> for mysql processes. But i do not know any manual for perl yet. Does
> anyone know any manual about for perl-mysql? Better if would
[snip]
This is too weird; I can quote until I see blew in the face, but I cannot
seem to make MySQL understand that the name 'group-name' is valid to select.
It keeps blabbing "You have an error in your SQL syntax". I mean, what is
the purpose of its own quote function if it can not even quote pro
This is too weird; I can quote until I see blew in the face, but I cannot
seem to make MySQL understand that the name 'group-name' is valid to select.
It keeps blabbing "You have an error in your SQL syntax". I mean, what is
the purpose of its own quote function if it can not even quote properly?
[snip]
My VB application has a log-in screen with two fields, userID and
userPassword.
When these are correctly filled in, MySQL logs me in and the application
opens.
But, I can also log in (as myself) if I leave both fields blank. And the
plot
thickens when considering the following VB code sni
through a servlet i insert my form data into my table
(primary key is auto-incremented) and then i throw
another query which is
select last_insert_id() from mytable limit 1
through my .executeQuery method. when i ask
for the data through
.getString(1) i get null
NullPointerException
why ... any
Hi.
I am trying out MySQL with Visual Basic and the ODBC 3.5 API. I am finding
that everything works just the same as with other DBMS systems. (Except for
the different MySQL syntax.) So, no problems there. (yet).
However, I clearly don't know enough about MySQL security because something i
Hello,
I had written last week because I tried to send a mail to
[EMAIL PROTECTED] about MySQL transactions without success.
[EMAIL PROTECTED] answered me, but I can't send a mail to him.
Using "set autocommit=0;" doesn't fix the problem...
My problem was :
We have 2 threads using sql instruct
Hello,
I have a question:
We want to real-time synchronize a MySQL database part with a distant
database.
We have a central database containing all the data. This database must share
several parts (records) with the local databases.
All transactions made in the central database must be replicate
Richard Idalski a écrit :
>
> I need to connect to a MySQL database from a remote machine but it seems
> that when the mysql was setup, that it was only setup with localhost, and
> not it's hostname. IE: When I try these commands:
>
> 'mysqladmin -h ren2 --port=3306 version'
> I get the followin
I use Perl, Php, mysql for my applications. I have a great manual for php
for mysql processes. But i do not know any manual for perl yet. Does
anyone know any manual about for perl-mysql? Better if would be .chm
version. Thanks.
-Onder
--
mysql> show slave status
-> ;
+-+-+-+---+--+-+
---+-+-++---
-+--+
| Master_Host | Master_User | Master_Port | Connect_retry | Log_File | Pos |
Slave_Runni
I need to connect to a MySQL database from a remote machine but it seems
that when the mysql was setup, that it was only setup with localhost, and
not it's hostname. IE: When I try these commands:
'mysqladmin -h ren2 --port=3306 version'
I get the following :
mysqladmin: connect to server at 'ren
max a écrit :
>
> hi all,
> I'm in trouble trying to create a sql query to get the prev & next value not
> null starting from a specified point ... I mean:
>
> table_a
>
> id
>
> 23
> 24
> 56
> 62
>
> starting from id 56, I need the id 24 & the id 62 ... I've trying several
> way & mysql
It should be 'username'@'localhost'
Mark Shade wrote:
>Yep...
>
>I am in as root, so I should have rights to everything.
>
>Yep, I have confirmed that the dbname is right, but doublechecking it
>multiple times. Plus, this happens even on db that I did the same thing to
>only a week ago. Th
hi all,
I'm in trouble trying to create a sql query to get the prev & next value not
null starting from a specified point ... I mean:
table_a
id
23
24
56
62
starting from id 56, I need the id 24 & the id 62 ... I've trying several
way & mysql funct to do this job but w/o success :(
anyone
Let's see your my.cnf file.
- Original Message -
From: "Azhar Khan" <[EMAIL PROTECTED]>
Date: Wed, 8 May 2002 17:49:55 -0400
To: <[EMAIL PROTECTED]>
Subject: re: replication
> During the replication process
>http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_A
Hi,
I tried using a FreeBSD box with MySQL as the Master and W2K as the slave
and it works fine. I then swapped it so the W2K was master and I get the
following from the Unix box.
020510 14:14:22 mysqld started
/usr/local/libexec/mysqld: ready for connections
020510 14:14:22 Slave: connected t
On Fri, 10 May 2002, Jon Lochner wrote:
> Greetings,
>
> Using the semi-static linux binaries to connect to localhost mysqld/mysql 3.23.47.
> Can connect to the database with "mysql -u -p". ODBC also OK
>
> But I keep getting the following with the GUI:
> Can't connect to local MySQL server
actually you may want to change [MYSQLD] to [mysqld] and restart your slave
server
I don't think it has read your my.cnf file correctly ( that means the other
settings will not have taken affect either, like password and server ID)
-Original Message-
From: Raymond Brighenti [mailto:[EMAIL
btw, things look much prettier if you use "show slave status\G"
the replicant user, and host ip address does not match your my.cnf on the
slave
>master-host=20.0.0.54
>master-user=echo
| Master_Host | Master_User | Master_Port | Connect_retry | Log_File | Pos |
| | test| 33
Hi Raymond,
That's an interesting message you're getting. Obviously there is an issue with IP
address not getting to mysqld. The only thing that can make any sense to me in this
one is double check the name and location of the my.cnf file.
See ya,
Terrence
- Original Message -
From:
1 - 100 of 114 matches
Mail list logo
