![[Release]Server+DB abspeichern](https://www.elitepvpers.com/forum/iconimages/metin2-pserver-guides-strategies/release-server-db-abspeichern_ltr.gif){kind=small}
[Release]Server+DB abspeichern
da die SuFu nix gebracht hat zeig ich euch jetzt mal wie man den Server speichert (die db u.s.w.)
Also 1.Möglichkeit:
Einfach die Mt2.vhd in einen anderen Ordner kopieren...
und wenn der Server kaputt ist einfach wieder rein kopieren.
Und 2.Möglichkeit:
In Navicat einloggen und auf Export Wizard klicken>sql auswählen>Was ihr wollt auswählen>bei export Verzeichnis auswählen>weiter>start
So dann die gespeicherte .sql Datei öffnen und schreibt vorne dran:
PHP Code:
/*
Navicat MySQL Data Transfer
Source Server : MT2PRIVAT
Source Server Version : 50085
Source Host : 5.190.177.100:3306
Source Database : player
Target Server Type : MYSQL
Target Server Version : 50085
File Encoding : 65001
Date: 2010-01-15 15:00:54
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `mob_proto`
-- ----------------------------
DROP TABLE IF EXISTS `mob_proto`;
CREATE TABLE `mob_proto` (
`vnum` int(11) NOT NULL default '0',
`name` varchar(24) NOT NULL default 'Noname',
`gb2312name` varbinary(24) NOT NULL default 'Noname ',
`rank` tinyint(2) NOT NULL default '0',
`type` tinyint(2) NOT NULL default '0',
`battle_type` tinyint(1) NOT NULL default '0',
`level` smallint(3) NOT NULL default '1',
`size` enum('SMALL','MEDIUM','BIG') NOT NULL default 'SMALL',
`ai_flag` set('AGGR','NOMOVE','COWARD','NOATTSHINSU','NOATTCHUNJO','NOATTJINNO','ATTMOB','BERSERK','STONESKIN','GODSPEED','DEATHBLOW','REVIVE') default NULL,
`mount_capacity` tinyint(2) NOT NULL default '0',
`setRaceFlag` set('ANIMAL','UNDEAD','DEVIL','HUMAN','ORC','MILGYO','INSECT','FIRE','ICE','DESERT') NOT NULL default '',
`setImmuneFlag` set('STUN','SLOW','FALL','CURSE','POISON','TERROR') NOT NULL default '',
`empire` tinyint(4) NOT NULL default '0',
`folder` varchar(100) NOT NULL default '',
`on_click` tinyint(4) NOT NULL default '0',
`st` smallint(5) unsigned NOT NULL default '0',
`dx` smallint(5) unsigned NOT NULL default '0',
`ht` smallint(5) unsigned NOT NULL default '0',
`iq` smallint(5) unsigned NOT NULL default '0',
`damage_min` smallint(5) unsigned NOT NULL default '0',
`damage_max` smallint(5) unsigned NOT NULL default '0',
`max_hp` int(10) unsigned NOT NULL default '0',
`regen_cycle` tinyint(3) unsigned NOT NULL default '0',
`regen_percent` tinyint(3) unsigned NOT NULL default '0',
`gold_min` int(11) NOT NULL default '0',
`gold_max` int(11) NOT NULL default '0',
`exp` int(10) unsigned NOT NULL default '0',
`def` smallint(5) unsigned NOT NULL default '0',
`attack_speed` smallint(6) unsigned NOT NULL default '100',
`move_speed` smallint(6) unsigned NOT NULL default '100',
`aggressive_hp_pct` tinyint(3) unsigned NOT NULL default '0',
`aggressive_sight` smallint(10) unsigned NOT NULL default '0',
`attack_range` smallint(5) unsigned NOT NULL default '0',
`drop_item` int(10) unsigned NOT NULL default '0',
`resurrection_vnum` int(10) unsigned NOT NULL default '0',
`enchant_curse` tinyint(4) unsigned NOT NULL default '0',
`enchant_slow` tinyint(4) unsigned NOT NULL default '0',
`enchant_poison` tinyint(4) unsigned NOT NULL default '0',
`enchant_stun` tinyint(3) unsigned NOT NULL default '0',
`enchant_critical` tinyint(3) unsigned NOT NULL default '0',
`enchant_penetrate` tinyint(3) unsigned NOT NULL default '0',
`resist_sword` tinyint(4) NOT NULL default '0',
`resist_twohand` tinyint(4) NOT NULL default '0',
`resist_dagger` tinyint(4) NOT NULL default '0',
`resist_bell` tinyint(4) NOT NULL default '0',
`resist_fan` tinyint(4) NOT NULL default '0',
`resist_bow` tinyint(4) NOT NULL default '0',
`resist_fire` tinyint(4) NOT NULL default '0',
`resist_elect` tinyint(4) NOT NULL default '0',
`resist_magic` tinyint(4) NOT NULL default '0',
`resist_wind` tinyint(4) NOT NULL default '0',
`resist_poison` tinyint(4) NOT NULL default '0',
`dam_multiply` float default NULL,
`summon` int(11) default NULL,
`drain_sp` int(11) default NULL,
`mob_color` int(10) unsigned default NULL,
`polymorph_item` int(10) unsigned NOT NULL default '0',
`skill_level0` tinyint(3) unsigned default NULL,
`skill_vnum0` int(10) unsigned default NULL,
`skill_level1` tinyint(3) unsigned default NULL,
`skill_vnum1` int(10) unsigned default NULL,
`sp_berserk` tinyint(4) NOT NULL default '0',
`sp_stoneskin` tinyint(4) NOT NULL default '0',
`sp_godspeed` tinyint(4) NOT NULL default '0',
`sp_deathblow` tinyint(4) NOT NULL default '0',
`sp_revive` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`vnum`)
) ENGINE=MyISAM DEFAULT CHARSET=big5;
-- ----------------------------
-- Records of mob_proto
-- ----------------------------
Ich werde bald noch Deutsche Mob und item_proto mit neuer king und Neuen Monstern hochladen
Viel Spaß
PS:Thx Button beißt nicht
