Hi, I install the mySQL in my machine and when I going
to see the service that it running in to it I don´t see the
service of MySQL, but it run because I test it and run...
What can I do to see the service
Best Regards
Jorge
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Richard --
...and then Richard Reina said...
%
% I would like to backup databases from a linux MySQL server to another
% linux machine on the same private network but I don' see in the docs how
% I can do this with mysqlhotcopy or mysqldump. Is th
Hi -
I'm running 4.0.13-Max on Linux via PHP. I don't have BDB shared mode set.
I've been experimenting with the BDB transactions and been getting confusing results.
My tests
are separate threads running a PHP test script.
It seems that a transaction can acquire 1 or more locks, then fail on
Mysterious. I assume `mysql -p` prompts you for root's password and
works as expected, since without -p it says you're not using a password,
rather than saying there's something wrong with the password.
When you tried the defaults-file option, did you use the full path?
That is,
mysql --def
Thanks for your answer, you can see my comments below.
-Original Message-
From: Matt W [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 13, 2003 3:36 PM
To: Jason Ramsey; [EMAIL PROTECTED]
Subject: Re: Backslash and full text searches
Hi Jason,
Of course somebody's isn't going to matc
Hi Gabriel,
No, the order of the WHERE clause shouldn't have anything to do with how
the query is executed. The only exception may be if MySQL thinks 2
different ways of doing something are of equal cost. In that case it may
choose one or the other depending on how the query is written.
Matt
-
Hi Scott,
This kind of ordering thing has come up before and there's never a great
answer I don't think.
You could try this ORDER BY
ORDER BY l.age + 0.0, l.age, l.date
But I think that might cause sorting problems if age has leading 0s.
Maybe not...
Matt
- Original Message -
From:
Hi Tony,
shell> perror 143
Error code 143: Unknown error
143 = Conflicting table definition between MERGE and mapped table
Matt
- Original Message -
From: <[EMAIL PROTECTED]>
Sent: Thursday, November 13, 2003 4:00 PM
Subject: Merge Tables not working...
> Hello,
>
> I've posted this
Hi Jason,
Of course somebody's isn't going to match somebody\'s. :-) somebody\'s
should match somebody\'s -- because it's really matching the "somebody"
part. If you're using 4+, you can use IN BOOLEAN MODE to match
somebody\'s exactly:
MATCH (col) AGAINST (' "somebody\\\'s" ' IN BOOLEAN MODE)
H
I have the following...
tSql = "SELECT l.team, l.link, lc.category, l.age, l.date
FROM league AS l
INNER JOIN league_category AS lc
ON l.category = lc.id
WHERE lc.id = " & prepSQL(tConn, id) & " AND l.status = '1'
ORDER BY l.age, l.date";
L.age has data in
I posted this before, "Subject: 64bit G5 Panther compiles" but
received no reply.
Is there any answer yet for the ability to compile a working, 64bit
Mysql on OSX Panther?
Would you use GCC compiler flags-mpowerpc-gpopt and -mpowerpc64 ?
--
Adam Goldstein
White Wolf Networks
http://whitewlf.n
Hi Jason,
There is no "format" per-se of the stopword file. The words are parsed
in the same way as when they're being indexed. e.g. A "word" is a
sequence of aplhanumeric characters, _ and '
So one line per word (which is how I do it) will work fine. As would
separating with spaces, commas, etc.
Hi all,
Has anyone here seen or heard anything concrete about Sybase iQ (other
than Sybase's performance claims). They say that the basis of their new
engine is "analytics", not transactions. A Google search turned up
nothing of technical merit and the whole idea seems to be using seperate
sto
I have Mysql 4.0.14 with MyODBC3.51 and Access97.
I have a query
SELECT inquiry_data_simple.inquiry_id, inquiry_data_simple.organization,
inquiry_data_simple.event_date, inquiry_data_simple.event_id FROM
inquiry_data_simple ORDER BY inquiry_data_simple.organization;
The "organization" field does
Hi,
I'm trying to load some data into a MySql table, but some of the srtings
that I try to load come with colons in them and then I get an error... is it
possible to insert colons and special characters into MySql? How?
Thanks!
--
MySQL General Mailing List
For list archives: http://lists.mysql
Thanks for the help to ALL
I got it to work.
I do not know how but I think that they might have been hidden
characters in the program doing insert
in the actuall insert statements. I retyped the insert code in the
program and things started to
work. Probably when I ftp the code somethin gel
We make extensive use of full text searches, but have run into some problems
with backslashes. If a word like "somebody's" is entered into our database,
we escape the string using "mysql_escapes_string" in php. So,
mysql_escape_string("somebody's") becomes "somebody\'s" when it is saved in
the da
In the docs is says that you can define your own stopwords file for fulltext
searching. The following is under show variables...
ft_stopword_file The file from which to read the list of stopwords for
full-text searches. All the words from the file will be used; comments are
not honored. By defaul
In the last episode (Nov 13), Paride De Gasperis said:
> Hello all,
> I have a problem storing an SHA1 hash generated as user password for an
> application...
> This is the original SELECT Command:
> INSERT INTO Auth$ VALUES ('System', '
> % 3/4
> ÃX;Z^E(xB9Â?(?U?N~oSSE?$03Ã^O?#^1j?'U'YÃÃ??-#N
Nestor Florez wrote:
I actually took a look at the mysql.user table and user nestor has a
password in both entries to the table.
One entry is for localhost and the other is for '%';
I try inserting from the command line and I get:
mysql> insert into School (school_desc) values ('Nestor');
Query OK
Hello,
I've posted this before, but did not get a fix or find out what I am not doing
coreectly.
I've established several merge tables. 3 out of the 5 of my merge tables work
fine...but when I try to access (e.g. describe or query) the other two, I get the
following error:
mysql> describe
Paride De Gasperis wrote:
> I have a problem storing an SHA1 hash generated as user password for
> an application...
I do the same thing (although not with a MySQL database) and I anticipated
problems in storing the binary hash, so I chose to perform a simple Base64
encoding of the hash result fi
Thanks for the reply, I'm getting the message
A shorter question
I have seen that you can create an index across multiple columns, is
there any way one can tell which column returned the results (this would
help me short term). Or indeed have more than one word that's indexed in
a single column.
> -Original Message-
> From: Matt Babineau [mailto:[EMAIL PROTECTED]
> I am running 4.0.15-standard on RH9. My mysql database just stopped
> working, is there a way I can log information about why it stops like
> this? the *.err was unhelpful.
Did you just install a glibc upgrade/bugfix
on 11/13/03 3:57 PM, Michael Stassen at [EMAIL PROTECTED] wrote:
> The client (mysql) reads the .my.cnf file when you start it, so
> restarting mysqld and relogging in as root are not necessary.
>
> Let's see if I have this straight: While logged in as root, you created
> .my.cnf in root's home d
On Thursday, Nov 13, 2003, at 12:03 US/Eastern, John Berman wrote:
I have a single table with 120 fields (its full of genealogical data)
All the records apart from marriages have an entry in the surname field
[snip]
Now marriages don't have an entry in surname but they do in
groomsurname
and bri
Hello all,
I have a problem storing an SHA1 hash generated as user password for an application...
This is the original SELECT Command:
INSERT INTO Auth$ VALUES ('System',
'%¾ÿX;ZÊ(×B9ª?(?U?Nõ§E?$03ÇÔ?#¹j?ÚÝùÿ??-#NÂ?·¨Ùü½î[. 6?þþ^?', 3)
but the stored values are:
%¾ÿX;ZÊ(×B9ª?(?U?Nõ§E?$03ÇÔ?#
You should search the archives. This topic has been covered quite a few
times before, mainly in reference to increasing performance. Of course,
peoples definition of "large" differs.
If you think large is 10 or 20 millions records, then you will find
stuff in the archives discussing databases th
I actually took a look at the mysql.user table and user nestor has a
password in both entries to the table.
One entry is for localhost and the other is for '%';
I try inserting from the command line and I get:
mysql> insert into School (school_desc) values ('Nestor');
Query OK, 1 row affected (0.
Victor,
I will fixed this, but I do not think this is th eproblem.
I have the same settings on both W2K and Mac OS X and it only fails on
the Mac
Also When I log in as nestor with a password on the Mac I can not
insert a record
from the ocmmand line. I can do this on my W2K database.
Thanks I wi
The client (mysql) reads the .my.cnf file when you start it, so
restarting mysqld and relogging in as root are not necessary.
Let's see if I have this straight: While logged in as root, you created
.my.cnf in root's home directory. This file contains the password for
the mysql user "root". Ye
Anyone? Hope that does not mean that mySql is not used with large dbs ... :)
Thanks
--- ow <[EMAIL PROTECTED]> wrote:
> Hi,
>
> We are considering using mySql or postgreSql for an app that handles large
> volume of data. Somehow, it appears (mostly from the mailing lists) that
> mySql
> does not
Thanks to You Brent and Bill Easton
and Sorry
Hrmm , that what happen when not clipping direct into mail program ,
here is the Original :-) :
Select A.DepartmentName,A.Address,P.Postcode,P.cityname,CP.firstname
from caddress A,cpostinfo P
left Join CContactPerson CP , caddresscontactperson C
Their are two nestor users. One with a password and one without a password.
The one with connect from anywhere is only allowed to modify the test
database. Fix your privileges and you should be okay.
-Original Message-
From: Nestor Florez [mailto:[EMAIL PROTECTED]
Sent: Thursday, November
Hi all,
I have a MyISAM table with a decimal field (12,2)
I have loaded a bunch of data into this table, from ascii dumps of data being
migrated from other systems. Some of these dumps include a value for the
decimal field in the form of "00078000.00"
My understanding was that decimal fields be
OK guys this is beyond me.
I just found out that I can NOT insert into my SCHOOL table
when I login into mysql as user nestor on my Mac OS X.
The table is autoincremented. how do I find out what is the next
number to be incremented?
Nestor :-)
Nestor A. Florez
>>> "Nestor Florez" <[EMAIL PRO
I created the .my.cnf file in root's home dir, added the directives below
setting the correct password. Restarted mysqld, re-logged in as root, but
nothing works. It's not getting the password.
> The simplest solution is to keep the password in the .my.cnf file in
> your home directory. See http
I just realized that if I login to mysql as the user I can insert
records.
It must be somehting with my code
I will try the trace_on
It is just amazing that the same code works in my W2K machine
and when I ftp it to the Mac OS X only adding to th eschools fails.
Thanks,
Nestor :-)
Nestor A. F
+-+
| Grants for [EMAIL PROTECTED]
|
+-+
| GRANT USAGE ON *.* TO 'nestor'@'%' I
Got it, thanks
SELECT PROJECTCODE.ID AS 'ID', PROJECTCODE.Name AS 'Reference', EVENT.ID,
EVENT.ID_PROJECTCODE FROM PROJECTCODE LEFT JOIN EVENT ON PROJECTCODE.ID =
EVENT.ID_PROJECTCODE WHERE EVENT.ID IS NULL ORDER BY PROJECTCODE.Name
-Original Message-
From: Luc Foisy
Sent: Thursday, N
Hi Nestor. What does the mysql_error() report as the exact error
message? This could help you identify what kind of access control
issue it is.
Alternatively, you could try running the same query from the command
line (using the mysql client) and see if you get the same error.
Also, I'm not rea
execute show grants for nestor@'%' and see what that user has.
-Original Message-
From: Nestor Florez [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 13, 2003 12:21 PM
To: Nestor Florez; [EMAIL PROTECTED]
Subject: Re: Grant permissions problems - help
I forgot to mentioned that this s
I have two tables EVENT and PROJECTCODE
EVENT.ID
EVENT.ID_PROJECTCODE
PROJECTCODE.ID
PROJECTCODE.Name
EVENT PROJECTCODE
ID = 1 ID_PROJECTCODE = 0 ID = 1
ID = 2 ID_PROJECTCODE = 0 ID = 2
ID = 3 ID_PROJECTCODE = 1 ID = 3
I forgot to mentioned that this same code works on the same database on
my W2K
but I am having problems on my Mac OS X (Darwin). I sqldump the
database from my W2K
to my Mac Os X.
Nestor :-)
Nestor A. Florez
>>> Nestor Florez 11/13/2003 10:17:37 AM >>>
I have a mysql db where via a web page I
two last gotchas I thought of...
1- the routine will erase all the old records, but the day's logs will increment
between executions, so you may want to give it a day's worth of 'padding' if the 20GB
is a hard limit (disk size). No worries if it's flexible
2- until you have filled to your size
I have a mysql db where via a web page I access a database
I have set the permissions to
grant select, insert, update, delete on test.* to [EMAIL PROTECTED]
identified by 'nestor';
flush privileges;
The database has 3 tables. I can select via PHP code all the tables,
but when I try to insert
or
>Description:
configure contains the lines
compile_readline= no
compile_libedit= no
which causes a message
./configure: line xxx: no: command not found
unless you happen to have a program named "no" in your path.
>How-To-Repeat:
./confi
Got it Harald, thanks. OK, I've got this working
now, so I'll do a quick overview of what I've
learned... for the archives:
I am setting up mysql with msyslog to be a
centralized logging server. My servers (Windows
& Red Hat) will send their logs to this mysql
box. To keep the mysql db from gro
what type is item_id?
That query is looking for a value in the field item_is that is equal to the
a constant string "itemId". is there a record with the value in it?
- Original Message -
From: "florentina kore" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, November 13,
Hi,
> I am using mySQL on windows 98 machine.
> In my (java)program I want to run the following query
>
> query = "Select * from kids_books where item_id = 'itemId' ";
You are comparing values in column "item_id" with the string
'itemId'. I guess this is not what you want, is it?
With regards,
Hi ,
I am using mySQL on windows 98 machine.
In my (java)program I want to run the following query
query = "Select * from kids_books where item_id = 'itemId' ";
I get the itemId as a parameter from one of the functions.
When i run this query I am not getting any out put.
I have checked that
Hm
Lost me a bit, if you can all bear with me I will give a little more
info
I have a single table with 120 fields (its full of genealogical data)
All the records apart from marriages have an entry in the surname field
Every record has a set identifier (uniqueref)
When I search I have a statem
On Wed, Nov 12, 2003 at 08:10:58PM -0600, Mike Blezien wrote:
> Hello,
>
> we've set up many displays using the "Previous" and "Next" simple linking
> set up of search results. But now would like to implement the page number
> style, IE. "Previous" [1] [2] [3] "Next" style format and was hopi
You need to do a count before your select, use limmit to only select a set
number of records. That way you can work out how many pages there are and
just have a link. You run the same query for each page except that the start
record for the "limit" is the pagenumber * number of records per page.
-
On Wed, Nov 12, 2003 at 08:10:58PM -0600, Mike Blezien wrote:
> Hello,
>
> we've set up many displays using the "Previous" and "Next" simple linking
> set up of search results. But now would like to implement the page number
> style, IE. "Previous" [1] [2] [3] "Next" style format and was hoping
Hi there,
I am not sure I understood your question correctly. What exactly is it that
you want to test ?
a) the recovery possibility in case of power down
b) the recovery possibility in case of client disconnection (network
interruption, timeout etc.)
c) Recovery possibilities in general access
William R. Mussatto wrote:
Joe Lewis said:
We're experiencing the same issues, but not neccesarily after an
upgrade. We're using MySQL 4.0.12 and FreeBSD 4.7 Release. We're
getting max'd connections only on specific users, and the "show
processlist" is returning only the "show processlist" proc
restart mysql with the skip-grants option
-Original Message-
From: Rainer M. Krug [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 13, 2003 3:03 AM
To: [EMAIL PROTECTED]
Subject: Urgent problem
Hi
I did something very stupid: I locked myself out of the
MySQL server (all accounts, inc
From: Scott Yamahata [mailto:[EMAIL PROTECTED]
> At the command prompt, I'm supposed to type:
>
> mysql -h host -u user -p
>
> Does that mean that I type, for example:
>
> mysql -h localhost -u admin -p
>
> with localhost=host and admin=user?
>
> When I'm asked for the password, I hit return
A full table scan was performed on the rwt_screens table. The /* ... */
means that if the dbms is 4.0.x then do not cache this query.
-Original Message-
From: Luis Lebron [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 13, 2003 8:52 AM
To: Mysql (E-mail)
Subject: Question on slow querie
At the command prompt, I'm supposed to type:
mysql -h host -u user -p
Does that mean that I type, for example:
mysql -h localhost -u admin -p
with localhost=host and admin=user?
When I'm asked for the password, I hit return and it lets me in.
But if I try to create a database, by using:
GRAN
Hi,
> Do you know how to test a crash and a rollback?
You mean a client app crashing on you?
How about disabling/unplugging the network?
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com
Do you know how to test a crash and a rollback?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
From: Mikael Fridh [mailto:[EMAIL PROTECTED]
> or read about the TIMESTAMP type, but I guess that's too much
> precision since you only wanted the date, not the time.
> http://www.mysql.com/doc/en/DATETIME.html
It's only too much precision when you're selecting the whole field. You can simply
Mikael:
Thanks - I must have missed that in the create table docs - I did look there
first - honest!
And you are correct - in that the timestamp is too much precision, and
unfortunately due to the thousands of distributed apps that access this DB,
I cannot modify all the queries - oh well, gues
Mike Morton <[EMAIL PROTECTED]> wrote:
> I am trying to change a column specification, a date column, so that the
> default value is the current date. Is this possible? I just get an error
> on the change query:
>
> alter table Hits modify modify Date date NOT NULL default CURDATE();
>
> ERROR
http://www.mysql.com/doc/en/CREATE_TABLE.html
"A DEFAULT value has to be a constant, it cannot be a function or an
expression."
...
"Default values must be constants. This means, for example, that you cannot
set the default for a date column to be the value of a function such as NOW()
or CURREN
i believe you'll need to use a timestamp column, which will set to the
current date/time at each insert/update. I don't think you can set the
date default to a function.
You are also using a reserved word Date for your column name without
escaping it, i.e. `Date`, also you have two modify's in y
I am trying to change a column specification, a date column, so that the
default value is the current date. Is this possible? I just get an error
on the change query:
alter table Hits modify modify Date date NOT NULL default CURDATE();
ERROR 1064: You have an error in your SQL syntax. Check th
I am try to copy a couple of fields from one table to another. Here is my
query
Insert into users_test (firstName, lastName) Select firstName, lastName from
users;
The users table has 1,263 rows. However, only 1 row is inserted into
users_test.
If I perform the following query
Insert into use
I just started logging slow queries. Today I found the following lines in
the slow query log.
# Query_time: 14 Lock_time: 0 Rows_sent: 293 Rows_examined: 293
use storyboards;
SELECT /*!40001 SQL_NO_CACHE */ * FROM `rwt_screens`;
What exact does the third line mean?
thanks,
Luis R. Lebron
S
I am sure that this problem has already been answered but some how I can't
figure it out.
When I try to start the mysqld I get the error 2002 can't start server: Bind
or TCP/IP port: Address already in use or...
I check that the damoen is not runnig (ps -ef |grep mysqld ) and shows
nothing runni
Hi i have just installed the mysql_client
and i am trying to remotely connect to the database of
the other pc so i gave the following command
mysqlshow -h 192.168.64.12 -u [EMAIL PROTECTED]
mysqlshow: Host 'akroneiro' is not allowed to connect
to this M
What i msut do in order to gain access to th
On Nov 13, 2003, at 14:02, Alaios wrote:
Hi there . How can i passwords so i can login into
myqsl. With current configuration anyone is allowded
to login.
See the REVOKE command at http://mysql.com/GRANT
Cheers!
--zak
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
T
On Thursday, Nov 13, 2003, at 02:55 US/Eastern, John Berman wrote:
Can I have multiple values in one column and then index the column, I
have used different delimiters but the index only seems find the whole
contents of the column no matter what I separate the data with
It seems like you'd be bett
Thanks. Well I can't figure out what the problem is, I keep getting single
e-mails for each post :( even after unsubscribing and resubscribing with
digest selected.
-Original Message-
From: Rob A. Brahier [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 13, 2003 7:44 AM
To: Paul Fine;
Hello,
I have got problem with ordering records selected by LEFT JOIN, there
is a SQL select:
SELECT so.label, so.price, o.name, o.id id, o.location, p.filename, p.format
FROM offers o, offers_soffer so
LEFT JOIN offers_photos p ON o.id = p.record_id
WHERE so.rec_id = o.id
GROUP BY (o.id)
ORDER B
Hi there . How can i passwords so i can login into
myqsl. With current configuration anyone is allowded
to login.
__
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
http://antispam.yahoo.com/whatsnewfree
--
MySQL General Mailing List
For list ar
Hi all:
Need some clarification on this because the books and
articles don't make it clear.
Let's say I have a program in php or whatever language
that contains the username and password for access to
mysql and the program executes once anyone visits the
site.
Can multiple visitors to my site m
Your syntax is wrong, or at least not standard, if you are trying to do
multiple left joins.
Your ordering is not your typical for a query.
And you say "there" instead of "where".
Your query should be structure like this:
SELECT
FROM , ,...
LEFT JOIN ON
LEFT JOIN ON
LEFT JOIN ON
...
WHERE
Digest mode for this list is 2 digests a day.
-Original Message-
From: Paul Fine [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 12, 2003 3:37 PM
To: [EMAIL PROTECTED]
Subject: Digest Again, PLEASE SOMEONE HELP?
Unless I am misinformed, subscription to the DIGEST format of this list
Hi
I am pretty new to mysql.
I am porting an access driven website to mysql.
All has gone pretty much to plan bar one final page.
This page is basically a listing of duplicate users based on the email field.
In the access db I had a predefined query called emailduplicate
The site asp page cal
Can anyone please tell me what if anything happens with database locking
during the execution of a mysqldump? Ie. What happens to database
transactions occurring while performing a dump?
Thanks!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:ht
Thanks but if I am not mistaken, you are talking about SSH tunneling the
connection not what I am looking for. I am interested in how to
implement SSL. Thanks!
-Original Message-
From: Ferguson, Michael [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 12, 2003 2:47 PM
To: Paul Fin
Hello
I'll compile mysql on Solaris 2.6 with gcc 2.95.2 and gnumake and
and GNUtar and such error has been present
Making all in isam
make[2]: Entering directory `/export/home/pekasz/src/mysql-3.23.58/isam'
/bin/ksh ../libtool --mode=link gcc -O3 -DDBUG_OFF -DHAVE_RWLOCK_T
-lbind -o isamlog
Hello!
Does mySQL support a thing like Pascal/C++ unions for attribute types,
i.e. an attribute can be of two types at the same time.
Thanks in advance.
Florian
Hi
I set a 2-way replication on 2 servers.
I made some test transactions and it is working.
I can make the clients go to any of my servers and the replication
is done in real time, or so. It looks great.
What are the potential problems I could have? Suggestions?
Do you have any experience?
(usin
Hi!
Thanks for the info. We ARE getting tons of connections/second, so that
might be the problem... We hoped that 4.0.16 would solve it, which it
didn't, so now we're hoping for 4.0.17...
-- Henrik
Matt W skrev:
> Hi guys,
>
> Just wanted to say that I think I remember a recent commit to the sou
On Thursday 13 November 2003 10.41, nm wrote:
> Hi there
>
> I have a question regarding replication.
> This is the situation:
>
> Mysql-Max4.0.16
>
> 192.168.0.10 master
> 192.168.0.11 slave
>
> I would like to use the slave as the backup server
> and use it in case the master goes down for any re
Hi
thanks a lot for your prompt reply. The second email
went out on accident - apologies.
I managed to fix it - I found "localhost; EcolMod1"
in user.myd.
Thanks again,
Rainer
On 13 Nov 2003 at 10:41, nm wrote:
>
> Hi there
>
> I have a question regarding replication.
> This is the situat
On Nov 12, 2003, at 20:37, Paul Fine wrote:
Unless I am misinformed, subscription to the DIGEST format of this list
should cause all messages to come in one daily e-mail? Can someone
else who
is subscribed this way please at least let me know that this is at
least the
case for them?
While I do n
On Nov 12, 2003, at 17:52, Gelu Gogancea wrote:
bk pull http://mysql.bkbits.net/mysql-5.0
Try bk clone http://mysql.bkbits.net/mysql-5.0
Cheers!
--zak
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
The main problem we are looking at is backing up the database.
We have several big tables that all need to backed so the problem is these
tables
are being use 24/7 so taking a snap shot of the database will course down
time.
We have had no problems with auto increment columns.
-Original Mes
Hi there
I have a question regarding replication.
This is the situation:
Mysql-Max4.0.16
192.168.0.10 master
192.168.0.11 slave
I would like to use the slave as the backup server
and use it in case the master goes down for any reason.
I'm looking for a safe method to re-update the master when
Hi,
I tried it in 4.0 and got the desired result - but at least the select
part should not depend on version, as long as it's recent.
The select should return all combinations of first and last names
available in the source table ordered by random to be more interesting.
You can try that by its
> I did something very stupid: I locked myself out of the
> MySQL server (all accounts, incl administrator)...
>
> My problem: I use MySQLFront to change the allowed
> hosts and did it for all users. They were 'localhost'
> and I set them to 'localhost; EcolMod1' where the
> EcolMod1 is the na
Hi
I did something very stupid: I locked myself out of the
MySQL server (all accounts, incl administrator)...
My problem: I use MySQLFront to change the allowed
hosts and did it for all users. They were 'localhost'
and I set them to 'localhost; EcolMod1' where the
EcolMod1 is the name of my c
Hi
I did something stupid: I locked myself out of the
MySQL server...
My problem: I use MySQLFront to change the allowed
hosts and did it for all users. They were 'localhost'
and I set them to 'localhost; EcolMod1' where the
EcolMod1 is the name of my computer where the MySQL
server is insta
Dear friends
We have our application with data tier as mysql database in our office running on
windows platform which we need to synchronize with the same database on a remote
system at data centre on Linux.
Awaiting your reply at the earliest,
Thanks & Regards,
Prashant A
Hi Hsiu-Hui,
I havent followed the threat, excuse if this was mentioned before.
Did you try to start the server with the
--skip-innodb
option yet ?
--
kind regards
Nils Valentin
Tokyo/Japan
http://www.be-known-online.com/mysql/
On Thursday 13 November 2003 17:38, Hsiu-Hui Tseng wrote:
> H
1 - 100 of 105 matches
Mail list logo
