Stories
Slash Boxes
Comments
NOTE: use Perl; is on undef hiatus. You can read content, but you can't post it. More info will be forthcoming forthcomingly.

All the Perl that's Practical to Extract and Report

use Perl Log In

Log In

[ Create a new account ]

jdavidb (1361)

jdavidb
  (email not shown publicly)
http://voiceofjohn.blogspot.com/

J. David Blackstone has a Bachelor of Science in Computer Science and Engineering and nine years of experience at a wireless telecommunications company, where he learned Perl and never looked back. J. David has an advantage in that he works really hard, he has a passion for writing good software, and he knows many of the world's best Perl programmers.

Journal of jdavidb (1361)

Friday March 14, 2008
10:38 AM

NEVER type DROP DATABASE mysql;

[ #35906 ]

Just don't. It will not be fun. It will be painful. "Pleasant" is not a word you will use to describe the experience.

I kinda tried to keep going hoping that maybe the mysqld server wouldn't notice, or that it would just drop the database I meant to drop instead, but it was too smart for me. Moreover, next I noticed I couldn't restore another database from a dump. And I couldn't even restore my mysql database from a dump off of another user's machine. mysqldumps are intricately tied into that particular database, no matter which database you're backing up and restoring.

So then I realized I'd better back up the one other database that mattered and totally reinstall the server, but of course mysqldump wouldn't work. sigh. :)

Update: Other database (my notes wiki) lost forever. Don't just back up /var/lib/mysql/dbname; you have to back up other files as well. Sigh.

The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.
 Full
 Abbreviated
 Hidden
More | Login | Reply
Loading... please wait.
  • Hopefully you haven't done anything drastic yet...

    The MySQL database is made up of MyISAM tables.

    And, you *should* be able to copy that folder [paragon-cs.com] from another install and then restart MySQL. (correct version [mysql.com], of course)

    However, you will most likely need to start MySQL with --skip-grant-tables.

    That should get you running well enough to dump everything safely and reinstall.

    HTH
    • Thank you. Unfortunately, I've already done something drastic, and it was not the right thing. :(

      Expensive lesson learned. :)

      --
      J. David works really hard, has a passion for writing good software, and knows many of the world's best Perl programmers