Sql Заливка

[devillord]

Кто шарит как залить ексколько sql бекапов через майскл консоль одним махом?

[NotSpecified]

https://www.google.com/search?q=%D0%BA%D...e&ie=UTF-8

[Krasavella]

Код:

mysql -uroot -proot -hlocalhost mydb < C:\mydb.sql

[NotSpecified]

https://www.google.com/search?q=%D0%BA%D...66&bih=667

[devillord]

перед этим гуглил не нашел нужного варианта, нужно залить базу люцеры так как нету батника написаного

[Krasavella]

Код:

@echo off
title Lucera Database Installer
color 08

REM ############################################
REM ## You can change here your own DB params ##
REM ############################################
REM MYSQL BIN PATH
set mysqlBinPath=C:\Program Files\MySQL\MySQL Server 5.5\bin

REM AUTHSERVER
set lsuser=root
set lspass=root
set lsdb=db
set lshost=localhost

REM GAMESERVER
set gsuser=root
set gspass=root
set gsdb=db
set gshost=localhost
REM ############################################

set mysqldumpPath="%mysqlBinPath%\mysqldump"
set mysqlPath="%mysqlBinPath%\mysql"

echo.
echo.                          database installation
echo.                        __________________________
echo.
echo OPTIONS : (f) full install, it will destroy all (need validation).
echo           (s) skip characters data, it will install only static server tables.
echo.
:asklogin
set loginprompt=x
set /p loginprompt=Installation type: (f) full, (s) skip or (q) quit?
if /i %loginprompt%==f goto fullinstall
if /i %loginprompt%==s goto lskip
if /i %loginprompt%==q goto end
goto asklogin

REM ############################################
:fullinstall

:validation
set jaja=x
set /p jaja=Are you sure to delete all databases, even characters (y/n) ?
if /i %jaja%==y goto destruction
if /i %jaja%==n goto lskip
goto validation

:destruction
echo.
echo.
echo Deleting characters-related tables.
%mysqlPath% -h %lshost% -u %lsuser% --password=%lspass% -D %lsdb% < full_install.sql
echo Done.
echo.
echo Installing empty character-related tables.
%mysqlPath% -h %lshost% -u %lsuser% --password=%lspass% -D %lsdb% < sql/accounts.sql
%mysqlPath% -h %lshost% -u %lsuser% --password=%lspass% -D %lsdb% < sql/account_premium.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/auction.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/auction_bid.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/augmentations.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/bookmarks.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/castle_doorupgrade.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/castle_manor_procure.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/castle_manor_production.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/character_friends.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/character_hennas.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/character_macroses.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/character_mail.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/character_quests.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/character_raid_points.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/character_recipebook.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/character_recommends.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/character_shortcuts.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/character_skills.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/character_skills_save.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/character_subclasses.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/characters.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/clan_data.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/clan_notices.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/clan_privs.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/clan_skills.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/clan_subpledges.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/clan_wars.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/clanhall.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/clanhall_functions.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/cursed_weapons.sql
%mysqlPath% -h %lshost% -u %lsuser% --password=%lspass% -D %lsdb% < sql/forums.sql
%mysqlPath% -h %lshost% -u %lsuser% --password=%lspass% -D %lsdb% < sql/games.sql
%mysqlPath% -h %lshost% -u %lsuser% --password=%lspass% -D %lsdb% < sql/gameservers.sql
%mysqlPath% -h %lshost% -u %lsuser% --password=%lspass% -D %lsdb% < sql/grandboss_list.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/heroes_diary.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/heroes.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/items.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/itemsonground.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/mods_wedding.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/olympiad_data.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/olympiad_fights.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/olympiad_nobles_eom.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/olympiad_nobles.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/pets.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/posts.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/quest_global_data.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/seven_signs.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/seven_signs_festival.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/seven_signs_status.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/siege_clans.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/topic.sql

echo Done.
echo.

REM ############################################
:lskip
echo Deleting server tables.
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < gs_install.sql
echo Done.
echo.
echo Installing server tables.
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/castle.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/castle_siege_guards.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/global_tasks.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/grandboss_data.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/merchant_areas_list.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/merchant_buylists.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/merchant_shopids.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/merchants.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/minions.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/npc.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/npc_ai_data.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/npc_buffer.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/npc_skills.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/raidboss_spawnlist.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/random_spawn.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/random_spawn_loc.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/spawnlist_4s.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/spawnlist.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/custom/l2top_votes.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/custom/mmotop_votes.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/custom/character_offline_trade.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < sql/custom/character_offline_trade_items.sql
REM ############################################
:end
echo.
pause

[devillord]

благодарю ))

Добавлено через 2 минуты
но нужно под unix

Добавлено через 3 минуты
помню николай когда то писал на своем форуме

[Krasavella]

Код:

trap finish 2

configure() {

# Authserver
LSDBHOST="localhost"
LSDB="l2j"
LSUSER="root"
LSPASS="root"

# Gameserver
GSDBHOST="localhost"
GSDB="l2j"
GSUSER="root"
GSPASS="root"

echo "                          database installation"
echo "                        __________________________"
echo ""

MYSQLDUMPPATH=`which mysqldump 2>/dev/null`
MYSQLPATH=`which mysql 2>/dev/null`
if [ $? -ne 0 ]; then
echo "We were unable to find MySQL binaries on your path"
while :
do
  echo -ne "\nPlease enter MySQL binaries directory (no trailing slash): "
  read MYSQLBINPATH
    if [ -e "$MYSQLBINPATH" ] && [ -d "$MYSQLBINPATH" ] && [ -e "$MYSQLBINPATH/mysqldump" ] && [ -e "$MYSQLBINPATH/mysql" ]; then
       MYSQLDUMPPATH="$MYSQLBINPATH/mysqldump"
       MYSQLPATH="$MYSQLBINPATH/mysql"
       break
    else
       echo "The data you entered is invalid. Please verify and try again."
       exit 1
    fi
done
fi
MYL="$MYSQLPATH -h $LSDBHOST -u $LSUSER --password=$LSPASS -D $LSDB"
MYG="$MYSQLPATH -h $GSDBHOST -u $GSUSER --password=$GSPASS -D $GSDB"

echo "OPTIONS : (f) full install, it will destroy all."
echo "          (s) skip characters data, it will install only static server tables."
echo ""
echo -ne "Installation type: (f) full, (s) skip or (q) quit? "

read PROMPT
case "$PROMPT" in
    "f"|"F") fullinstall; upgradeinstall I;;
    "s"|"S") skip; upgradeinstall U;;
    "q"|"Q") finish;;
    *) configure;;
esac
}

fullinstall(){
echo "Deleting all tables for new content."
$MYG < gs_install.sql &> /dev/null
$MYG < full_install.sql &> /dev/null
$MYL < full_install.sql &> /dev/null
}

skip(){
echo "Deleting all gameserver tables for new content."
$MYG < gs_install.sql &> /dev/null
}

upgradeinstall(){
if [ "$1" == "I" ]; then
echo "Installling new content."
else
echo "Upgrading gameserver content"
fi

$MYL < sql/accounts.sql &> /dev/null
$MYL < sql/gameservers.sql &> /dev/null

$MYL < sql/account_premium.sql &> /dev/null
$MYG < sql/auction.sql &> /dev/null
$MYG < sql/auction_bid.sql &> /dev/null
$MYG < sql/augmentations.sql &> /dev/null
$MYG < sql/bookmarks.sql &> /dev/null
$MYG < sql/castle.sql &> /dev/null
$MYG < sql/castle_doorupgrade.sql &> /dev/null
$MYG < sql/castle_manor_procure.sql &> /dev/null
$MYG < sql/castle_manor_production.sql &> /dev/null
$MYG < sql/castle_siege_guards.sql &> /dev/null
$MYG < sql/character_friends.sql &> /dev/null
$MYG < sql/character_hennas.sql &> /dev/null
$MYG < sql/character_macroses.sql &> /dev/null
$MYG < sql/character_mail.sql &> /dev/null
$MYG < sql/character_quests.sql &> /dev/null
$MYG < sql/character_raid_points.sql &> /dev/null
$MYG < sql/character_recipebook.sql &> /dev/null
$MYG < sql/character_recommends.sql &> /dev/null
$MYG < sql/character_shortcuts.sql &> /dev/null
$MYG < sql/character_skills.sql &> /dev/null
$MYG < sql/character_skills_save.sql &> /dev/null
$MYG < sql/character_subclasses.sql &> /dev/null
$MYG < sql/characters.sql &> /dev/null
$MYG < sql/clan_data.sql &> /dev/null
$MYG < sql/clan_notices.sql &> /dev/null
$MYG < sql/clan_privs.sql &> /dev/null
$MYG < sql/clan_skills.sql &> /dev/null
$MYG < sql/clan_subpledges.sql &> /dev/null
$MYG < sql/clan_wars.sql &> /dev/null
$MYG < sql/clanhall.sql &> /dev/null
$MYG < sql/clanhall_functions.sql &> /dev/null
$MYG < sql/cursed_weapons.sql &> /dev/null
$MYG < sql/forums.sql &> /dev/null
$MYG < sql/games.sql &> /dev/null
$MYG < sql/global_tasks.sql &> /dev/null
$MYG < sql/grandboss_data.sql &> /dev/null
$MYG < sql/grandboss_list.sql &> /dev/null
$MYG < sql/heroes_diary.sql &> /dev/null
$MYG < sql/heroes.sql &> /dev/null
$MYG < sql/items.sql &> /dev/null
$MYG < sql/itemsonground.sql &> /dev/null
$MYG < sql/merchant_areas_list.sql &> /dev/null
$MYG < sql/merchant_buylists.sql &> /dev/null
$MYG < sql/merchant_shopids.sql &> /dev/null
$MYG < sql/merchants.sql &> /dev/null
$MYG < sql/minions.sql &> /dev/null
$MYG < sql/mods_wedding.sql &> /dev/null
$MYG < sql/npc.sql &> /dev/null
$MYG < sql/npc_ai_data.sql &> /dev/null
$MYG < sql/npc_buffer.sql &> /dev/null
$MYG < sql/npc_skills.sql &> /dev/null
$MYG < sql/olympiad_data.sql&> /dev/null
$MYG < sql/olympiad_fights.sql&> /dev/null
$MYG < sql/olympiad_nobles_eom.sql&> /dev/null
$MYG < sql/olympiad_nobles.sql&> /dev/null
$MYG < sql/pets.sql &> /dev/null
$MYG < sql/posts.sql &> /dev/null
$MYG < sql/quest_global_data.sql &> /dev/null
$MYG < sql/raidboss_spawnlist.sql &> /dev/null
$MYG < sql/random_spawn.sql &> /dev/null
$MYG < sql/random_spawn_loc.sql &> /dev/null
$MYG < sql/seven_signs.sql &> /dev/null
$MYG < sql/seven_signs_festival.sql &> /dev/null
$MYG < sql/seven_signs_status.sql &> /dev/null
$MYG < sql/siege_clans.sql &> /dev/null
$MYG < sql/spawnlist_4s.sql &> /dev/null
$MYG < sql/spawnlist.sql &> /dev/null
$MYG < sql/topic.sql &> /dev/null
$MYG < sql/custom/l2top_votes.sql &> /dev/null
$MYG < sql/custom/mmotop_votes.sql &> /dev/null
$MYG < sql/custom/character_offline_trade.sql &> /dev/null
$MYG < sql/custom/character_offline_trade_items.sql &> /dev/null
echo ""
}

finish(){
echo ""
echo "Script execution finished."
exit 0
}

clear
configure

[devillord]

lucera < /home/lucera/sql/server/ *

что то по типу

[NotSpecified]

Вы чего снова флуд разводите? Выше же дана ссылка на запрос в гугле, а по ней ответ есть http://mysqlru.com/faq/%D0%BA%D0%B0%D0%B...%BE-1.html