View Single Post
Old 04-29-2004, 10:20 PM   #2 (permalink)
redhead
Newbie
 
redhead's Avatar
 
Join Date: Jun 2002
Location: Denmark
Posts: 1,726
redhead is on a distinguished road
I havn't tried phpopenchat, but the error you're getting is because you didn't tell mysqladmin that you wanted the 'poc' created in the "tablespace" database.
Then just do it the old fasion way..
Code:
~> mysql -u root -p tablespace
 Enter password: ********* # roots password
 Reading table information for completion of table and column names
 You can turn off this feature to get a quicker startup with -A

 Welcome to the MySQL monitor.  Commands end with ; or \g.
 Your MySQL connection id is 12707 to server version: 3.23.49-log

 Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

 mysql> CREATE TABLE poc ( id INT DEFAULT '0' NOT NULL ); # What ever poc should be holding
 Query OK, 0 rows affected (0.10 sec)
 mysql> quit;
 Bye
~>
But that would require you to know exactly which columns this 'poc' should take care of, itg should be listed in the database dump filed that came with phpopenchat, altho if this is the case, 'poc' should have been created when you told mysql to read that file as your "tablespace" design.
__________________
Don't worry Ma'am, We're university students, We know what We're doing.
-----
If you pull the pin, Mr.Grenade would no longer be your friend.
-----
01000111 01101111 00100000 01000011 00100000 00100001
redhead is offline   Reply With Quote