старые » L2J Fortress » Открытые форумы » Новые идеи в L2J » Бэкапы

Бэкапы

Теги:
 
Новый опрос Новый фотосет Новая тема Написать сообщение в тему
AD Реклама Google — средство выживания форумов :)
RU Abaddon #18.11.2005 01:50
+
-
edit
 

Abaddon

опытный
☆
админ. бан
Сделал вменяемую систему сабжа при установке апдейтов... Вопщем так:

Есть папки
%server%/tools - тут батники
%server%/tools/backup - тут будут храниться бэкапы (папку можно сделать любую)

backup.bat - просто делает backup базы, создает файл типа "backup_18.11.2005-01`41`41.sql"
full_install.bat - полная установка, файл типа "install_18.11.2005-01`37`18.sql"
upgrade.bat - апгрейд, файл типа "upgrade_18.11.2005-01`37`24.sql"

Конечно надо привести в порядок и сделань аналог для линукса еще...

Содержимое backup.bat
code text
  1. @echo off
  2.  
  3. REM MYSQL 4.0
  4. rem set mysqlBinPath=C:mysqlbin
  5. REM MYSQL 4.1
  6. rem set mysqlBinPath=C:Program FilesMySQLMySQL Server 4.1bin
  7. REM MYSQL 5.0
  8. set mysqlBinPath=C:Program FilesMySQLMySQL Server 5.0bin
  9. set user=root
  10. set pass=
  11. set DBname=l2jdb
  12. set DBHost=localhost
  13.  
  14. set mysqldumpPath="%mysqlBinPath%mysqldump"
  15. set mysqlPath="%mysqlBinPath%mysql"
  16.  
  17. set ctime=%TIME:~0,2%
  18. if "%ctime:~0,1%" == " " (
  19. set ctime=0%ctime:~1,1%
  20. )
  21. set ctime=-%ctime%`%TIME:~3,2%`%TIME:~6,2%
  22.  
  23. echo.
  24. echo Making a full backup.
  25. %mysqldumpPath% --add-drop-table -h %DBHost% -u %user% --password=%pass% %DBname% > backup/backup_%DATE%%ctime%.sql
  26.  
  27. echo Done.
  28. pause


Содержимое full_install.bat
code text
  1. @echo off
  2.  
  3. REM ############################################
  4. REM ## You can change here your own DB params ##
  5. REM ############################################
  6.  
  7.  
  8. REM MYSQL 4.0
  9. rem set mysqlBinPath=C:mysqlbin
  10. REM MYSQL 4.1
  11. rem set mysqlBinPath=C:Program FilesMySQLMySQL Server 4.1bin
  12. REM MYSQL 5.0
  13. set mysqlBinPath=C:Program FilesMySQLMySQL Server 5.0bin
  14. set user=root
  15. set pass=
  16. set DBname=l2jdb
  17. set DBHost=localhost
  18.  
  19. REM ############################################
  20.  
  21. set mysqldumpPath="%mysqlBinPath%mysqldump"
  22. set mysqlPath="%mysqlBinPath%mysql"
  23.  
  24. set ctime=%TIME:~0,2%
  25. if "%ctime:~0,1%" == " " (
  26. set ctime=0%ctime:~1,1%
  27. )
  28. set ctime=-%ctime%`%TIME:~3,2%`%TIME:~6,2%
  29.  
  30. echo.
  31. echo Making a backup of the original database.
  32. %mysqldumpPath% --add-drop-table -h %DBHost% -u %user% --password=%pass% %DBname% > backup/install_%DATE%%ctime%.sql
  33. echo.
  34. echo Deleting tables for new content.
  35. %mysqlPath% -h %DBHost% -u %user% --password=%pass% -D %DBname% < ../sql/full_install.sql
  36. echo.
  37. echo Installling full_install content.
  38. %mysqlPath% -h %DBHost% -u %user% --password=%pass% -D %DBname% < ../sql/common/accounts.sql
  39. %mysqlPath% -h %DBHost% -u %user% --password=%pass% -D %DBname% < ../sql/common/character_friends.sql
  40. %mysqlPath% -h %DBHost% -u %user% --password=%pass% -D %DBname% < ../sql/common/character_hennas.sql
  41. %mysqlPath% -h %DBHost% -u %user% --password=%pass% -D %DBname% < ../sql/common/character_macroses.sql
  42. %mysqlPath% -h %DBHost% -u %user% --password=%pass% -D %DBname% < ../sql/common/character_quests.sql
  43. %mysqlPath% -h %DBHost% -u %user% --password=%pass% -D %DBname% < ../sql/common/character_recipebook.sql
  44. %mysqlPath% -h %DBHost% -u %user% --password=%pass% -D %DBname% < ../sql/common/character_shortcuts.sql
  45. %mysqlPath% -h %DBHost% -u %user% --password=%pass% -D %DBname% < ../sql/common/character_skills.sql
  46. %mysqlPath% -h %DBHost% -u %user% --password=%pass% -D %DBname% < ../sql/common/character_skills_save.sql
  47. %mysqlPath% -h %DBHost% -u %user% --password=%pass% -D %DBname% < ../sql/common/characters.sql
  48. %mysqlPath% -h %DBHost% -u %user% --password=%pass% -D %DBname% < ../sql/common/clan_data.sql
  49. %mysqlPath% -h %DBHost% -u %user% --password=%pass% -D %DBname% < ../sql/common/clan_wars.sql
  50. %mysqlPath% -h %DBHost% -u %user% --password=%pass% -D %DBname% < ../sql/common/items.sql
  51. %mysqlPath% -h %DBHost% -u %user% --password=%pass% -D %DBname% < ../sql/common/pets.sql
  52. %mysqlPath% -h %DBHost% -u %user% --password=%pass% -D %DBname% < ../sql/common/seven_signs.sql
  53. %mysqlPath% -h %DBHost% -u %user% --password=%pass% -D %DBname% < ../sql/common/seven_signs_festival.sql
  54. %mysqlPath% -h %DBHost% -u %user% --password=%pass% -D %DBname% < ../sql/common/siege_clans.sql
  55.  
  56. call upgrade.bat
  57. pause


Содержимое upgrade.bat
code text
  1. @echo off
  2.  
  3. REM MYSQL 4.0
  4. rem set mysqlBinPath=C:mysqlbin
  5. REM MYSQL 4.1
  6. rem set mysqlBinPath=C:Program FilesMySQLMySQL Server 4.1bin
  7. REM MYSQL 5.0
  8. set mysqlBinPath=C:Program FilesMySQLMySQL Server 5.0bin
  9. set user=root
  10. set pass=
  11. set DBname=l2jdb
  12. set DBHost=localhost
  13.  
  14. set mysqldumpPath="%mysqlBinPath%mysqldump"
  15. set mysqlPath="%mysqlBinPath%mysql"
  16.  
  17. set ctime=%TIME:~0,2%
  18. if "%ctime:~0,1%" == " " (
  19. set ctime=0%ctime:~1,1%
  20. )
  21. set ctime=-%ctime%`%TIME:~3,2%`%TIME:~6,2%
  22.  
  23. echo.
  24. echo Making a backup of the original database.
  25. %mysqldumpPath% --add-drop-table -h %DBHost% -u %user% --password=%pass% %DBname% > backup/upgrade_%DATE%%ctime%.sql
  26. echo.
  27. echo Deleting table for new content.
  28. %mysqlPath% -h %DBHost% -u %user% --password=%pass% -D %DBname% < ../sql/upgrade.sql
  29. echo.
  30. echo Installing new content.
  31. %mysqlPath% -h %DBHost% -u %user% --password=%pass% -D %DBname% < ../sql/common/armor.sql
  32. %mysqlPath% -h %DBHost% -u %user% --password=%pass% -D %DBname% < ../sql/common/boxaccess.sql
  33. %mysqlPath% -h %DBHost% -u %user% --password=%pass% -D %DBname% < ../sql/common/boxes.sql
  34. %mysqlPath% -h %DBHost% -u %user% --password=%pass% -D %DBname% < ../sql/common/castle.sql
  35. %mysqlPath% -h %DBHost% -u %user% --password=%pass% -D %DBname% < ../sql/common/castle_door.sql
  36. %mysqlPath% -h %DBHost% -u %user% --password=%pass% -D %DBname% < ../sql/common/castle_doorupgrade.sql
  37. %mysqlPath% -h %DBHost% -u %user% --password=%pass% -D %DBname% < ../sql/common/castle_guards.sql
  38. %mysqlPath% -h %DBHost% -u %user% --password=%pass% -D %DBname% < ../sql/common/castle_guards_skills.sql
  39. %mysqlPath% -h %DBHost% -u %user% --password=%pass% -D %DBname% < ../sql/common/castle_siege_guards.sql
  40. %mysqlPath% -h %DBHost% -u %user% --password=%pass% -D %DBname% < ../sql/common/char_templates.sql
  41. %mysqlPath% -h %DBHost% -u %user% --password=%pass% -D %DBname% < ../sql/common/character_variables.sql
  42. %mysqlPath% -h %DBHost% -u %user% --password=%pass% -D %DBname% < ../sql/common/class_list.sql
  43. %mysqlPath% -h %DBHost% -u %user% --password=%pass% -D %DBname% < ../sql/fortress/droplist.sql
  44. %mysqlPath% -h %DBHost% -u %user% --password=%pass% -D %DBname% < ../sql/common/etcitem.sql
  45. %mysqlPath% -h %DBHost% -u %user% --password=%pass% -D %DBname% < ../sql/common/henna.sql
  46. %mysqlPath% -h %DBHost% -u %user% --password=%pass% -D %DBname% < ../sql/common/henna_trees.sql
  47. %mysqlPath% -h %DBHost% -u %user% --password=%pass% -D %DBname% < ../sql/fortress/locations.sql
  48. %mysqlPath% -h %DBHost% -u %user% --password=%pass% -D %DBname% < ../sql/common/lvlupgain.sql
  49. %mysqlPath% -h %DBHost% -u %user% --password=%pass% -D %DBname% < ../sql/common/mapregion.sql
  50. %mysqlPath% -h %DBHost% -u %user% --password=%pass% -D %DBname% < ../sql/common/merchant_areas_list.sql
  51. %mysqlPath% -h %DBHost% -u %user% --password=%pass% -D %DBname% < ../sql/common/merchant_buylists.sql
  52. %mysqlPath% -h %DBHost% -u %user% --password=%pass% -D %DBname% < ../sql/common/merchant_lease.sql
  53. %mysqlPath% -h %DBHost% -u %user% --password=%pass% -D %DBname% < ../sql/common/merchant_shopids.sql
  54. %mysqlPath% -h %DBHost% -u %user% --password=%pass% -D %DBname% < ../sql/common/merchants.sql
  55. %mysqlPath% -h %DBHost% -u %user% --password=%pass% -D %DBname% < ../sql/common/minions.sql
  56. %mysqlPath% -h %DBHost% -u %user% --password=%pass% -D %DBname% < ../sql/fortress/npc.sql
  57. %mysqlPath% -h %DBHost% -u %user% --password=%pass% -D %DBname% < ../sql/fortress/npcskills.sql
  58. %mysqlPath% -h %DBHost% -u %user% --password=%pass% -D %DBname% < ../sql/common/server_variables.sql
  59. %mysqlPath% -h %DBHost% -u %user% --password=%pass% -D %DBname% < ../sql/common/skill_learn.sql
  60. %mysqlPath% -h %DBHost% -u %user% --password=%pass% -D %DBname% < ../sql/common/skill_spellbooks.sql
  61. %mysqlPath% -h %DBHost% -u %user% --password=%pass% -D %DBname% < ../sql/common/skill_trees.sql
  62. %mysqlPath% -h %DBHost% -u %user% --password=%pass% -D %DBname% < ../sql/fortress/spawnlist.sql
  63. %mysqlPath% -h %DBHost% -u %user% --password=%pass% -D %DBname% < ../sql/common/teleport.sql
  64. %mysqlPath% -h %DBHost% -u %user% --password=%pass% -D %DBname% < ../sql/common/weapon.sql
  65. %mysqlPath% -h %DBHost% -u %user% --password=%pass% -D %DBname% < ../sql/common/zone.sql
  66.  
  67. echo.
  68. echo Installing fixes.
  69.  
  70. %mysqlPath% -h %DBHost% -u %user% --password=%pass% -D %DBname% < ../sql/fixes/c3.sql
  71. %mysqlPath% -h %DBHost% -u %user% --password=%pass% -D %DBname% < ../sql/fixes/drop.sql
  72. %mysqlPath% -h %DBHost% -u %user% --password=%pass% -D %DBname% < ../sql/fixes/exp_sp.sql
  73. %mysqlPath% -h %DBHost% -u %user% --password=%pass% -D %DBname% < ../sql/fixes/FixDrop.sql
  74. %mysqlPath% -h %DBHost% -u %user% --password=%pass% -D %DBname% < ../sql/fixes/FixNPC.sql
  75. %mysqlPath% -h %DBHost% -u %user% --password=%pass% -D %DBname% < ../sql/fixes/FixPirTun.sql
  76. %mysqlPath% -h %DBHost% -u %user% --password=%pass% -D %DBname% < ../sql/fixes/l2wh.sql
  77. %mysqlPath% -h %DBHost% -u %user% --password=%pass% -D %DBname% < ../sql/fixes/prices.sql
  78. %mysqlPath% -h %DBHost% -u %user% --password=%pass% -D %DBname% < ../sql/fixes/respawn.sql
  79.  
  80. echo.
  81. echo Fixes installed.
  82. echo.
  83. pause
Пытаясь понять рекурсию, следи за тем, чтобы она не поняла тебя первой...  

в начало страницы | новое
старые » L2J Fortress » Открытые форумы » Новые идеи в L2J » Бэкапы
Copyright © Balancer 1997..2018
Создано 18.11.2005
Связь с владельцами и администрацией сайта: anonisimov@gmail.com, rwasp1957@yandex.ru и admin@balancer.ru.
 
Поиск
Настройки
Твиттер сайта
Статистика
Рейтинг@Mail.ru