Go Back   EQEmulator Home > EQEmulator Forums > Support > Support::Windows Servers

Support::Windows Servers Support forum for Windows EQEMu users.

Reply
 
Thread Tools Display Modes
  #1  
Old 02-13-2021, 10:41 AM
Zandig's Avatar
Zandig
Hill Giant
 
Join Date: Jun 2006
Location: New York City
Posts: 180
Default Backing up database player tables with perl eqemu_server.pl ?

Using the Perl script: perl eqemu_server.pl
and selecting --> database --> backup_player_tables

creates a full backup of the database, which is the same size and number of lines as creating a database backup using -- backup_database.

I've noticed that the file ' character_table_list.txt ' when created is an empty/0 byte file

Code:
Enter a command #> backup_player_tables
[Update] No script update necessary...
[Database] Performing database backup of player tables....
[Download] Saved [backups/character_table_list.txt] from [https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/character_table_list.txt]
Is the file missing from the Github?
It would seem the command: backup_player_tables
would just backup the player tables unless I'm getting confused here ?
Reply With Quote
  #2  
Old 02-17-2021, 12:08 PM
Zandig's Avatar
Zandig
Hill Giant
 
Join Date: Jun 2006
Location: New York City
Posts: 180
Default

Looked into this a bit further inside the eqemu_server.pl file, at this particular section:

Code:
sub database_dump_player_tables
{
    check_for_database_dump_script();
    print "[Database] Performing database backup of player tables....\n";
    get_remote_file($eqemu_repository_request_url . "utils/sql/character_table_list.txt",
        "backups/character_table_list.txt");

    $tables = "";
    open(FILE, "backups/character_table_list.txt");
    $i = 0;
    while (<FILE>) {
        chomp;
        $o      = $_;
        $tables .= $o . ",";
    }
    $tables = substr($tables, 0, -1);

    print `perl database_dumper.pl database="$db" loc="backups" tables="$tables" backup_name="player_tables_export" nolock`;

    print "[Database] Press any key to continue...\n";
The file "character_table_list.txt" is not being found or is empty at the URL:
"https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/character_table_list.txt"
and is therefore creating an empty file which in turn backs up the entire database.

The solution for now is to back up your player tables manually until the character_table_list.txt file is available.
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 09:00 AM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3