Help backup manager for l2j server

[GoldenNightmare]

hello guys this is extreme useful for servers but got a problem not working please help to make it work

 

package com.l2jserver.gameserver.backupManager;

import java.io.BufferedReader;
import java.io.File;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.InputStream;
import java.io.InputStreamReader;
import java.io.OutputStream;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.zip.ZipEntry;
import java.util.zip.ZipOutputStream;

import org.slf4j.Logger;
import org.slf4j.LoggerFactory;

import com.l2jserver.Config;
import com.l2jserver.gameserver.ThreadPoolManager;
import com.l2jserver.gameserver.backupManager.runnable.BackUpManagerTask;

public final class DatabaseBackupManager
{
	private static final Logger _log = LoggerFactory.getLogger(DatabaseBackupManager.class);
	
	public DatabaseBackupManager()
	{
	}
	
	@SuppressWarnings("resource")
	public static void makeBackup()
	{
		_log.info("Initializing Database Backup Manager.");
		
		File f = new File(Config.DATABASE_BACKUP_SAVE_PATH);
		if ((!f.mkdirs()) && (!f.exists()))
		{
			_log.info("Could not create folder " + f.getAbsolutePath());
			return;
		}
		
		Process run = null;
		try
		{
			run = Runtime.getRuntime().exec(Config.DATABASE_BACKUP_MYSQLDUMP_PATH + "/mysqldump --user=" + Config.DATABASE_LOGIN + " --password=" + Config.DATABASE_PASSWORD + " --compact --complete-insert --default-character-set=utf8 --extended-insert --lock-tables --quick --skip-triggers "
				+ Config.DATABASE_BACKUP_DATABASE_NAME, null);
		}
		catch (Exception e)
		{
			_log.error(DatabaseBackupManager.class.getSimpleName() + ": Could not make backup: " + e.getMessage(), e);
			return;
		}
		
		try
		{
			SimpleDateFormat sdf = new SimpleDateFormat("dd-MM-yyyy_HH-mm-ss");
			Date time = new Date();
			
			File bf = new File(f, sdf.format(time) + (Config.DATABASE_BACKUP_COMPRESSION ? ".zip" : ".sql"));
			if (!bf.createNewFile())
			{
				throw new IOException("Cannot create backup file: " + bf.getCanonicalPath());
			}
			InputStream input = run.getInputStream();
			OutputStream out = new FileOutputStream(bf);
			if (Config.DATABASE_BACKUP_COMPRESSION)
			{
				ZipOutputStream dflt = new ZipOutputStream(out);
				dflt.setMethod(8);
				dflt.setLevel(9);
				dflt.setComment("L2Server Schema Backup Utility\r\n\r\nBackup date: " + new SimpleDateFormat("dd-MM-yyyy_HH-mm-ss:SSS z").format(time));
				dflt.putNextEntry(new ZipEntry(Config.DATABASE_BACKUP_DATABASE_NAME + ".sql"));
				out = dflt;
			}
			
			if (Config.ENABLE_DATABASE_BACKUP_MANAGER)
			{
				if (Config.DATABASE_BACKUP_SCHEDULER)
				{
					ThreadPoolManager.getInstance().scheduleGeneralAtFixedRate(new BackUpManagerTask(), Config.DATABASE_BACKUP_START_DELAY * 1000 * 60, Config.DATABASE_BACKUP_DELAY_BETWEEN_BACK_UPS * 1000 * 60);
				}
				else if (Config.DATABASE_BACKUP_MAKE_BACKUP_ON_STARTUP)
				{
					DatabaseBackupManager.makeBackup();
				}
				_log.info("Backup Manager: Enabled.");
			}
			
			byte[] buf = new byte['က'];
			int written = 0;
			int read;
			while ((read = input.read(buf)) != -1)
			{
				out.write(buf, 0, read);
				written += read;
			}
			input.close();
			out.close();
			
			if (written == 0)
			{
				bf.delete();
				BufferedReader br = new BufferedReader(new InputStreamReader(run.getErrorStream()));
				String line;
				while ((line = br.readLine()) != null)
				{
					_log.info(DatabaseBackupManager.class.getSimpleName() + ": " + line);
				}
				br.close();
			}
			else
			{
				_log.info(DatabaseBackupManager.class.getSimpleName() + ": DB `" + Config.DATABASE_BACKUP_DATABASE_NAME + "` backed up in " + ((System.currentTimeMillis() - time.getTime()) / 1000L) + " s.");
			}
			
			run.waitFor();
		}
		catch (Exception e)
		{
			_log.error(DatabaseBackupManager.class.getSimpleName() + ": Could not make backup: " + e.getMessage(), e);
		}
	}
}

package com.l2jserver.gameserver.backupManager.runnable;

import com.l2jserver.gameserver.backupManager.DatabaseBackupManager;

public class BackUpManagerTask implements Runnable
{
	public BackUpManagerTask()
	{
	}
	
	@Override
	public void run()
	{

	}
}

 

Edited September 2, 2018 by GoldenNightmare

[Kara]

String dbName = "jdbc:mysql://localhost/xdemSucks";
String dbUser = "root"; 
String dbPass = "12345";
String path="C:\test.sql";
	  
String  executeCmd = "C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqldump -u " + dbUser + " -p" + dbPass + " --add-drop-database -B " + dbName + " -r " + path;
Runtime.getRuntime().exec(executeCmd);

 

Something like that maybe? idk.

Edited September 2, 2018 by Kara`

[Nightw0lf]

navicat or heidi sql managers can do that with 1 click

[GoldenNightmare]

lf dev to make it work and tell me price

[Zacapa]

 

[melron]

https://pastebin.com/a1fbAb6p

 

I'm not using configs. Feel free to create them (for global variables)

 

p.s dont forget to run it 

Quote

AutoDatabaseBackUp.getInstance();

 

 

 

Edited September 2, 2018 by melron

[tazerman2]

@melron how to run this like ingame ? or with cmd call ?

[GoldenNightmare]

thx for share but i got some warnings its ok to use suppress warnings?? and also on threadpool i got this error : Cannot make a static reference to the non-static method scheduleGeneralAtFixedRate(Runnable, long, long) from the type ThreadPoolManager

Edited September 2, 2018 by GoldenNightmare

[melron]

5 hours ago, tazerman2 said:

@melron how to run this like ingame ? or with cmd call ?

gameserver.java 

AutoDatabaseBackUp.getInstance();

 

 

5 hours ago, GoldenNightmare said:

thx for share but i got some warnings its ok to use suppress warnings?? and also on threadpool i got this error : Cannot make a static reference to the non-static method scheduleGeneralAtFixedRate(Runnable, long, long) from the type ThreadPoolManager

 

Paste some photos of your warnings,errors

[GoldenNightmare]

Edited September 3, 2018 by GoldenNightmare

[GoldenNightmare]

https://ibb.co/h88P7z

[Reborn12]

42 minutes ago, GoldenNightmare said:

https://ibb.co/h88P7z

ThreadPoolManager.getInstance()

[GoldenNightmare]

where i put this line?

[melron]

Add getInstance() in your line.

About the suggestions simply ignore them or edit it with try-with-resources style

[GoldenNightmare]

thx worked 

one last problem when i start it in console error

Path of mysql: C:\Program Files\MySQL\MySQL Server 5.6\C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqldump"
Save path of sql file: "C:\Users\tzort\Desktop\l2h\database_backup\backup.sql"
Command To Execute: cmd /c C:\Program Files\MySQL\MySQL Server 5.6\C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqldump" la2_game_server --single-transaction -uroot -p457890 --skip-create-options --skip-comments --disable-keys > "C:\Users\tzort\Desktop\l2h\database_backup\backup.sql"
Here is the standard output of the command:

Here is the standard error of the command (if any):

'C:\Program' is not recognized as an internal or external command,
operable program or batch file.
Backup to SQL Failure