try:
select limit , 1
eva
-Original Message-
From: Marc Bakker [mailto:[EMAIL PROTECTED]
Sent: 29. marca 2003 16:55
To: [EMAIL PROTECTED]
Subject: MySQL: Selecting a patricular row
Hello,
I am working on a PHP/MySQL/Apache website. I have a MySQL table with 5
rows. I want to sele
After a routine restart of our MySQL 3.23 server today, we began getting
the following PHP error message during times of moderately high database
server load:
Warning: MySQL Connection Failed: Can't create a new thread (errno 11). If
you are not out of
available memory, you can consult the man
Christian,
While fulltext had some problems with latin1 charset and German language
it worked quite well for me with latin1_de and a customized German
stopword list. BTW I create my stopword list from the texts to be indexed.
All words are sorted by frequency and then common words from the top of
Hi,
I am Shylendra from HP, working on the ServiceGuard (Clustering product
of HP).
Problem 1
-
While Starting and Stopping MySQL Server frequently, sometimes it hangs
up and the output of ps -ef is as below.
--
I really hate mailing lists - they are dinosaurs for this type of thing.
A web discussion board is a much more powerful and flexible tool for this
type of community. Thread tracking, archiving, searching, dont have to
download 50 emails a day just to monitor a couple threads...cmon its 2003!
Cant
Most ppl don't like forums. Do you know even one serious project which uses
a forum? I know Slackware did and it really was a PAIN.
Mail to this list gets mirrored on more places then you can imagine, same
goes for PHP lists. You can't blame this on the MySQL ppl.
There would be less mail if pp
On Mon, Mar 31, 2003 at 12:52:43AM -0800, Seth Brundle wrote:
>
> I really hate mailing lists - they are dinosaurs for this type of thing.
I really hate on-line forums. They're difficult to track because I
must remember visit them daily. And I can't use them while
disconnected. With e-mail, I d
I am making my own shopping cart, and I'm trying to figure out, how to store "previous
orders", so
they can view them later. If they have multiple products(tangible to be shipped), and
they have the
possibility of having colors, sizes, and or styles, each of them their own attribute,
plus qty, a
Hi all,
I have a problem about the innodb memory usage. The following is my
config file for mysql and the version I am using is 4.0.12 in FreeBSD
4.7 stable.
my.cnf
[mysqld]
port=3306
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
set-variable = thread_cache_size=700
set-variable = ta
On Monday 31 March 2003 02:37, vinita Vigine Murugiah wrote:
> I have been use mysql ver 3.23.53, also I'm using on DELETE CASECADE. It
> seems working fine.
>
> I believe UPDATE CASECADE is working from version 4.0.8.
>
> --
On Sunday 30 March 2003 16:04, Paul Reilly wrote:
> Does MySQL 4.0 allow mixing of character sets in a database?
> I'd like a table which lists the locale string for a particular
> phrase in multiple languages. I have it working in french, english, german
> etc in MySQL 3.23 but I needed a seperat
I am with you jeremy... Web based discussion boards are horrible. I never remember to
go daily. I can write my responses to this on the train and send them when I get to my
desk.
Rich
>> On Mon, Mar 31, 2003 at 12:52:43AM -0800, Seth Brundle wrote:
>> >
>> > I really hate mailing lists -
I'm upgrading from 3.23.53 to 4.0.12 and noticed that
4.0.12 wants to pull data files from /var/lib/mysql. I
set the prefix to be /home/mysql4, so why is it
wanting to get the data from this new location?
When I installed 3.23.53, I set the prefix as
/home/mysql3 and it pulls data from /home/mysql
On 31-Mar-2003 Mike William wrote:
> After a routine restart of our MySQL 3.23 server today, we began getting
> the following PHP error message during times of moderately high database
> server load:
>
> Warning: MySQL Connection Failed: Can't create a new thread (errno 11).
> If
> you are no
forgot to cc the list...
# [EMAIL PROTECTED] / 2003-03-18 08:06:37 -0700:
> On Sunday, March 16, 2003, at 03:33 AM, Roman Neuhauser wrote:
> ># [EMAIL PROTECTED] / 2003-03-15 08:29:51 -0700:
> >>On Thursday, March 13, 2003, at 12:46 PM, Roman Neuhauser wrote:
> >>># [EMAIL PROTECTED] / 2003-
Hi.
In novice in this, can you tell me how application uses to edit your
databases in your server (not in local).
Did someone uses MySQL Control Center I cant configure it to works
in remote.
PS My english sucks
check this first in command prompt "mysqladmin ping".
You should receive "Mysql is alive". Otherwise you have to start your
service.
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Subject: Cant connect to Mysql server on 'localhost' (10061)
Date: Mon, 31 Mar 2003 12:11:32
Uttam wrote:
u can use highly customizabe MySQL DATE_FORMAT() function for retrieving
date in desired format.
Thanks for the detailed information.
For manipulating date in php, u can use the MySQL UNIX_TIMESTAMP(date)
function to return unix timestamp of the date and use the php date functions
Hello
If you mean Administering your MySQL server, then
probably SQLyog ( http://www.webyog.com ) will be a
good choice. It is small, powerful and a FREE front
end to MySQL.
Karam
--- Javier Gonzalez <[EMAIL PROTECTED]> wrote:
> Hi.
>
> In novice in this, can you tell me how application
> uses
Kaming,
please run SHOW INNODB STATUS to monitor the amount of memory allocated by
InnoDB. If you have very many tables, the dictionary cache can take quite a
lot of memory. But it should not grow indefinitely.
If the problem is memory fragmentation caused by the malloc() in FreeBSD,
you can te
Sounds to me that you have some permission problems. I use Crystal Reports
against MySQL and many other databases and it works fine. All you have to do
is setup a ODBC DSN (user or system DSN) with a username and password. Make
sure this user exists in MySQL so the user can get in. I would check yo
Hi, I'm just wondering what the right syntax for using the delete
statement is? I'm trying to write a simple garbage collection/deletion
query similar to the queries below.
delete from 'item' where 'quantity_of_item_in_stock' <= 10;
(the above version of the query pops up a Java-applet alert as
Can someone provide a link to the use of these in queries in the
online MySQL manual? I did find them a few weeks ago but I've been lurking
around the manual now for an hour or so and can't find them at all.
TIA,
Ed
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
Don't do that !!!
You will eventually get the wrong row when someone else inserts after you.
Use last_insert_id().
MySQL List wrote:
Nevermind I got it
$next_number = $dbh->selectrow_array(qq{ SELECT MAX(id) FROM
whatever_table });
Richard.
- Original Message -
From: "MySQL List" <[E
[EMAIL PROTECTED] wrote:
Can someone provide a link to the use of these in queries in the
online MySQL manual? I did find them a few weeks ago but I've been lurking
around the manual now for an hour or so and can't find them at all.
TIA,
Ed
http://www.mysql.com/doc/en/Date_and_time_functions.htm
If this is an April fools joke, you are off a day.
Seth Brundle wrote:
I really hate mailing lists - they are dinosaurs for this type of thing.
A web discussion board is a much more powerful and flexible tool for this
type of community. Thread tracking, archiving, searching, dont have to
downloa
Joseph Bannon wrote:
I'm upgrading from 3.23.53 to 4.0.12 and noticed that
4.0.12 wants to pull data files from /var/lib/mysql. I
set the prefix to be /home/mysql4, so why is it
wanting to get the data from this new location?
When I installed 3.23.53, I set the prefix as
/home/mysql3 and it pull
warm-fusion wrote:
Hi, I'm just wondering what the right syntax for using the delete
statement is? I'm trying to write a simple garbage collection/deletion
query similar to the queries below.
delete from 'item' where 'quantity_of_item_in_stock' <= 10;
delete from item where quantity_of_item_
Hi,
On Mon, Mar 31, 2003 at 03:40:03PM +0100, warm-fusion wrote:
> Hi, I'm just wondering what the right syntax for using the delete
> statement is? I'm trying to write a simple garbage collection/deletion
> query similar to the queries below.
>
> delete from 'item' where 'quantity_of_item_in_s
Dear MySQL users developers and programmers,
ERWin 4.1 not applicable for MySQL
I'd like to model some logical databases in Entity Relationships
diagrams
>From here I found interesting software
URL:
http://www3.ca.com/trials/
https://www3.ca.com/register/form.aspx?cid=8403
Download ERwin
You could try:
Datanamic's Dezign - www.datanamic.com
or you could use MS Visio Professional
HTH
Richard
>> Dear MySQL users developers and programmers,
>> ERWin 4.1 not applicable for MySQL
>> I'd like to model some logical databases in Entity Relationships
>> diagrams
>> From
I'm trying go get a future date from a query that contains a datetime
column. I figured I would be able to use an alias in the query to
calculate the future date as follows:
select expires as date_add('date' + interval 180 days) from table;
'date' is the column where the datetime is stored in th
Thanks, in the message you pointed me to
> set-variable = ft_min_word_len=3 (mysql defaults to 4)
is what is required, but how do I do this from PHP (I am using shared
hosting so don't have access to the MySQL config file).
Ben
At 18:56 30/03/2003 -0800, Adam Randall wrote:
Could anyone pleas
I recently updated from MySQL 3.23-55 to 4.0.12 now my mysql log keeps
showing lots of restarts. I've searched around but have not found anything.
I upgraded the 3.x rpm's using rpm -Uvh MySQL* and did the following rpm's.
I also followed the upgtrade doc on the MySQL page and ran the
mysql_fix_p
>I am looking for any type of documentation on using Crystal Reports
with
>MySQL. I have connected to mysqld from CR but when it shows the
>selected database, there are no tables listed. Is there something I
>have to configure in the MyODBC driver? Please help me out with any
>advice you may ha
I'm trying to set up my own web server . . . the typical
Linux/apache/perl/php/mysql combination. I've got all these components
working *except* that I am unable to connect to a MySQL database from
perl or php.
PHP & Perl are working fine with Apache and I can run MySQL commands
from the shell
I too have had problems with Crystal Reports and MySQL using the ODBC
drivers provided by MySQL. The problem is not that you can't make
Crystal Reports work with MySQL, but that when you connect to the
database Crystal Reports is unable to display the tables that are in the
database.
This makes
Hi,
Does anybody know of any MySQL vs. PostgreSQL recent article?
I mean, that it covers MySQL 4.x and PostgreSQL 7.3.x
Thanks in advance,
Juan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
hello,
i'am working on REDHAT,and trying to connect to a mysql DB. i tested this code which
works correctly on Windows.
import java.sql.*;
//
public class TestMM
{
public static void main(String args[])
{
// Chargement du driver JDBC
On Monday 31 March 2003 18:27, wrote:
> I'm trying go get a future date from a query that contains a datetime
> column. I figured I would be able to use an alias in the query to
> calculate the future date as follows:
>
> select expires as date_add('date' + interval 180 days) from table;
>
> 'dat
On Monday 31 March 2003 17:35, wrote:
> Can someone provide a link to the use of these in queries in the
> online MySQL manual? I did find them a few weeks ago but I've been lurking
> around the manual now for an hour or so and can't find them at all.
Use search in the online manual ;)
On Monday 31 March 2003 10:34, Shylendra H V wrote:
> I am Shylendra from HP, working on the ServiceGuard (Clustering product
> of HP).
>
>
> Problem 1
> -
>
>
> While Starting and Stopping MySQL Server frequently, sometimes it hangs
> up and the output of ps -ef is as below.
>
> -
Hey guys,
Ii could not find an answer on the innodb website, i'm using InnoDB now for some
months and i'm very happy since the constant corruptions i had in MyISAM are gone now.
Although i have been warned that InnoDB would take up more diskspace i did not suspect
gigabytes.
When first install
[EMAIL PROTECTED] wrote:
I'm trying go get a future date from a query that contains a datetime
column. I figured I would be able to use an alias in the query to
calculate the future date as follows:
select expires as date_add('date' + interval 180 days) from table;
'date' is a string.
Did you m
Hi, how do I configure mysql to be Case-Sensitive globally?
(ie where, like, clauses work with case-sensitive strings
Help is greatly appreciated.
-Dan
At 09:17 AM 3/31/2003, you wrote:
Dear MySQL users developers and programmers,
ERWin 4.1 not applicable for MySQL
I'd like to model some logical databases in Entity Relationships
diagrams
From here I found interesting software
What design tool do you use under Windows or Linux for modeling a
log
Start reading here:
http://www.mysql.com/doc/en/Privileges.html
and read to 4.2.10.
Two tips I found useful:
1. The current_user() function tells you what MySQL user name it thinks that
you are. This can be used to verify if you are an authenticated user.
mysql> SELECT current_user();
2. Remove
I did use date as a column name but I'll change that.
Also, I'm trying to select the contents of each column for each recors
and do this date calculation but apparently I cannot do both at the same
time?
I can do SELECT * from table;
but can't do SELECT id, agent, ad_type, date_add('submit',
Those are binary log files used in replication.
If you are not running replication, remove the line
bin-log
from the config file.
Tiele Declercq wrote:
Hey guys,
Ii could not find an answer on the innodb website, i'm using InnoDB now for some months and i'm very happy since the constant corruptio
Hello,
This actually brings up a question I've been meaning to ask.
from the InnoDB documentations
"To be able to recover your InnoDB database to the present from the
binary backup described above, you have to run your MySQL database with
the general logging and log archiving of MySQL switched
[EMAIL PROTECTED] wrote:
I did use date as a column name but I'll change that.
Also, I'm trying to select the contents of each column for each recors
and do this date calculation but apparently I cannot do both at the same
time?
I can do SELECT * from table;
but can't do SELECT id, agent, ad
First, a little rant: I don't know what it is about
the MySQL docs that make them so difficult for me to
read, but try as I may, I have the most difficult time
making heads or tails of anything in the official
MySQL documentation.
That being said, here's my question, the answer to
which I was NOT
Hey, thanks fopr the tip. Indeed the line was in there. Can i now erase
those bin files that have been written before ?
- Original Message -
From: "gerald_clark" <[EMAIL PROTECTED]>
To: "Tiele Declercq" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, March 31, 2003 6:39 PM
Subjec
Great!
any links to working examples would be greatly appreciated!
Thanks!
Martin
- Original Message -
From: "Michael Shulman" <[EMAIL PROTECTED]>
To: "Martin Gainty" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Monday, March 31, 2003 10:02 AM
Subject: Re: Passwords d
Michael et al-
I am trying to locate ONE working MySQL example for windows. Is this a myth
or is there WORKING source example out there somewhere?
Thanks,
Martin
- Original Message -
From: "Michael Shulman" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, March
I delete the old binlogs after doing my nightly mysqlhotcopy.
Tiele Declercq wrote:
Hey, thanks fopr the tip. Indeed the line was in there. Can i now erase
those bin files that have been written before ?
- Original Message -
From: "gerald_clark" <[EMAIL PROTECTED]>
To: "Tiele Declercq" <[
This is not really a MySQL docs problem.
The manual gives the mysql syntax, but you are expected to already know SQL.
You need to get a book on SQL.
SELECT data.id, data.title
FROM data,archive
WHERE data.favorite=archive.favorite AND data.favorite='Y';
Bob Sawyer wrote:
First, a little rant: I d
I wont work for me, I dont have access to SQL layer.
I use JDO
In Micorosft SQL Server I can specify the Collate during database creation
to make my string case-sensitive. Is there an equivalent configuration for
MySQL?
Thanks ahead for all suggestions
-Dan
- Original Message -
From: "M
We are using it on Windows 2000 and Windows XP. But it doesn't seem to be
tied in to the Windows security system, so it should work the same on WinME.
-ms
- Original Message -
From: "Martin Gainty" <[EMAIL PROTECTED]>
To: "Michael Shulman" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>;
<[EMAIL
On Mon, 2003-03-31 at 07:57, Wynne Crisman wrote:
Hi !!
> I too have had problems with Crystal Reports and MySQL using the ODBC
> drivers provided by MySQL. The problem is not that you can't make
> Crystal Reports work with MySQL, but that when you connect to the
> database Crystal Reports is un
I'm not sure if you can do it globally... but here is what I do:
select passwd
from blerg
where login = "Matt"
and binary login = "Matt";
I do it twice b/c the binary operation is quite slow and doing the
normal equate first speeds it up significantly.
Doesn't exactly answer your questio
Hello Michael-
Would you know of any links to working examples for Windows?
Thanks!
Martin
- Original Message -
From: "Michael Shulman" <[EMAIL PROTECTED]>
To: "Martin Gainty" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Monday, March 31, 2003 10:02 AM
Subject: Re: Pa
Thanks, Gerald. I appreciate the assist.
As for the docs: I know it's not a docs problem, really - yet if you
compare, say, the PHP docs with the MySQL docs, the PHP docs are much easier
to read and the examples are clearer than in the MySQL docs - IMHO. I think
it's unrealistic to expect anyone t
Hi Don,
Thanks for the suggestions. Here's what happened.
> Your pconnects are probably sleeping too long.
in /etc/my.cnf:
[mysqld]
set-variable = wait_timeout=10
I tried this, and it was a mixed bag. On the one hand, the "Can't create
thread..." error did indeed go away, and max_used_conn
Hi,
Is there a way in mysql to get the
record's last updated date?
Thanks,
Mike
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
If you added a timestamp column when you created the table then it's
easy... the timestamp column is updated automagically when an update or
insert is done.
create table tablename (id int, timestamp timestamp);
select timestamp from tablename where id = 123;
If you didn't use a timestamp column,
> -Original Message-
> From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]
> I really hate on-line forums. They're difficult to track because I
> must remember visit them daily.
Agreed. I don't need yet another web page to keep track of. I prefer to
let my mail reader thread up the messag
Anyone know why the two ISPs I use (www.pair.com, www.oneandone.co.uk) are
still using V3 and don't have any timescales for upgrading?
Ben
* Ben Edwards +44 (0)117 968 2602 *
* Critical Site Builder
I have successfully used Erwin 4.1 to connect to and model MySQl databases. Read
the Erwin tutorial. You need to create an ODBC connection first.
David
sql, query
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL P
Apparently V4 douse, its been out for over a year but for some reason ISP
don't use it.
ben
At 10:29 31/03/2003 -0800, Adam Randall wrote:
Well, as far as I know, your SOL =) MySQL does not support settings for
full text indexing as of yet, so the only way that I know how to do it is
to modif
All,
I am having difficulty loading data into a DB using a perl script.Linux
RH8 box.
DB creation:
mysql -uroot -p -e 'create database yeast'
mysql -uroot -p -e 'grant all privileges on yeast.* to [EMAIL PROTECTED]'
mysql -uroot -p -e 'grant all privileges on yeast.* to [EMAIL PROTECTED]'
On 31 Mar 2003 at 9:49, Dan Tran wrote:
> I wont work for me, I dont have access to SQL layer.
You can declare your columns as VARCHAR BINARY rather than VARCHAR in
your table creation. Another possibility might be to set your
character set for the database to latin1csas rather than the defaul
Charles Hauser wrote:
All,
I am having difficulty loading data into a DB using a perl script.Linux
RH8 box.
DB creation:
mysql -uroot -p -e 'create database yeast'
mysql -uroot -p -e 'grant all privileges on yeast.* to [EMAIL PROTECTED]'
mysql -uroot -p -e 'grant all privileges on yeast
On Mon, Mar 31, 2003 at 06:00:12PM +0100, Ben Edwards wrote:
> Anyone know why the two ISPs I use (www.pair.com, www.oneandone.co.uk) are
> still using V3 and don't have any timescales for upgrading?
No idea. Ask them, maybe?
Jeremy
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine,
Ben,
I certainly can't speak for those organizations, but from our
point of
view MySQL v 4.x has just been declared stable. This means that its now
time for us to run it internally for a few weeks and see if its going to
cause any new problems over the existing 3.2.x series AND test the
u
Do you happen to know how to change the charset?
I have read thru the manual, but I have no clue where to start.
Thanks in advance
-Dan
- Original Message -
From: "Keith C. Ivey" <[EMAIL PROTECTED]>
To: "MySQL List" <[EMAIL PROTECTED]>
Cc: "Dan Tran" <[EMAIL PROTECTED]>; "Matt Gostick"
First people, please dont get all angry about my suggestion...please hear me
out...
> I really hate on-line forums. They're difficult to track because I
> must remember visit them daily.
OK this is the first issue - 95% of people who need MySQL info do not need
it daily. Mailing lists are a poor
I'm using MySQL/InnoDB 4.0.12
I set replication to replicate only database escribaupdate...
The bug is:
I connect in database escribaupdate and run:
delete from escriba_autorizacao;
go to shell and execute:
scribthree:/database/log-bin# /usr/local/mysql4/bin/mysqlbinlog logbin.001
# at 4
#03
Ben, this is really a question you have to pose to them.
Many "professional" ISPs won't just automatically upgrade to the newest
version of X before taking the time to create a full test environment to run
through any and all circumstances that they think they might come across.
Also, a new versi
You may consider it a bug, but it is the documented behavior.
Dyego Souza do Carmo wrote:
I'm using MySQL/InnoDB 4.0.12
I set replication to replicate only database escribaupdate...
The bug is:
I connect in database escribaupdate and run:
delete from escriba_autorizacao;
go to shell and execut
On 31 Mar 2003 at 16:39, Dyego Souza do Carmo wrote:
> this is a bug... because i modify the database escribaupdate from
> database mysql and this is not logged...
Yes, it is a bug, but you can work around it by using replicate-wild-
do-table. See the documentation for the replicate-do-db option
> -Original Message-
> From: Seth Brundle [mailto:[EMAIL PROTECTED]
> H...seems like some Yahoo! employee has never used
> Yahoo! Groups ;)
I know a lot of people who refuse to use Yahoo Groups because of Yahoo's
very open and ever-changing privacy policy.
Most of the other comb
Hi,
I would like to add my 2 cents worth.
First, I like having a mailing list. I do not post very frequently but I do like to
scan the posts of others. It is a great way to learn little tricks and tips about
MySQL.
Second, I don't see why you can't have both a mailing list and an on-line forum
Jeremy Zawodny wrote:
On Mon, Mar 31, 2003 at 06:00:12PM +0100, Ben Edwards wrote:
Anyone know why the two ISPs I use (www.pair.com, www.oneandone.co.uk) are
still using V3 and don't have any timescales for upgrading?
No idea. Ask them, maybe?
This is probably a "don't fix what's not
Yes, if someone has something to complain about, make a website and
point the others to it. This topic of dicussion - improving the state of
things - has been recurrent in every mailing lists for ages, and it
stops only when somebody DOES something about it ;-)
Very nice argumentation by Seth Brun
Sorry everybody. I assumed that as it had been out for a long time (2
years?) it was stable. I should of chequed.
Ben
At 14:32 31/03/2003 -0500, Scott Helms wrote:
Ben,
I certainly can't speak for those organizations, but from our
point of
view MySQL v 4.x has just been declared stab
In the last episode (Mar 31), Seth Brundle said:
> First people, please dont get all angry about my suggestion...please
> hear me out...
>
> > I really hate on-line forums. They're difficult to track because I
> > must remember visit them daily.
>
> OK this is the first issue - 95% of people who
On 31-Mar-2003 Mike William wrote:
> Hi Don,
>
> Thanks for the suggestions. Here's what happened.
>
> > Your pconnects are probably sleeping too long.
>> in /etc/my.cnf:
>>
>>[mysqld]
>> set-variable = wait_timeout=10
>
> I tried this, and it was a mixed bag. On the one hand, the "Can't
There are two weeks i try it...but...the replication don't start!!
I've follow the istruction
http://www.mysql.com/doc/en/Replication_HOWTO.html without success.
In the slave i have:
>Show slave status;
***
Headeranswer note
**
It the master actually writting to the binlog? What does the master say
when you run SHOW MASTER STATUS? Is the size of the binlog growing?
-Original Message-
From: trashMan [mailto:[EMAIL PROTECTED]
Sent: Monday, March 31, 2003 1:29 PM
To: [EMAIL PROTECTED]
Subject: Replication don't wo
Massi,
How about looking in the data directory, on the master. There will be
a file called hostname.err the contents will probably lead you to the
answer or least give some more data for the list to look at ;p
Scott Helms
On Mon, 2003-03-31 at 16:29, trashMan wrote:
> There are two wee
MySQL List,
MySQL was working fine until today. I hadn't used it for a
month or so but now, I try to restart the MySQL Daemon and I get this
error:
030331 12:32:27 mysqld started
/usr/local/mysql/mysql-3.23.55-max/bin/mysqld: Too many parameters
/usr/local/mysql/mysql-3.23.55-max/bin/mys
> I really hate on-line forums. They're difficult to track because I
> must remember visit them daily.
OK this is the first issue - 95% of people who need MySQL info do not need
it daily. Mailing lists are a poor tool for them.
No but those in need of help does. And those ppl who are capable of h
The first time I run winmysqladmin, it creates a my.ini file for me in the
windows directory. It prompts for a username and password, recommended for
first time users, it says.
What does the "user=" and "password=" fields in the my.ini file do? They
don't seem related to the "mysql" command lin
The error.log on the master dont' report anything...
MySql: ready for connections
Other info
>Show master status;
***
Headeranswer note
***
File webserver-bin.008
Position 73
On Mon, Mar 31, 2003 at 06:00:12PM +0100, Ben Edwards wrote:
> Anyone know why the two ISPs I use (www.pair.com, www.oneandone.co.uk) are
> still using V3 and don't have any timescales for upgrading?
I should point out that if you're looking for an ISP that can support
MySQL 4.0.xx, let me know o
What position and in what binlog does your slave show it is at? It might be
helpful if you post the entire output of show slave status (minus user and
host if you are concerned about that for some reason).
-Original Message-
From: trashMan [mailto:[EMAIL PROTECTED]
Sent: Monday, March 31
Well,
I have a firewall on my LAN, but need to have access to the database
server from the wild internet. What ports do I need to forward ?
thanks in advance.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED
At 11:57 -0800 3/31/03, Michael Shulman wrote:
The first time I run winmysqladmin, it creates a my.ini file for me in the
windows directory. It prompts for a username and password, recommended for
first time users, it says.
What does the "user=" and "password=" fields in the my.ini file do? They
This is probably a topic that has been beaten to
death, but I need help in finding a resource for
getting postfix to support mysql on RedHat 8.0. I'm
not a serious RedHat admin, so I'm looking more for an
rpm of a prebuilt mysql-ready postfix for RedHat, but
if I can find a set of (fairly explicit
1 - 100 of 133 matches
Mail list logo
