Sorry for not getting back to you with this, have been busy with work and stuff.. anyway, i went in a ran the command, and get..
bash$ mysql whaleweb_WWWThreads < WWWThreads.dump -p
Enter password:
ERROR 1146 at line 21: Table 'whaleweb_WWWThreads.w3t_AddressBook' doesn't exist
bash$ mysql whaleweb_WWWThreads -p
Enter 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 21222 to server version: 3.23.32
Type 'help;' or '\h' for help. Type '\c' to clear the buffer
mysql> SHOW TABLES;
+-------------------------------+
| Tables_in_whaleweb_WWWThreads |
+-------------------------------+
| w3t_addressbook |
+-------------------------------+
1 row in set (0.00 sec)
mysql>
okay, so. the tables.. um, looking at them, i notice the differnt cases, i know unix is case sensitive, but is MySQL?
hmm.. the only solution i can think of would be. (eek) to try and editing my dump with a text editor and changing the case to match?
um.. (5am, not thinking well, lol) []/testimages/icons/wink.gif[/]
and i get the same error, either way, if i do a.
Fresh database>adduser> import> "error of "table_blah doesn't exist"
Fresh database>adduser> run createtable>imporrt> "table_blah already exists"
*scratches head and ponders*
well, your turn. heh. lemme know what you think..