input from script

2010-08-13 Thread xPol
Hi, i am very new to databases. I would like to know if new entries can be added to my database from the character terminal. Hints for achieving such result by a shell script welcome. thank you ---Pol -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsub

Re: mysql is crashing

2010-08-13 Thread Yectli Huerta
On Fri, Aug 13, 2010 at 11:54:02AM -0700, Rob Wultsch wrote: > # file /usr/local/mysql/bin/mysqld > /usr/local/mysql/bin/mysqld: ELF 64-bit LSB executable, AMD x86-64, > version 1 (SYSV), for GNU/Linux 2.4.0, dynamically linked (uses shared > libs), for GNU/Linux 2.4.0, not stripped > it is 64bit

Re: mysql is crashing

2010-08-13 Thread Rob Wultsch
On Fri, Aug 13, 2010 at 11:47 AM, Krishna Chandra Prajapati wrote: > Hi Yectli, > > I am talking about mysql server. Is it 32bit or 64bit. > > Provide some additional information. mysql configuration file, show > variables, Error log file details etc. > > Kirshna > > On Fri, Aug 13, 2010 at 8:36 P

Re: mysql is crashing

2010-08-13 Thread Yectli Huerta
On Sat, Aug 14, 2010 at 12:17:20AM +0530, Krishna Chandra Prajapati wrote: > Hi Yectli, > > I am talking about mysql server. Is it 32bit or 64bit. > > Provide some additional information. mysql configuration file, show > variables, Error log file details etc. > > Kirshna > i provided the trace

Re: mysql is crashing

2010-08-13 Thread Krishna Chandra Prajapati
Hi Yectli, I am talking about mysql server. Is it 32bit or 64bit. Provide some additional information. mysql configuration file, show variables, Error log file details etc. Kirshna On Fri, Aug 13, 2010 at 8:36 PM, Yectli Huerta wrote: > On Fri, Aug 13, 2010 at 04:33:38PM +0530, Krishna Chandr

Mysqld crashes. Stack Trace Attached.

2010-08-13 Thread Garima Lahoti
Hi My mysql server suddenly crashed. Not it does not start and dumps the following stack trace. I suspect some table corruption. Please help me to start it. stack_bottom = (nil) thread_stack 0x4 /usr/sbin/mysqld(my_print_stacktrace+0x24) [0x84fd84] /usr/sbin/mysqld(handle_segfault+0x320) [0x5

Re: mysql is crashing

2010-08-13 Thread Yectli Huerta
On Fri, Aug 13, 2010 at 04:33:38PM +0530, Krishna Chandra Prajapati wrote: > Hi Yectli, > > In mysql configuration file (my.cnf) you have given > > key_buffer_size = 5G > > For 32bit OS it should be less than or equal to 4GB and for 64bit it can be > greater than 4GB. > Reduce the key_buffer_siz

Re: Reg: Migration

2010-08-13 Thread Joerg Bruehe
Hi Kranthi! Kranthi schrieb: > Hi , > > I am migrating the database from mssql server to Mysql.i am getting > problem with newid(),I don't know about newid(),i am using mysql migration > tool kit. > > if anybody knows please help me. > > Ex: > > CREATE TABLE cust > ( > cust_id uniq

RE: Migration

2010-08-13 Thread John Daisley
Hi Lenz, You cannot use UUID() or indeed any other function (with the exception of current_timestamp) as the default value for a column As per the manual at http://dev.mysql.com/doc/refman/5.1/en/create-table.html The DEFAULT clause specifies a default value for a column. With on

Re: mysql is crashing

2010-08-13 Thread Krishna Chandra Prajapati
Hi Yectli, In mysql configuration file (my.cnf) you have given key_buffer_size = 5G For 32bit OS it should be less than or equal to 4GB and for 64bit it can be greater than 4GB. Reduce the key_buffer_size to 3GB and try. _Kirshna On Fri, Aug 13, 2010 at 3:02 AM, Yectli Huerta wrote: > Hello,

RE: Migration

2010-08-13 Thread Kranthi
Hi Lenz, I used UUID() function, I am getting error "Check the manual that corresponds to your mysql server version for the right syntax to use near UUID()". I am using mysql version 5.0.45. DROP TABLE IF EXISTS `AdventureWorks_HumanResources`.`Employee`; CREATE TABLE `AdventureWorks_Huma

Re: Reg: Migration

2010-08-13 Thread Lenz Grimmer
Hi, On 08/13/10 09:34, Kranthi wrote: > I am migrating the database from mssql server to Mysql.i am getting > problem with newid(),I don't know about newid(),i am using mysql migration > tool kit. > > if anybody knows please help me. Would using the UUID() MySQL function work for you

Re: RHEL Auto Start / stop mysql???

2010-08-13 Thread Jaime Crespo Rincón
2010/8/12 Nunzio Daveri : > Hi Guifre, thanks for answering.  I already have mysql installed and works > just > fine, but I did untar and then go to folder and run.  I used what is called > mysql no-install so no yum, rpm etc..  No files in /etc/init.d and no startup > or > services script since

[ANN]VTD-XML 2.9

2010-08-13 Thread jimmy Zhang
VTD-XML 2.9, the next generation XML Processing API for SOA and Cloud computing, has been released. Please visit https://sourceforge.net/projects/vtd-xml/files/ to download the latest version. a.. Strict Conformance a.. VTD-XML now fully conforms to XML namespace 1.0 spec b.. Performan

Reg: Migration

2010-08-13 Thread Kranthi
Hi , I am migrating the database from mssql server to Mysql.i am getting problem with newid(),I don't know about newid(),i am using mysql migration tool kit. if anybody knows please help me. Ex: CREATE TABLE cust ( cust_id uniqueidentifier NOT NULL DEFAULT newid(), company va