Ide, Jim writes:
>
> Pentium III 667 mhz, 256mb ram, 20 gb hd
> OpenBSD 2.7
> MySQL 3.22.32 (installed with pkg_add mysql-3.22.32.tgz)
> started with:
> safe_mysqld --user=mysql > /dev/null &
>
> I have several text files that look like this:
> use mydb;
> create table mytable (
> (field defs)
> );
>
> I run:
> mysql < file.sql
>
> Then I run:
> mysql mydb
>
> mysql displays:
> Reading table information for completion of table and column names
> You can turn off this feature to get a quicker startup with -A
>
> Didn't find any fields in table 'table1'
> Didn't find any fields in table 'table2'
> Didn't find any fields in table 'table3'
> Didn't find any fields in table 'table4'
> Didn't find any fields in table 'table5'
> Didn't find any fields in table 'table6'
> Didn't find any fields in table 'table7'
> Welcome to the MySQL monitor. Commands end with ; or \g.
> Your MySQL connection id is 28 to server version: 3.22.32
>
> Type 'help' for help.
>
> mysql>
>
> When I go to the data directory and type
> ls -l *.ISD
> many of the *.ISD files are zero length.
>
> Why am I using OpenBSD 2.7? Because MySQL doesn't work on OpenBSD 2.8
> because of a bug in OpenBSD (http://www.mysql.com/doc/O/p/OpenBSD_2.8.html)
>
> Please help!
> Thanks -
> Jim
>
Hi!
The above can not work on any system.
create table mytable (
(field defs)
);
This will cause parsing error on any system.
If the aobve is just an abbreviation, then you have most probably a
permission problem.
Regards,
Sinisa
____ __ _____ _____ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____
^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^
/*/ \*\ Developers Team
---------------------------------------------------------------------
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