Quick License Question...

[Nicholas Stuart]

Quick question about the license issue that I thought of while reading
through the Interbase Vs. MySQL threads.
If I develop a program that uses MySQL for my company and it is only used
for internal use, never repacked and sold/distributed outside the company
what type of license aggrement is that under?
This project would have code that would obviously be 'sensitive'
information for the company so Open Source would be out the question, but
as this would never be re-distributed am I right in thinking we do not
need to buy a license aggrement from MySQL? I was reading throuhg the
manual in the license section and noticed they said it would be 'nice'
that if MySQL was helping your enterprise then you should at least buy
some support from them. However, I am comfortable enough with MySQL and
its use is VERY light weight that it would be pretty silly to buy support
from them. Not saying anything against the MySQL team, but they did make
the product fairly easy to work with :)

Thanks for any info on these questions!
-Nick



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Opposite selection...

[Nicholas Stuart]

Ok I'm stumped on what I think should be a somewhat simple query. What I
have so far is a list of names that is in a list of projects AND in a the
main contact list by doing the following query:
SELECT p.name, p.company FROM contacts c, projects p WHERE
CONCAT(c.firstName, " ", c.lastName) = p.name AND c.company = p.company

This is good and works correctly, what I need now is the opposite of this.
The names that are in the project list but NOT in the contact list. If I
had some subqueries this would be a simple NOT IN :) but as I dont (mysql
3.23.55) I'm not sure how to attack this.

Thanks for any pointers/advice.
-Nick



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: mysql dump for remote db

[Nicholas Stuart]

The biggest problem is if you want to do this from a remote pc, that pc
will need access to the server itself and the mysql client tools. It
sounds as if this pc is not on your LAN and I doubt the hosting service
will be willing to expose there database to the internet so you can do a
backup. If you do have access to the db from your computer you should be
able to schedule something as simple as:
mysqldum -u  -p -h   > 
to do your backup. Other then that I'm not sure how you could do this
since you already stated your service wont schedule cron jobs.

-Nick

Mark Stringham said:
> Does anyone have a suggestion as to how I could run a periodic mysql
> dump for a db that is hosted remotely - IE a web host. I do know that
> this host does not support crons.
>
> Any help is appreciated.
>
> thanks
>
> MS
>
> sql, query
>
>
>




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: MySQL Question

[Nicholas Stuart]

The optimization is understandable but I'm not sure how much it would
affect it if you did the select outside the insert statment vs inside.
Either way you are selecting the same thing but I dont know which way is
better.
Well just playing around with it for a bit I think I found something.
The value from memory is a variable of some sort right? I dont know what
language you are using so I'm not sure what it will hold.
Anyways you could do something like the following:
INSERT INTO table1(col1, col2) SELECT table2.col1a, "variablehere" FROM
table2 WHERE [blah];

This will work becuase if you do a SELECT 5 you get 5 back. So if you do
it with SELECT variable(aka some literial) you will get the
variable(literial) back and you will have two cols to match your
table1(col1, col2).
HTH
-Nick

> Sorry...yes...both columns have a NOT NULL constraint which makes
> inserting a blank a problem. My only other option is to do the SELECT
> first, then push the result into the INSERT with the other memory only
> variable. I'm doing this for a system that will undergo high volumes,
> and want to do what I can to optimize the number of individual selects.
>
> I'm probably going to have to do the alternate technique regardless. =\
>
> On Tuesday, September 10, 2002, at 05:23  PM, Nicholas Stuart wrote:
>
>>> From my experince this is not possible.
>> Is there any reason why you can not simply do two inserts following
>> each
>> other?
>> INSERT INTO table1(column1) SELECT column1a FROM table2 WHERE
>> [something]
>> INSERT INTO table1(column2) VALUES(valueFromMemory)
>> (as if you didnt know that already)  =D
>> There should be no reason why you couldnt do this as there is nothing
>> that
>> ties the two columns together (that I can see here).
>> Maybe explain a bit more and we might be able to give you more info.
>>
>> -Nick
>>
>>> I have to do an insert and need to nest a select inside. I have tons
>>> of
>>> documentation on a very simple version of this, however my
>>> requirements
>>> are one step beyond that. Here is what I'd like to do in MySQL:
>>>
>>> insert into
>>>
>>> table1
>>>
>>> (column1, column2)
>>>
>>> values
>>> (select column1a from table2 where [something],
>>> valueFromMemory)
>>>
>>> If you'll notice, I want one column from a select and one column
>>> outside the select. Is this possible in MySQL? All the documentation
>>> I've read about MySQL says it can't be done.
>>>
>>> Thank you in advance!
>>>
>>> Mark
>>>
>>>
>>> -
>>> Before posting, please check:
>>>http://www.mysql.com/manual.php   (the manual)
>>>http://lists.mysql.com/   (the list archive)
>>>
>>> To request this thread, e-mail <[EMAIL PROTECTED]>
>>> To unsubscribe, e-mail
>> <[EMAIL PROTECTED]>
>>> Trouble unsubscribing? Try:
>> http://lists.mysql.com/php/unsubscribe.php
>>>
>>
>>
>>
>



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: MySQL Question

[Nicholas Stuart]

>From my experince this is not possible.
Is there any reason why you can not simply do two inserts following each
other?
INSERT INTO table1(column1) SELECT column1a FROM table2 WHERE [something]
INSERT INTO table1(column2) VALUES(valueFromMemory)
(as if you didnt know that already)  =D
There should be no reason why you couldnt do this as there is nothing that
ties the two columns together (that I can see here).
Maybe explain a bit more and we might be able to give you more info.

-Nick

> I have to do an insert and need to nest a select inside. I have tons of
> documentation on a very simple version of this, however my requirements
> are one step beyond that. Here is what I'd like to do in MySQL:
>
> insert into
>
> table1
>
> (column1, column2)
>
> values
> (select column1a from table2 where [something],
> valueFromMemory)
>
> If you'll notice, I want one column from a select and one column
> outside the select. Is this possible in MySQL? All the documentation
> I've read about MySQL says it can't be done.
>
> Thank you in advance!
>
> Mark
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: show tables

[Nicholas Stuart]

DB independent? As in an entire list of tables in your MySQL server? Or as
in independent from MySQL to say MS SQL Server? If the later then I'm sure
each db as some form of query to get a list of tables, just look it up. I
don't think there would be a unified way simple because each db is
completly different (unless they all use the same "SHOW TABLES" command
which I don't know if they do or not.)
As far as the first way goes you could only do it, as far as I know, in
some form of program.
-Nick

p.s. this really isn't related to MySQL becuase you are asking about other
db's but I thought I would be nice and answer it any how  :)

> hi all,
> how do i retrieve a list of all tablenames in the database? i know i can

> do it with a "show tables" query in MySQL, but i'd like to try to make
> this db-independent..
> thanx!
> jasper
>
>
>
> -
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html";
before
> posting. To request this thread, e-mail [EMAIL PROTECTED]
>
> To unsubscribe, send a message to the address shown in the
> List-Unsubscribe header of this message. If you cannot see it,
> e-mail [EMAIL PROTECTED] instead.
>




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Select question

[Nicholas Stuart]

You would have to do something like:
SELECT * FROM users WHERE CONCAT(firstname, " ", lastname) = "John Smith"
That should get you what you want.
If your taking your DB from MS SQL to MySQL only a few queries will port
directly over. You have to be careful that you follow the MySQL syntax and
functions as they are slightly different.
-Nick

>
> Hi,
>
> I have a table called users with the columns firstname and lastname. I
would
> like to do a search on the fullname and have tried:
>
> select * from users where (firstname + ' ' + lastname) = "John Smith"
>
> which returns all rows for some reason and not only the rows with users
> named John Smith (which SQL Server does). Any ideas?
>
> Kind regards, Elin
>
>
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Upgrading

[Nicholas Stuart]

Hello Richard,
I just went through something similar with upgrading from 3.23.49 to 4.03.
The reason you can't connect to MySQL is
>020908 15:53:33  mysqld ended
This should obviously not be here.
Check the error logs to see if they say anything important and/or helpful
there. Most likely found under
/usr/local/mysql-3.23.49a-pc-linux-gnu-i686/data in your case.
Also, have you re-linked the usr/local/mysql link with the new folder?
And check to make sure that the data folder is owned by MySQL and that its
group is also MySQL with the correct permissions.
I also found that once I installed the new MySQL, and got it working, I
had to go back and recompile Apache with all the packages you need (of
course making sure to add MySQL support) for it to work correctly. I don't
know if this is necessary but it's how I resolved the problem.
Hope this helps.

-Nick

> Update: Now, after rebooting the server, the site can't connect...that's
> more like it ;)
>
> -Original Message-
> From: Richard W. Berriman [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, September 08, 2002 4:43 PM
> To: [EMAIL PROTECTED]
> Subject: Upgrading
>
>
>
> Hi!
>
> I have a number of tables in development in 3.22.32
>
> (running in apache_1.3.12 on a linux kernel)
>
> I'd really like to upgrade to 3.23.49a but my installs in both rpm and
> binary have not succeeded in "taking over" from my previous install.
>
> I've read quite a bit at the mysql.com site, but haven't found the
> appropriate documentation ... my last attempt was
>
> by downloading
>
> MySQL-3.23.49-1.src.rpm,
>
> 0. Turn off current Web Server (/etc/rc.d/init.d/httpd stop)
>
> 1. cp MySQL-3.23.49-1.src.rpm into /usr/local
> 2. rpm --recompile MySQL-3.23.49-1.src.rpm
> 3. mysql-3.23.49a-pc-linux-gnu-i686]# ./bin/safe_mysqld &   // To start
> MySQL & use it
>
> This returns:
>
> Starting mysqld daemon with databases from /usr/local/m
> ysql-3.23.49a-pc-linux-gnu-i686/data
> 020908 15:53:33  mysqld ended
>
> And the Mysql database driven website works...
>
> Yet, when I want to go into line commands (to alter tables for easy
> searching) using:
>
> mysql-3.23.49a-pc-linux-gnu-i686]# ./bin/mysql
>
> I get
>
> ERROR 2002: Can't connect to local MySQL server through socket
> '/tmp/mysql.sock'
>  (111)
>
> There is no file by that name there...
>
> Well thankyou for any help :-)
>
> Richard
>
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Bitten by a strange bug...

[Nicholas Stuart]

I had this problem to but was never able to find what was causing it. The
way I got around it was by doing execute statements like:
connection.execute("INSERT INTO .")
That way I avoided VB handling the updates and it worked. But since Josh
pointed this little problems "solution" out I might give that a try.

-Nick


> Tom -
>
> I'll address what I can
>
> I had the same problem with fields being truncated on direct connections
(the
> problem does not manifest on ODBC table attaches in Access).
>
> IIRC, the way to "solve" this problem is to make sure the "optimize
columns
> widths" (option 1) in the ODBC properties.
>
> Hope that helps (at least a little).
>
> j- k-
>
> On Wednesday 28 August 2002 15:37, Tom Emerson wrote:
>> But enough of the background, here is the problem:
>>
>> developing a visual-basic (6) application using myodbc connected to a
> mysql
>> database on the network.  Adding records works well "the first time",
> but
>> after the database has closed (i.e., "the next time I run the
> program"), I
>> run into problems.  I've tracked it down to what VB "believes" is the
>> maximum field size for a given field, and it appears to be limited to
>> whatever the "longest" value is in the particular field -- when a
> table is
>> "new" (empty), there are no entries, so VB "thinks" the fields are
> "-1" in
>> length (technically, "unlimited"), and the program works fine.  The
> next
>> time the program runs, the fields "definedlength" property is set to
>> whatever the "longest" value happens to be in the table (hence the
> "ugly"
>> workaround is to insert a "bogus" entry with spaces or some filler
>> character padded out to the maximum length -- this is fine for
> "master"
>> [key] tables, but for detail entries it might become problematic.)
>>
>> I've even tried the "pad char fields to maximum" option via the ODBC
> driver
>> window in the control panel, but that doesn't seem to have any effect.
>
> --
> Joshua Kugler, Information Services Director
> Associated Students of the University of Alaska Fairbanks
> [EMAIL PROTECTED], 907-474-7601
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: MS Access and mySQL

[Nicholas Stuart]

Aye Arthur this is a different experince then what I had with Access and
MySQL. I guess my main reason for not using is because I personally dont
really need to. Nothing against you or anyone using it but to me it always
seemed to be a bit cumbersum, just my feelings.

I wish I had some e-mails I've seen about the downside of using Access for
a front end (I know I've seen some, but can't find em). I know this topic
has been discussed before. But if it works for you great!

And for your previous e-mail about the queries you are right that a lot of
them will work if you leave them in access, but if you plan on taking them
out then a lot of them may need some fine tunning for MySQL. Again,
whatever works for you.

My interpratation from Jon's original e-mail was that he had VB Forms and
the like in access (using vba) and was planning on moving those out of it
perhaps I was wrong. But if I read it right then my original feelings
still stand that you should not go through access to get to mysql from a
program. That would be kinda silly if you asked me, but thats besides the
point.

Glad you came along and pointed out another side Arthur. I guess it all
comes down to what you find works for you as there are A LOT of options
out there with no real "correct" way.

-Nick

p.s. Why is this needed:
>adding a column of type TimeStamp to every table in
>the database. This is necessary so that you can read auto-increment
>values.

Just curious  :)



> That has not been my experience, in fact my experience has been
completely
> the opposite. As my first test case I ported the Northwind sample
database
> to MySQL. I had to make a few changes here and there, most notably to
some
> queries, but also including (and I forgot to mention this in my previous
> reply on this subject) adding a column of type TimeStamp to every table
in
> the database. This is necessary so that you can read auto-increment
values.
>
> Next, I took my current app, with about 94 tables, and ported it. The
> production app is in MS SQL 2000, but I wanted to port it because I
wanted a
> proof-of-concept to show management. The absence of sprocs was a big
problem
> (come on, 4.1 :-) but I worked around it. No one but me and a few
testers is
> using this version. The production app remains in MS SQL.
>
> Finally, I took my killer-database, whose tables number 400+.
Fortunately,
> with dbScripter in hand I didn't have to create say 1000 indexes by
hand! It
> ported well and my Access front end talks blissfully to it. The MySQL
part
> resides on a P233 running Mandrake, set up for InnoDB. This may simply
be
> high praise for MyODBC, but my Access app has no difficulty at all
talking
> to the database.
>
> Arthur
>
> - Original Message -
> From: <[EMAIL PROTECTED]>
> To: "Arthur Fuller" <[EMAIL PROTECTED]>
> Sent: Wednesday, August 28, 2002 1:57 PM
> Subject: [Fwd: RE: MS Access and mySQL]
>
>
>> wodya think?
>>
>>
>>  Original Message 
>> From: "Nicholas Stuart" <[EMAIL PROTECTED]>
>> Subject: RE: MS Access and mySQL
>> To: <[EMAIL PROTECTED]>
>> CC: <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>
>>
>> I would strongly urg you not to use Access as the front end. The
> biggest
>> problem is that the Jet Engine/Access backend is pretty much completly
>> different then MySQL and you will run into problems with table
> structure
>> and the like. Also, using access as the front end has been extremly
> slow
>> when ever I tried it.
>> You will however need to download the MyODBC driver if you wish to
> access
>> MySQL through VB.
>>
>> -Nick
>>
>> >
>> > -BEGIN PGP SIGNED MESSAGE-
>> > Hash: SHA1
>> >
>> > Jonathan,
>> >
>> > If you are going to be completely converting the Access db to MySQL,
>> > and just using Access as the frontend, you will need to download
>> > MyODBC:
>> >
>> > http://www.mysql.com/downloads/api-myodbc.html
>> >
>> > You can download either the stable or development release. There is
>> > also a FAQ that will answer your questions there about how to setup
>> > almost exactly what you are referring to.
>> >
>> > http://www.mysql.com/products/myodbc/faq_toc.html
>> >
>> > This FAQ is for the development release (3.51.03) but can also be
>> > used for the stable release (2.50.xx). I recently had to do the same
>> > thing with a Paradox database for a client, and have had relatively
>> > few issues following the documentation. After downloading and
>> > installing MyODBC you will be able 

RE: MS Access and mySQL

[Nicholas Stuart]

True you could, but then that way you will loose portability if Jon (for
whatever reason) decides to move to another type of DB. Never used
libmySQL so I dont know how the speed is, but assume its as fast if not
faster then ODBC.
ODBC has the plus of being user friendly and of being an M$ Universal
Standard.
-Nick

Roger Davis wrote:

Or you could just use the libmySQL.dll and handle everything yourself
through VB.


You will however need to download the MyODBC driver if you wish to access
MySQL through VB.

-Nick









-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: MS Access and mySQL

[Nicholas Stuart]

I would strongly urg you not to use Access as the front end. The biggest
problem is that the Jet Engine/Access backend is pretty much completly
different then MySQL and you will run into problems with table structure
and the like. Also, using access as the front end has been extremly slow
when ever I tried it.
You will however need to download the MyODBC driver if you wish to access
MySQL through VB.

-Nick

>
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> Jonathan,
>
> If you are going to be completely converting the Access db to MySQL,
> and just using Access as the frontend, you will need to download
> MyODBC:
>
> http://www.mysql.com/downloads/api-myodbc.html
>
> You can download either the stable or development release. There is
> also a FAQ that will answer your questions there about how to setup
> almost exactly what you are referring to.
>
> http://www.mysql.com/products/myodbc/faq_toc.html
>
> This FAQ is for the development release (3.51.03) but can also be
> used for the stable release (2.50.xx). I recently had to do the same
> thing with a Paradox database for a client, and have had relatively
> few issues following the documentation. After downloading and
> installing MyODBC you will be able to export the database directly to
> your Linux MySQL, however you will lose your table structures for the
> most part and will have to do some ALTER TABLE statements to put your
> keys back and the majority of your fields set to their proper type.
>
> HTH,
> Bryant Hester
> Juxtapose, inc.
>
> - -Original Message-
> From: Jonathan Coleman [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, August 28, 2002 12:40 AM
> To: [EMAIL PROTECTED]
> Subject: MS Access and mySQL
>
>
> Hi.
>
> I have a situation where a church I am doing some volunteer work for
> has a MS Access (office 97) database running on NT.  They are
> (woohoo) upgrading to a QUBE (linux box) for a server which has mySQL
> installed (and I can upgrade it etc..)
>
> My job therefore is to
>
> a) port MS Access data and queries to mySQL database
>
> b) use the MS Access forms to access the data and queries through
> ODBC.
>
> Is there anyone who can point me in the right direction, either to
> where the searchable discussion archives are, OR even better, someone
> who has gone through this before?
>
> Cheers
> Jon
>
> http://digital.yahoo.com.au - Yahoo! Digital How To
> - - Get the best out of your PC!
>
> - -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try:
> http://lists.mysql.com/php/unsubscribe.php
>
> -BEGIN PGP SIGNATURE-
> Version: PGPfreeware 7.0.3 for non-commercial use 
>
> iQA/AwUBPWzH6UlWu7/HFp4nEQJOGwCgr5af7wIi1AcbpP1rih/vABg/zb8An13w
> 4Tm8I6eugdNnVhLYZ+CcTYq2
> =Z0ov
> -END PGP SIGNATURE-
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: MS Access and mySQL

[Nicholas Stuart]

That and Access also uses sub-selects and some other mutlitable features
that MySQL does not yet implement. Aslo, most of the internal functions
are different as well such as: To get only the top row of a query in
Access you use SELECT TOP 1 blah blah, but in MySQL you use SELECT blah
blah LIMIT 1
All it means is you may have rewrite your queries. For the most part there
are no queries in Access that you can't do in MySQL. It will just take
some time to convert the queries is all.

-Nick

Mary Stickney wrote:

the join syntax is what is differnt between Access and MYSQL.

in MS-SQL =  indexs will be used on tables mentioned in the JOIN clause
and they will not in MYSQL

-Original Message-
From: Nicholas Stuart [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 28, 2002 9:40 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: MS Access and mySQL


I have been there done that with old access data, but no forms. Your
plans should be focused around what you know and what your systems are
tied to. Since its an NT box you could go with pretty much any language
ie java/vb/c++. VB would be the obvious choice for ease of transfering
the Access VBA forms to straight VB. The only thing you have to be
careful is the access querys. A lot of them will not work on MySQL and
the funny thing is a lot of them will not work on M$'s on SQL server :)
go figure.
As far as the data goes the easist thing I found to transfer it into
mysql is a program called dbtools. You can find it at:
http://www.dbtools.com.br/EN/ It's fairly easy to use and has a great
import wizard.
If you have an specific questions let me know and I'll try my best to
answer them.
-Nick

MySQL Newsgroup (@Basebeans.com) wrote:

Subject: MS Access and mySQL
From: =?iso-8859-1?q?Jonathan=20Coleman?= <[EMAIL PROTECTED]>
===
Hi.

I have a situation where a church I am doing some volunteer work for
has a MS Access (office 97) database running on NT.  They are (woohoo)
upgrading to a QUBE (linux box) for a server which has mySQL installed
(and I can upgrade it etc..)

My job therefore is to

a) port MS Access data and queries to mySQL database

b) use the MS Access forms to access the data and queries through ODBC.

Is there anyone who can point me in the right direction, either to
where the searchable discussion archives are, OR even better, someone
who has gone through this before?

Cheers
Jon

http://digital.yahoo.com.au - Yahoo! Digital How To
- Get the best out of your PC!

-
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail

<[EMAIL PROTECTED]>

Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail

<[EMAIL PROTECTED]>

Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php






-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php







-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: MS Access and mySQL

[Nicholas Stuart]

I have been there done that with old access data, but no forms. Your
plans should be focused around what you know and what your systems are
tied to. Since its an NT box you could go with pretty much any language
ie java/vb/c++. VB would be the obvious choice for ease of transfering
the Access VBA forms to straight VB. The only thing you have to be
careful is the access querys. A lot of them will not work on MySQL and
the funny thing is a lot of them will not work on M$'s on SQL server :)
go figure.
As far as the data goes the easist thing I found to transfer it into
mysql is a program called dbtools. You can find it at:
http://www.dbtools.com.br/EN/ It's fairly easy to use and has a great
import wizard.
If you have an specific questions let me know and I'll try my best to
answer them.
-Nick

MySQL Newsgroup (@Basebeans.com) wrote:

>Subject: MS Access and mySQL
>From: =?iso-8859-1?q?Jonathan=20Coleman?= <[EMAIL PROTECTED]>
> ===
>Hi.
>
>I have a situation where a church I am doing some volunteer work for
>has a MS Access (office 97) database running on NT.  They are (woohoo)
>upgrading to a QUBE (linux box) for a server which has mySQL installed
>(and I can upgrade it etc..)
>
>My job therefore is to
>
>a) port MS Access data and queries to mySQL database
>
>b) use the MS Access forms to access the data and queries through ODBC.
>
>Is there anyone who can point me in the right direction, either to
>where the searchable discussion archives are, OR even better, someone
>who has gone through this before?
>
>Cheers
>Jon
>
>http://digital.yahoo.com.au - Yahoo! Digital How To
>- Get the best out of your PC!
>
>-
>Before posting, please check:
>   http://www.mysql.com/manual.php   (the manual)
>   http://lists.mysql.com/   (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail
<[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
>-
>Before posting, please check:
>   http://www.mysql.com/manual.php   (the manual)
>   http://lists.mysql.com/   (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail
<[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
>



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: mysql 4.0.2 problems

[Nicholas Stuart]

Heh...ya I knew I fogot to do something. You would think that would be an
install step.
Next task is recompilling the apache httpd as it doesnt like not having
the libmysqlcleint.so.10 file which is now libmysqlcleint.so.11

thx for the tip.  =D

-Nick

louie miranda said:
> Add the mysql lib path on /etc/ld.so.conf
> and type ldconfig.
>
> :)
>
>
> =
> Thanks,
> Louie Miranda...
>
> WebUrl: http://axis0.endofinternet.org
> Email: [EMAIL PROTECTED] - [EMAIL PROTECTED]
>
> - Original Message -
> From: "Nick Stuart" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Tuesday, August 20, 2002 12:23 PM
> Subject: mysql 4.0.2 problems
>
>
>> Ok I got mysql 4.0.2 installed on Mandrake and its up and running. My
>> problem is that when I go to connect to it I get the error:
>> error while loading shared libraries: libmysqlclient.so.11: cannot
>> open shared object file: No such file or directory
>>
>> Actually (just fixed it). All I had to do was and a soft link the the
>> /lib directory. Anyone know if this is normal or not?
>>
>> -Nick
>>
>>
>> -
>> Before posting, please check:
>>http://www.mysql.com/manual.php   (the manual)
>>http://lists.mysql.com/   (the list archive)
>>
>> To request this thread, e-mail <[EMAIL PROTECTED]> To
>> unsubscribe, e-mail
> <[EMAIL PROTECTED]>
>> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: COLDFUSION AND MYSQL

[Nicholas Stuart]

First thing I would do is update your mysql. That version is very old and
probably does not support a lot of stuff you are looking for. After that I
would go and download the newest JDBC drivers from:
http://www.mysql.com/downloads/api-jdbc.html
-Nick

marco said:
> Hello everybody
> I'm just getting mad with coldfusion, installed on a redhat platform
> running mysql 2.1.0
>
> Well, the problem occures when I try to create a data source, because I
> always get this ERROR MESSAGE:
>
> []java.sql.SQLException: SQLException occurred in JDBCPool while
> attempting to connect, please check your username, password, URL, and
> other
> connectivity info.
> The root cause was that: java.sql.SQLException: SQLException occurred in
> JDBCPool while attempting to connect, please check your username,
> password, URL, and other connectivity info.
>
> So I was wondering if it's a problem of drivers. for example I may
> not have JDBC drivers installed on that redhat server???Is it
> possible???If so, can I install them??
>
> thanx
> marco
>
>
>
> -
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html";
> before posting. To request this thread, e-mail
> [EMAIL PROTECTED]
>
> To unsubscribe, send a message to the address shown in the
> List-Unsubscribe header of this message. If you cannot see it,
> e-mail [EMAIL PROTECTED] instead.




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Importing into MySQL from Access

[Nicholas Stuart]

Check out http://www.dbtools.com.br/EN/ I use it to import from access to
mysql. By the sounds of it though you have some dirty data which may or
may not need to be cleaned before going through there program. The only
real problem I had was that working with old dirty data is a pain since a
lot of the columns have spaces in there names (which mysql doesnt like)
and the access isn't as strict as MySQL with what can be put into certain
fields.

-Nick

Ian Zabel said:
> I already have my table structure in place in MySQL, and I just want to
> import the data from my Access 2000 database. (the .mdb is about 50
> megs)
>
> The MySQL server is on a Linux system.
>
> I've been using DBTools to do the import, because it allows me to import
> just the data, and not create the tables. (I don't want it to create the
> tables, because it's creates them inccorectly. I used another tool to
> create the schema, and and fixed all the problems with it.)
>
> My problem is that when the import is done, all my varchar (text in
> access) and text (memo in access) field data leaves behind escape
> switches. All quotes look like this \' or \" and all linefeeds look like
> this \r\n. I also have other weird characters in the data.
>
> If I export the data using MySQL-Front, I get stuff like this: \\\" \\\'
> \\r\\n
>
>
> Also, some of my data has special characters like the ellipses characer,
> ., and when I view access the data through my code, it comes out like
> this ?.
>
> What is the best way to import data to a MySQL server on Linux and
> preserve the correct escaping?
>
> Ian.
>
>
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]> To
> unsubscribe, e-mail
> <[EMAIL PROTECTED]> Trouble
> unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Backup automation..

[Nicholas Stuart]

Aye, I forgot to mention to lock the db before backing up...my bad. But
again the idea is the same just schedule win2k to do it.

-Nick

Ed Carp said:
>> >> On windows you could simply copy the entire data directory with a
>> Scheduled job. Copying the files should be all you need to do for
>> windows.
>> >> For a cleaner, and what most people would say is a better way you
>> could schedule a batch file to run mysqldump that would dump the
>> data and structure to a file.
>> >> mysqldump info can be found at:
>> >> http://www.mysql.com/doc/m/y/mysqldump.html
>> >
>> >I hope you're shutting down MySQL before you do this.  If yuo're not,
>> your
>> "backups" are probably worthless.
>
> sql, query
>
>> Shouldn't it be enough to lock the tables and FLUSH before doing the
>> copy? I want to keep read access while doing the backup, and let
>> writes queue (i.e. writers will find the database a bit soggy during
>> backups, but read work OK and INSERT DELAYED will just be delayed - I
>> hope.
>
> If you can guarantee that writes will not be propagated to the disk, you
> may be all right.  You might want to test to make sure you can ready
> your backups, though - just in case.
>
> We use mysqldump here for backups - it's fast, gives us ASCII SQL files
> to look at if something happens, and compresses well.  I'd highly
> recommend using it as opposed to copying the actual disk files around.
> --
> Ed Carp, N7EKG  http://www.pobox.com/~erc
> 214/986-5870 Director, Software Development
> Escapade Server-Side Scripting Engine Development Team
> Pensacola - Dallas - London - Dresden
> http://www.squishedmosquito.com




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Backup automation..

[Nicholas Stuart]

On windows you could simply copy the entire data directory with a
Scheduled job. Copying the files should be all you need to do for windows.
For a cleaner, and what most people would say is a better way you could
schedule a batch file to run mysqldump that would dump the data and
structure to a file.
mysqldump info can be found at:
http://www.mysql.com/doc/m/y/mysqldump.html

-Nick

Nixarlidis Aris said:
> Hi,
> I am looking for a way to automate the way i take backups.
> I run mysql on w2k server and I seek for a way to take backups of the
> database at certain times automaticaly.
> Is out there any suggestion?
> thanks..
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]> To
> unsubscribe, e-mail
> <[EMAIL PROTECTED]> Trouble
> unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: rounding?!

[Nicholas Stuart]

Thanks, that was simple enough...guess I just couldnt think of that.

Thanks again!
-Nick

Gordon said:
> Try round(value*4,0)/4
> Worked on the samples I tried
>
>> -Original Message-
>> From: Nicholas Stuart [mailto:[EMAIL PROTECTED]]
>> Sent: Tuesday, July 23, 2002 1:47 PM
>> To: [EMAIL PROTECTED]
>> Subject: rounding?!
>>
>> Ok here's the problem. Trying to write a select statement to be able
> to
>> round a set of numbers to the nearest quarter of an inch. Here is what
> I
>> have so far:
>>
> *---
> --
>> *
>> SELECT
>> CONCAT(ROUND(inside_length + (wall_thickness * 2), 0),'\'-',
>> mod(((inside_length + (wall_thickness * 2)) * 12), 12),'\" x ',
>> ROUND(inside_width + (wall_thickness * 2), 0),'\'-',
> mod(((inside_width +
>> (wall_thickness * 2)) * 12), 12),'\"' ) AS footprint,
>> CONCAT(ROUND(inlet_invert - inlet_sump - base_slab_thck, 2), '\'') as
>> outside_Bottom_Elevation,
>> CONCAT(inlet_invert, '\'') as inlet_invert,
>> CONCAT(outlet_invert, '\'') AS outlet_invert,
>> CONCAT(TopofTank, '\'') AS TopOfTank,
>> CONCAT(Rim, '\'') as Rim,
>> CONCAT(ROUND(((inlet_Sump + base_slab_thck) - (((inlet_ko_dia -
> inlet_dia)
>> / 2) / 12)) * 12, 1), '\"') AS inlet_ko_outside,
>> CONCAT(ROUND(((outlet_Sump + base_slab_thck) - (((outlet_ko_dia -
>> outlet_dia) / 2) / 12)) * 12, 1), '\"') AS outlet_ko_outside,
>> CONCAT(ROUND((inlet_Sump + base_slab_thck) * 12, 1), '\"') as
>> inlet_invert_outside,
>> CONCAT(ROUND((outlet_Sump + base_slab_thck) * 12, 1), '\"') as
>> outlet_invert_outside,
>> CONCAT(ROUND(inlet_Sump * 12, 1), '\" ') AS inlet_Sump,
>> CONCAT(ROUND(outlet_Sump * 12, 1), '\"') AS outlet_Sump,
>> CONCAT(ROUND(inlet_Sump * 12 + (inlet_dia / 2), 1), '\"') AS
>> inlet_cl_floor,
>> CONCAT(ROUND(outlet_Sump * 12 + (outlet_dia / 2), 1), '\"') AS
>> outlet_cl_floor,
>> CONCAT(inlet_dia, '\"') AS inlet_dia,
>> CONCAT(outlet_dia, '\"') AS outlet_dia,
>> CONCAT(inlet_ko_dia, '\"') AS inlet_ko_dim,
>> CONCAT(outlet_ko_dia, '\"') AS outlet_ko_dim,
>> CONCAT(ROUND((inlet_ko_dia - inlet_dia) / 2, 1), '\"') AS
>> inlet_invert_ko_invert,
>> CONCAT(ROUND((outlet_ko_dia - outlet_dia) / 2, 1), '\"') AS
>> outlet_invert_ko_invert,
>> CONCAT(inlet_offset, '\"') AS inlet_offset,
>> CONCAT(outlet_offset, '\"') AS outlet_offset
>> FROM tbl_prj_dims
>>
> *---
> --
>> *
>>
>> This will get all of the values I need in decimal inches but I would
> like
>> to be able to round them up or down to the nearest quarter of an inch,
> so
>> the only decimal values will be .0 or .25 or .5 or .75
>> I'm not really sure if there is efficent way to do it and would like
> all
>> of your inputs.
>> And dont mind the first few values in feet. Those need to be like
> that.
>>
>> Thanks a lot!
>> -Nick Stuart
>>
>> Filter Fodder: MySQL QUERY
>>
>>
>>
>> -
>> Before posting, please check:
>>http://www.mysql.com/manual.php   (the manual)
>>http://lists.mysql.com/   (the list archive)
>>
>> To request this thread, e-mail <[EMAIL PROTECTED]> To
>> unsubscribe, e-mail > [EMAIL PROTECTED]>
>> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]> To
> unsubscribe, e-mail
> <[EMAIL PROTECTED]> Trouble
> unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

rounding?!

[Nicholas Stuart]

Ok here's the problem. Trying to write a select statement to be able to
round a set of numbers to the nearest quarter of an inch. Here is what I
have so far:
*-*
SELECT
CONCAT(ROUND(inside_length + (wall_thickness * 2), 0),'\'-',
mod(((inside_length + (wall_thickness * 2)) * 12), 12),'\" x ',
ROUND(inside_width + (wall_thickness * 2), 0),'\'-',  mod(((inside_width +
(wall_thickness * 2)) * 12), 12),'\"' ) AS footprint,
CONCAT(ROUND(inlet_invert - inlet_sump - base_slab_thck, 2), '\'') as
outside_Bottom_Elevation,
CONCAT(inlet_invert, '\'') as inlet_invert,
CONCAT(outlet_invert, '\'') AS outlet_invert,
CONCAT(TopofTank, '\'') AS TopOfTank,
CONCAT(Rim, '\'') as Rim,
CONCAT(ROUND(((inlet_Sump + base_slab_thck) - (((inlet_ko_dia - inlet_dia)
/ 2) / 12)) * 12, 1), '\"') AS inlet_ko_outside,
CONCAT(ROUND(((outlet_Sump + base_slab_thck) - (((outlet_ko_dia -
outlet_dia) / 2) / 12)) * 12, 1), '\"') AS outlet_ko_outside,
CONCAT(ROUND((inlet_Sump + base_slab_thck) * 12, 1), '\"') as
inlet_invert_outside,
CONCAT(ROUND((outlet_Sump + base_slab_thck) * 12, 1), '\"') as
outlet_invert_outside,
CONCAT(ROUND(inlet_Sump * 12, 1), '\" ') AS inlet_Sump,
CONCAT(ROUND(outlet_Sump * 12, 1), '\"') AS outlet_Sump,
CONCAT(ROUND(inlet_Sump * 12 + (inlet_dia / 2), 1), '\"') AS inlet_cl_floor,
CONCAT(ROUND(outlet_Sump * 12 + (outlet_dia / 2), 1), '\"') AS
outlet_cl_floor,
CONCAT(inlet_dia, '\"') AS inlet_dia,
CONCAT(outlet_dia, '\"') AS outlet_dia,
CONCAT(inlet_ko_dia, '\"') AS inlet_ko_dim,
CONCAT(outlet_ko_dia, '\"') AS outlet_ko_dim,
CONCAT(ROUND((inlet_ko_dia - inlet_dia) / 2, 1), '\"') AS
inlet_invert_ko_invert,
CONCAT(ROUND((outlet_ko_dia - outlet_dia) / 2, 1), '\"') AS
outlet_invert_ko_invert,
CONCAT(inlet_offset, '\"') AS inlet_offset,
CONCAT(outlet_offset, '\"') AS outlet_offset
FROM tbl_prj_dims
*-*

This will get all of the values I need in decimal inches but I would like
to be able to round them up or down to the nearest quarter of an inch, so
the only decimal values will be .0 or .25 or .5 or .75
I'm not really sure if there is efficent way to do it and would like all
of your inputs.
And dont mind the first few values in feet. Those need to be like that.

Thanks a lot!
-Nick Stuart

Filter Fodder: MySQL QUERY



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

'Nother Repl. Error

[Nicholas Stuart]

Had a wierd problem with my first slave.
Slave 1 has MySQL 4.02 on win 2000
Slave 2 has MySQL 3.23.49(?) or some where arond there on win nt 4
Master has MySQL 3.23.51 on Linux RH 7.2

Slave 2 and master appear to be running with out problems. How ever after
making several table drops to the master I got an error on slave 1.
It had an error while trying to do the first table drop with an error code
of 6 and saying it had a problem with tbl_prj_features.MYI or something
similar (dont have error log in front of me now). Not sure whats going on
has Slave 2 dropped the tables fine with no problems.
Will try to see if the tables in question have an errors on them tommorrow
but dont see why the would as I dumped both slaves at the same time.

Thanks for the help again!
-Nick



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Adding more slaves...

[Nicholas Stuart]

Hello all. I have been trying to add a second slave to my server but have
come up to a hopefully easy problem. The first slave is up and running
fine, but after copying down the master info to the second slave when I go
to start it it is trying to read the original logs which were/are being
used from the first slave. So basically its just starting at wrong spots
in logs.

Is there a safe way to flush the logs out/delete them so that the first
slave does not loose its place? I tried the mysqladmin flush-logs but that
didnt appear to do anything.

Thanks for the help!
-Nick



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

testing mysql

[Nicholas Stuart]

Hello and good morning all! I'm running into a problem when trying to test
mysql on Red Hat Linux. I have the server up and running just fine with no
problems, but when I go to run ./mysql-test-run it spits back the
following.


 TEST USER   SYSTEM  ELAPSEDRESULT

alias      [ fail ]

/home/nstuart/mysql-3.23.49/bin/mysqltest: Failed in mysql_real_connect():
Can't connect to local MySQL server through socket
'/home/nstuart/mysql-3.23.49/mysql-test/var/tmp/mysql-master.sock' (2)
Command exited with non-zero status 1 real 0.01 user 0.01 sys 0.01
Aborting. To continue, re-run with '--force'.

Ending Tests
Shutting-down MySQL daemon

/home/nstuart/mysql-3.23.49/bin/mysqladmin: connect to server at
'localhost' failed
error: 'Can't connect to local MySQL server through socket
'/home/nstuart/mysql-3.23.49/mysql-test/var/tmp/mysql-master.sock' (2)'
Check that mysqld is running and that the socket:
'/home/nstuart/mysql-3.23.49/mysql-test/var/tmp/mysql-master.sock' exists!
Master shutdown finished

I would like to simply run the test on the server that is running but
apparently it doesn't want to do that. I thought I changed the correct
settings in the mysql-test-run but apparently not. Also tried the
mysql-test-run --local but that do anything different.
Also, I dont want to run the slave test either but again the --skip-rpl
seems to do nothing.
Thanks for all the help!
-Nick



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: API++ Question

[Nicholas Stuart]

There has been some work done on this by the folks at
http://www.icarz.com/mysql/They have a dll that can be used to replace ADO for mysql. 
Haven't
personally used it, but they say its faster.-Nick

Efren Pedroza said:
> Maybe I'm goin to ask something stupid, but I've to do it, MySQL++ API
> can be used from VB 6.0 ?
>
> What I'm looking for is to access MySQL DB from an application maded in
> Visual Basic 6.0 SP5 without using MyODBC, is there some way to do it ?
>
> I'll appreciate any directions that you can give me or some article
> that I've to read.
>
> Thanks in advance.
>
>
>
>
> -
> Before posting, please check:
>   http://www.mysql.com/manual.php   (the manual)
>   http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]> To
> unsubscribe, e-mail
> <[EMAIL PROTECTED]> Trouble
> unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

still having rep. problems

[Nicholas Stuart]

Never got any replies from the list with suggestions from my last post so
I thought I would give another cry for help.To recap:
Master Server - Win NT 4.0 mysql 3.23.49-nt-log dual pII 600
Slave Server - Win 2k mysql 4.0.1-alpha-max-nt p4 2.0

Procedure: Followed the manual to set up the slave master cnf files. Shut
down the both servers. Copied the original data from master to server.
Started master then slave.
Problem: mysql.err log on slave gives the following error every 60 secs on
trying to synch.020618 13:59:20  Slave: Failed reading log event, reconnecting to 
retry,
log 'FIRST' position 28020618 13:59:20  Slave: connected to master 
'repl@taz:3306',replication
resumed in log 'FIRST' at position 28020618 13:59:20  Slave: received 0 length packet 
from server, apparent
master shutdown:  (2)
Showing the process list on the master shows no process from the slave.
Showing the ps list on the slave gives the state of:Waiting to reconnect after a 
failed read

I have gone through all the steps I could think of that might solve the
problem but to no avail. =\Any help, suggestions would be greatly appreciated as I 
would really like
to get replication working.
Thanks for the help!
-Nick



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php