Jinxter
08-10-2009, 06:18 PM
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)
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)