Cannot Overwrite MySQL Database

[sabao]

This involves a very long, tragic story revolving around my inability to properly upgrade forum software, but skipping right to the ending, I exported my entire MySQL database and wiped it but now I can't reupload it because I am unable to overwrite my own database.

I suppose I could add everything by hand, but I'm not entirely sure it would be safe, given my knowledge (or lack thereof) of handling the MySQL database.

[Xepher]

I'm not quite clear on your problem. First off, what do you mean by "overwrite"? If you wiped it, there shouldn't be anything to overwrite, and indeed your database looks to be empty of all tables when I check. Secondly, what/where are you trying to reupload it? Are you using the forum's backup/restore, or phpmyadmin, or some other thing?

[sabao]

I was using php MyAdmin at the time, and I had exported the entire database into a zip file before wiping the database. My problem now is whenever I try to reupload the database file, it won't let me, returning the error message that the database 'sabao' already exists (although completely empty), so now I can't seem to reimport what I had exported earlier.

[Xepher]

Hmm... Hard to say without the actual database file. Can you email it to me, or upload it somewhere on your site where I can get it? I'll poke around at it, see if I can get it back into your DB.

[sabao]

http://sabao.xepher.net/localhost.sql.zip

It's a backup from before I had started my cleanout. ^^;

[Xepher]

Okay, it should all be there/working now. I simply unzipped the file, commented out the line at the top that tried to create the database, then dumped it into mysql. I had to do it as an admin (since I don't have your password or anything) so if you run into permission problems or anything, let me know.

[sabao]

It's fixed now. Thanks for the help.