If you are looking for a client to connect to MySQL
using SSH tunnel, try out SQLyog. It has SSH
Tunneling.
Karam
--- Jerry Swanson [EMAIL PROTECTED] wrote:
How to create ssh tunnel for Mysql?
TH
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail
Title: DIY MTB
Is there any built in or other
support for recursive queries . I suspect not, but wonder what is
considered the best approach.
With stored procedures being supported in 5.0 is that the way to handle
these.
Thanks
--
Duncan Miller
[EMAIL PROTECTED]
www.diymtb.com.au
DBTools Software is pleased to announce the new DBManager Professional
Enterprise Edition 3.2.0. This release is not only a bug fix, but also
brings a lot of improvements and new features. Check it ot the change log:
New Features and Improvements
a.. Query Builder Completely Redesigned with
Duncan Miller [EMAIL PROTECTED] wrote on 12/08/2005 06:40:55 AM:
Is there any built in or other support for recursive queries . I
suspect not, but wonder what is considered the best approach.
With stored procedures being supported in 5.0 is that the way to handle
these.
Thanks
--
Jerry,
SQLYog is great, I use it all the time. I've been on the BETA team for 3
years now and I buy at least one copy at every company I work for. Well
worth the money if you are a serious MySQL developer.
However, to answer your question, google for putty.exe. The docs explain
to you how
The mysqldump utility allows granularity up to tables, not columns.
But you can use SELECT ... INTO OUTFILE to export the data:
http://dev.mysql.com/doc/refman/5.1/en/select.html
and then LOAD DATA INFILE (or LOAD DATA LOCAL INFILE) to import it.
-Sheeri
On 12/7/05, Test USER [EMAIL
Hi Brandon,
Not everyone on this list has worked with Sybase. An explanation of
@@error and @@rowcount might be helpful.
That being said, I think you want SHOW ERRORS:
http://dev.mysql.com/doc/refman/5.1/en/show-errors.html
(note there's also a SHOW WARNINGS that show you a deeper debug level:
Hi Marco,
My hint is to read the BDB section of the manual:
http://dev.mysql.com/doc/refman/5.0/en/bdb-start.html
specifically the part that says:
With the bdb_max_lock variable, you can specify the maximum number
of locks that can be active on a BDB table. The default is 10,000. You
should
Well I tried removing -lmtmalloc from the LIBS line. Like before, I was
able to make but not make test. This time I just get a different error
after test.
I could look into solving this error, but is this just treating the symptoms
though?
Ideas welcome,
TIA,
F
# /usr/local/bin/make test
Hello.
As far as I know - it is impossible with mysqldump. You may want to
use SELECT INTO OUTFILE to produce files with certain columns or
create tab-separated files with --tab option and load specific columns
using LOAD DATA INFILE. See:
On 12/7/05, Marco Baroetto [EMAIL PROTECTED] wrote:
Hi,
I have a berkeley db table containing about 5 rows where I do this
transaction (pseudocode follows):
begin work
delete from mytable where myfield='boo' /*delete about 100 rows*/
for (i=0; i=100; i++){
insert into mytable
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
In the manual (http://dev.mysql.com/doc/refman/5.0/en/insert.html) I saw
this snippet: If you use an INSERT ... VALUES statement with multiple
value lists
But, I thnk I am missing some information on the syntax of INSERT ...
VALUES.
This may be what
Hi James,
INSERT INTO table (a,b,c) VALUES (1,2,3),(4,5,6);
is an example of inserting multiple rows with one insert statement,
instead of these 2:
INSERT INTO table (a,b,c) VALUES (1,2,3);
INSERT INTO table (a,b,c) VALUES (4,5,6);
That should give you enough to work with.
-Sheeri
On
James Black [EMAIL PROTECTED] wrote on 12/08/2005 01:07:15 PM:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
In the manual (http://dev.mysql.com/doc/refman/5.0/en/insert.html) I saw
this snippet: If you use an INSERT ... VALUES statement with multiple
value lists
But, I thnk I am
I've got a table that just hit the 4gig limit for MyISAM tables in a 4.x
ver db. I need to alter the table structure and set the max_rows and
Avg_row_length to override the default of 4 gig. Problem is I can't
find any refernce in the mysql docs that indicates how to decide a
setting for
On a 1.6ghz, 1gb ram, Linux machine running Mysql 4.1x.
I have an Innodb table with over 20 million records and index size
about 3.7 gig, data size 2.2gig (yes, many indexes, more space then
the data itself). Last night I tried an Optimize from the Admin gui
console (logged in as root at the
I do not know the answer to this. I do think your machine is slow, and
has too little memory. For such a large database you should have a
faster processor and more memory.
But, I cannot speak to how the Optimize action works.
Bob Cochran
Greenbelt, Maryland, USA
Nathan Gross wrote:
On a
-Original Message-
From: Nathan Gross [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 08, 2005 13:58
To: mysql@lists.mysql.com
Subject: Optimize: 14 hours and still running!
On a 1.6ghz, 1gb ram, Linux machine running Mysql 4.1x.
I have an Innodb table with over 20 million
Jeff wrote:
I've got a table that just hit the 4gig limit for MyISAM tables in a 4.x
ver db. I need to alter the table structure and set the max_rows and
Avg_row_length to override the default of 4 gig. Problem is I can't
find any reference in the mysql docs that indicates how to decide a
-Original Message-
From: Michael Stassen [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 08, 2005 14:34
To: Jeff
Cc: mysql@lists.mysql.com
Subject: Re: Alter MyISAM table to adjust max_rows and Avg_row_length
Jeff wrote:
I've got a table that just hit the 4gig limit for
Hi,
We install the mysql version 5.0.16 on Linux Red hat as the root operating
system user. After the install we changed the ownership and group to a mysql
UNIX user. We tested starting and stopping the mysql server using the mysql
UNIX user account and it worked fine.
But when we reboot
I am trying to install the following rpm on a red hat linux machine.
MySQL-client-standard-5.0.16-0.rhel3.i386.rpm
MySQL-devel-standard-5.0.16-0.rhel3.i386.rpm
MySQL-server-standard-5.0.16-0.rhel3.i386.rpm
MySQL-shared-standard-5.0.16-0.rhel3.i386.rpm
Hi all!
Look:
mysql select version();
+---+
| version() |
+---+
| 5.0.13-rc |
+---+
1 row in set (0.00 sec)
mysql create database test1 charset='utf8';
Query OK, 1 row affected (0.01 sec)
mysql use test1;
Reading table information for completion of table and column names
Nathan,
you can use SHOW INNODB STATUS\G to monitor how many rows per second it is
inserting to the new, reorganized table.
If the workload is disk-bound, it may be as low as 100 rows per second. Then
inserting 20 million rows will take 2 days.
Best regards,
Heikki
Oracle Corp./Innobase
In the last episode (Dec 08), ISC Edwin Cruz said:
Hi all!
Look:
mysql select version();
+---+
| version() |
+---+
| 5.0.13-rc |
+---+
...
mysql quit
Bye
apps# mysqldump --databases test1
...
`d`.`idTCiudad`) and (`d`.`TEstado_idTEstado` = `e`.`idTEstado`));
So I'm trying to write some triggers to help synchronize account information
between my master account database and a secondary database where I keep
information for radius accounts. My SQL syntax sucks, and I don't have much
luck reading the docs on the site (I might have a learning
At 21:07 -0700 12/8/05, Andre Turpin wrote:
So I'm trying to write some triggers to help synchronize account information
between my master account database and a secondary database where I keep
information for radius accounts. My SQL syntax sucks, and I don't have much
luck reading the docs on
I am looking to do a query on a self join table that returns the parent
records.
Obviously there are ways to do this, but just wondered if there are any
functions in MySQL that make this easier, or specific functions
available to stored procedures. I have read the manual and couldn't find
Is there a possibility to select all columns from a table except one or
two columns? For example I have a table with 30 columns and want all
columns but one column *not*. Do I have to write a very long select
statement with 29 column names that i want to get?
--
Perumal, Jai wrote:
Hi,
We install the mysql version 5.0.16 on Linux Red hat as the root operating
system user. After the install we changed the ownership and group to a mysql
UNIX user. We tested starting and stopping the mysql server using the mysql
UNIX user account and it worked fine.
30 matches
Mail list logo