Hello
I am using MYSQL Server version 3.22.27 on a Redhat Linux System. The
question I have is I have created a database with three tables in it. One
of the tables has been populated by data. I later decided I wanted to add a
new column to the already populated table. Can anyone explain or point me
to relevant information about how I can create another table with the new
column and then import the data from the old table. I used mysqldump to
export the data but when I try to use mysqlimport to import the dump file to
the newly created table structure I get the following error:
Can't get stat of '/path/filename'
(Errcode: 2), when using table: tablename
Anyone have any suggestions about reorganizing a table??
John Vaughan
Micro Analysis & Design, Inc.
4900 Pearl East Circle, Suite 201 E
Boulder, CO 80301
303 442-6947
303 442-8274 fax
mailto:[EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
