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
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
> 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
]
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 Replication.
>
Regarding number 1, you might be able to do something with this:
mysql> show variables like 'pid%';
+---+-+
| Variable_name | Value |
+---+--
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
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
1. I would just keep the names in the database table. Storing the
images themselves would require a blob field, which means that you would
have to run OPTIMIZE TABLE a lot more often to keep it running fast. If
you just store the name, you can use a varchar. Not only does it take
up less space
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 the images in the file
14 matches
Mail list logo
