So you want to mean that i can create (4TB/average_table_size) number
of tables in a linux(2.6 kernel) operating system assuming i have
that much hard disk space?
On 12/11/05, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
sunaram patir [EMAIL PROTECTED] wrote on 12/11/2005 12:10:52 AM:
hi,
Thanks JR, Shawn, Scott, ... for your replies.
I choose to make use of the SELECT ... INTO OUTFILE.
This works fine, but I also want a header-line in the CSV file.
So I made the following statement:
SELECT `ID`, `Code`, `Name`
UNION
SELECT `ID`, `Code`, `Name` INTO OUTFILE 'D:/MySQL
Hi all,
Say, is there a way to tell if a table has been corrupted? We're having some
weird things happening and the only thing I can think of is possible corruption
of a table, but is there anything you can do to find out?
Jenifer
C.R.Vegelin wrote:
Thanks JR, Shawn, Scott, ... for your replies.
I choose to make use of the SELECT ... INTO OUTFILE.
This works fine, but I also want a header-line in the CSV file.
So I made the following statement:
SELECT `ID`, `Code`, `Name`
UNION
SELECT `ID`, `Code`, `Name` INTO OUTFILE
As I read the docs, yes! Is that going to be a limitation for you?
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
sunaram patir [EMAIL PROTECTED] wrote on 12/11/2005 05:50:58 AM:
So you want to mean that i can create (4TB/average_table_size) number
of tables in a
No, thanks! It's, in fact, more than enough!
On 12/11/05, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
As I read the docs, yes! Is that going to be a limitation for you?
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
sunaram patir [EMAIL PROTECTED] wrote on 12/11/2005
I have a table with several columns. The ones of interest are flight_id,
angle, and baseline. I want to find the flight_ids for the flights with the
maximum and minimum altitudes, where altitude=baseline*tan(radians(angle)).
For example,
Flights
+++---+
Hello there,
I've searched long and hard, and pestered many people for a solution
and for help however I can not get around this problem.
I have installed MySQL on my computer which is an Apple iBook G4
which is running Mac OS X 10.4.2 and I wish to use MySQL so that I
can learn
If mysql detects corruption it will stop further access to the table
until you repair it. It is possible for corruption to happen where
mysql can't detect it. If you suspect corruption run a repair on the
table.
On 12/11/05, Subscriptions [EMAIL PROTECTED] wrote:
Hi all,
Say, is there a way to
Hi All,
I have read thehttp://dev.mysql.com/doc/refman/5.0/en/
mysqldump.html and can find nothing regarding getting dump to
INSERT IGNORE instead of simply INSERT INTO. Is there any way to get
INSERT IGNORE to be dumped? Otherwise, I fear I may be forced to
parse the dump file
Hi.
Use the --insert-ignore option of mysqldump.
You can type 'mysqldump --help' on command line to see all options available.
Richard AB.
- Original Message -
From: Michael Williams [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Sunday, December 11, 2005 6:19 PM
Dear All,
I do not have much experience with PHP or MySql although I have used SQL
quite a lot. I am going to set up a relatively small MySQL database (circa
40 tables) and we are expecting a hit rate of about 40,000 visitors per
annum mostly browsing a relatively low number of pages each.
Nathan Whitington wrote:
Hello there,
I've searched long and hard, and pestered many people for a solution
and for help however I can not get around this problem.
I have installed MySQL on my computer which is an Apple iBook G4 which
is running Mac OS X 10.4.2 and I wish to use MySQL so
On Sunday 11 December 2005 23:51, Charles Walmsley wrote:
Dear All,
I do not have much experience with PHP or MySql although I have used SQL
quite a lot. I am going to set up a relatively small MySQL database (circa
40 tables) and we are expecting a hit rate of about 40,000 visitors per
Hi Peter,
40 tables seems to be relatively small, I have several databases that I
manage that have tables that number in the hundreds. In other databases,
I have one site that has 7,500 tables. Have a look at some of the open
source ERP systems around eg. Nola or similar, their tables number in
Oops, I meant to copy the list on this reply so that others could
benefit
Rhino
- Original Message -
From: Rhino [EMAIL PROTECTED]
To: Mark Phillips [EMAIL PROTECTED]
Sent: Sunday, December 11, 2005 6:19 PM
Subject: Re: Need Help with a query
- Original Message -
Hi Jenifer,
You can use mysqlcheck to confirm any corruption and also to fix it. See
http://dev.mysql.com/doc/refman/5.0/en/mysqlcheck.html
or you can also run statements from the mysql client such as CHECK
TABLE, REPAIR and ANALYZE etc.
References to this can be found at
Is there a command that will load in all of the data from a table
within a database .sql file on disk? The only import option I am
seeing is LOAD DATA INFILE which requires a text file already
exported to disk. How about a way to load in the table data directly
from the database file?
Hi John,
If it is a .sql file, with all appropriate SQL statements already in
place then you only have to do the following
$ mysql -u -p databasename .sql file
This will process all appropriate statements in the file.
Regards
David Logan
Database Administrator
HP Managed Services
148
Thanks for the response, David. How about if I want to import all the
entries from one specific TABLE within that sql file into a table with
identical columns on my MySQL server? Is there a way?
Thanks,
John
On Dec 11, 2005, at 5:29 PM, Logan, David (SST - Adelaide) wrote:
Hi John,
If
Hi John,
Personally, I'd just do a cut and paste job on the .sql file unless it
is too unmanageable. Not knowing your platform, and being a unixy type
person, I would use sed or grep to strip out the lines that I need and
then plonk them straight into another file. I don't know how you could
I forgot to copy the list as well
Mark
-- Forwarded Message --
Subject: Re: Need Help with a query
Date: Sunday 11 December 2005 06:47 pm
From: Mark Phillips [EMAIL PROTECTED]
To: Rhino [EMAIL PROTECTED]
Rhino,
My apologies for leaving out the version of mysql. I agree
Okay, so I haven't been able to find any corrupted tables. Has anyone ever run
into problems with joins between tables that contain funky data? I have a
table that contains encrypted info and some of the characters being used/stored
are definitely odd.
I'm still trying to find the answer to
Subscriptions [EMAIL PROTECTED] wrote on 12/11/2005
10:46:08 PM:
Okay, so I haven't been able to find any corrupted tables. Has
anyone ever run into problems with joins between tables that contain
funky data? I have a table that contains encrypted info and some of
the characters being
I have two tables 'table1', 'table2' with a matching column 'column1'.
How can I return all rows from table2 where the entry for
table2.column1 does not match any entries in table1.column1?
SELECT * FROM table2 WHERE table2.column1 table1.column1
returns all the rows, rather than the unique
Sorry... I thought I had posted the issues, that must have been a support
ticket somewhere instead. heh
I have a main customer table with a handful of other tables that I join with it
via PHP pages. I've written a phone order system that works fine 98% of the
time. Every once in a while,
Hi,
Iam running a mysql server version 5.0.15. My mysql query log is
occupying nearly 21 GB of disk space. how do i truncate the same ?
Thanks in advance,
Abdul.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
John Mistler wrote:
I have two tables 'table1', 'table2' with a matching column 'column1'.
How can I return all rows from table2 where the entry for table2.column1
does not match any entries in table1.column1?
SELECT * FROM table2 WHERE table2.column1 table1.column1
returns all the rows,
28 matches
Mail list logo