Thread: PI | MySQL Backup Handler | Will save the character file online!

this is pointless lol. why don't you just parse player details from sql? instead of writing text files to sql for backup purposes.

Originally Posted by Dondxon

Can you leave those useless reply's away?

How is my reply rendered "useless"? A more efficient way of handling backups would be to parse all the player details from SQL. Then each time a player logs out, make the server create a new record for the save based on the logout time. This way, you could just export all the ACTUAL saves from a certain date instead of exporting text files from a redundant database.

Originally Posted by LT Smith

How is my reply rendered "useless"? A more efficient way of handling backups would be to parse all the player details from SQL. Then each time a player logs out, make the server create a new record for the save based on the logout time. This way, you could just export all the ACTUAL saves from a certain date instead of exporting text files from a redundant database.

Or you could use a database the correct way and just have a cron job back it up to say amazon e3 every day.


OT

Code:

try(PreparedStatement ps = connection.prepareStatement("insert into backups(username, backup) values(?, ?)")) {
    ps.setString(1, player.username);
    ps.setString(2, FileUtils.readFileAsString(new File("/characters/" + player.username + ".txt"));
    ps.execute();
}

written in rely box and you want to charge people for it?