Foreign Keys

2008-08-23 Thread Steffan A. Cline
I am hoping for a little clarification/education here. My understanding of how foreign keys work is very minimal. In using MySQL for the last several years as a backend to web apps I have always managed relationships amongst the tables with auto increment primary keys myself. I have a new projec

Language - MySQL connection collation

2008-08-23 Thread Nanu Kalmanovitz
Hi! I just upgraded from 4.0.26 to 4.1.22. On phpMyAdmin with the older (4.0.26) was only one field for "Language" and it was set to "Hebrew (he-iso-8859-i)". Now, upgrading (4.1.22) in the "Language" field appears "Hebrew (he-utf-8)" and a new field " MySQL connection collation:" offer 2 possibi

בעניין: Re: mysqldump questions

2008-08-23 Thread Nanu Kalmanovitz
Thanks! Nanu >>> <[EMAIL PROTECTED]> 23/08/2008 09:50:13 >>> Whatever you name it Wherever you place it Mysqldump (options) > filename -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

mysqld hangs

2008-08-23 Thread Andreas Andersen
Hi, I'm running a server on FreeBSD 6.3 (prerelease) with mysql server and client 4.1.22. The server is hosting several websites running Joomla. Recently the mysql server has started hanging (perhaps 3-5 times a week) with a load (top) above 95%. Nothing shows up in /var/log/messages or dmesg nor