Vanilla 1 is no longer supported or maintained. If you need a copy, you can get it here.
HackerOne users: Testing against this community violates our program's Terms of Service and will result in your bounty being denied.

Re-setting the MySQL database

edited March 2006 in Vanilla 1.0 Help
I am new to Vanilla. I installed and started setting up and fiddling around. Unfortunately, I pressed the wrong button when fiddling around with some of the admin options, and wiped myself out as administrator. Thus I couldn't re-set as I no longer had access to that section of admin. No worries, I thought, since I'm just learning the ropes, I'll just trash the uploaded files and upload the original ones again. But now Vanilla won't re-install because it says I'm trying to change the DB, which it won't allow. (Clearly, trashing all the uploaded files didn't trash the DB.) Does anyone know what I should do please? I have lost no data, as I had barely started, but I do want to be able to re-install. Thanks


  • If youre doing a reinstall (since you've already deleted the files), just go into your database using your chosen DB administration app (phpmyadmin or some such) and delete the lum_ tables. Then the install script should run fine.
  • Or if you dont have access to that, in your host's control panel, just delete the whole database and then create one again.
  • MarkMark Vanilla Staff
    Or if you do have access to a command prompt on your server, you can drop the database like this:

    mysql -u your_username -p Enter Password: ********* mysql> drop database your_database_name; Query OK, 0 rows affected (0.02 sec) mysql> quit bye

    Then go back and run the installer again and it will re-create the database for you.
  • Hey guys, it took my a while to get back to it, but that was helpful. Mark, I used your suggestion, and minisweeper, I downloaded phpmyadmin, which I wasn't aware of before, in case I need it later. I really LOVE how the online community, including this one, is so helpful.
  • Thats cuz we're awesome.
  • MarkMark Vanilla Staff
    lol @ mini
This discussion has been closed.