Repair/add spatial index on a spatial column

2008-02-12 Thread Etienne Sandré
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

Re: Send INSERT statement from MS SQL SERVER to MySQL

2008-02-12 Thread Moon's Father
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

Re: finding duplicate key

2008-02-12 Thread Moon's Father
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

Re: stored procedure, parameter type help needed

2008-02-12 Thread Moon's Father
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

Re: R: rename database in 4.1

2008-02-12 Thread Ken Menzel
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

how to find the statement was successfull in procedure

2008-02-12 Thread Saravanan
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?

Re: MySQL 5 on OS X Leopard

2008-02-12 Thread Unnsse Khan
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

crash

2008-02-12 Thread Eli Shemer
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

Crashed InnoDB

2008-02-12 Thread Bryan Cantwell
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

locking rows with innodb

2008-02-12 Thread Frederic Belleudy
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',

Re: how to find the statement was successfull in procedure

2008-02-12 Thread Moon's Father
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

Re: locking rows with innodb

2008-02-12 Thread Perrin Harkins
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

R: rename database in 4.1

2008-02-12 Thread Nanni Claudio
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,

rename database in 4.1

2008-02-12 Thread Thomas Raso
hi list, how can I rename a database with full innodb tables ? The version is 4.1 Thnaks all

Re: Send INSERT statement from MS SQL SERVER to MySQL

2008-02-12 Thread ddevaudreuil
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,

RE: crash

2008-02-12 Thread Eli Shemer
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