Dear all,
Is repair by sort working for building spatial indexes on spatial columns?
I have a table with a spatial column for storing geospatial data. My table
is rather big (18M records, 7GB disk space)
When I want to add a spatial index CREATE SPATIAL INDEX geomindex ON
arcs(geometry), I end
Save the sql statement to text file,then execute it inside the mysql shell.
On Feb 12, 2008 2:00 PM, Mário Gamito [EMAIL PROTECTED] wrote:
Hi,
Is it possible to send an INSERT statement from a Windows server running
MS SQL SERVER 2005 to a Linux box running MySQL ?
If so, how ? Do I need
Maybe you should view this article:
http://blog.chinaunix.net/u/29134/showart_375303.html
On Feb 12, 2008 8:32 AM, Grant Limberg [EMAIL PROTECTED] wrote:
Something like this should help you find all of the dupes
select email_address from table
group by email_address
having count(*)1;
On
Just use the type varchar.I always use it in my regular life.
On Feb 11, 2008 4:44 PM, Magne Westlie [EMAIL PROTECTED] wrote:
Jerry Schwartz wrote:
SELECT user_id, user_name FROM user_test WHERE user_id IN (SELECT
uid
FROM temp_uids);
[JS] Couldn't you replace the WHERE user_id IN
Nanni Claudio wrote:
You can try to dump-to-sql the whole DB,
Create a new DB and import the sql-dump in the new DB.
Aloha!
Claudio
-Messaggio originale-
Da: Thomas Raso [mailto:[EMAIL PROTECTED]
Inviato: martedì 12 febbraio 2008 17.20
A: mysql@lists.mysql.com
Oggetto: rename
Hi List,
I am trying to write a procedure. I want to know whether the last statement
updated correctly. Then I can add the count.
anybody can help me.
Saravanan
Looking for last minute shopping deals?
Does it also fix the problem with the MySQL 5 Admin GUI (located in
System Preferences) or does one have to use launchd manually every-
time from the command line?
-Unnsse
On Feb 11, 2008, at 8:28 PM, Grant Limberg wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I found this a while
Can someone explain this?
Thanks.
080212 15:54:39 mysqld started
080212 15:54:39 InnoDB: Started; log sequence number 0 43743
080212 15:54:40 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.54-log' socket: '/var/lib/mysql/mysql.sock' port: 3306
Source distribution
We had a power outage, now the mysql wont start at all. Here is the err file
output... Any help on how to recover?
080212 11:35:50 mysqld started
080212 11:35:50 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd
Hello, I'm having some problems to figure out how I could handle my
problem with innodb.
my table is innodb engine:
CREATE TABLE `videos_innodb` (
`video_id` int(10) unsigned NOT NULL auto_increment,
`client_id` int(10) unsigned default NULL,
`client_id_upload` int(11) NOT NULL default '0',
if row_count()0 then
select 'Successfully update';
else
select 'Failed update.';
endif;
On Feb 13, 2008 7:42 AM, Saravanan [EMAIL PROTECTED] wrote:
Hi List,
I am trying to write a procedure. I want to know whether the last
statement updated correctly. Then I can add the count.
anybody
On Feb 12, 2008 12:28 PM, Frederic Belleudy [EMAIL PROTECTED] wrote:
select video_id from videos_innodb where state='QUEUE' limit 10 FOR UPDATE;
= it's waiting for the first to session to commit, so I cannot get
other videos with the same state!!
commit;
= I get 10 video_id
You can try to dump-to-sql the whole DB,
Create a new DB and import the sql-dump in the new DB.
Aloha!
Claudio
-Messaggio originale-
Da: Thomas Raso [mailto:[EMAIL PROTECTED]
Inviato: martedì 12 febbraio 2008 17.20
A: mysql@lists.mysql.com
Oggetto: rename database in 4.1
hi list,
hi list,
how can I rename a database with full innodb tables ?
The version is 4.1
Thnaks all
Mário Gamito [EMAIL PROTECTED] wrote on 02/12/2008 01:00:25 AM:
Hi,
Is it possible to send an INSERT statement from a Windows server running
MS SQL SERVER 2005 to a Linux box running MySQL ?
If so, how ? Do I need any special tools ?
Any help would be appreciated.
Warm Regards,
Unfortuantely the server crashed and I had to manually boost it
It happened before and I would like to know why so it doesn’t again
I don’t have any innodb database on the system, only mysiam
Do you think adding ram might help ?
From: Krishna Chandra Prajapati [mailto:[EMAIL
16 matches
Mail list logo