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
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
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 update as
is ANSI, and detect some bad chars.
Teddy
- Original Message -
From: Gleb Paharenko [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Saturday, December 24, 2005 23:47 PM
Subject: Re: 2 questions
Hello.
It gives an error near some special chars (because the file is not
ANSI).
Please
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
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 it
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.
1
]
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,
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
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
Regarding number 1, you might be able to do something with this:
mysql show variables like 'pid%';
+---+-+
| Variable_name | Value |
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
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
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
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
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
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
remember the name but it is on /System
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:
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 to
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 to
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
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 can I join to big tables and verify if there are any duplicat
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
23 matches
Mail list logo