UBB.Developers Forums UBB.threads 7 Development How Do I? MySQL Import trouble

okay,
going crazy at this point. i'm moving my forums to a hosted server for bandwidth reasons, and right now i have everything working, -except- i can;t get my wwwthreads dump imported into mysql. going crazy.
( create the database, blank, haven't done a thing, and i get)

bash$ mysql whaleweb_WWWThreads < WWWThreads.dump
ERROR 1146 at line 21: Table 'whaleweb_WWWThreads.w3t_AddressBook' doesn't exist
(okay, so then, i figure, i'll just use createtable.pl, and try again..)
i get:
ERROR 1050 at line 11: Table 'w3t_addressbook' already exists

am i doing something wrong? i'm confused what i should do, ideas?
Thanks.
Keet

Okay, worked on it some more, and still, having the same trouble, some more info:
currently running windows 2000 and w3t 5.1.5 Perl, i downloaded the 5.2-5.3, mady a copy of my current version, and ran it, did a dump to a file, then restored the original on my server, and uploaded the w3t.dump over to the other server, where i've installed 5.3PHP version, works well and fine when i just use createtable and start from scratch, but i'm moving my users and stuff over, and need to import the databases. i've tried even using -f in mysql to force it to overwrite existing keys or whatever, but i'm still having no luck.. :o(

Howdy.

This may or may not help, but check out Importing and exporting your database.

If you're missing a step here and there, this may be of some help.

One thing: Unless I read it wrong, you're running your createtable. You don't do this at all when you're importing. To import, you simply create your database (using mysqladmin create databasename) and run your GRANT statements, and that's it. Don't mess with the createtable at all if you're importing.

Hope this helps.



[]/testimages/icons/smile.gif[/] 6 []/testimages/icons/frown.gif[/]
Screamers

nope, i'm just creating a fresh database, adding the user, and thats it, []/testimages/icons/frown.gif[/]
i dunno what do to at this point..

It almost looks like you are getting case sensitive stuff going on here because of the 2 different cases of w3t_Addressbook, unless that's just a typo.

What you can try doing is doing a fresh database and then import with the mysql wwwthreads < WWWThreads.dump. Then if you get an error stating a table doesn't exist, go into your mysql command prompt and do SHOW TABLES; to get a list of tables that currently exist.

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..