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 PROTECTED]

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. > >

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 b

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: 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 databa

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 N

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.

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 fi

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',

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, how

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

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 "

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;

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

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 e