Hi,
You can try to use the command select into outfile.
thanks,
ehrwin
At 03:29 PM 3/22/2006, Mohammed Abdul Azeem wrote:
Hi,
Can we any use bcp to perform bulk copy for MYSQL as in SYBASE ? If not,
is there any other tool which can do the same operation. I need to
perform a "bcp out" from
Try "SELECT INTO OUTFILE..."
Here's the MySQL documentation on that: http://dev.mysql.com/doc/
refman/5.0/en/select.html
Good luck!
On Mar 22, 2006, at 1:29 AM, Mohammed Abdul Azeem wrote:
Hi,
Can we any use bcp to perform bulk copy for MYSQL as in SYBASE ? If
not,
is there any other
Hi,
Can we any use bcp to perform bulk copy for MYSQL as in SYBASE ? If not,
is there any other tool which can do the same operation. I need to
perform a "bcp out" from Mysql and then "bcp in" to Sybase. Please help
me out regarding the same.
Thanks in advance,
Abdul.
___
Thanks for coming to the rescue, Mark and Bruce.
Mark Leith wrote:
This is actually for Linux/Unix, not Windows.
What error do you get from MySQL when trying to log in? Does the
mysqld(-nt) process show within Task Manager? What does the new error
log say?
You may need to reset permissions:
Good evening -
I'd like to chime in saying that I've been using 5.1.7 with a lot of
success. I'm sure there's a bit to go with it's development, but half
the stuff that the MySQL dev team is working on, we will never use.
Your case may vary.
I can't speak for the MySQL guys, but as far as m
On 3/21/06, Addison, Mark <[EMAIL PROTECTED]> wrote:
>
> > -Original Message-
> > From: Gregory Machin [mailto:[EMAIL PROTECTED]
> > Sent: 21 March 2006 11:28
> > To: mysql@lists.mysql.com
> > Subject: mysql query and version problem Help!
> >
> > Hi.
> >
> > I have just found out that
Hello,
Not at this time, currently 5.1 is in Beta.
We should see a release candidate soon, but I can't commit to a specific
date at this time.
Thanks,
Jimmy Guerrero, Senior Product Manager
MySQL Inc, www.mysql.com
Houston, TX USA
> -Original Message-
> From: Mohammed Abdul Aze
Hello Jimmy,
Do we have a production release of MYSQL cluster 5.1 ? If yes please let
me know the path from where i can download the same.
Thanks in advance,
Abdul.
On Tue, 2006-03-21 at 07:16 -0600, Jimmy Guerrero wrote:
> Hello,
>
> MySQL 5.0 Cluster is an in-memory database. Meaning that the
Hello,
we had to reboot our server and now we can't get MySQL started, in the error log
it states:
==
060321 19:34:13 mysqld started
060321 19:34:13 [Warning] Asked for 196608 thread stack, but got 126976
InnoDB: Error: log file ./ib_logfile0 is of
Thanks Bill.
--- Bill Adams <[EMAIL PROTECTED]> wrote:
> UPDATE table SET field_a=field_b;
>
> b.
>
>
> Ravi Malghan wrote:
>
> >Hi: is there a way to copy all field values from
> one
> >field to another from the mysql prompt?
> >
> >Thanks
> >Ravi
> >
> >_
Robert,
Your restatement of your original question uses "FULL JOIN" as if it means
the same things as "INNER JOIN": that's simply not correct. A full join
contains the results of an inner join PLUS the "orphan rows" from the
right-hand table in the join PLUS the "orphan rows" from the left-han
UPDATE table SET field_a=field_b;
b.
Ravi Malghan wrote:
Hi: is there a way to copy all field values from one
field to another from the mysql prompt?
Thanks
Ravi
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
Hi: is there a way to copy all field values from one
field to another from the mysql prompt?
Thanks
Ravi
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
--
MySQL General Mailing List
For li
Hi all,
So, I understand the nested set idea described here:
http://dev.mysql.com/tech-resources/articles/hierarchical-data.html
http://www.sitepoint.com/article/hierarchical-data-database/2
However, from what I remember of trees and searching and stuff, a node
having more than one parent breaks
InnoDB always needs the shared tablespace because it puts its
internal data dictionary and undo logs there. The .ibd files are
not sufficient for InnoDB to operate.
well, thats what I found before. But it doesn't explain why InnoDB
does need a logfile even when all transactions are committ
Not a db setting - the DROP statement itself.
http://dev.mysql.com/doc/refman/5.0/en/drop-table.html
HTH,
James Harvard
At 1:56 pm -0700 21/3/06, ChadDavis wrote:
>I'm runnning a script that creates a few tables. I have line that drops the
>tables before the creation of the tables just in case t
I'm runnning a script that creates a few tables. I have line that drops the
tables before the creation of the tables just in case they already exist (
such as on a re-creation of the tables ).
mysql is giving me the following error on the drop table when I run the
script the first time -- i.e. w
>From the 5.0.x manual
How to create user accounts:
The next examples create three accounts and give them access
to specific databases. Each of them has a username of custom
and password of obscure.
To create the accounts with GRANT, use the following
statements:
shell> mysql --user=root
Hello,
This is spelled out pretty clearly in the manual:
InnoDB always needs the shared tablespace because it puts its
internal data dictionary and undo logs there. The .ibd files are not
sufficient for InnoDB to operate.
well, thats what I found before. But it doesn't explain why InnoDB
Hello Chad,
>Does mysql have sequences?
No, it does not.
>If not what is the functional equivalent?
auto-increment would be the closest.
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
My thoughts:
http
Newbie question.
Does mysql have sequences? If not what is the functional equivalent?
Hello Barbara,
> When does constraint checking occur?
>
> I can create a table that has a constraint on a column that doesn't exist.
I would expect an error on the table creation, but the table gets created
successfully.
>
> I'm running on windows 5.0.18 client/server.
>
> mysql> show create tabl
Robert DiFalco wrote:
For me the argument is a little pedantic. The contract of the descriptor
table is that it must reference a name; there is code and constraints to
enforce this. I am happy to have the query return nulls to indicate a
programming error that can be quickly addressed. _If_ (aft
On Tue, 21 Mar 2006, Áquila Chaves wrote:
> [ERROR]
> /usr/local/mysql/bin/mysqld: Can't create/write to file
> '/var/run/mysqld/mysqld.pid' (Errcode: 13) 060321 12:12:22
> [ERROR] Can't start server: can't create PID file:
> Permission denied 060321 12:12:22 mysqld ended
Check the directory
For me the argument is a little pedantic. The contract of the descriptor
table is that it must reference a name; there is code and constraints to
enforce this. I am happy to have the query return nulls to indicate a
programming error that can be quickly addressed. _If_ (after buffer
tuning et al) a
On Mar 21, 2006, at 1:08 PM, Marten Lehmann wrote:
I had a lot of trouble today because the InnoDB integration in
MySQL is lousy. I read the manual and worked with
innodb_per_file_table. So when I shutdown mysql I should be able to
delete ib_logfile0, ib_logfile1 and ibdata1, because all ta
When does constraint checking occur?
I can create a table that has a constraint on a column that doesn't exist. I
would expect an error on the table creation, but the table gets created
successfully.
I'm running on windows 5.0.18 client/server.
mysql> show create table product;
+-+---
Take a look at these links Charles.
http://dev.mysql.com/doc/refman/4.1/en/privilege-system.html
http://dev.mysql.com/doc/refman/4.1/en/user-account-management.html
You don't need to fully understand the mysql privilege
access system to set up users, but it would help in the long
term.
Regard
Marten Lehmann wrote:
I had a lot of trouble today because the InnoDB integration in MySQL
is lousy. I read the manual and worked with innodb_per_file_table. So
when I shutdown mysql I should be able to delete ib_logfile0,
ib_logfile1 and ibdata1, because all table-data should be stored in
th
*Someone could help me? I think that the problem is related with some
configuration PATH or some configuration of permissions. But, I just
think... Below, I put the delaited description of the problem:**
*
- I downloaded the binary file "Standard 5.0.19" of "Linux (non RPM
package)"
- Later, I ex
Charles,
2 thing I woul do:
1) Grant permissions to the user that is trying to access mysql on that db.
2) I was having problems accessing mysql using php, although I was
able to access
mysql from the command line. The fix was using the old_password() function
on mysql.
Hi,
I had a lot of trouble today because the InnoDB integration in MySQL is
lousy. I read the manual and worked with innodb_per_file_table. So when
I shutdown mysql I should be able to delete ib_logfile0, ib_logfile1 and
ibdata1, because all table-data should be stored in the .idb and .frm
fi
I know this must be a simple issue and maybe I am asking it in the
wrong place, so if the latter is the case, please direct me to the
correct place.
I am getting my feet wet with MySQL. I have installed running on
WhiteBox linux and have created a datebase with one table and put some
date in it.
My question wasn't about how to compress tables. It was about how to
regenerate indexes from a myisampacked table.
On Tue, 2006-03-21 at 16:40 +0530, Dilipkumar wrote:
> Hi,
>
> First Use this to compress :
>
> /usr/local/mysql/bin/myisampack (table name) troubleticket.*
>
> then use this
Robert,
> Of course one should use the right JOIN for the job. But let me ask you,
> which join would you use here?
>
> You have a table called Descriptors, it has a field called nameID which
> is a unique key that relates to a Names table made up of a unique
> identity and a VARCHAR name. I thin
Martjin,
Of course one should use the right JOIN for the job. But let me ask you,
which join would you use here?
You have a table called Descriptors, it has a field called nameID which
is a unique key that relates to a Names table made up of a unique
identity and a VARCHAR name. I think most peop
> -Original Message-
> From: Gregory Machin [mailto:[EMAIL PROTECTED]
> Sent: 21 March 2006 11:28
> To: mysql@lists.mysql.com
> Subject: mysql query and version problem Help!
>
> Hi.
>
> I have just found out that my hosting provider is using mysql
> 4 and I'm
> using mysql 5 the o
>I installed 5.0 and 5.1-beta on three different system (all are Fedora Core
>4), and each time when I use the command-line client, I can not use the
>familiar up-arrow feature that normally lets you scroll through queries issued
>during previous command-line sessions. My history is completely
Robert,
A RIGHT JOIN would potentially return more results than an INNER JOIN.
I do not see how it could be, in the absolute, be faster.
How large were the tables and how did you do your testing? What platform
did you use and were you InnoDB or MyISAM?
-Original Message-
From: Robert Di
See, for the UK, on that date, 2am to 2:59 inclusive do not officially
exist - hence, 3am to 3:59 for GMT+1, etc. I couldn't quite figure why 3am
was being rejected until now. I'm impressed that MySQL knows that {:v)
--
Jason Teagle
[EMAIL PROTECTED]
> -Original Message-
> From: Ricardas
"Rhino" <[EMAIL PROTECTED]> wrote on 21/03/2006 13:41:49:
>
> - Original Message -
> From: "Zsolt" <[EMAIL PROTECTED]>
> To: "MySql Mailing List"
> Sent: Tuesday, March 21, 2006 2:58 AM
> Subject: How to shutdown mysql from Java
>
>
> > Hi,
> >
> > my application starts mysqld (via Ru
- Original Message -
From: "Jochem van Dieten" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, March 21, 2006 3:53 AM
Subject: Re: RIGHT JOIN better than INNER JOIN?
On 3/21/06, Robert DiFalco wrote:
I apologize if this is a naive question but it appears through my
testing that a RIGHT JOIN
- Original Message -
From: "Zsolt" <[EMAIL PROTECTED]>
To: "MySql Mailing List"
Sent: Tuesday, March 21, 2006 2:58 AM
Subject: How to shutdown mysql from Java
Hi,
my application starts mysqld (via Runtime.getRuntime().exec) and I would
like to stop it also from Java (because of tec
Thanks. This gets me going.
Re proper file permissions: there seem to be mysql files all over the
place. Do I have to find them all and change permissions on all of them?
The MySQL manual I downloaded lists about eight different directories as
including MySQL files, and I'll already seen at least
Hello,
MySQL 5.0 Cluster is an in-memory database. Meaning that the entire database
(tables, indexes, etc.) must fit in RAM along with your other OS and
application processes.
In 5.1, we have introduced disk-based data support. Note, that although data
can now be stored on disk, indexes must stil
not sure, but it may be worth trying the following
run the script:
mysql_install_db --user=root
In the installation dir
this should change ownership and make mysql recognise the data dir.
good luck
Ade
Foo Ji-Haw wrote:
Hi all,
My Windows-based database server crashed (no fault of MySQL. pr
Hi All,
Today, I encountered problem when trying to insert '2006-03-26 03:00:00' value
into timestamp column:
CREATE TABLE `test` (
`a` timestamp
) ENGINE = InnoDB DEFAULT CHARSET = latin1 COLLATE = latin1_german1_ci;
INSERT INTO test VALUES ('2006-03-26 03:00:00' );
Server response was:
ERROR
On Tue, 2006-03-21 at 09:58 +0100, Dominik Klein wrote:
> > [EMAIL PROTECTED] ~]$ mysqlshow
> > +---+
> > | Databases |
> > +---+
> > | test |
> > +---+
>
> In standard setup, there is a user without a name and password, who can
> connect from localhost to database "t
This is actually for Linux/Unix, not Windows.
What error do you get from MySQL when trying to log in? Does the
mysqld(-nt) process show within Task Manager? What does the new error
log say?
You may need to reset permissions:
http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html
Hi all,
My Windows-based database server crashed (no fault of MySQL. probably OS
or hardware), and I managed to copy out the data files. I am using
version 5.0 of the Essentials package.
I tried to install a similar setup on another server, then copy the
data\ folder over. The MySQL service
Hi.
I have just found out that my hosting provider is using mysql 4 and I'm
using mysql 5 the one query I need wont work and is a key feature in the
application .. here is the query i'm using
SELECT dealer_id, auto_id, bid_amount FROM bids b1 WHERE bid_amount=(SELECT
MAX(b2.bid_amount)
FROM bids
> I apologize if this is a naive question but it appears through my
> testing that a RIGHT JOIN may out perform an INNER JOIN in those cases
> where they would produce identical result sets. i.e. there are no keys
> in the left table that do not exist in the right table.
>
> Is this true? If s
[EMAIL PROTECTED] ~]$ mysqlshow
+---+
| Databases |
+---+
| test |
+---+
In standard setup, there is a user without a name and password, who can
connect from localhost to database "test".
So, accessing with this user gives you a list of the databases this user
can
On 3/21/06, Robert DiFalco wrote:
> I apologize if this is a naive question but it appears through my
> testing that a RIGHT JOIN may out perform an INNER JOIN in those cases
> where they would produce identical result sets. i.e. there are no keys
> in the left table that do not exist in the right
54 matches
Mail list logo
