Not signed in (Sign In)

Categories

Vanilla 1.1.4 is a product of Lussumo. More Information: Documentation, Community Support.

Help keep Vanilla free:
Welcome Guest!
Want to take part in these discussions? If you have an account, sign in now.
If you don't have an account, apply for one now.

General Support & Troubleshooting: Re-setting the MySQL database

Bottom of Page

1 to 7 of 7

  1.  
    •  
      CommentAuthorercatli
    • CommentTimeMar 14th 2006
     # 1
    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
  2.  # 2
    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.
    • CommentAuthorh4xnoodle
    • CommentTimeMar 14th 2006
     # 3
    Or if you dont have access to that, in your host's control panel, just delete the whole database and then create one again.
    •  
      CommentAuthorMark
    • CommentTimeMar 15th 2006
     # 4
    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.
    •  
      CommentAuthorercatli
    • CommentTimeMar 30th 2006
     # 5
    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.
  6.  # 6
    Thats cuz we're awesome.
    •  
      CommentAuthorMark
    • CommentTimeMar 30th 2006
     # 7
    lol @ mini

1 to 7 of 7

  1.  
Add your comments
    Username Password
  • Format comments as
 
Back to Discussions Top of Page