Re: Mysql 4.1.13 Problems

2005-08-16 Thread Peter Nikolic
On Tuesday 09 August 2005 08:17, Gleb Paharenko wrote:
 Hello.

  I have noticed that since the update i have multiple instances of mysql
  running which seem to be causing the problem ps uax output below

 I usually see a lot of mysqld processes (these are
 just different threads of the same process), and I don't see anything
 wrong with it:

 [EMAIL PROTECTED] gleb]$ ps uax |grep gleb |grep mysqld |wc -l
 23

  4.1.13 from the Mysql site   however since the upgrade i have been having
  problems trying to write lines in tables .

 Could you provide more information about this problem?

 Peter Nikolic [EMAIL PROTECTED] wrote:
snip

 --
 For technical support contracts, goto https://order.mysql.com/?ref=ensita
 This email is sponsored by Ensita.NET http://www.ensita.net/
__  ___ ___   __
   /  |/  /_ __/ __/ __ \/ /Gleb Paharenko
  / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
 /_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
___/   www.mysql.com

Hi  .

 sorry bout the delay replying have been rather busy  on a car rally 

Right i think i have solved the problem i was having by completely deleting 
all mysql instances and all files associated with it and re-installing  
4.1.13 , I still have the multiple instances that i never used to get on the 
version supplied by Suse out of the box but that was never stable for me .

For now 4.1.13 is running and seems ok i have anothetr problem now but that is 
comming in a seperat mail to the list 

Thanks  
pete .
  

-- 
If Bill Gates had gotten LAID at High School do YOU think there would be a 
Microsoft  ?   Of course NOT ! 

You gotta spend a lot of time at your school Locker stuffing underware up
your ass  to think , I am going to take on the worlds Computer Industry

---:heard on Cyber Radio.:---




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



now i am getting confused (i could not think of a better title)

2005-08-16 Thread Peter Nikolic
Hi folks 

I have several small data bases running on mysql 4.1.13 no problem brought a 
book read it yes well 

i have a data base consisting of 3 tables  , radios , users , events

radios contains 4 fields   csgn , setid , sernum cmmnts. this is populated and 
is more a lookup table for the radio info 

then there is events this contains 5 fieldsevnt , eloc , edate , 
cllct_date  , rtn_date 

and lastly  users  this contains 6 fields sur_nme , fr_name , ph_w , 
ph_h , ph_m , addrss

Using knoda (part of kde) i have created an form that looks all very nice (to 
me )  the selection of the radio works  enters the right info into the form 
i can enter users data  and event data but when i try to save the data and 
insert a new row i am unable to  my question is 

How do i go about saving data to multiple tables from one entry form or should 
this happen automatically  

The book i purchased Beggining SQL i did not find any help at all  i could 
not find anything on mysql in my local store or a bit further out 

any help pointers much appreaceted 


Thanks Pete .
  
-- 
If Bill Gates had gotten LAID at High School do YOU think there would be a 
Microsoft  ?   Of course NOT ! 

You gotta spend a lot of time at your school Locker stuffing underware up
your ass  to think , I am going to take on the worlds Computer Industry

---:heard on Cyber Radio.:---




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Mysql 4.1.13 Problems

2005-08-07 Thread Peter Nikolic
Hi 

I am newish to Mysql  i recently upgraded my install on suse 9.2 to version 
4.1.13 from the Mysql site   however since the upgrade i have been having 
problems trying to write lines in tables .

I have noticed that since the update i have multiple instances of mysql 
running which seem to be causing the problem ps uax output below 

 root  5368  0.0  0.1  2592 1252 pts/3S19:16   
0:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql 
--pid-file=/var/lib/mysql/ds9.pid
mysql 5401  5.0  1.2 40152 12576 pts/3   S19:16   
0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql 
--pid-file=/var/lib/mysql/ds9.pid --skip-locking --port=3306 --socket=/
mysql 5402  0.0  1.2 40152 12576 pts/3   S19:16   
0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql 
--pid-file=/var/lib/mysql/ds9.pid --skip-locking --port=3306 --socket=/
mysql 5404  0.0  1.2 40152 12576 pts/3   S19:16   
0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql 
--pid-file=/var/lib/mysql/ds9.pid --skip-locking --port=3306 --socket=/
mysql 5405  0.0  1.2 40152 12576 pts/3   S19:16   
0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql 
--pid-file=/var/lib/mysql/ds9.pid --skip-locking --port=3306 --socket=/
mysql 5406  0.0  1.2 40152 12576 pts/3   S19:16   
0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql 
--pid-file=/var/lib/mysql/ds9.pid --skip-locking --port=3306 --socket=/
mysql 5407  0.0  1.2 40152 12576 pts/3   S19:16   
0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql 
--pid-file=/var/lib/mysql/ds9.pid --skip-locking --port=3306 --socket=/
mysql 5411  0.0  1.2 40152 12576 pts/3   S19:16   
0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql 
--pid-file=/var/lib/mysql/ds9.pid --skip-locking --port=3306 --socket=/
mysql 5412  0.0  1.2 40152 12576 pts/3   S19:16   
0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql 
--pid-file=/var/lib/mysql/ds9.pid --skip-locking --port=3306 --socket=/
mysql 5413  0.0  1.2 40152 12576 pts/3   S19:16   
0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql 
--pid-file=/var/lib/mysql/ds9.pid --skip-locking --port=3306 --socket=/
mysql 5414  0.0  1.2 40152 12576 pts/3   S19:16   
0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql 
--pid-file=/var/lib/mysql/ds9.pid --skip-locking --port=3306 --socket=/

My question is how do i get back to the state of just one instance of mysql 
running as everything worked ok then ..

Thanks in advance   Pete .

-- 
If Bill Gates had gotten LAID at High School do YOU think there would be a 
Microsoft  ?   Of course NOT ! 

You gotta spend a lot of time at your school Locker stuffing underware up
your ass  to think , I am going to take on the worlds Computer Industry

---:heard on Cyber Radio.:---




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]