Eathena Sql Backup Tool (v 1.2.0.2), Backup your eAthena SQL (for Windows) Options

[Myzter]

Hi,
This is a tool to back-up your eAthena databases (only for SQL versión), i make this tool because MySql Administrator can't create auto backups when your MySQL have some root password. (very bad)

This tool will backup your eAthena database in hide mode.
* A new folder "backup" is created inside your server folder (default)
* Every backup is created in a sub-folder named like the Database
* Backup files have the name of the tables
* Data is stored with titles and TABs as separator (or SQL)
* MySql "Username", "Password", "Server IP" and "Database Name" are readed from "\conf\inter_athena.conf" (by default) (ensure you will run this tool in the same folder than your server is running)
* Files are zipped during the process (1 zip with all csv files)

1) Your server needs Visual Basic 6 run-time
2) For spanish systems: install SETUP from this location: eABackup Components
3) For english systems: install SETUP of PowRoLauncher (pass: pow)
3.1) Download this free dll: XZip (thanks XStandard company for this free DLL)
3.2) Extract them into System32 and run register.cmd (or run: regsvr32 <path of XZip.dll>
4) Install MyODBC 3.51 (tested with 3.51.11-2)
5) Uncompress eaBackup.rar in your SERVER FOLDER (Very important), in the same folder of login, char and map exe files
6) Go to Control Panel -> Task Scheduler
7) Add a new Task and browse for eaBackup.exe
8) Setup the task as you like (i use every 4 hours)
9) Apply and Save

DOWNLOAD: eABackup 1.2.0.2

Test the first time running eaBackup.exe your self (this tool have not forms, runs in hide mode), check the folder Backup inside your server folder and look for a new folder with a name like your Database.

If there aren't new files, please check your event viewer (run: eventvwr) and search inside "Application".

After the first use of this tool, check the registry (run: regedit) and find this location: "HKEY_LOCAL_MACHINE\SOFTWARE\PowRo.cl\eABackup"
Sample:
(IMG:http://www.pow4games.com/downloads2/eaBackupReg.gif)

To disable some table from the back-up, just edit the value in the regedit and set 1, in the next back-up, the table with value 1 will be ignored.

1) After the first use, check the registry (run: regedit) and find this location: "HKEY_LOCAL_MACHINE\SOFTWARE\PowRo.cl\eABackup\cfg"
Sample:
(IMG:http://www.pow4games.com/downloads2/eaBackupCfg.jpg)
2) Set the relative path and filename of your config file in "config_filename"
3) Edit "field_database" and set the fieldname that contain the name of your database in the specified config file
4) Edit "field_ip" and set the fieldname that contain the IP (or name) of your MySql server in the specified config file
5) Edit "field_username" and set the fieldname that contain the UserName to connect with your MySql server in the specified config file
6) Edit "field_password" and set the fieldname that contain the password to connect with your MySql server in the specified config file

Don't set connection data in the registry, only fieldnames to get the right information from the config file.
Now, eABackup will read the specified config file and get all connection parameters searching by name.

(IMG:http://www.pow4games.com/downloads2/eaBackupCfg2.jpg)
1) Open Registry (run: regedit) and find this location: "HKEY_LOCAL_MACHINE\SOFTWARE\PowRo.cl\eABackup\cfg"
2) Add a new Alpha String: "format_sql"
3) Set value to 1
4) Now, your eABackup will save all backups in SQL format (very Slow but works (IMG:style_emoticons/default/rolleyes.gif) )
5) If you want to reduce the size of insert querys, add a new alpha string "format_insert" value 1

1) Open Registry (run: regedit) and find this location: "HKEY_LOCAL_MACHINE\SOFTWARE\PowRo.cl\eABackup\cfg"
2) Edit field "connection_string" an set the string as you need.
Sample (default):

DRIVER={MySQL ODBC 3.51 Driver};SERVER=$SRV;DATABASE=$DTB;UID=$USR;PWD=$PWD;OPTION=165932

Use the dynamic parameters ($) to set your string:
$SRV (server)
$DTB (database)
$USR (user)
$PWD (password)

1) Open Registry (run: regedit) and find this location: "HKEY_LOCAL_MACHINE\SOFTWARE\PowRo.cl\eABackup\cfg"
2) Edit field DataBaseName+"_path" and set the new path (don't use \\ paths)
Sample (with a database named MyeAthenaDB):
HKEY_LOCAL_MACHINE\SOFTWARE\PowRo.cl\eABackup\cfg\MyeAthenaDB_path="D:\MyBackups"

(Backup will saved in: D:\MyBackups\MyeAthenaDB\YYYYMMDDHHNNSS.zip)

This tool is very new, so i need all your feedback.

20060116: Add: Date & DateTime fields now are converted to universal format (cool)
20051129: Add: Set Backup destination
> Fix: BLOB fields saved OK
20051128: Fix: Some improvements, but there are a problem with BLOB fields, data is saved as '???'. (only guild emblems (IMG:style_emoticons/default/rolleyes.gif) )
> Add: Connection string in registry, users can set his own connection strings.
20051123: Fix: Text Data Type Corrected
> Fix: No more unicode -> half size files
>added CFG folder in registry to save the configuration (if you are using a old version, set the right values in CFG folder)
> Fix: Values with special characters
20051122: Added support to backup in SQL format
> Fix: Empty values in Text fields
20051120: Change: 1 zip file with all backup files inside
> Add: Settings to get server connection information
> Add: Compresion
20051119: Alpha versión, read path fixed

This post has been edited by Myzter: Dec 22 2009, 01:36 PM

[Angel Eyes]

It didnt create any folder or anything so i checked with "eventvwr" and there i found that it cant open the \conf\inter_athena.conf file, but it is there.
So, it would be nice if you could help me with this. (IMG:http://www.eathena.ws/board/style_emoticons/default/rolleyes.gif)

[Myzter]

UPDATED:

Ouch! that was my error, sorry, a debug flag was not removed, download again the eABackup, i'm sure now its working fine.

Myzter!

It didnt create any folder or anything so i checked with "eventvwr" and there i found that it cant open the \conf\inter_athena.conf file, but it is there.
So, it would be nice if you could help me with this. (IMG:http://www.eathena.ws/board/style_emoticons/default/rolleyes.gif)

Are you sure you are running the eABackup.exe in the same folder of your server???

> YourServerFolder\
>> login-server.exe
>> char-server.exe
>> map-server.exe
>> eABackup.exe
>> conf\
>>> inter_athena.conf
>> backup\
>>> 20051119XXXX\
>>>> your tables in csv format

This post has been edited by Myzter: Nov 20 2005, 01:54 AM

[Myzter]

Updated!, fixed initial path and added compression.

[Angel Eyes]

Again it didn't work so i copied the error and translated it with an online translator, so i dont know if it's good but anyway here it is:

CODE

The name of the fact source has not been found and no standard peering programme has not been given up

[mrmagoo]

Nice idea (IMG:http://www.eathena.ws/board/style_emoticons/default/biggrin.gif)

I have one suggestion though, can you make it read inter_conf.txt from the import folder too as that's where my username/password is. You should read this first as a lot of people use the import files rather than the main .conf files for configuring.

I couldn't get it to work either, it's getting access denied to the MySQL database even though i've added my username/pass to the usual conf files. It looks like it's reading the username etc. ok so i'll fiddle some more and get back to you.

[Myzter]

Again it didn't work so i copied the error and translated it with an online translator, so i dont know if it's good but anyway here it is:

CODE

The name of the fact source has not been found and no standard peering programme has not been given up

Please, show me the error message in the original language.

I think you can register the new DLL for Zip to fix that error. Look in the main post.

[Myzter]

Nice idea (IMG:http://www.eathena.ws/board/style_emoticons/default/biggrin.gif)

I have one suggestion though, can you make it read inter_conf.txt from the import folder too as that's where my username/password is. You should read this first as a lot of people use the import files rather than the main .conf files for configuring.

I couldn't get it to work either, it's getting access denied to the MySQL database even though i've added my username/pass to the usual conf files. It looks like it's reading the username etc. ok so i'll fiddle some more and get back to you.

Thanks.
Updated, now you can set the right config filename and parameter names that contain the connection information, look in the first post. I hope this works for you.

[Angel Eyes]

It works great now, thank you! (IMG:http://www.eathena.ws/board/style_emoticons/default/biggrin.gif)

[Dark Light]

Great job!

But, it´s possible to create the files in .sql format, instead of .csv ?

Thank you! (IMG:http://www.eathena.ws/board/style_emoticons/default/smile.gif)

[Myzter]

Great job!

But, it´s possible to create the files in .sql format, instead of .csv ?

Thank you! (IMG:http://www.eathena.ws/board/style_emoticons/default/smile.gif)

Download "MySQL Front", is a wonderfull Administration tool for MySql. You can import csv files, browse your tables, edit data directly (like SQL Enterprice Administrator), you can create filters, etc.

[Nexon]

Wouldn't it be better if it auto created the files into .sql? 'cause some people are lazy and don't want to download MySQL Front :< Like myself.

It would be easyier for the people who use your program if it made them into .sql files instead of .csv

Thanks. Good job by the way.

[Myzter]

Wouldn't it be better if it auto created the files into .sql? 'cause some people are lazy and don't want to download MySQL Front :< Like myself.

It would be easyier for the people who use your program if it made them into .sql files instead of .csv

Thanks. Good job by the way.

Parsing SQL files is more complex and slow, and SQL files are bigger than CSV, maybe in some next version i try to include the option to export directly to SQL.

I need think about data with chars like ( \ " ' ), replace this values in every row is very slow but not imposible.

PD: MySQL Front change my life, i hope you will try it to get the right feeling.

[Myzter]

It's done! (IMG:http://www.eathena.ws/board/style_emoticons/default/biggrin.gif)
now you can setup the eABackup to save .SQL files. Check the first post.

[Dark Light]

Wow Thank you! *Testing now* (IMG:http://www.eathena.ws/board/style_emoticons/default/smile.gif)