I am trying to to use a DSNless connection from an ASP script( on IIS5) to a
MySQL db on Linux.
I am trying this:
strConnection=_
"driver={MySQL};server=192.168.33.124;uid=me;pwd=mypassword;database=MySQL;o
ption=NUM"
Set adoDataConn = Server.CreateObject("ADODB.C
hi all,
load data infile doesn't work with escaped by '\\' line
terminated by '\r'
the problem is the '\r' . doesn't work with '\r\n' either.
if i replace the \r with \n in the the text file itself then it works
fine the files i'm trying to load are tab delimited txt files generated
by xc
In the last episode (Jul 03), Thomas J. Harris said:
> This query does not work, giving me the following error:
> Unknown column 'resource1_.COMPETENCE_LEVEL' in 'having clause'
>
> BUT, if I change the query so that the having clause is the following:
>
> having (x2_0_>? )
>
> It runs fine!
To any MySQL users,
I am using an open-source object relational mapping layer from Java
called Hibernate to interface with a MySQL database on my machine. I am
running version 4.0.13 of the server, and SQL/J Connector version 3.0.7.
The query that is generated from Hibernate looks like this:
sel
Hi All,
Can anyone please explain to me the usage of foreign keys?
As I understand it, foreign keys are used to relate one table to another.
But, mysql (new version can?) cannot ensure that what's inputted is an
actual key in that other table.
What's the need for foreign keys then? If My
No, no you are welcome. ;-)
Note that the mysql_install_db script does NOT delete or oeverwrite an
existing mysql privilege database (folder /var/lib/mysql/mysql).
What I am saying is that you have to explicitly delete the folders contents
(if you wish to do so ).
You should also be able to us
Hello, mysql,
I would also like to know the impact when:-
- the master db fail
- a lot of insert/update transactions in the master, would it replicate
immediately to the 2nd database
- when the secondary db fail, the master cannot send the data to the 2nd,
would the data queue up ?
- Any chance fo
Hi Mario,
Try this please:
1) stop the mysql server
2) delete the contents in the folder /var/lib/mysql/mysql
3) run mysql_install_db
4) start the server
5) log in to check that everything is reset
6) set your password
Best regards
Nils Valentin
Tokyo/Japan
2003年 7月 4日 金曜日 09:21、Mario さんは
(B
(BMario wrote:
(B
(B>"Victoria Reznichenko" <[EMAIL PROTECTED]> wrote:
(B>
(B>
(B>>"Mario" <[EMAIL PROTECTED]> wrote:
(B>>
(B>>
(B>>>I'm a newbie in experimental mode and have just deleted /ALL/ databases
(B>>>
(B>>>
(B>on a
(B>
(B>
(B>>>MySQL server, i.e. includin
"Victoria Reznichenko" <[EMAIL PROTECTED]> wrote:
(B>
(B> "Mario" <[EMAIL PROTECTED]> wrote:
(B> >
(B> > I'm a newbie in experimental mode and have just deleted /ALL/ databases
(Bon a
(B> > MySQL server, i.e. including the one ("mysql") that contains all the
(B> > administrative stuff like u
Hi Stefan,
I haven't ad experience with such a big table yet, but I would like to make a
guess.
Depending how you use the data (often read, often write, mixed etc.) I would
suggest setting up 2 tables.
If you use innodb you can distribute the two tables over several disks which
should at lea
I am trying to set up mysql 4.0.13 on my RedHat 9 machine. I rebuilt
the source rpm. (I had a previous installation which I deleted first).
I can log on to the mysql monitor as root but can't creat databases,
can't change passwords, can't grant privileges, can't select hosts,
can't seem to do
>Description:
when trying to compile proftpd with mysql using ./configure
--with-modules=mod_sql:mod_sql_mysql
--with-libraries=/usr/local/lib:/usr/local/mysql/lib
--with-includes=/usr/local/mysql/include --with-zlib
I get this error:
make[1]: Leaving directory `/root/proft
On June 28, 2003 05:33 am, Aodhan Cullen wrote:
> 6/27/03 6:37:49 PM, Jeremy Zawodny <[EMAIL PROTECTED]> wrote:
> >> My read/update ratio would be something along the lines of 1:3, 3
> >> updates for every read. So it is highly unusual, and more or less
> >> rules replication out of the picture.
>
Chris,
thank you for the bug report. I was able to repeat the bug.
It is indeed a bug if MySQL does not roll back the whole SQL statement if
the statement provokes a foreign key constraint error. And it should not be
written to the binlog.
The fix is to change in /sql/sql_delete.cc the line 148
Mysql uses a btree+
-->-Original Message-
-->From: awarsd [mailto:[EMAIL PROTECTED]
-->Sent: Thursday, July 03, 2003 1:50 PM
-->To: [EMAIL PROTECTED]
-->Subject: Binary tree
-->
-->Hi,
-->
-->I think MySQL uses binary tree, but my question is that what happens
when
-->we
-->delete record.
Hi,
I think MySQL uses binary tree, but my question is that what happens when we
delete record. Does the binary regenerate itself??
thanx
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi,
I have a setup that consists of two MySql Database
Server.
Server A(WEB DB) is in web hosting location , runs
behind a websever.
Server B(LAN DB) is in my LAN.
My requirment is synchronize both(WEB DB and LAN DB)
databases over the internet.
I am thinking of the following approaches.
1) D
Hi there,
Does anybody know how to drop table option? I added a table option "alter table
abc order by col1 desc". Now I want to remove this option, How can I do?
Thanks
Hello All,
A few days ago there was a thread about how to perform backups on large
scale enterprise systems of mysql databases. This is an issue that I
have a problem with and came up with a possible cheap solution.
Problem:
Currently I have about 40 Mysql Servers with about 25 of these serve
Alex,
> ---TRANSACTION 0 125987852, ACTIVE 1217449 sec, OS thread id 1712
you have transactions which have been active 1.2 million seconds, that is,
15 days!
You should commit those transactions.
You can also use SHOW PROCESSLIST to show those open sessions.
Regards,
Heikki
- Original Me
I am deciding how to setup my MySQL database but i'm having some doubts.
I just want to know which is faster, when I query:
One table with a double primary key and one search field (3 search conditions)
of
Two tables with each a single primary and one search field in each table (3
search conditi
Hello Heikki,
> why you do not look with SHOW INNODB STATUS if there are dangling
> transactions which could still see the delete-marked rows? Purge cannot
> remove them then.
This is what I see:
mysql> show table status like 'sccchangelog';
+--++++---
I have encountered an interesting problem using mysql. On both 3.23 and another
4.01 server when I try to batch load a file with sql statements (ex. mysql -u
user -p < mysql_statements.SQL) and the file is greater that 500MB it never
seems to finish. I have never had the patiences to see if it ever
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Wed, 2 Jul 2003, Paul DuBois wrote:
> At 11:33 -0400 7/2/03, Andrew Pierce wrote:
> >I am getting ready to try to upgrade MySQL on my RedHat 9 box. I want to
> >go from the version that came with the distro (version 3.23.54) to the
> >latest
> so mysql can take full advantage of the dual cpu w/out a recompile?
Your choice of OS will probably affect this as well.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
Did I help you? Want to show your thanks?
www.amazon.com/o/registry/EGDXEBBWTYUU
- Original Message -
F
If your internet connections aren't very fast and stable, or perhaps
dialup or similar you can do a poor-mans replication. I do this and
after lots of starts and stops on my scripts that get the data to the
slave server it's finally working very good. When you turn on bin-log in
my.cnf it just star
I need to know how to be able to read in data from to mysql from two different places.
For example from /usr/local/mysql and /usr/local/data
Please help me if you have any answer. Thanks for your response.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubs
Hello,
I have nine process that import data to tables with the same structure
within about 1000 databases on a server. Each process fires at the same
time, every 5 minutes.
Lately I'm seeing these inserts hang, all waiting upon the same table, and
they do not clear up. I've searched through th
"Mario" <[EMAIL PROTECTED]> wrote:
>
> I'm a newbie in experimental mode and have just deleted /ALL/ databases on a
> MySQL server, i.e. including the one ("mysql") that contains all the
> administrative stuff like users, privileges, etc. Is there some way to
> recreate some default version of tha
"Rob Mann" <[EMAIL PROTECTED]> wrote:
> What format should a file be in to properly import it into MYSQL, such as do
> you need tab-delimited items with carriage returns between records? Should
> each item in each record be within quotation marks? I can export the file
> from the current program it
Andrey Mishenin <[EMAIL PROTECTED]> wrote:
> I've got a problem using temporary tables. Tring to make one (mysql> CREATE
> TEMPORARY TABLE ... ) I recieve an error message:
> ERROR 1044: Access denied for user: '[EMAIL PROTECTED]' to database 'hardware'
> At the me
I am a newbie and need to fiugre out how to read in database info from two seperate
file systems. if anyone can please help I would appreciate it. Thankdvance for any
response.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql
Hi,
As I understand it any statement that fails with a foreign key error should not
be written to the binlog and subsequently should not execute on the slave.
Referring to the InnoDB manual, section 4.5:
"If a statement fails, for example, because of a foreign key violation, then
the statement
Try putting the following before the mysqld call but before your ulimit calls -
export LDR_CNTRL='MAXDATA=0x8000'
Also try setting ulimit -m unlimited and ulimit -s unlimited.
Hopefully this helps.
Scott Pippin
[EMAIL PROTECTED]
- Original Message -
From: "Bernd Jagla" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, July 03, 2003 1:14 PM
Subject: Re: sort-records
> Yup, I guess I set parameters too high...
>
> Thanks
>
> Bernd
>
> - Original Message -
> From: <[EMAIL PROTECTED]>
> To: <[EMAIL
Hi list,
what are the plans on the Spatial part of MySQL introduced in 4.1 beta?
Will there be anything done before the 5.0 release? And when
(approximately) is the 5.0 release?
Thanks,
Bart
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://
On Thu, Jul 03, 2003 at 09:19:07AM -0700, Priya Manivannan wrote:
> Can MySQL database be replicated over the internet ?
>
> If so, Please give me a pointer on that
Yes.
Type "replication" into the search box in the on-line manual.
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Y
Hi there,
I wanted to sort the records in one of my tables (205,000,000 entries) to test if this
will give me any speed increase.
It is an MyISAM table, and was trying to use myisamchk -R 2 user.
But what I get in return is a core dump and that the index file is not working
anymore...
I am usin
Can MySQL database be replicated over the internet ?
If so, Please give me a pointer on that
Thanks and regards
Manivannan
__
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
--
MySQL General Mailing List
For list archives: http:/
Mark,
You're correct, when I change the output file to /tmp/filename it works
but now I've got a file in /tmp with permissions
-rw-rw-rw- mysql mysql
So I'm still stuck.
What I'm trying to do is under user "MIS" run a report that dumps to a
.csv file, then emails that .csv file to me and then
Hi,
Somehow I managed to make all users (root also) unable to access and use
'mysql' database, and so I cannot fix it. Could you tell me how to fix it?
No matter what user I use to get access finally I get: "ERROR 1044: Access
denied for user: '@localhost' to database 'mysql'.
The only database I
You should have stopped mysql before running the update.
The update might have removed the socket file, leaving the server with
no way to communicate.
you may try connecting through the network interface.
mysqladmin -h 127.0.0.1 shutdown
If that does not work, kill the running mysqld processes alo
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Jeff McKeon wrote:
> Ok, I've got FILE priv set on my user now, it had to use
>
> GRANT FILE ON *.*
>
> As it appears the FILE prive isn't a db level priv?
>
> Still getting the same results though, can't write the file...
>
> ERROR 1 at line 1: Can't
You do not have access to either that file or that directory. Try to adjust
permissions then rerun.
-Original Message-
From: Jeff McKeon [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 03, 2003 9:50 AM
To: Mysql List
Subject: RE: CSV Formated output
Ok, I've got FILE priv set on my user n
Hello,
I am interested in utilizing full text search in a way that I have not
seen in my run across the various examples and docs.
What I'd like to do is create full text indexes on individual columns in
order to attain relevancy of the individual search criterion per column.
I'd then like to agg
Ok, I've got FILE priv set on my user now, it had to use
GRANT FILE ON *.*
As it appears the FILE prive isn't a db level priv?
Still getting the same results though, can't write the file...
ERROR 1 at line 1: Can't create/write to file '/home/MIS/shiplist.csv'
(Errcode: 13)
Jeff McKeon
IT Mana
You could create your own script that runs myisamchk then after completing
starts the MySQL service and place this in the windows startup folder.
-Original Message-
From: Luis Lozano [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 03, 2003 9:32 AM
To: MySQL List
Subject: Include Check and R
It's probably a matter of granting CREATE TEMPORARY TABLE privilege for the
"hardware" user.
HTH,
Lian
> -Original Message-
> From: Andrey Mishenin [mailto:[EMAIL PROTECTED]
> Sent: Thursday, July 03, 2003 8:26 PM
> To: [EMAIL PROTECTED]
> Subject: Problem using TEMPORARY TABLE
>
>
>
> I'
How can i check and repair DBs, before service in WIN32 started?
I try to include group [myisamchk] in my.ini files, but nothing happen. How can i
include it?
Thanks
Luis
Yes, I used the proper name for "username" on the GRANT command..
It was actually
mysql> GRANT FILE ON database.* TO [EMAIL PROTECTED] IDENTIFIED BY
'password';
Query OK, 0 rows affected (0.00 sec)
Mysql>
Jeff McKeon
IT Manager
Telaurus Communications LLC
[EMAIL PROTECTED]
(973) 889-8990 ex 2
I've got a problem using temporary tables. Tring to make one (mysql> CREATE TEMPORARY
TABLE ... ) I recieve an error message:
ERROR 1044: Access denied for user: '[EMAIL PROTECTED]' to database 'hardware'
At the mean time all other sql requests work correctly. How
Ok, so SELECT INTO OUTFILE and TERMINATED BY will work except for one
thing
They require GRANT FILE access for the user to work and I can't seem to
add that priv to my user...
---snip---
mysql> GRANT FILE ON database.* TO [EMAIL PROTECTED] IDENTIFIED BY
'password';
Query OK, 0 rows affected (
Jeff,
By "manual", I mean http://www.mysql.com/documentation/index.html
It's worth downloading the "all in one HTML file" version so you can search
through the whole document for things like "SELECT INTO OUTFILE" or "FIELDS
SEPARATED BY"
All the best,
Andy
> -Original Message-
> From:
[snip]
I don't have a manual, using the open source MySQL. I do have a book
(New Riders "MySQL") but was looking for "deliminated" not "terminated."
Found it now. Thanks again for the help.
[/snip]
You can always use the online manual.
HTH
--
MySQL General Mailing List
For list archives: http:
I've found the rpm.
fab a écrit :
Hi and thanx :)
I've found dbf2mysql and it should solve my prob.
However, my linux server is a production server (web + mail) and none
programmation environnement is installed on it (no gcc and so on) and i
don't want to.
So, could anyone send me the binary f
Hi!
(B
(BI'm a newbie in experimental mode and have just deleted /ALL/ databases on a
(BMySQL server, i.e. including the one ("mysql") that contains all the
(Badministrative stuff like users, privileges, etc. Is there some way to
(Brecreate some default version of that database short of reinst
Thanks Andy, that will do!
I don't have a manual, using the open source MySQL. I do have a book
(New Riders "MySQL") but was looking for "deliminated" not "terminated."
Found it now. Thanks again for the help.
Jeff McKeon
IT Manager
Telaurus Communications LLC
[EMAIL PROTECTED]
(973) 889-8990 e
Don't forget ouput with spaces/tabs/quotes etc...
The more adventurous solution
use perl
use DBI
use DBD:CSV(or Text::CSV_XS)
use DBD:mysql
then just take the output of the select and insert into the CSV
Matthew
On Thu, 3 Jul 2003, Jeff McKeon wrote:
> Is there a way to output the
can any one help
is there a way where i can import a csv file into multiple tables in MySQL
database this has to be a run when ever there is a file in a wating
directory
thanks in advance
==
Disclaimer Notice
This message
hi jeff:
what i do - have been doing for year is dump the data you want using the
dump proceedure in mysql - then use a simple shell script to convert it to
csv - i.e.
cat mysql.dump.file |
while read line
do
field1=`echo "$line" | cut -f1`
field2=`echo "$line" | cut -f2`
field???=`echo "$
Jeff,
Use SELECT INTO OUTFILE and FIELDS TERMINATED BY ','
See the manual for more info.
Andy
> -Original Message-
> From: Jeff McKeon [mailto:[EMAIL PROTECTED]
> Sent: 03 July 2003 12:38
> To: [EMAIL PROTECTED]
> Subject: CSV Formated output
>
>
> Is there a way to output the results
What format should a file be in to properly import it into MYSQL, such as do
you need tab-delimited items with carriage returns between records? Should
each item in each record be within quotation marks? I can export the file
from the current program it is in to any format need to then import it in
Is there a way to output the results of a select query into a CSV or
Comma Deliminated format?
Thanks,
Jeff McKeon
IT Manager
Telaurus Communications LLC
[EMAIL PROTECTED]
(973) 889-8990 ex 209
***The information contained in this communication is confidential. It
is intended only for the sole
"Duffy, Richard" <[EMAIL PROTECTED]> wrote:
>
> Do you have any idea when version 5.0 will be available?
You can install 5.0 from development source tree:
http://www.mysql.com/doc/en/Installing_source_tree.html
--
For technical support contracts, goto https://order.mysql.com/?ref=ensi
"Bill Easton" <[EMAIL PROTECTED]> wrote:
> Under MySQL 3.23, FLUSH LOGS was replicated. Under 4.0.13, this appears to
> no longer be the case.
>
> Was this intentional? Could it be put back the way it was?
>
> We do backups by, at a time of low usage, (1) FLUSH LOGS on the master, (2)
> Dump th
Fabrizio Tivano <[EMAIL PROTECTED]> wrote:
>
> on MySQL 3.23.54
> i have a table that list the number of user-time days like: 35
>
> whellbased on curdate() function
>
> can i able to make a select wich display the sum (150-35)
> where 150 is date_format(curdate(), '%j')
> in a format l
I've got a problem using temporary tables. Tring to make one (mysql> CREATE TEMPORARY
TABLE ... ) I recieve an error message:
ERROR 1044: Access denied for user: '[EMAIL PROTECTED]' to database 'hardware'
At the mean time all other sql requests work correctly. How
Try this:
select delivery, count(*) as ticketcount
from ticketsales
where delivery="post" or delivery="pickup"
group by delivery
Andy
> -Original Message-
> From: Ville Mattila [mailto:[EMAIL PROTECTED]
> Sent: 03 July 2003 11:28
> To: [EMAIL PROTECTED]
> Subject: Counting question
>
>
I've just installed various updates to SuSE 8.2 via SuSE's web site. One of
these was an update to MySQL to fix a security bug. Now MySQL doesn't work!
During boot-up, I get the message that MySQL failed. In the log it says:
starting service mysql
failed
[..]S13mysql start
Hi there,
We are currently having a large festival here in Ikaalinen, Finland
(www.satahamesoi.fi) and we have our booking system based on MySQL.
I should find out how many tickets are sold in each concert with different
delivery methods. How could I make a count like this:
SELECT COUNT(delivery=
Hi and thanx :)
I've found dbf2mysql and it should solve my prob.
However, my linux server is a production server (web + mail) and none
programmation environnement is installed on it (no gcc and so on) and i
don't want to.
So, could anyone send me the binary for dbf2mysql ?
I use Red-Hat 7.3 on
MySQL 5.0 Downloads: http://www.mysql.com/downloads/mysql-5.0.html
-Original Message-
From: Duffy, Richard [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 03, 2003 10:16 AM
To: '[EMAIL PROTECTED]'
Subject: MySQL 5.0
Do you have any idea when version 5.0 will be available?
regards,
Richa
Do you have any idea when version 5.0 will be available?
regards,
Richard Duffy
Dresdner Kleinwort Wasserstein
Group Risk Management IT
DDI: +44 (0)20 7475 7652
[EMAIL PROTECTED]
--
If you have received this e-mail in error o
Hello Kevin,
Thursday, July 03, 2003, 12:28:38 AM, you wrote:
For example you can do this: /with Perl/
Make connection to first database , then fill data from table source in array, then
make
connection to another database and fill data from array to another
table.
K> Hello,
K> I have two mys
75 matches
Mail list logo
