RE: sql or import file

2003-03-21 Thread Paul Larue
its a flat file with the ext .sql I just didn't want to spend the next 8 hours cutting and pasting :) Andrew >-Original Message----- >From: Paul Larue [mailto:[EMAIL PROTECTED] >Sent: 21 March 2003 23:46 >To: [EMAIL PROTECTED] >Subject: RE: sql or import file > > >

RE: images with mysql

2003-03-21 Thread Paul Larue
Don't forget that the images can be stored *outside* the root dir. Access them using ../../ until you reach your img dir. There's no way to get to the images directly then. Paul -Original Message- From: lasse [mailto:[EMAIL PROTECTED] Sent: Friday, March 21, 2003 12:14 AM To: unlisted-rec

[MySQL] InnoDB - Updating a parent table won't update the child table

2003-03-17 Thread Paul Larue
Hi all, I created 2 tables in MySQl with the following statements == CREATE TABLE employees ( emp_id INT NOT NULL AUTO_INCREMENT, emp_last_name TINYTEXT NOT NULL, emp_first_name TINYTEXT NOT NULL, emp_nick_name TINYTEXT

MySQL Client on Linux won't connect to MySQL Server on XP

2003-03-10 Thread Paul Larue
Hi all, I got MySQL 3.23.55-nt running on XP and MySQL Client 3.23.36 running on Linux Red Hat 7. I'm trying to have the client connect to the server but I get the same error all the time: [EMAIL PROTECTED] /root]# mysql -h 10.0.0.41 -u guest ERROR 1130: Host '10.0.0.220' is not allowed to connect

startingMySQL with InnoDB on Red Hat

2003-02-25 Thread Paul Larue
Hi All, I'm quite a novice with Mysql and more than a newbee with Linux but I managed to install Red Hat on an x86 and installed MySQl too. Now I need to have InnoDB support. I installed MySQl on my notebook too (winxp) and edited my.cnf to start innodb and set all the required params. I use my not