VZ/TZ Souce/Database setup

[Jinxter]

Hey everyone, I'm a MySQL newb so here goes...

I'm interested in setting up a server from the source and database that was released when VZ/TZ went down for a few friends and myself to play on. I was able to get a PEQ source/database server running following the guide(s), and moved on to the source/DB from VZTZ.

I'm currently having a problem accessing the tables within the VZTZ DB. I sourced the VZTZ DB using

create database vztzdb;
\u vztzdb
source CleanedVZTZ.sql

and this created about 108 tables within the database. Unfortunately, when I try to access these tables via the source code many (if not all) tables don't exist and the launcher fails. I'm pretty sure this is because i didn't source the individual sql files (many of which seem to be found in the player_tables folder), e.g. variables.sql, rule_sets.sql, etc.

Note: Both the variables and rule_sets tables exist within the vztzdb database.

I noticed that when I would source the variables table, for example, that the variables.MYD, variables.MYI, variables.FRM would be created in the "MySQL/Data/vztzdb" folder and this table could now be accessed with the World.exe executable.

My question... If i want to maintain all that is VZTZ, yet I do not have access to these SQL files, is there a way to create these 3 MYI, MYD FRM files for all of the missing tables with just the CleanedVZTZ.sql file?

Or.. does it even matter and I should just source all the player_table SQL files from the PEQ download individually since they would most likely be the same or very similar?

Much Thanks,
Toodles (VZ/TZ and SZ Live)

[Fallinfar]

did you ever get this figured out?

im having the same issues with the database/tables etc but i only started it like 6 hours ago so barely scratched the surface considering it being my first attempt at any server lol!

shit aint easy w/o any experience...he he