I would encourage people to use date filters on their searches, as
that could help by eliminating rows prior to the fulltext search.
For backup and recovery of a database this size, with MyISAM tables, I
recommend the included 'mysqlhotcopy' script. Also a mastery of the
mysqldump command will h
Dear list,
I'm programming a PHP-driven Search Engine for a newspaper.
Full-text Search with MyISAM Tables, MySQL 4.1.11, PHP 4.3.0
1GB of Text encoded by UTF-8
An average of 1Mbyte Data is inserted to database every day
A common SQL-Query:
SELECT COUNT(*) FROM news_archive
WHERE
MATCH(news_tit
that the file is ANSI, and detect some bad chars.
Teddy
- Original Message -
From: "Gleb Paharenko" <[EMAIL PROTECTED]>
To:
Sent: Saturday, December 24, 2005 23:47 PM
Subject: Re: 2 questions
> Hello.
>
> > It gives an error near some special chars (because t
Hello.
> It gives an error near some special chars (because the file is not >ANSI).
Please, could you provide the error message. Check if it disappears if you
perform the dump with --quote-names option.
> The second question is related to "explain". Is there a "explain"
>function for upd
Hi,
I have used mysqldump with 5.0.15-nt and I have seen that it saves the file
in UTF-8 format.
This is OK, but if I try to run:
mysql database < saved_file.sql
It gives an error near some special chars (because the file is not ANSI).
If I convert the file as ANSI, I can import the data from i
> 1) For what I see on the MySQL manual you can have an Auto Increment not
> null Field as the primary key. Say that you have a table with only
> two columns the first being an Auto_Increment. How do I write an INSERT
> or REPLACE SQL statement to insert data on this table? Can
> I write it so that
Hello all,
I have two question on Auto Increment fields:
1) For what I see on the MySQL manual you can have an Auto Increment not
null Field as the primary key. Say that you have a table with only
two columns the first being an Auto_Increment. How do I write an INSERT
or REPLACE SQL statement
]
Sent: 19 November 2004 08:01
To: [EMAIL PROTECTED]
Subject: Re: 2 questions about Replication
Hello.
MySQL only supports one master and many slaves.
As I saw in comments at:
http://dev.mysql.com/doc/mysql/en/Replication_Options.html
You may use replicate-rewrite-db for tables:
replicate
Hello.
MySQL only supports one master and many slaves.
As I saw in comments at:
http://dev.mysql.com/doc/mysql/en/Replication_Options.html
You may use replicate-rewrite-db for tables:
replicate-rewrite-db = RemoteTableName ->LocalTableName
>i have 2 questions about Repli
Hello,
i have 2 questions about Replication.
1) I managed to make one slave and one master. The replication works fine and
it updates only one table from one database (cause of the
replicate-do-table=db.table1). The first question is can I tell mysql that
table1 from master to be named table2
Regarding number 1, you might be able to do something with this:
mysql> show variables like 'pid%';
+---+-+
| Variable_name | Value |
+---+--
I have 2 unrelated questions:
1) Is there any way to get the hostname that the server is
running on from within mysql?
All I can come up with is (pseudo coded):
mysql> system echo insert mysql.hostname `hostname` ... > hostname.sql
mysql> s
At 10:54 -0700 7/15/04, Tom Kirkman wrote:
1. Though I was not able to find it explicitly stated in the online
manual, I'm inferring from what I did find that the server v4.1.3 Win32
cannot store fractions of a second in DateTime columns (though oddly
enough, several existing DataTime functions do
Hi Tom,
===
2. Will an ADO sqlTransaction that is begun but not explicitly
committed or rolled back (i.e. the session was terminated before the
transaction could be concluded) be automatically rolled back or
automatically committed by the server?
===
This question has a rather high "duh" factor
1. Though I was not able to find it explicitly stated in the online
manual, I'm inferring from what I did find that the server v4.1.3 Win32
cannot store fractions of a second in DateTime columns (though oddly
enough, several existing DataTime functions do handle them). It was
stated that support f
On 9/5/03 7:47 AM, "Fortuno, Adam" <[EMAIL PROTECTED]> wrote:
> All:
>
> (1) I've got "/user/local/mysql/data" in my path, but when I attempt to run
> "mysqld_safe" I get a message reading:
>
> "Please do a cd to the mysql installation directory and restart this script
> from there as follows: .
Corporation
http://www.cfmc.com/
> From: Santino <[EMAIL PROTECTED]>
> Date: Fri, 5 Sep 2003 19:22:12 +0200
> To: [EMAIL PROTECTED]
> Subject: Re: 2-Questions: Starting MySQL and Shutting Down on OS X
>
> You have to make a script and put it in a folder (sorry I don't
>
You have to make a script and put it in a folder (sorry I don't
remember the name but it is on /System/startup) Try to locate a shell
script like cron in a cron directory and modify it creating a script
mysql in a mysql directory.
To start:
cd /user/local/mysql/data
./bin/mysqld_safe &
To stop
All:
(1) I've got "/user/local/mysql/data" in my path, but when I attempt to run
"mysqld_safe" I get a message reading:
"Please do a cd to the mysql installation directory and restart this script
from there as follows: ./bin/mysqld_safe"
Do I really need to be in the installation directory to ki
"Mojtaba Faridzad" <[EMAIL PROTECTED]> wrote:
> I'm learning MySQL and I got two question:
>
> 1) As I know, MySQL has a buffer to keep the last records which have
been retreived. So if I run a query two times, the second time will be
faster. How can I temporarly stop this service? because I want
"Mojtaba Faridzad" <[EMAIL PROTECTED]> wrote:
> I'm learning MySQL and I got two question:
>
> 1) As I know, MySQL has a buffer to keep the last records which have been retreived.
> So if I run a query two times, the second time will be faster. How can I temporarly
> stop this service? because I
Hi,
I'm learning MySQL and I got two question:
1) As I know, MySQL has a buffer to keep the last records which have been retreived.
So if I run a query two times, the second time will be faster. How can I temporarly
stop this service? because I want to run different queries and compare their sp
example in PHP if this is
what you're looking for.
-Angela
Arthur Radulescu wrote:
>
> Hi!
>
> I have 2 questions!
>
> 1.What is more eficient to keep some images into a table or to keep their names in
>the table and images separated in a directory?
>
> 2.How ca
On Mon, Jan 15, 2001 at 11:41:39AM -0800, Arthur Radulescu wrote:
> Hi!
>
> I have 2 questions!
>
> 1.What is more eficient to keep some images into a table or to keep
> 1.their names in the table and images separated in a directory?
If your main concern is effiency, keep
From: Anthony Cooke <[EMAIL PROTECTED]>
Date: Mon, 15 Jan 2001 10:33:05 -0400
To: Arthur Radulescu <[EMAIL PROTECTED]>
Subject: Re: 2 questions!
Two answers!
1. Answer: Read "Chapter 12.6: Other optimization tips". In essence let
the file system cache image files, st
Hi!
I have 2 questions!
1.What is more eficient to keep some images into a table or to keep their names in the
table and images separated in a directory?
2.How can I join to big tables and verify if there are any duplicates (i have tried
just to view the data from those tables with something
26 matches
Mail list logo
