Importing Large Files Into MySQL?

2002-10-17 Thread Erica Douglass
Hi! I have three large files containing MySQL commands. However, when importing them using mysql -u [username] -p [database] < file.sql, I get an error: ERROR 2006 at line xxx: MySQL server has gone away >From reading more at mysql.com, it seems that MySQL reads these large packets as errors on

Importing fixed-width delimited large text files?

2001-11-01 Thread Erica Douglass
I have a text file that is fixed-width delimited (that is, fields are delimited by certain column widths.) I have encountered the problem listed in the manual entry for LOAD DATA INFILE as: Fixed-size rows (FIELDS TERMINATED BY and FIELDS ENCLOSED BY both empty) and BLOB or TEXT columns. Basi

RE: User Permissions Issue (Easy questions?)

2001-10-01 Thread Erica Douglass
Thank you so much! That worked. *big sigh of relief* Erica > -Original Message- > From: Carsten H. Pedersen [mailto:[EMAIL PROTECTED]] > Sent: Monday, October 01, 2001 12:48 PM > To: Erica Douglass > Subject: RE: User Permissions Issue (Easy questions?) > >

User Permissions Issue (Easy questions?)

2001-10-01 Thread Erica Douglass
Hi, I am working with an internal database. We add a user using the following statements: create database name_of_database; GRANT alter, create, delete, drop, insert, select, update, index ON name_of_database TO username@localhost identified by "password" with grant option; GRANT alter, create