Xepher.Net Forums

Xepher.net => Technical Support => Topic started by: sabao on December 16, 2006, 03:26:07 PM

Title: Cannot Overwrite MySQL Database
Post by: sabao on December 16, 2006, 03:26:07 PM
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.
Title: Cannot Overwrite MySQL Database
Post by: Xepher on December 16, 2006, 07:43:49 PM
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?
Title: Cannot Overwrite MySQL Database
Post by: sabao on December 17, 2006, 05:24:20 AM
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.
Title: Cannot Overwrite MySQL Database
Post by: Xepher on December 17, 2006, 07:37:33 PM
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.
Title: Cannot Overwrite MySQL Database
Post by: sabao on December 17, 2006, 09:02:43 PM
http://sabao.xepher.net/localhost.sql.zip

It's a backup from before I had started my cleanout. ^^;
Title: Cannot Overwrite MySQL Database
Post by: Xepher on December 18, 2006, 07:09:13 AM
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.
Title: Cannot Overwrite MySQL Database
Post by: sabao on December 18, 2006, 08:31:36 AM
It's fixed now. Thanks for the help. :)