Dear Alec
Thanks for the quick response.
I am doing some work in High Availabilty. We have two real servers(just
2 PC's) and we want the both PC to run MySQL but uses one common
database data file. We have one NAS server, we will keep all the data
file there and mount it on local system and try
I'm pretty new to MySQL, but I already like it. Kudos to the developers!
I recently did a mysqlimport on a few data files, and it came back with over
4000 warnings. How can I actually see what the warnings were? I'm still
not sure what it was upset about...
TIA.
- Bryan
--
MySQL General
You need a license if you sell a product designed specifically for use
with MySQL or that requires the MySQL server to function at all. This is
true whether or not you provide MySQL for your client as part of your
product distribution.
Does this mean that I must make all of my web sites
Hi,
Hi there I have some trouble with MyISAM tables. I
have found that supports 3 different types of the 1:1
relation.
a)1:1
b)1:1 (Non-Identyfying)
c)1:1 (Descedent Obj.)
What all these about?
What type of tables do u use normally?
I'm unsure of what you're trying to ask -
hi,
i enable option log-bin in my mysql db server so that i can use the log to recover the
transaction which did not backup.
But, except for the binary log file hostname-bin, i found another file
hostname-bin.index. What is the function of it?
Thanks
Brian
Hi!
On Dec 04, Mirza wrote:
Hi,
In 4.1.1. new features there is:
* Added `MATCH ... AGAINST( ... WITH QUERY EXPANSION)' and the
`ft_query_expansion_limit' server variable.
What is WITH QUERY EXPANSION? I found no details in manual.
Fixed.
WITH QUERY EXPANSION is now documented.
Bhartendu Maheshwari [EMAIL PROTECTED] wrote on 07/12/2003
07:56:26:
I am doing some work in High Availabilty. We have two real servers(just
2 PC's) and we want the both PC to run MySQL but uses one common
database data file. We have one NAS server, we will keep all the data
file
Hello All
I have two tables
Table: 1
+---+--+
| city | zip_code |
+---+--+
| New York | 12354|
| New York | 12355|
| New York | 12356|
| New York | 12357|
| New York | 12358|
| New York | 12359|
| New York | 12353|
On Sun, Dec 07, 2003 at 01:48:08PM +0100, Sergei Golubchik wrote:
What is WITH QUERY EXPANSION? I found no details in manual.
Fixed.
WITH QUERY EXPANSION is now documented.
I'm sorry, but I must be blind. Where is it on
http://www.mysql.com/doc/en/Fulltext_Search.html ?
Did someone forget
On Sun, Dec 07, 2003 at 12:11:21AM -0500, Alex Khordos wrote:
I am trying to work out the query to retrieve city name based on the zip
code in the second table.
How can I compare two strings? I tried LIKE in my query but it did not work.
Use SUBSTRING to cut down the extended zipcode to 5
Hi!
On Dec 07, Chris Elsworth wrote:
On Sun, Dec 07, 2003 at 01:48:08PM +0100, Sergei Golubchik wrote:
What is WITH QUERY EXPANSION? I found no details in manual.
Fixed.
WITH QUERY EXPANSION is now documented.
I'm sorry, but I must be blind. Where is it on
You need a license if you sell a product designed specifically for
use with MySQL or that requires the MySQL server to function at all.
This is true whether or not you provide MySQL for your client as part
of your product distribution.
Does this mean that I must make all of my web sites
Hello,
I have a db(logs) that I have been working on. This db has tables that are
created every month, they are Nov03,Dec03,Jan04, etc..
Each month/table has about 480,000,000 records. Data file is about 80GB the
index file is about 40GB.
Mysql/apache run on a Dell 2550 4gb ram 2cpu's OS - RH 9.
Hello,
what is the best way to convert a TIMESTAMP value to a value
similar to a DATETIME value ??
thx's
--
MikemickaloBlezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet Publishing
Providing Internet Solutions that work!
http://www.thunder-rain.com
Quality Web Hosting
i've used FROM_UNIXTIME with success. you can also supply a format.
http://www.mysql.com/doc/en/Date_and_time_functions.html
hth
jeff
You need a license if you sell a product designed specifically for
use with MySQL or that requires the MySQL server to function at all.
This is true whether or not you provide MySQL for your client as part
of your product distribution.
Does this mean that I must make all of my web sites
I am not very experienced with Linux, but SuSE Linux 9.0 and YaST makes it
very comfortable for me to install various SW-packages. Therefore I try to
install also MySQL with YaST.
There are MySQL packages (Version 4.0.15) included in SuSE Linux 9.0
distribution and I try to install the server
So this is getting really confusing now...
I have two quite explicit questions to this and I hope there are some
experts listening on this list who can answer them.
(1) I want to start a (small, non-free) webhosting service and offer
webspace with PHP support and a MySQL database account. There
Hi!
On Nov 27, [EMAIL PROTECTED] wrote:
Description:
The included sql test script (output of mysqldump 10.2 (create table
statement and insertion of 250 records into this table) with added
check for table integrity) results in corrupted table and error
message 'Found key at page
Yves Goergen wrote:
(1) I want to start a (small, non-free) webhosting service and offer
webspace with PHP support and a MySQL database account. There will be some
standard tariffs that include a database account but I'm going to make them
available as extra upgrade, too, for a monthly fee. Do I
Hi there,
I have been asked to investigate a solution to offer MySQL to our staff.
I am not sure how many people will make use of it at this stage.
Most people would most likely use it as a backend for message boards
And to store information on whatever they are doing. I am sure it will
be
Hello Franz,
On Sunday 07 December 2003 12:42, Franz Edler wrote:
I do not have specific experiences with SuSE 9.0 (stiil waiting for it from my
distributor) but I do with previous versions of SuSE (7.x and 8.x),
I am not very experienced with Linux, but SuSE Linux 9.0 and YaST makes it
very
Hi!
On Nov 27, Uros Kotnik wrote:
Executing this SQL, takes ~5 sec.
select artists.name, cds.title, tracks.title from artists, tracks, cds
where artists.artistid = tracks.artistid and cds.cdid = tracks.cdid
and MATCH (artists.name) AGAINST ('madonna')
and MATCH (cds.title) AGAINST
Thank you so much guys, for your attention and help.
I'm upgrading my MySQL to 4.0.16 as suggested.
Rgds,
Vanessa
- Original Message -
From: Paul DuBois [EMAIL PROTECTED]
To: Jay Blanchard [EMAIL PROTECTED]; miguel
solorzano [EMAIL PROTECTED]; Kiky [EMAIL PROTECTED];
[EMAIL PROTECTED]
I hope someone can help, I am a newbe as sql and need a some help
I can by using this command at mysql prompt |select ACCTSESSIONID from radiuslog
where ACCTSESSIONTIME='0';| get a list that I then need to delete
but when I used the following I keep get errors
delete from radiuslog where
Are you aware that you are using a nested sql query which isn't available
until version 4.1?
Try splitting the delete into multiple steps 1) populate a temp table with
the id's you want to delete then 2) use the temp table data to delete the
rows.
- Original Message -
From: tech
I accepted the performance issue but I don't want two separate copies of
data, I only want on every SQL command the MySQL daemon reads/writes
from/in the file. How can I force MySQL daemon to do the same?
regards
bhartendu
On Sun, 2003-12-07 at 18:51, [EMAIL PROTECTED] wrote:
Thank you for taking the time to reply
I am using version 4.1 as can be seen from the out put below
mysql Ver 13.5 Distrib 4.1.0-alpha, for portbld-freebsd5.1 (i386)
Also I am unsure of the syntax for what you suggest
Are you aware that you are using a nested sql query which isn't available
28 matches
Mail list logo