Announcement

Collapse
No announcement yet.

Mysql table list for vb 2.2.6

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

  • Mysql table list for vb 2.2.6

    I run a script to backuo my forum database every now and then. I used a backup from that to move the forum to a new server but it seems I missed some of the tables and I'm getting errors. Perhaps someone could post a list of tables that should be in place for version 2.2.6?

    Of course the number of installed hacks will influence the tables but I would like to verify that I have all the standard tables in place. Currently I have the following..

    access
    adminlog
    <NOBR>announcement</NOBR>
    <NOBR>attachment</NOBR>
    <NOBR>avatar</NOBR>
    <NOBR>bbcode</NOBR>
    <NOBR>calendar_events</NOBR>
    <NOBR>customavatar</NOBR>
    <NOBR>forum</NOBR>
    <NOBR>forumpermission</NOBR>
    <NOBR>icon</NOBR>
    <NOBR>moderator</NOBR>
    <NOBR>poll</NOBR>
    <NOBR>pollvote</NOBR>
    <NOBR>post</NOBR>
    <NOBR>privatemessage</NOBR>
    <NOBR>profilefield</NOBR>
    <NOBR>replacement</NOBR>
    <NOBR>replacementset</NOBR>
    <NOBR>search</NOBR>
    <NOBR>searchindex</NOBR>
    <NOBR>session</NOBR>
    <NOBR>setting</NOBR>
    <NOBR>settinggroup</NOBR>
    <NOBR>smilie</NOBR>
    <NOBR>stars</NOBR>
    <NOBR>style</NOBR>
    <NOBR>subscribeforum</NOBR>
    <NOBR>subscribethread</NOBR>
    <NOBR>template</NOBR>
    <NOBR>templateset</NOBR>
    <NOBR>thread</NOBR>
    <NOBR>threadrate</NOBR>
    <NOBR>user</NOBR>
    <NOBR>useractivation</NOBR>
    <NOBR>userfield</NOBR>
    <NOBR>usergroup</NOBR>
    <NOBR>usertitle</NOBR>
    <NOBR>vbstats_counter</NOBR>
    <NOBR>vbstats_countries</NOBR>
    <NOBR>vbstats_date</NOBR>
    <NOBR>vbstats_exclude</NOBR>
    <NOBR>vbstats_options</NOBR>
    <NOBR>vbstats_referrer</NOBR>
    <NOBR>word</NOBR>
    Last edited by numerodix; Sat 7 Dec '02, 6:53am.

  • #2
    Originally posted by numerodix
    I run a script to backuo my forum database every now and then. I used a backup from that to move the forum to a new server but it seems I missed some of the tables and I'm getting errors. Perhaps someone could post a list of tables that should be in place for version 2.2.6?

    Of course the number of installed hacks will influence the tables but I would like to verify that I have all the standard tables in place. Currently I have the following..

    access
    adminlog
    <NOBR>announcement</NOBR>
    <NOBR>attachment</NOBR>
    <NOBR>avatar</NOBR>
    <NOBR>bbcode</NOBR>
    <NOBR>calendar_events</NOBR>
    <NOBR>customavatar</NOBR>
    <NOBR>forum</NOBR>
    <NOBR>forumpermission</NOBR>
    <NOBR>icon</NOBR>
    <NOBR>moderator</NOBR>
    <NOBR>poll</NOBR>
    <NOBR>pollvote</NOBR>
    <NOBR>post</NOBR>
    <NOBR>privatemessage</NOBR>
    <NOBR>profilefield</NOBR>
    <NOBR>replacement</NOBR>
    <NOBR>replacementset</NOBR>
    <NOBR>search</NOBR>
    <NOBR>searchindex</NOBR>
    <NOBR>session</NOBR>
    <NOBR>setting</NOBR>
    <NOBR>settinggroup</NOBR>
    <NOBR>smilie</NOBR>
    <NOBR>stars</NOBR>
    <NOBR>style</NOBR>
    <NOBR>subscribeforum</NOBR>
    <NOBR>subscribethread</NOBR>
    <NOBR>template</NOBR>
    <NOBR>templateset</NOBR>
    <NOBR>thread</NOBR>
    <NOBR>threadrate</NOBR>
    <NOBR>user</NOBR>
    <NOBR>useractivation</NOBR>
    <NOBR>userfield</NOBR>
    <NOBR>usergroup</NOBR>
    <NOBR>usertitle</NOBR>
    <NOBR>vbstats_counter</NOBR>
    <NOBR>vbstats_countries</NOBR>
    <NOBR>vbstats_date</NOBR>
    <NOBR>vbstats_exclude</NOBR>
    <NOBR>vbstats_options</NOBR>
    <NOBR>vbstats_referrer</NOBR>
    <NOBR>word</NOBR>
    I don't see anything missing, although I have a table called adminutil, not sure if that was added in a hack or not.

    The problem could be that the table didn't backup properly. How do you do backups, from the admin cp or do you do mySQL dumps?

    Comment


    • #3
      mysqldumps

      Comment

      Loading...
      Working...
      X