Hello.
I've been using 'load data infile...' to build a data warehouse and it seems
to be extremely efficient. However, I receive very large, fixed delimited
file and (so far) have to parse them with a little Perl code. It's not a
terrible situation, but a step I'd like to eliminate if I coul
In a message dated 2/11/2004 4:44:00 PM Eastern Standard Time,
[EMAIL PROTECTED] writes:
Hi,
I do just this at the moment - I have a cron job that runs MySQL dump, gzips
the output, and will then ftp the important files to a machine that get's
backed-up to a tape drive. I also time the dump, and
In a message dated 2/11/2004 2:26:09 PM Eastern Standard Time,
[EMAIL PROTECTED] writes:
I read this over and over.. I am curious why replication is such high
finance?? I run it here. The Production system is a high finance machine and the
replicated box is a old clunker basically.. It doesn't t
In a message dated 2/15/2004 4:39:00 PM Eastern Standard Time,
[EMAIL PROTECTED] writes:
I've got an iBook running gentoo and MySQL version 4.0.17 and it's on the
same router with my desktop running gentoo and MySQL version 4.0.17. I would
simply like to use the iBook as a mysql client and have
Has anyone had much luck with UnixODBC on RedHat Linux. I've recently moved
a 100 Gb MySQL database from Win2000 Server to a RedHat 9 server and installed
UnixODBC to access it. It appears that the performance is dramatically
slower using the same application, pointed to the RedHat server.
Th
I know that MySQL 3.23.nnn did not support a delete subselect, just wondering
what the best/most efficient way to do the following is:
delete from table_a where table_a.column_1 in ( select column_1 from
table_b);
Assuming that column_1 is the same data type and size in both table_a and
tab
I am trying to establish temporary tables that are accessible via MyODBC. I can
create the table with data in it and query it from the MySQL command line, but it
never shows up through MyODBC. Is there something magical about temporary
(memory-based) tables that prevents this?
I am running My
I am trying to establish temporary tables that are accessible via MyODBC. I can
create the table with data in it and query it from the MySQL command line, but it
never shows up through MyODBC. Is there something magical about temporary
(memory-based) tables that prevents this?
I am running My
Hi,
We are trying to find a way to distribute a large MySQL database across
several systems, each configured as a master to a slave. At this point we are
tossing architectural ideas around and here is where we are right now:
Primary (Master)
In a message dated 9/9/03 4:52:53 PM Eastern Daylight Time,
[EMAIL PROTECTED] writes:
> If you're accessing your db through JDBC, an idea that I've been following
is
> the c-jdbc project...
Very nice, but we will be using LAMP (Perl and PHP). :-/
>
> http://c-jdbc.objectweb.org/
>
> it'
In a message dated 9/9/03 7:53:59 PM Eastern Daylight Time,
[EMAIL PROTECTED] writes:
> By "partitioning", you mean having one table divided across N
> partitions?
Yes, I do.
>
> Such a feat isn't directly possible with MySQL, however you can create N
> tables instead of 1, and use a table
...just a shot in the dark, but isn't 'description' a reserved word? If so,
um, maybe a bug/inconsistency between table types. If not, ramble on.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
In a message dated 9/13/03 8:40:08 AM Eastern Daylight Time,
[EMAIL PROTECTED] writes:
> 1) can I create groups, add users and assign privileges to the group?
Yup.
> 2) since this system is going over a VPN the data should be encrypt using
> 3DES. If a authorized user needs access to the data
Has anyone ever used a non-ODBC, 3rd party ADO connector to MySQL?
Any suggestions would be greatly appreciated. My client does not wish to use
ODBC.
/tony
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED
In a message dated 9/15/03 9:50:22 AM Eastern Daylight Time,
[EMAIL PROTECTED] writes:
> Jeff McKeon wrote:
>
> > Is it possible to relate a record in one database to a record in another
> > and do queries that pull from both databases?
Programmatically yes. Using referential integrity (for
In a message dated 9/15/03 3:05:09 PM Eastern Daylight Time,
[EMAIL PROTECTED] writes:
> Hey,
>
> Does anyone have any suggestions? Is this the correct list to post MySQL
> ssl questions? I didn't get any responses so far. Thanks.
>
> Sherrill
Are you orunning the monitor from the sam
Hmmm, have you tried putting is a folling mysqladmin flush-threads command?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Has anyone ever had to move a database from one machine to another? I tried
to just copy all the files from /var/lib/mysql/db1 to another machine into
/var/lib/mysql/db2. Although I can see the tables using SHOW TABLES, I get an
error 13 trying to access or repair them.
Is it possible to move
I am using a portable drive with a few tables on it that I copied from a
MySQL server. My intent is to be able to transport the portable drive home (with
the large DB) and plug it into my Windows server to continue working.
To do this, I need to change the datadir to the portable drive (in my c
In a message dated 9/24/03 12:34:34 PM Eastern Daylight Time,
[EMAIL PROTECTED] writes:
> Have you tried using the blackslash? `\` instead of the forward slash `/`?
Same results. The manual states that even on Windows that the '/' should be
used as the '\' is MySQL's escape char. Optionally, y
...after finding a log in the directory that I was trying to use for my new
DataDir, I've discovered my problem (and, surprise, it makes sense).
The MySQL database table must also be in place in the directory, I suppose in
order to keep track of the other databases and tables, etc.
Cheer.
--
In a message dated 9/30/03 1:33:07 PM Eastern Daylight Time, [EMAIL PROTECTED]
writes:
> HI List,
>
>
>
> Using version 4.0.15
>
>
>
> I'm trying to copy a database. Copy db1 to (new) db2.
>
>
>
> So I created db2.
>
>
>
> And then tried the following and got the s
In a message dated 9/30/03 3:13:59 PM Eastern Daylight Time, [EMAIL PROTECTED]
writes:
> What if you have InnoDB tables?
I don't. ;-)
But I'd certainly like to know other strategies.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.
I've been reading the online docs and asking around about MySQL's ability to
perform parallel processing. It does not appear to support such
functionality. Maybe this is intentional, or I missed something in the manual.
I have a 4 way Intel server that I'd like to be able to contain certain
u
In a message dated 10/16/03 9:27:04 AM Eastern Daylight Time,
[EMAIL PROTECTED] writes:
> This is down to the OS. As MySQL is multy threaded its all down to SMP
> support.
>
with all due respect, I don't think that is 100% true. Although certainly
the underlying OS kernel must support multi
We use MS Access with ODBC links to MySQL, but prefer a commercial product
called MyManager. It cost about $199.00 US. for the professional version.
looks and works much like MS Access. There are several on the market, we chose
this one as the best for our purposes.
Here's the link: http:
What you've seen is what you get. None.
Try tunneling through SSH. Try this link to learn more:
http://www.cs.kuleuven.ac.be/system/security/ssh/tunnel.shtml
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTE
I've created several merge tables from the command prompt. All seems well,
the .frm and .MRG files are created. The contents of the .MRG files are
accurate.
I flushed the tables (even restarted MySQL).
I can see the newly created merge tables, but when I try to run a DESCRIBE or
a SELECT
Does anyone know of any limitations on the number of underlying tables in a MERGE
table? Seems to be a topic of scant coverage in the books and online docs.
ANY help or ideas would be appreciated.
/Tony
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscri
In a message dated 10/29/03 4:18:28 AM Eastern Standard Time,
[EMAIL PROTECTED] writes:
> Ok, I've set my root password and have found (by creating a db) that
> the databases are stored (Mac OSX Server 10.3) in /private/var/mysql.
>
> I have my old system on a separate hard disk; however, my
Hello,
I've posted this before, but did not get a fix or find out what I am not doing
coreectly.
I've established several merge tables. 3 out of the 5 of my merge tables work
fine...but when I try to access (e.g. describe or query) the other two, I get the
following error:
mysql> describe
I am using MySQL 4.0.18 and trying to generate a list of the number of row in a table
with the same last name, by last name.
Is there any way to do this without creating another table?
Here is what I am trying:
mysql> select count(distinct last_name) as "LnameCnt", last_name from table_ABC gro
What is the version of your mysql client? If it is pre 4.1 then it is likely being
bitten by the password length change from 4.0.xx to 4.1 from 16bytes to 41bytes.
You'll need to read the note on passwords in the 4.1 docs.
Hope this helps.
--
MySQL General Mailing List
For list archives: ht
hmmmif you are on the same machine, does it work if you do not specify the '-h
localhost'?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
...blind as a bat, it was right in front of me in basic SQL .
Thank you kindly.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I have a program which read rows from one table (new_data) and attempts to find a
matching record in another table, called master_table. Upon determining a that we
have seen a record from this client (in new_data) before, based upon some exact
matching and probability matching logic, we insert
36 matches
Mail list logo
