Hi,
Thanx for responding.
Only one worker thread was accesing MYSQL* myHdl. Nevertherless i have placed mutexes
around all calls involing MYSQL*.
main-thread: Defined MYSQL* myHdl as global variable and called mysql_init(), and
mysql_connect();
worker: Defined MYSQL_RES* res and used myHdl to
I figured it out, I had compiled one of its dependencies and not compiled
mysql itself afterwards, so it was seg faulting and leaving behind those
logs as part of bail-out
On Tue, 29 Jun 2004, David King wrote:
Date: Tue, 29 Jun 2004 17:53:57 -0700 (PDT)
From: David King <[EMAIL PROTECTED]>
To:
Dear, [EMAIL PROTECTED],
We have set up 1 master and 4 slave as replication.
Sometime,the slave need 4~10 minutes to synchronize the data with master database.
Do any way to tune the performance?
Or any other way to reduce the time to replicate?
Best regards.
Hi
Is it possible to change the table memory usage quota through mysql scripts as we do
in Oracle.
We are migrating our application from Oracle 9i to MySQL does any body have experience
in this area and are there some common problems faced during this procedure.
Any information will be helpful.
Mike Koponick wrote:
Hello all,
I would like to be able to select the certain dates within my script.
select created_date, status, user, comment1, comment7, comment8, action
from users WHERE customerid = 'Customer' AND created_date BETWEEN
'2004-05-31' AND '2004-07-01' ORDER BY created_date, sta
I can help easily enough on formatting the dates...
The DATE_FORMAT( date, format ) function is what you want:
DATE_FORMAT( date, "%m/%d/%Y" )
Wes
On Jun 30, 2004, at 9:40 PM, Mike Koponick wrote:
Hello all,
I would like to be able to select the certain dates within my script.
select created_date,
Hello all,
I would like to be able to select the certain dates within my script.
select created_date, status, user, comment1, comment7, comment8, action
from users WHERE customerid = 'Customer' AND created_date BETWEEN
'2004-05-31' AND '2004-07-01' ORDER BY created_date, status into outfile
'te
Lana:
The easiest thing would be if your field always contained the same
number of comma-separated strings. Then you could just do something
like a SUBSTRING_INDEX() function to break out the field into separate
values. But, assuming your field does not always contain the same
number of str
If you have multiple threads accessing the same connection remember to
make sure that only one thread enters mysql_query() mysql_connect() or
mysql_store_result() after you store the result another thread will be
able to use that connection without problems.
-Eric
On Wed, 30 Jun 2004 11:01:35 +00
At 13:58 -0700 6/30/04, Bill MacAllister wrote:
Hello,
I am a bit confused by processing of user= specifications in the
mysqld_safe script. Here is what I see:
* If user= is specificed in the [mysqld] or [server] sections then it is
ignored and a flag is set that prevents the specification of a
You may want more indexes but you might be getting killed because you already have too
many.
To test - try loading into a table without indexes and see if it makes a difference.
At the very least - check to see if the primary index which starts with 'dic' can make
your special 'dic' index super
Yes indeed, Lenz is preparing the build and has updated the news section.
(let's hope no critical bugs will be discovered which could slip the release
:))
Jocelyn
- Original Message -
From: "Jeremy Zawodny" <[EMAIL PROTECTED]>
To: "Jocelyn Fournier" <[EMAIL PROTECTED]>
Cc: "Andrew Patt
On Wed, Jun 30, 2004 at 11:52:32PM +0200, Jocelyn Fournier wrote:
> Hi,
>
> 4.1.3 is labeled beta in the bktree.
> So I assume 4.1.3 will be beta when it will be released ;)
And that looks to be soon, based on the commits I've seen.
Jeremy
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Mag
Hi,
4.1.3 is labeled beta in the bktree.
So I assume 4.1.3 will be beta when it will be released ;)
Regards,
Jocelyn
- Original Message -
From: "Andrew Pattison" <[EMAIL PROTECTED]>
To: "Jon Frisby" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, June 30, 2004 11:45 PM
S
I saw reference somewhere (I believe it was either an Apache or PHP
discussion) to 4.1.3 being beta but I'm not sure if this was just wishful
thinking on the part of those particular developers. If this is the case
then going by the dates of previous releases in the 4.1 branch (not always a
good gu
Hello,
Im working on a search function using PHP4 and MYSQL4.
Im looking for a function that allow to take a string value (consisted of
several substrings separated by coma) out of db field and return each
substring one by one.
Could you please tell me if there is a function that can do somet
Hello,
I am a bit confused by processing of user= specifications in the
mysqld_safe script. Here is what I see:
* If user= is specificed in the [mysqld] or [server] sections then it is
ignored and a flag is set that prevents the specification of a user
in any subsequent options parsing.
* Othe
matt
1) inserts using this format is much faster:
INSERT INTO table (col1, col2) VALUES (val1,val2), (val3,val4)
is much faster then single row insert. My experience is
2.5 hrs vs.. 36 hrs.
2) The PACK_KEYS=1 may be hurting you. I've never used it.
3) There may be a cache somewhere
The current approach is better. Having one row with 81 columns will be
harder to deal with in terms of writing code to display it. The size of the
table will be roughly the same either way -- either you have a few very big
rows, or many small rows, but that shouldn't be a huge issue if you index
Are you using delayed insert statements?
-Original Message-
From: Chip Bell
To: Victor Pendleton; [EMAIL PROTECTED]
Sent: 6/30/04 3:50 PM
Subject: RE: authentication error
After looking through, "show variables;" the only one I found with a
value of "100" is the "delayed_insert_limit"
C
As I understand it, the particular cycle a release is in depends on how long
it's been since a major bug was reported. So an alpha becomes a beta if
nobody reports a major bug after N days, and a beta becomes a production
release if goes N days without a major bug report. Thus, even if 4.1.3 is
r
After looking through, "show variables;" the only one I found with a
value of "100" is the "delayed_insert_limit"
Could this be the issue?
-Original Message-
From: Victor Pendleton [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 30, 2004 4:45 PM
To: Chip Bell; Victor Pendleton; '[EMAIL
No sir...
-Original Message-
From: Victor Pendleton [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 30, 2004 4:43 PM
To: Chip Bell; Victor Pendleton; '[EMAIL PROTECTED] '
Subject: RE: authentication error
I would check to see if your server is swapping at this point.
-Original Messa
alter table t add fulltext (col)
-Eric
On Wed, 30 Jun 2004 22:28:03 +0200, Schalk <[EMAIL PROTECTED]> wrote:
>
> I am using the following command on MySQL 4.0.18
>
> ALTER TABLE tablename MODIFY columnname FULLTEXT;
>
> I keep getting an error regarding FULLTEXT. Where am I going wrong?
>
> K
Do you have a high number of temp tables being created or high i/o?
-Original Message-
From: Chip Bell
To: Victor Pendleton; [EMAIL PROTECTED]
Sent: 6/30/04 3:44 PM
Subject: RE: authentication error
No sir...
-Original Message-
From: Victor Pendleton [mailto:[EMAIL PROTECTED]
Se
I would check to see if your server is swapping at this point.
-Original Message-
From: Chip Bell
To: Victor Pendleton; [EMAIL PROTECTED]
Sent: 6/30/04 3:27 PM
Subject: RE: authentication error
Hi Victor,
I have stumbled on to something. The server is bouncing back and forth
b/t fast an
ALTER TABLE table_name ADD FULLTEXT INDEX index_name (col);
-Original Message-
From: Schalk
To: [EMAIL PROTECTED]
Sent: 6/30/04 3:28 PM
Subject: FULLTEXT
I am using the following command on MySQL 4.0.18
ALTER TABLE tablename MODIFY columnname FULLTEXT;
I keep getting an error rega
I am using the following command on MySQL 4.0.18
ALTER TABLE tablename MODIFY columnname FULLTEXT;
I keep getting an error regarding FULLTEXT. Where am I going wrong?
Kind Regards
Schalk Neethling
Web Developer.Designer.Programmer.President
Volume4.Development.Multimedia.Branding
em
Hi Victor,
I have stumbled on to something. The server is bouncing back and forth
b/t fast and slow. When I do "show processlist" and its above 100, it's
slow. When it's below, it's fine.
What variable is wrong? I have Max_connections = 250?
Thanks
Chip
-Original Message-
From: Vic
I have to ask, why would you even want to pull that many records at
once? No user would want to sift through that many records. I always
add a limit clause to all my queries. There is no harm in having a
limit 500 when you are just receiving 10 records. But it's good to have
the limit there in
Try changing driver to Driver
Kind Regards
Schalk Neethling
Web Developer.Designer.Programmer.President
Volume4.Development.Multimedia.Branding
emotionalize.conceptualize.visualize.realize
Tel: +27125468436
Fax: +27125468436
email:[EMAIL PROTECTED]
web: www.volume4.co.za
This messag
Hi,
I'm trying to compile from the development source tree (bitkeeper)
version 4.1.3-beta, on a Mandrake 9.2 box. It keeps failing to compile
in ndb/src/kernel/ArrayPool.hpp. I am trying to compile it with cluster,
since that is what I need to test. I've done all the autoconf/etc steps,
and mad
If the table type is MyISAM, have you tried full text indexing?
-Original Message-
From: Schalk
To: [EMAIL PROTECTED]
Sent: 6/30/04 2:31 PM
Subject: RE: Query on large text field
Hey there everyone
I have tried a couple of things but would like to know what suggestions
people on the l
Hi,
I have just down loaded the mysql connector/j version 3.0.14-
production. I have set the classpath for the jar file and
the url that I am using for the driver is
com.mysql.jdbc.driver.
I have not been succesful.
Can any body please tell me what i might be doing wrong.
Thanks
--
MySQL
Hi list,
I'm currently in the middle of planning a server migration and am
trying to figure out how I am going to keep the databases in sync. The
problem lies in DNS. When I make the DNS change to switch our site from
one host to another, it's not automatic. For a period of a few days,
cus
So the table is,
folio int
vacante int
folio2 char(10)
and the table type is MyISAM
create index some_index on table(folio2);
and the table has about 200,000,000 rows.
MyISAM creates a file per table for table data, and for index data. You
can find the files created underneath the mysql install di
Hey there everyone
I have tried a couple of things but would like to know what suggestions
people on the list may have. What would be the best query term or string is
to use when searching a field, using a keyword(s), in the database that
contains a large amount of text, for example an article'
How can i achieve Security acpect in mysql?
How secure can we make transactions over internet for
3306 ?
Thanks
Sak
__
Do you Yahoo!?
Yahoo! Mail - 50x more storage than other providers!
http://promotions.yahoo.com/new_mail
--
MySQL General
Thx's :)
David Griffiths wrote:
These errors could mean a connection timed out, or a mysql-client didn't
properly close the connection, or possibly a network error.
I went to mysql.com and looked in the searchable docs:
http://dev.mysql.com/doc/mysql/en/Communication_errors.html
Daphne,
There are two or three parts to this application. It all depends on how you
are designing it. You put so many things in one sentence that I cannot
figure out what you have already done and what you have been asked to do.
You mentioned "web database". Does that mean that you will have thi
It really boils down to what is your favorite programming language? You
say you are using vb? If so, there isn't a lot that would need to be
changed in your current vb app (if that is what you have and not vba in
access). The key will be to get the odbc driver, and use ado (at least
that's what I
Hi,
This is a dumb newbie question, so please bear with me:) I'm trying to
connect to an existing database called 'billblac_recovery'.
I want the username to be 'billblac_bill' and the password to be 'wgb'. I'm
having no luck with the CLI
or MySQLAdministrator. I'm using MySQL 4.1, upgraded from 3.
You could also use 'show full processlist;' at the mysql prompt.
even better is an app called mytop whis looks/acts like top but is
specifically used for mysql.
Victor Pendleton wrote:
Have you checked the slow query log and the error log?
you could also che
-Original Message-
From: Moha
These errors could mean a connection timed out, or a mysql-client didn't
properly close the connection, or possibly a network error.
I went to mysql.com and looked in the searchable docs:
http://dev.mysql.com/doc/mysql/en/Communication_errors.html
If |Aborted connections|
Below are the answers
Best Regards
-Mensaje original-
De: David Griffiths [mailto:[EMAIL PROTECTED]
Enviado el: Miércoles, 30 de Junio de 2004 01:29 p.m.
Para: [EMAIL PROTECTED]
Asunto: Re: Index problem
What's the definition of the table? IE are you indexing an INT, VARCHAR,
etc?
3 f
I've a funny feeling the kernel authors re-wrote much of the SMP code for
2.6 with the aim of getting it to scale better to 8 processor systems, so I
would expect there to be a few stray bugs in it. You could always downgrade
to 2.4 if it doesn't work out ;-)
Cheers
Andrew.
- Original Messag
What is wrong with me today?!?! I explained myself incorrectly:
a) information from outbound_fax_info where the barcodes DO match.
Sorry all!!
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
Rebuilding index takes 3 1/2 days!!! Growing pains with mysql..
I've got 2 dedicated servers, each with a slave, all run 32gig 15k rpm
raid 5 on u320 perc raid cards, dell 2600/4600's with single channel
backplanes (new ones will have dual channel)
All have 2 gig of ram, but I've never seen mysql
I've not seen this on MySQL but under Informix 7.24 on Solaris 2.6 I noticed
a similar problem when doing a lot of number crunching and transaction
logging was turned on. If you are running with transaction logging switched
on then you might want to try turning it off. For some reason the database
The way I do this is within PHP is to echo the value stored in mysql_error
after each SQL statement. If you're not using PHP then this probably doesn't
help though ;-)
Cheers
Andrew.
- Original Message -
From: "Bob Lockie" <[EMAIL PROTECTED]>
To: "MySQL Mailing List" <[EMAIL PROTECTED]>
Hello,
I recently noticed this error in our mysql error log file:
Aborted connection 5439 to db: 'database_name' user: 'someuser' host:
`localhost' (Got an error reading communication packets)
-
Hello, Everyone,
I'd like to get some comments form you.
I have developed some window database applications from MS Access with VB.
My boss wanted me use mysql to develope new web database application and
rewrite my current database application using MySql.
Any one can point me the right directi
Actually, i figured it out. don't know why it was so hard to see it.
all i did was change:
LEFT JOIN outbound_fax_info b on ucase(a.barcode) = ucase(b.barcode)
to:
LEFT JOIN outbound_fax_info b on (b.barcode != '' and ucase(a.barcode =
b.barcode).
if barcode was blank in outbound (b) then the
Hello,
I am trying to see if replication (or some open source software) can
help me
I have a multiple external databases that have the exact same table
structure. They need to be merged into a central database on a nightly
basis. The only difference between the external and central database
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wednesday 30 June 2004 01:09 pm, Jeff Smelser wrote:
> On Wednesday 30 June 2004 12:46 pm, J S wrote:
> > Thanks for your reply.
> > By replication do you mean do I have tables with duplicate rows? If
> > that's the case then I do have one table wit
Have you checked the slow query log and the error log?
-Original Message-
From: Mohammad shojatalab
To: [EMAIL PROTECTED]
Sent: 6/30/04 11:58 AM
Subject: Minitoring mysqld process activities
Hi all,
I'm running a small database as backend of a relatively quiet website,
This is the versi
Eliminate the rows from outbound_fax_info where the barcode is blank. The
result of the JOIN will be all of the rows of inbound_fax_info matched up
to:
a) information form outbound_fax_info except where the barcodes match
b) blank columns where the barcodes didn't match.
Use the COALE
What's the definition of the table? IE are you indexing an INT, VARCHAR,
etc?
What's the definition of the index? Is it unique, composite, etc?
What's the storage engine in use? InnoDB? MyISAM?
Can you show the relevant parts of your my.cnf file?
What operating system are you using?
David
Oropeza
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wednesday 30 June 2004 12:46 pm, J S wrote:
> Thanks for your reply.
> By replication do you mean do I have tables with duplicate rows? If that's
> the case then I do have one table with duplicate rows.
No.. Replication, meaning, you have the same
Hi, i'm trying to create an index on a table with 199 million records.
The problem is that is taking too long (8 hours and is not yet
finnished).
does anyone have any idea?
the server is 2Xeon 2.8 gigs with 6 Gb of ram.
Best regards
Alejandro
using mysql 4.0.x
please review the following sql then see below for the problem:
DROP TABLE IF EXISTS inbound_fax_info;
CREATE TABLE inbound_fax_info (
fax_id int(10) unsigned NOT NULL auto_increment,
barcode varchar(100) default '',
document_id int(10) unsigned default NULL,
department_id int
On Wednesday 30 June 2004 12:10 pm, J S wrote:
> Hi,
>
> I would like to switch off the logging that creates the large files
below
> (in the mysql data directory)
> Could someone tell me how to do this please?
take out log-bin from my.cnf. But you better not have replication as that
is
the file
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wednesday 30 June 2004 12:10 pm, J S wrote:
> Hi,
>
> I would like to switch off the logging that creates the large files below
> (in the mysql data directory)
> Could someone tell me how to do this please?
take out log-bin from my.cnf. But you bet
Aaron,
How about something like :
SELECT CONCAT(UCASE(LEFT(FieldName, 1)),
LCASE(RIGHT(FieldName,LENGTH(FieldName)-1)))
Right out of my head, I didn't count all the parantheses :-)
Freddie
> -Ursprüngliche Nachricht-
> Von: Aaron Wolski [mailto:[EMAIL PROTECTED]
> Gesendet: Mittwoch,
Someone else hopefully has something more efficient:
UPDATE table SET field = CONCAT( UPPER( LEFT( field, 1 ) ), LOWER(
SUBSTRING( field, 2 ) ) )
Wes
On Jun 30, 2004, at 12:46 PM, Aaron Wolski wrote:
Hi Guys,
I'm trying to figure out of this is possible. I know I could do it in
PHP but I am deali
Hi,
I would like to switch off the logging that creates the large files below
(in the mysql data directory)
Could someone tell me how to do this please?
Thanks,
js.
# ls -l
total 5418648
-rw-rw 1 mysqlmysql 25088 Jun 28 14:27 ib_arch_log_00
-rw-rw 1 mysqlmysql
For the record/list archives,
The solution seems to have been upgrading to Fedora Core 2
kernel-smp-2.6.6-1.435.x86_64.rpm. What fix it contained that affected
my case... I'm not sure :)
Been running okay for 18 hours at high volume!
- Matt
> -Original Message-
> From: Matthew Kent
> Se
Hi all,
I'm running a small database as backend of a relatively quiet website,
This is the version Im running:
mysql Ver 11.15 Distrib 3.23.47, for dec-osf5.1 (alphaev6)
yesterday for the first time, mysql process response time dropped
significantly and when I monitored running processes I realiz
Hi Guys,
I'm trying to figure out of this is possible. I know I could do it in
PHP but I am dealing with a ton of records and would rather put the
processing on the DB than PHP/client side.
Question is. can I do a SELECT query on a column that changes all the
results to lower case and THEN chan
Harold,
THANK YOU!! As I was writing that bit of code I had that creepy feeling
that "knew" that I was overlooking something simple. I guess I win the
"D'OH" prize for today. 8-D. (Maybe I shouldn't write any more SQL until
*after* the coffee kicks in..hmmm...)
Nice catch!
Shawn
In ODBC applications, I have seen the application give a not responding
message when the database is taking longer than expected to return a result
set.
...
You say you see the query still executing? So the select statement is just
taking a long time to process? If this is so I would try to optimiz
Victor
Thanks for your reply.
I checked the processlist and it continues to execute even after the VB
application is hung. I know the application is hung by checking its status
in the Windows Task manager.
The 'hostname.err' file did not show any errors. Is there another file i
should be lookin
In article <[EMAIL PROTECTED]>,
[EMAIL PROTECTED] writes:
> SELECT t1.*
> FROM ytbl_development t1
> INNER JOIN tmpShortCodes sc
> ON INSTR(t1.txtDevPostCode, sc.short_code) =1
This is the same as
SELECT t1.*
FROM ytbl_development t1
INNER JOIN tmpShortCodes sc
ON t1.txtDevPostCode LIKE
Your SQL syntax is fine, I just get a better view of what is joining to
what if I format it a little differently (I also avoid a lot of line
wrapping this way too):
SELECT S.FirstName
, T.CreateDateTime
, T.TranDateTime
, P.FirstName
, P.LastName
, D.DiagnosisIDStrin
In all of your examples so far, the short postcode ends with the first
character after the space. If that is true for all short postcodes, we
could take the portion of the full postcode up to the first character after
the space, then compare that to the list. I think that's what you were
hopi
I'm running a ton of sql statements to load data.
Is there a way to not display successes:
Query OK, 1 row affected (0.02 sec)
Records: 1 Duplicates: 0 Warnings: 0
and display failures and the query statement that failed?
There are 60 000+ of these and I'd ideally like to debug the inserts
witho
While the Visual Basic application is querying the database can you log into
the MySQL via the mysql monitor and do a show processlist to see if the
query is executing? If not I would suggest you view the mysql error log or
set up Visual basic to throw and error when it is getting disconnected.
-
I have an SQL which looks something like:
SELECT S.FirstName, T.CreateDateTime, T.TranDateTime, P.FirstName,
P.LastName, D.DiagnosisIDString, T.CheckNumber, T.StmtDesc,
T.ServPayAdjIDString, T.PatientAmt, T.InsuranceAmt, T.ClaimID,
T.AuditDateTime, T.TransactionType, T.ProviderID, PR.FirstName,
Have you looked at "MySQL Cluster" as a solution? Does this meet your
definition of "federated"?
http://www.mysql.com/products/cluster/
Yours,
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
Tom,
I would keep your current fiveish-column design with the 20 inserts. It
will save you a LOT of headache in the future when you want to search for
things like particular artists or titles or to compute a sort of "most
popular top twenty" based on everyone else's rankings.
SELECT artist, titl
do a show grants for root@'localhost' and look at it privileges. If your
root account has been altered you can started the database with the skip
grant table option, log, fix the grant tables, and flush privileges.
-Original Message-
From: Scott Haneda
To: MySql
Sent: 6/30/04 4:30 AM
Subj
I think I understand the problem now... You generate a list of "postal
prefixes" (the first portion of a full postal code) whose items may or may
not be all the same length. Then you could want to do either of two things:
1) compare a given full postal code to the list to see if matches any of
the
Hi,
I am trying to compile mysql-4.0.20 on my HP-UX 10.20 hppa2.0 with
gcc-2.95.3 but it allways stop
this point:
gcc -DDEFAULT_BASEDIR=\"/usr/local/mysql\" -DDATADIR="\"/homed2/mysql\""
-DDEFAULT_CHARSET_HOME="\"/usr/local/mysql\""
-DSHAREDIR="\"/usr/local/mysql/share/mysql\"" -DHAVE_CONFIG_H -
> Would I be better keeping this format and inserting multiple rows on each
> submit, or to have one row for all 81 variables ($name, 20 x
> Position, 20 x
> Artists, 20 x Titles, 20 x Labels.)
> I know that the latter will be easier to query.
Are you sure? Why?
> Also, without maintenance, the
Hello Tom,
Wednesday, June 30, 2004, 1:26:52 PM, you wrote:
TC> My question is this:
TC> Would I be better keeping this format and inserting multiple rows on each
TC> submit, or to have one row for all 81 variables ($name, 20 x Position, 20 x
TC> Artists, 20 x Titles, 20 x Labels.)
TC> I know tha
Please can someone let me know their opinion on the following.
I am new to MySQL and can't seem to find the right info anywhere.
I have written some code for submitting a top 20 music chart online.
I use the following to insert into mysql:
INSERT INTO chart (name, chartpos, artist, title, label)
Victor,
Thanks for all your help with the authentication issue. I still have it, but at least
I know what to look for.
My server is running RH9 with 3 gigs ram, PIII. I have about 150 users at any given
time and they're all coming via IMAP or HTTPD. They all authenticate against MySQL
but
Hi all,
I am writing a multi-threaded client that requires shared access to a single MySQL
connection. The environment is Redhat 7.3 with the patched mysql-3.23.58-2.71.i386.rpm
installed and compiled with -l libmysqlclient_r.
The connection is made from the main thread and a MYSQL_RES* myres d
Thanks so much to everyone for all your help... Jim
on 6/29/04 11:31 PM, Paul DuBois wrote:
> At 22:14 -0300 6/29/04, Jim Carwardine wrote:
>> I'm new to the list and new to mySQL. I'm a Mac user and would like to set
>> up a DB on my Mac. When I look at the MySQL web site, I can't seem to find
What is the procedure for altering tables in MASTER in a master, slave
replication configuration. For example I made some test and I see that if I
made a change in a table on master I got an error like "Shutdown in
progress" on SLAVES. I also tested to make "slave stop" and make the
change.. At
Ok, I am stumped, mysql 4.0.18-standard, which was upgraded from 3.x, I ran
the fix_privs_something_or_other as well, has been working just fine for
ages.
Tonight I decided it would be a good idea to test one of the mysqldump's and
actually try to load it in. Well, I cant.
I send in mysql -uuse
Michael
Ignoring my attempt at a query, I'll restate the problem
T1.devtxtpostcode contains full UK Postcodes eg OX14 5RA, OX14 5BH, Se1 1AH, etc
I want to check if a particular postcode is within a list of postcode areas, these
postcode areas
are naturally shorter ie ox14 5,ox14 6 etc. So I ne
Marc Liyanage has taken much of the effort out of php and mysql
installation for the mac.
http://www.entropy.ch/software/welcome.html
On 30 Jun 2004, at 04:41, Kieran Kelleher wrote:
Mac OS X is well supported by MySQL. MySQL is even preinstalled in Mac
OS X Server, although we choose to ign
Hi!
Ok, but is it possible to have the same table on booth servers and split the
data by rows? Like you can with ms-sql and the federated servers technique?
Can you be more specific and maybe guide me to some documentation?
Thanks!
andy thomas writes:
On Tue, 29 Jun 2004 [EMAIL PROTECTED
94 matches
Mail list logo
