Revert using Binlog

2006-01-29 Thread Rob Gormley
Am hoping someone can give me the safest advice here. Using 4.1 and InnoDB, someone in an attempt to be helpful set up a lot of foreign key constraints. However... ON DELETE CASCADE When we needed RESTRICT. Net effect? Some editing today lead to cries of "Where has half the data gone?" We have

Re: MySQL ignores foreign key relationships between tables?

2006-01-29 Thread Paul DuBois
At 18:03 -0500 1/29/06, Ferindo Middleton Jr wrote: Ferindo Middleton Jr wrote: Ferindo Middleton Jr wrote: Paul DuBois wrote: At 17:56 -0500 1/28/06, Ferindo Middleton Jr wrote: I have two tables, registration & schedules, that look like this: CREATE TABLE registration (

Can't reload from dump file

2006-01-29 Thread Chris Mason (Lists)
We have had some problems with corrupt data due to running out of space recently. I wanted to repair the tables so I backed up our database by dumping to a file with mysqldump. I then tried to repair the database and had some problems with that. I stopped MySQL and moved the database to database

Re: MySQL ignores foreign key relationships between tables?

2006-01-29 Thread Ferindo Middleton Jr
Ferindo Middleton Jr wrote: Ferindo Middleton Jr wrote: Paul DuBois wrote: At 17:56 -0500 1/28/06, Ferindo Middleton Jr wrote: I have two tables, registration & schedules, that look like this: CREATE TABLE registration ( idSERIAL NOT NULL UNIQUE,

Re: display a hierarchic tree

2006-01-29 Thread mysql
Hi Jochen. An alternative approach could be to pull all the values out of the database using select * from ..., and then build the tree-structure in your application logic. Insert the relevant values returned from mysql in the appropriate places of the tree-structure in the app code. Keith

Re: Support between MySQL and PHP

2006-01-29 Thread mysql
Hi Philip. I'm wondering if you have mysql server version 3.23.49 still running on your machine? If so, version 5 would not start up, as it would not be allowed access to port 3306. Try doing my_print_defaults mysqld and my_print_defaults client mysql from a root shell and see what values y

Re: display a hierarchic tree

2006-01-29 Thread Peter Brawley
Jochen, ...I want to display a tree like: Software Virenscanner Linux Debian Woody Windows Windowsd XP Packprogramm Sniffer Hardware Vermischtes It looks more like a parts

display a hierarchic tree

2006-01-29 Thread Jochen Kaechelin
I have the following table: mysql> select * from link_categories; ++---+-+---+---+-+ | id | level | category_id | category | parent_id | deleted | ++---+-+---+---+-+ | 1 | 1 |1000 | So

Support between MySQL and PHP

2006-01-29 Thread Philip R. Thompson
Hi all. I figured this question was suitable for both the MySQL list and the PHP-General list. Here's what I'm running into. I just installed MySQL5 and currently have PHP 4.3.11 installed. I am wanting to connect to the mysql database on localhost, but I get the following results: --

Help on query joining a 3rd table

2006-01-29 Thread pedro mpa
Solved. Thanks. -Mensagem original- De: pedro mpa [mailto:[EMAIL PROTECTED] Enviada: domingo, 29 de Janeiro de 2006 18:25 Para: mysql@lists.mysql.com Assunto: Help on query joining a 3rd table Hello! I am building a query to get a monthly total for receipts and receipts plus TAX. My p

Help on query joining a 3rd table

2006-01-29 Thread pedro mpa
Hello! I am building a query to get a monthly total for receipts and receipts plus TAX. My problem is the TAX, it can be different for each receipt. I need help on including and relating each TAX value/id with each receipt, like receipt_items.price * 1.21 etc. The tables are like the following ex

default characterset of function string parameter

2006-01-29 Thread Hirofumi Fujiwara
Dear MySQL fans, I am checking MySQL 5.0 to use multibyte strings, Japanese. When I use char type parameter without CHARACTER SET clause, parameter's character set is not the database character set but latin1. 17.2.1. CREATE PROCEDURE says: For character data types, if there is a CHARACTER S