Re-setting the MySQL database

ercatli

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

Minisweeper

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.

h4xnoodle

Or if you dont have access to that, in your host's control panel, just delete the whole database and then create one again.

Mark

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.

ercatli

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.

Minisweeper

Thats cuz we're awesome.

Mark

lol @ mini