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 13

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

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

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 PROTECTED]

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

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 'novice';

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

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 you