Announcement

Collapse
No announcement yet.

mysql table.

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • mysql table.

    Humm, I did something stupid. I set up VB on top of my other mysql database, which was fully populated. no data has been lost, but I now have loads of empty or uneeded table (the VB ones, as its now got its own database) I need to "uninstall" Vb form the database, but leave 'sessions' alone as its used by my other php script, hence why Vb has its own DB. Is there anyway of doing this without having to get a list of the VB tables and deleting each one?
    Last edited by Shadow_Xj5; Thu 22 Mar '01, 2:57pm.

  • #2
    MySQL command:
    drop table access; drop table adminlog; drop table announcement; drop table attachment; drop table avatar; drop table bbcode; drop table calendar_events; drop table customavatar; drop table forum; drop table forumpermission; drop table icon; drop table moderator; drop table poll; drop table pollvote; drop table post; drop table privatemessage; drop table profilefield; drop table replacement; drop table replacementset; drop table search; drop table searchindex; drop table setting; drop table settinggroup; drop table smilie; drop table style; drop table subscribeforum; drop table subscribethread; drop table template; drop table templateset; drop table thread; drop table threadrate; drop table user; drop table userfield; drop table usergroup; drop table userfield; drop table word;

    Have fun. (I left session off for ya.)

    Comment


    • #3
      Thank you, your a life saver.. well a database saver .

      Thanks again.

      Comment

      Related Topics

      Collapse

      Working...
      X