SQL.txt

GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.0.13'
 IDENTIFIED BY '25826' WITH GRANT OPTION;
FLUSH PRIVILEGES;

GRANT ALL PRIVILEGES ON b_characters.* TO 'anton'@'%'
 IDENTIFIED BY 'dvarf1884' WITH GRANT OPTION;
FLUSH PRIVILEGES;

Çàëèâàåì áàçû ëåãêî!!
// Âñå äåëàåòñÿ ÷åðåç êîíñîëü, ýêîíîìèò âðåìÿ â ðàçû!
// ïèøåì

mysql -u root -p25826

// òóò ïîïðîñèò ïàðîëü ðóòà! ââîäèì åãî

passblabla

òåïåðü âûáèðàåì áàçó â êîòîðóþ ëèòü! Åñëè åå íåò òî ñîçäàäèì à ïîòîì çàëüåì

CREATE DATABASE `world` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE DATABASE `characters1` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE DATABASE `auth` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

// áàçû ñîçäàíû.. âûáèðàåì áàçó

use worldcata;

// óêàçàòåëü òåïåðü íà áàçå âûñòàâëÿåì êîäèðîâêó äëÿ çàëèâêè (íàì æå íåíóæíû êðàêîçÿáëû â ðóññêîì)

set names utf8;

// âñå òåïåðü ëüåì ôàéë

source /home/server/Cata/sql/world.sql
source /home/server/wow/lk/c/sql/characters.sql

// òóò êóðèì èëè âüåì êîôå íî ýòî íå î÷ äîëãî áóäåò) Ïóòü ó êàæäîãî ñâîé ê ôàéëàì áàçû! ß ëèøü ïðèìåð ïðèâåë.
// àíàëîãè÷íî ñ êàæäûé äëÿ âñåõ áàç! ïîâòîðÿåì

SELECT * FROM `creature` WHERE `id`=23709;