Re: Error 1013

2005-12-17 Thread Glennie Vignarajah
Le Saturday 17 December 2005 04:54, Karl Krelove(Karl Krelove <[EMAIL PROTECTED]>) disait: Hello, > LOAD DATA INFILE 'home/karl/Student_List.csv' into table ^^^ > student_list FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES > TERMINATED BY '\n'; > > In response I get: ERROR

Re: Error 1013

2005-12-17 Thread David Logan
Karl Krelove wrote: I'm trying to import a large amount of data from an Access database containing information about 9,000+ students in a school system. I've created a table 'student_list' to hold the data and issued the following command: LOAD DATA INFILE 'home/karl/Student_List.csv' into ta

Re: CPU 100% + crashes ...

2005-12-17 Thread Heikki Tuuri
Dilipan, indeed, there was a race in the printing of thd->query in 4.0.18. But the problem was probably fixed in May 2004. Best regards, Heikki Oracle Corp./Innobase Oy InnoDB - transactions, row level locking, and foreign keys for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB whic

Re: is there any BEEP command ?

2005-12-17 Thread C.R.Vegelin
Thanks Harrison !!! SELECT char(7); works excellent to simulate a BEEP with MySQL version 5.0.15 under Windows XP Pro. It is a simple but effective feature for running scripts. Regards, Cor - Original Message - From: "Harrison Fisk" <[EMAIL PROTECTED]> To: "C.R.Vegelin" <[EMAIL PROTECT

Re: Error 1013

2005-12-17 Thread Karl Krelove
David Logan wrote: Karl Krelove wrote: I'm trying to import a large amount of data from an Access database containing information about 9,000+ students in a school system. I've created a table 'student_list' to hold the data and issued the following command: LOAD DATA INFILE 'home/karl/S

Network login

2005-12-17 Thread Jørn Dahl-Stamnes
I'm trying to access a database over my local network. On the server, I had applied the following commands: shell > mysql -u root -p mysql> GRANT ALL on mydb.* To 'snotface'@'otherhost.mydomain' IDENTIFIED BY 'novice'; From the otherhost.mydomain, I try a: shell> mysql -h [EMAIL PROTECTED] -u

include a field from a table into another table

2005-12-17 Thread Sandy
Hi I have the following tables: CREATE TABLE `livres`( `id` int(10) unsigned NOT NULL auto_increment, `isbn` varchar(12) NOT NULL default '', 'titre' varchar(80) NOT NULL default '', `auteur` int(10) unsigned NOT NULL default '0', `categorie` varchar(60) NOT NULL default '', PRIMARY KEY (

Re: Network login

2005-12-17 Thread SGreen
Jørn Dahl-Stamnes <[EMAIL PROTECTED]> wrote on 12/17/2005 02:12:38 PM: > I'm trying to access a database over my local network. > > On the server, I had applied the following commands: > > shell > mysql -u root -p > mysql> GRANT ALL on mydb.* To 'snotface'@'otherhost.mydomain' IDENTIFIED BY >

Re: include a field from a table into another table

2005-12-17 Thread SGreen
Responses intermixed. See below ... news <[EMAIL PROTECTED]> wrote on 12/17/2005 03:16:48 PM: > Hi > > I have the following tables: > CREATE TABLE `livres`( > `id` int(10) unsigned NOT NULL auto_increment, > `isbn` varchar(12) NOT NULL default '', > 'titre' varchar(80) NOT NULL default '',

Re: Error 1013

2005-12-17 Thread David Logan
Karl Krelove wrote: David Logan wrote: Karl Krelove wrote: I'm trying to import a large amount of data from an Access database containing information about 9,000+ students in a school system. I've created a table 'student_list' to hold the data and issued the following command: LOAD DA

Re: Network login

2005-12-17 Thread Jørn Dahl-Stamnes
On Saturday 17 December 2005 21:43, [EMAIL PROTECTED] wrote: > I think the most likely culprit will be an unexpected reverse DNS result. > Here are the other likely reasons to get an access denied error: > http://dev.mysql.com/doc/refman/4.1/en/access-denied.html > > To the server, does the machine