Jump to content
  • 0

Pos na kanw instal ti Mysql


Question

Posted

Re paidia deixte m ekei pou kaneis Confing ti mysql_instal deixte m pou prepei na balw to Version

 

 

#!/bin/bash
############################################
## WARNING!  WARNING!  WARNING!  WARNING! ##
##                                        ##
## DON'T USE NOTEPAD TO CHANGE THIS FILE  ##
## INSTEAD USE SOME DECENT TEXT EDITOR.   ##
## NEWLINE CHARACTERS DIFFER BETWEEN DOS/ ##
## WINDOWS AND UNIX.                      ##
##                                        ##
## USING NOTEPAD TO SAVE THIS FILE WILL   ##
## LEAVE IT IN A BROKEN STATE!!!          ##
############################################
## Writen by DrLecter                     ##
## License: GNU GPL                       ##
## Based on Tiago Tagliaferri's script    ##
## E-mail: tiago_tagliaferri@msn.com      ##
## From "L2J-DataPack"                    ##
## Bug reports: http://l2jdp.com/trac     ##
############################################
trap finish 2

configure() {
echo "#############################################"
echo "# You entered script configuration area     #"
echo "# No change will be performed in your DB    #"
echo "# I will just ask you some questions about  #"
echo "# your hosts and DB.                        #"
echo "#############################################"
MYSQLDUMPPATH=`which -a mysqldump 2>/dev/null`
MYSQLPATH=`which -a 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
#LS
echo -ne "\nPlease enter MySQL Login Server hostname (default localhost): "
read LSDBHOST
if [ -z "$LSDBHOST" ]; then
  LSDBHOST="localhost"
fi
echo -ne "\nPlease enter MySQL Login Server database name (default l2jdb): "
read LSDB
if [ -z "$LSDB" ]; then
  LSDB="l2jdb"
fi
echo -ne "\nPlease enter MySQL Login Server user (default root): "
read LSUSER
if [ -z "$LSUSER" ]; then
  LSUSER="root"
fi
echo -ne "\nPlease enter MySQL Login Server $LSUSER's password (won't be displayed) :"
stty -echo
read LSPASS
stty echo
echo ""
if [ -z "$LSPASS" ]; then
  echo "Hum.. I'll let it be but don't be stupid and avoid empty passwords"
elif [ "$LSUSER" == "$LSPASS" ]; then
  echo "You're not too brilliant choosing passwords huh?"
fi
#GS
echo -ne "\nPlease enter MySQL Game Server hostname (default $LSDBHOST): "
read GSDBHOST
if [ -z "$GSDBHOST" ]; then
  GSDBHOST="$LSDBHOST"
fi
echo -ne "\nPlease enter MySQL Game Server database name (default $LSDB): "
read GSDB
if [ -z "$GSDB" ]; then
  GSDB="$LSDB"
fi
echo -ne "\nPlease enter MySQL Game Server user (default $LSUSER): "
read GSUSER
if [ -z "$GSUSER" ]; then
  GSUSER="$LSUSER"
fi
echo -ne "\nPlease enter MySQL Game Server $GSUSER's password (won't be displayed): "
stty -echo
read GSPASS
stty echo
echo ""
if [ -z "$GSPASS" ]; then
  echo "Hum.. I'll let it be but don't be stupid and avoid empty passwords"
elif [ "$GSUSER" == "$GSPASS" ]; then
  echo "You're not too brilliant choosing passwords huh?"
fi
save_config $1
}

save_config() {
if [ -n "$1" ]; then
CONF="$1"
else 
CONF="database_installer.rc"
fi
echo ""
echo "With these data I can generate a configuration file which can be read"
echo "on future updates. WARNING: this file will contain clear text passwords!"
echo -ne "Shall I generate config file $CONF? (Y/n):"
read SAVE
if [ "$SAVE" == "y" -o "$SAVE" == "Y" -o "$SAVE" == "" ];then 
cat <<EOF>$CONF
#Configuration settings for L2J-Datapack database installer script
MYSQLDUMPPATH=$MYSQLDUMPPATH
MYSQLPATH=$MYSQLPATH
LSDBHOST=$LSDBHOST
LSDB=$LSDB
LSUSER=$LSUSER
LSPASS=$LSPASS
GSDBHOST=$GSDBHOST
GSDB=$GSDB
GSUSER=$GSUSER
GSPASS=$GSPASS
EOF
chmod 600 $CONF
echo "Configuration saved as $CONF"
echo "Permissions changed to 600 (rw- --- ---)"
elif [ "$SAVE" != "n" -a "$SAVE" != "N" ]; then
  save_config
fi
}

load_config() {
if [ -n "$1" ]; then
CONF="$1"
else 
CONF="database_installer.rc"
fi
if [ -e "$CONF" ] && [ -f "$CONF" ]; then
. $CONF
else
echo "Settings file not found: $CONF"
echo "You can specify an alternate settings filename:"
echo $0 config_filename
echo ""
echo "If file doesn't exist it can be created"
echo "If nothing is specified script will try to work with ./database_installer.rc"
echo ""
configure $CONF
fi
}

asklogin(){
echo "#############################################"
echo "# WARNING: This section of the script CAN   #"
echo "# destroy your characters and accounts      #"
echo "# information. Read questions carefully     #"
echo "# before you reply.                         #"
echo "#############################################"
echo ""
echo "Choose full (f) if you don't have and 'accounts' table or would"
echo "prefer to erase the existing accounts information."
echo "Choose skip (s) to skip loginserver DB installation and go to"
echo "gameserver DB installation/upgrade."
echo -ne "LOGINSERVER DB install type: (f) full, (s) skip or (q) quit? "
read LOGINPROMPT
case "$LOGINPROMPT" in
"f"|"F") logininstall; loginupgrade; gsbackup; asktype;;
"s"|"S") gsbackup; asktype;;
"q"|"Q") finish;;
*) asklogin;;
esac
}

logininstall(){
echo "Deleting loginserver tables for new content."
$MYL < login_install.sql &> /dev/null
}

loginupgrade(){
echo "Installling new loginserver content."
$MYL < ../sql/accounts.sql &> /dev/null
$MYL < ../sql/account_data.sql &> /dev/null
$MYL < ../sql/gameservers.sql &> /dev/null
}

gsbackup(){
while :
  do
   echo ""
   echo -ne "Do you want to make a backup copy of your GSDB? (y/n): "
   read LSB
   if [ "$LSB" == "Y" -o "$LSB" == "y" ]; then
     echo "Making a backup of the original gameserver database."
     $MYSQLDUMPPATH --add-drop-table -h $GSDBHOST -u $GSUSER --password=$GSPASS $GSDB > gameserver_backup.sql
     if [ $? -ne 0 ];then
     echo ""
     echo "There was a problem accesing your GS database, either it wasnt created or authentication data is incorrect."
     exit 1
     fi
     break
   elif [ "$LSB" == "n" -o "$LSB" == "N" ]; then 
     break
   fi
  done 
}

lsbackup(){
while :
  do
   echo ""
   echo -ne "Do you want to make a backup copy of your LSDB? (y/n): "
   read LSB
   if [ "$LSB" == "Y" -o "$LSB" == "y" ]; then
     echo "Making a backup of the original loginserver database."
     $MYSQLDUMPPATH --add-drop-table -h $LSDBHOST -u $LSUSER --password=$LSPASS $LSDB > loginserver_backup.sql
     if [ $? -ne 0 ];then
        echo ""
        echo "There was a problem accesing your LS database, either it wasnt created or authentication data is incorrect."
        exit 1
     fi
     break
   elif [ "$LSB" == "n" -o "$LSB" == "N" ]; then 
     break
   fi
  done 
}

asktype(){
echo ""
echo ""
echo "WARNING: A full install (f) will destroy all existing character data."
echo -ne "GAMESERVER DB install type: (f) full install, (u) upgrade, (s) skip or (q) quit? "
read INSTALLTYPE
case "$INSTALLTYPE" in
"f"|"F") fullinstall; upgradeinstall I; custom;;
"u"|"U") upgradeinstall U; custom;;
"s"|"S") custom;;
"q"|"Q") finish;;
*) asktype;;
esac
}

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

upgradeinstall(){
if [ "$1" == "I" ]; then 
echo "Installling new gameserver content."
else
echo "Upgrading gameserver content"
fi
if [ "$1" == "I" ]; then
$MYG < ../sql/access_levels.sql &> /dev/null
$MYG < ../sql/auction.sql &> /dev/null
$MYG < ../sql/castle.sql &> /dev/null
$MYG < ../sql/clanhall.sql &> /dev/null
$MYG < ../sql/fort.sql &> /dev/null
$MYG < ../sql/forums.sql &> /dev/null
$MYG < ../sql/grandboss_data.sql &> /dev/null
$MYG < ../sql/npc_buffer.sql &> /dev/null
$MYG < ../sql/seven_signs_festival.sql &> /dev/null
$MYG < ../sql/seven_signs_status.sql &> /dev/null
fi
$MYG < ../sql/admin_command_access_rights.sql &> /dev/null
$MYG < ../sql/armor.sql &> /dev/null
$MYG < ../sql/armorsets.sql &> /dev/null
$MYG < ../sql/auction_bid.sql &> /dev/null
$MYG < ../sql/auction_watch.sql &> /dev/null
$MYG < ../sql/auto_announcements.sql &> /dev/null
$MYG < ../sql/auto_chat.sql &> /dev/null
$MYG < ../sql/auto_chat_text.sql &> /dev/null
$MYG < ../sql/castle_door.sql &> /dev/null
$MYG < ../sql/castle_doorupgrade.sql &> /dev/null
$MYG < ../sql/castle_functions.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/char_templates.sql &> /dev/null
$MYG < ../sql/char_creation_items.sql &> /dev/null
$MYG < ../sql/character_friends.sql &> /dev/null
$MYG < ../sql/character_hennas.sql &> /dev/null
$MYG < ../sql/character_instance_time.sql &> /dev/null
$MYG < ../sql/character_macroses.sql &> /dev/null
$MYG < ../sql/character_quest_global_data.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/character_tpbookmark.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_functions.sql &> /dev/null
$MYG < ../sql/class_list.sql &> /dev/null
$MYG < ../sql/cursed_weapons.sql &> /dev/null
$MYG < ../sql/dimensional_rift.sql &> /dev/null
$MYG < ../sql/droplist.sql &> /dev/null
$MYG < ../sql/enchant_skill_trees.sql &> /dev/null
$MYG < ../sql/etcitem.sql &> /dev/null
$MYG < ../sql/fish.sql &> /dev/null
$MYG < ../sql/fishing_skill_trees.sql &> /dev/null
$MYG < ../sql/fort_doorupgrade.sql &> /dev/null
$MYG < ../sql/fort_functions.sql &> /dev/null
$MYG < ../sql/fort_siege_guards.sql &> /dev/null
$MYG < ../sql/fort_spawnlist.sql &> /dev/null
$MYG < ../sql/fort_staticobjects.sql &> /dev/null
$MYG < ../sql/fortsiege_clans.sql &> /dev/null
$MYG < ../sql/four_sepulchers_spawnlist.sql &> /dev/null
$MYG < ../sql/games.sql &> /dev/null
$MYG < ../sql/global_tasks.sql &> /dev/null
$MYG < ../sql/grandboss_list.sql &> /dev/null
$MYG < ../sql/helper_buff_list.sql &> /dev/null
$MYG < ../sql/henna.sql &> /dev/null
$MYG < ../sql/henna_trees.sql &> /dev/null
$MYG < ../sql/heroes.sql &> /dev/null
$MYG < ../sql/item_attributes.sql &> /dev/null
$MYG < ../sql/items.sql &> /dev/null
$MYG < ../sql/itemsonground.sql &> /dev/null
$MYG < ../sql/locations.sql &> /dev/null
$MYG < ../sql/lvlupgain.sql &> /dev/null
$MYG < ../sql/mapregion.sql &> /dev/null
$MYG < ../sql/merchant_areas_list.sql &> /dev/null
$MYG < ../sql/merchant_buylists.sql &> /dev/null
$MYG < ../sql/merchant_lease.sql &> /dev/null
$MYG < ../sql/merchant_shopids.sql &> /dev/null
$MYG < ../sql/merchants.sql &> /dev/null
$MYG < ../sql/minions.sql &> /dev/null
$MYG < ../sql/npc.sql &> /dev/null
$MYG < ../sql/npcskills.sql &> /dev/null
$MYG < ../sql/olympiad_data.sql &> /dev/null
$MYG < ../sql/olympiad_nobles.sql&> /dev/null
$MYG < ../sql/olympiad_nobles_eom.sql&> /dev/null
$MYG < ../sql/pets.sql &> /dev/null
$MYG < ../sql/pets_skills.sql &> /dev/null
$MYG < ../sql/pets_stats.sql &> /dev/null
$MYG < ../sql/pledge_skill_trees.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/siege_clans.sql &> /dev/null
$MYG < ../sql/skill_learn.sql &> /dev/null
$MYG < ../sql/skill_spellbooks.sql &> /dev/null
$MYG < ../sql/skill_trees.sql &> /dev/null
$MYG < ../sql/skill_residential.sql &> /dev/null
$MYG < ../sql/spawnlist.sql &> /dev/null
$MYG < ../sql/special_skill_trees.sql &> /dev/null
$MYG < ../sql/teleport.sql &> /dev/null
$MYG < ../sql/topic.sql &> /dev/null
$MYG < ../sql/transform_skill_trees.sql &> /dev/null
$MYG < ../sql/walker_routes.sql &> /dev/null
$MYG < ../sql/weapon.sql &> /dev/null
$MYG < ../sql/zone_vertices.sql &> /dev/null
newbie_helper
}

custom(){
echo ""
echo ""
echo -ne "Install custom gameserver DB tables: (y) yes or (n) no or (q) quit?"
read ASKCS
case "$ASKCS" in
"y"|"Y") cstinstall;;
"n"|"N") finish;;
"q"|"Q") finish;;
*) custom;;
esac
finish
}

cstinstall(){
while :
  do
   echo ""
   echo -ne "Do you want to make another backup of GSDB before applying custom contents? (y/N): "
   read LSB
   if [ "$LSB" == "Y" -o "$LSB" == "y" ]; then
     echo "Making a backup of the default gameserver tables."
     $MYSQLDUMPPATH --add-drop-table -h $GSDBHOST -u $GSUSER --password=$GSPASS $GSDB > custom_backup.sql 2> /dev/null
     if [ $? -ne 0 ];then
     echo ""
     echo "There was a problem accesing your GS database, server down?."
     exit 1
     fi
     break
   elif [ "$LSB" == "n" -o "$LSB" == "N" -o "$LSB" == "" ]; then 
     break
   fi
  done 
echo "Installing custom content."
for custom in $(ls ../sql/custom/*.sql);do 
$MYG < $custom &> /dev/null
done
# L2J mods that needed extra tables to work properly, should be 
# listed here. To do so copy & paste the following 6 lines and
# change them properly:
# MOD: Wedding.
  echo -ne "Install "Wedding Mod" tables? (y/N): "
  read modprompt
  if [ "$modprompt" == "Y" -o "$LSB" == "y" ]; then
	$MYG < ../sql/mods/mods_wedding.sql &> /dev/null
fi

finish
}

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

newbie_helper(){
while :
  do
   echo ""
   echo -ne "If you're not that skilled applying changes within 'updates' folder, i can try to do it for you (y). If you wish to do it on your own, choose (n). Should i parse updates files? (Y/n)"
   read NOB
   if [ "$NOB" == "Y" -o "$NOB" == "y" -o "$NOB" == "" ]; then
     echo ""
     echo "There we go, it may take some time..."
     echo "updates parser results. Last run: "`date` >database_installer.log
     for file in $(ls ../sql/updates/*sql);do
        echo $file|cut -d/ -f4 >> database_installer.log
        $MYG < $file 2>> database_installer.log
if [ $? -eq 0 ];then
    echo "no errors">> database_installer.log
fi    
done
     echo ""
     echo "Log available at $(pwd)/database_installer.log"
     echo ""
     break
   elif [ "$NOB" == "n" -o "$NOB" == "N" ]; then 
     break
   fi
  done 
}

clear
load_config $1
MYL="$MYSQLPATH -h $LSDBHOST -u $LSUSER --password=$LSPASS -D $LSDB"
MYG="$MYSQLPATH -h $GSDBHOST -u $GSUSER --password=$GSPASS -D $GSDB"
lsbackup
asklogin

Recommended Posts

  • 0
Posted

Den to eipes kala alla epidi ego sou eipa na to kaneis auto , katalaba ti thes.

 

Pigene sto database_installer kai pata deksi click.

 

Bres auth thn grammh :

 

set mysqlBinPath=C:\Program Files\MySQL\MySQL Server 5.0\bin

 

Kai bale to path tou mysql sou . An einai auto , apla alakse to version.

  • 0
Posted

re file gia des esy mia edo kanto copy kai xromatise mou tin grami giati den tin briskw

 

 

 

#!/bin/bash

############################################

## WARNING!  WARNING!  WARNING!  WARNING! ##

##                                        ##

## DON'T USE NOTEPAD TO CHANGE THIS FILE  ##

## INSTEAD USE SOME DECENT TEXT EDITOR.  ##

## NEWLINE CHARACTERS DIFFER BETWEEN DOS/ ##

## WINDOWS AND UNIX.                      ##

##                                        ##

## USING NOTEPAD TO SAVE THIS FILE WILL  ##

## LEAVE IT IN A BROKEN STATE!!!          ##

############################################

## Writen by DrLecter                    ##

## License: GNU GPL                      ##

## Based on Tiago Tagliaferri's script    ##

## E-mail: tiago_tagliaferri@msn.com      ##

## From "L2J-DataPack"                    ##

## Bug reports: http://l2jdp.com/trac    ##

############################################

trap finish 2

 

configure() {

echo "#############################################"

echo "# You entered script configuration area    #"

echo "# No change will be performed in your DB    #"

echo "# I will just ask you some questions about  #"

echo "# your hosts and DB.                        #"

echo "#############################################"

MYSQLDUMPPATH=`which -a mysqldump 2>/dev/null`

MYSQLPATH=`which -a 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

#LS

echo -ne "\nPlease enter MySQL Login Server hostname (default localhost): "

read LSDBHOST

if [ -z "$LSDBHOST" ]; then

  LSDBHOST="localhost"

fi

echo -ne "\nPlease enter MySQL Login Server database name (default l2jdb): "

read LSDB

if [ -z "$LSDB" ]; then

  LSDB="l2jdb"

fi

echo -ne "\nPlease enter MySQL Login Server user (default root): "

read LSUSER

if [ -z "$LSUSER" ]; then

  LSUSER="root"

fi

echo -ne "\nPlease enter MySQL Login Server $LSUSER's password (won't be displayed) :"

stty -echo

read LSPASS

stty echo

echo ""

if [ -z "$LSPASS" ]; then

  echo "Hum.. I'll let it be but don't be stupid and avoid empty passwords"

elif [ "$LSUSER" == "$LSPASS" ]; then

  echo "You're not too brilliant choosing passwords huh?"

fi

#GS

echo -ne "\nPlease enter MySQL Game Server hostname (default $LSDBHOST): "

read GSDBHOST

if [ -z "$GSDBHOST" ]; then

  GSDBHOST="$LSDBHOST"

fi

echo -ne "\nPlease enter MySQL Game Server database name (default $LSDB): "

read GSDB

if [ -z "$GSDB" ]; then

  GSDB="$LSDB"

fi

echo -ne "\nPlease enter MySQL Game Server user (default $LSUSER): "

read GSUSER

if [ -z "$GSUSER" ]; then

  GSUSER="$LSUSER"

fi

echo -ne "\nPlease enter MySQL Game Server $GSUSER's password (won't be displayed): "

stty -echo

read GSPASS

stty echo

echo ""

if [ -z "$GSPASS" ]; then

  echo "Hum.. I'll let it be but don't be stupid and avoid empty passwords"

elif [ "$GSUSER" == "$GSPASS" ]; then

  echo "You're not too brilliant choosing passwords huh?"

fi

save_config $1

}

 

save_config() {

if [ -n "$1" ]; then

CONF="$1"

else

CONF="database_installer.rc"

fi

echo ""

echo "With these data I can generate a configuration file which can be read"

echo "on future updates. WARNING: this file will contain clear text passwords!"

echo -ne "Shall I generate config file $CONF? (Y/n):"

read SAVE

if [ "$SAVE" == "y" -o "$SAVE" == "Y" -o "$SAVE" == "" ];then

cat <<EOF>$CONF

#Configuration settings for L2J-Datapack database installer script

MYSQLDUMPPATH=$MYSQLDUMPPATH

MYSQLPATH=$MYSQLPATH

LSDBHOST=$LSDBHOST

LSDB=$LSDB

LSUSER=$LSUSER

LSPASS=$LSPASS

GSDBHOST=$GSDBHOST

GSDB=$GSDB

GSUSER=$GSUSER

GSPASS=$GSPASS

EOF

chmod 600 $CONF

echo "Configuration saved as $CONF"

echo "Permissions changed to 600 (rw- --- ---)"

elif [ "$SAVE" != "n" -a "$SAVE" != "N" ]; then

  save_config

fi

}

 

load_config() {

if [ -n "$1" ]; then

CONF="$1"

else

CONF="database_installer.rc"

fi

if [ -e "$CONF" ] && [ -f "$CONF" ]; then

. $CONF

else

echo "Settings file not found: $CONF"

echo "You can specify an alternate settings filename:"

echo $0 config_filename

echo ""

echo "If file doesn't exist it can be created"

echo "If nothing is specified script will try to work with ./database_installer.rc"

echo ""

configure $CONF

fi

}

 

asklogin(){

echo "#############################################"

echo "# WARNING: This section of the script CAN  #"

echo "# destroy your characters and accounts      #"

echo "# information. Read questions carefully    #"

echo "# before you reply.                        #"

echo "#############################################"

echo ""

echo "Choose full (f) if you don't have and 'accounts' table or would"

echo "prefer to erase the existing accounts information."

echo "Choose skip (s) to skip loginserver DB installation and go to"

echo "gameserver DB installation/upgrade."

echo -ne "LOGINSERVER DB install type: (f) full, (s) skip or (q) quit? "

read LOGINPROMPT

case "$LOGINPROMPT" in

"f"|"F") logininstall; loginupgrade; gsbackup; asktype;;

"s"|"S") gsbackup; asktype;;

"q"|"Q") finish;;

*) asklogin;;

esac

}

 

logininstall(){

echo "Deleting loginserver tables for new content."

$MYL < login_install.sql &> /dev/null

}

 

loginupgrade(){

echo "Installling new loginserver content."

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

$MYL < ../sql/account_data.sql &> /dev/null

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

}

 

gsbackup(){

while :

  do

  echo ""

  echo -ne "Do you want to make a backup copy of your GSDB? (y/n): "

  read LSB

  if [ "$LSB" == "Y" -o "$LSB" == "y" ]; then

    echo "Making a backup of the original gameserver database."

    $MYSQLDUMPPATH --add-drop-table -h $GSDBHOST -u $GSUSER --password=$GSPASS $GSDB > gameserver_backup.sql

    if [ $? -ne 0 ];then

    echo ""

    echo "There was a problem accesing your GS database, either it wasnt created or authentication data is incorrect."

    exit 1

    fi

    break

  elif [ "$LSB" == "n" -o "$LSB" == "N" ]; then

    break

  fi

  done

}

 

lsbackup(){

while :

  do

  echo ""

  echo -ne "Do you want to make a backup copy of your LSDB? (y/n): "

  read LSB

  if [ "$LSB" == "Y" -o "$LSB" == "y" ]; then

    echo "Making a backup of the original loginserver database."

    $MYSQLDUMPPATH --add-drop-table -h $LSDBHOST -u $LSUSER --password=$LSPASS $LSDB > loginserver_backup.sql

    if [ $? -ne 0 ];then

        echo ""

        echo "There was a problem accesing your LS database, either it wasnt created or authentication data is incorrect."

        exit 1

    fi

    break

  elif [ "$LSB" == "n" -o "$LSB" == "N" ]; then

    break

  fi

  done

}

 

asktype(){

echo ""

echo ""

echo "WARNING: A full install (f) will destroy all existing character data."

echo -ne "GAMESERVER DB install type: (f) full install, (u) upgrade, (s) skip or (q) quit? "

read INSTALLTYPE

case "$INSTALLTYPE" in

"f"|"F") fullinstall; upgradeinstall I; custom;;

"u"|"U") upgradeinstall U; custom;;

"s"|"S") custom;;

"q"|"Q") finish;;

*) asktype;;

esac

}

 

fullinstall(){

echo "Deleting all gameserver tables for new content."

$MYG < full_install.sql &> /dev/null

}

 

upgradeinstall(){

if [ "$1" == "I" ]; then

echo "Installling new gameserver content."

else

echo "Upgrading gameserver content"

fi

if [ "$1" == "I" ]; then

$MYG < ../sql/access_levels.sql &> /dev/null

$MYG < ../sql/auction.sql &> /dev/null

$MYG < ../sql/castle.sql &> /dev/null

$MYG < ../sql/clanhall.sql &> /dev/null

$MYG < ../sql/fort.sql &> /dev/null

$MYG < ../sql/forums.sql &> /dev/null

$MYG < ../sql/grandboss_data.sql &> /dev/null

$MYG < ../sql/npc_buffer.sql &> /dev/null

$MYG < ../sql/seven_signs_festival.sql &> /dev/null

$MYG < ../sql/seven_signs_status.sql &> /dev/null

fi

$MYG < ../sql/admin_command_access_rights.sql &> /dev/null

$MYG < ../sql/armor.sql &> /dev/null

$MYG < ../sql/armorsets.sql &> /dev/null

$MYG < ../sql/auction_bid.sql &> /dev/null

$MYG < ../sql/auction_watch.sql &> /dev/null

$MYG < ../sql/auto_announcements.sql &> /dev/null

$MYG < ../sql/auto_chat.sql &> /dev/null

$MYG < ../sql/auto_chat_text.sql &> /dev/null

$MYG < ../sql/castle_door.sql &> /dev/null

$MYG < ../sql/castle_doorupgrade.sql &> /dev/null

$MYG < ../sql/castle_functions.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/char_templates.sql &> /dev/null

$MYG < ../sql/char_creation_items.sql &> /dev/null

$MYG < ../sql/character_friends.sql &> /dev/null

$MYG < ../sql/character_hennas.sql &> /dev/null

$MYG < ../sql/character_instance_time.sql &> /dev/null

$MYG < ../sql/character_macroses.sql &> /dev/null

$MYG < ../sql/character_quest_global_data.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/character_tpbookmark.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_functions.sql &> /dev/null

$MYG < ../sql/class_list.sql &> /dev/null

$MYG < ../sql/cursed_weapons.sql &> /dev/null

$MYG < ../sql/dimensional_rift.sql &> /dev/null

$MYG < ../sql/droplist.sql &> /dev/null

$MYG < ../sql/enchant_skill_trees.sql &> /dev/null

$MYG < ../sql/etcitem.sql &> /dev/null

$MYG < ../sql/fish.sql &> /dev/null

$MYG < ../sql/fishing_skill_trees.sql &> /dev/null

$MYG < ../sql/fort_doorupgrade.sql &> /dev/null

$MYG < ../sql/fort_functions.sql &> /dev/null

$MYG < ../sql/fort_siege_guards.sql &> /dev/null

$MYG < ../sql/fort_spawnlist.sql &> /dev/null

$MYG < ../sql/fort_staticobjects.sql &> /dev/null

$MYG < ../sql/fortsiege_clans.sql &> /dev/null

$MYG < ../sql/four_sepulchers_spawnlist.sql &> /dev/null

$MYG < ../sql/games.sql &> /dev/null

$MYG < ../sql/global_tasks.sql &> /dev/null

$MYG < ../sql/grandboss_list.sql &> /dev/null

$MYG < ../sql/helper_buff_list.sql &> /dev/null

$MYG < ../sql/henna.sql &> /dev/null

$MYG < ../sql/henna_trees.sql &> /dev/null

$MYG < ../sql/heroes.sql &> /dev/null

$MYG < ../sql/item_attributes.sql &> /dev/null

$MYG < ../sql/items.sql &> /dev/null

$MYG < ../sql/itemsonground.sql &> /dev/null

$MYG < ../sql/locations.sql &> /dev/null

$MYG < ../sql/lvlupgain.sql &> /dev/null

$MYG < ../sql/mapregion.sql &> /dev/null

$MYG < ../sql/merchant_areas_list.sql &> /dev/null

$MYG < ../sql/merchant_buylists.sql &> /dev/null

$MYG < ../sql/merchant_lease.sql &> /dev/null

$MYG < ../sql/merchant_shopids.sql &> /dev/null

$MYG < ../sql/merchants.sql &> /dev/null

$MYG < ../sql/minions.sql &> /dev/null

$MYG < ../sql/npc.sql &> /dev/null

$MYG < ../sql/npcskills.sql &> /dev/null

$MYG < ../sql/olympiad_data.sql &> /dev/null

$MYG < ../sql/olympiad_nobles.sql&> /dev/null

$MYG < ../sql/olympiad_nobles_eom.sql&> /dev/null

$MYG < ../sql/pets.sql &> /dev/null

$MYG < ../sql/pets_skills.sql &> /dev/null

$MYG < ../sql/pets_stats.sql &> /dev/null

$MYG < ../sql/pledge_skill_trees.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/siege_clans.sql &> /dev/null

$MYG < ../sql/skill_learn.sql &> /dev/null

$MYG < ../sql/skill_spellbooks.sql &> /dev/null

$MYG < ../sql/skill_trees.sql &> /dev/null

$MYG < ../sql/skill_residential.sql &> /dev/null

$MYG < ../sql/spawnlist.sql &> /dev/null

$MYG < ../sql/special_skill_trees.sql &> /dev/null

$MYG < ../sql/teleport.sql &> /dev/null

$MYG < ../sql/topic.sql &> /dev/null

$MYG < ../sql/transform_skill_trees.sql &> /dev/null

$MYG < ../sql/walker_routes.sql &> /dev/null

$MYG < ../sql/weapon.sql &> /dev/null

$MYG < ../sql/zone_vertices.sql &> /dev/null

newbie_helper

}

 

custom(){

echo ""

echo ""

echo -ne "Install custom gameserver DB tables: (y) yes or (n) no or (q) quit?"

read ASKCS

case "$ASKCS" in

"y"|"Y") cstinstall;;

"n"|"N") finish;;

"q"|"Q") finish;;

*) custom;;

esac

finish

}

 

cstinstall(){

while :

  do

  echo ""

  echo -ne "Do you want to make another backup of GSDB before applying custom contents? (y/N): "

  read LSB

  if [ "$LSB" == "Y" -o "$LSB" == "y" ]; then

    echo "Making a backup of the default gameserver tables."

    $MYSQLDUMPPATH --add-drop-table -h $GSDBHOST -u $GSUSER --password=$GSPASS $GSDB > custom_backup.sql 2> /dev/null

    if [ $? -ne 0 ];then

    echo ""

    echo "There was a problem accesing your GS database, server down?."

    exit 1

    fi

    break

  elif [ "$LSB" == "n" -o "$LSB" == "N" -o "$LSB" == "" ]; then

    break

  fi

  done

echo "Installing custom content."

for custom in $(ls ../sql/custom/*.sql);do

$MYG < $custom &> /dev/null

done

# L2J mods that needed extra tables to work properly, should be

# listed here. To do so copy & paste the following 6 lines and

# change them properly:

# MOD: Wedding.

  echo -ne "Install "Wedding Mod" tables? (y/N): "

  read modprompt

  if [ "$modprompt" == "Y" -o "$LSB" == "y" ]; then

$MYG < ../sql/mods/mods_wedding.sql &> /dev/null

fi

 

finish

}

 

finish(){

echo ""

echo "Script execution finished."

exit 0

}

 

newbie_helper(){

while :

  do

  echo ""

  echo -ne "If you're not that skilled applying changes within 'updates' folder, i can try to do it for you (y). If you wish to do it on your own, choose (n). Should i parse updates files? (Y/n)"

  read NOB

  if [ "$NOB" == "Y" -o "$NOB" == "y" -o "$NOB" == "" ]; then

    echo ""

    echo "There we go, it may take some time..."

    echo "updates parser results. Last run: "`date` >database_installer.log

    for file in $(ls ../sql/updates/*sql);do

        echo $file|cut -d/ -f4 >> database_installer.log

        $MYG < $file 2>> database_installer.log

if [ $? -eq 0 ];then

    echo "no errors">> database_installer.log

fi   

done

    echo ""

    echo "Log available at $(pwd)/database_installer.log"

    echo ""

    break

  elif [ "$NOB" == "n" -o "$NOB" == "N" ]; then

    break

  fi

  done

}

 

clear

load_config $1

MYL="$MYSQLPATH -h $LSDBHOST -u $LSUSER --password=$LSPASS -D $LSDB"

MYG="$MYSQLPATH -h $GSDBHOST -u $GSUSER --password=$GSPASS -D $GSDB"

lsbackup

asklogin

 

  • 0
Posted

Mou leei to systima den einai se kathorismeni thesi ...

 

#!/bin/bash    <-------- Mhpws einai auto?????

############################################

## WARNING!  WARNING!  WARNING!  WARNING! ##

##                                        ##

## DON'T USE NOTEPAD TO CHANGE THIS FILE  ##

## INSTEAD USE SOME DECENT TEXT EDITOR.  ##

## NEWLINE CHARACTERS DIFFER BETWEEN DOS/ ##

## WINDOWS AND UNIX.                      ##

##                                        ##

## USING NOTEPAD TO SAVE THIS FILE WILL  ##

## LEAVE IT IN A BROKEN STATE!!!          ##

############################################

## Writen by DrLecter                    ##

## License: GNU GPL                      ##

## Based on Tiago Tagliaferri's script    ##

## E-mail: tiago_tagliaferri@msn.com      ##

## From "L2J-DataPack"                    ##

## Bug reports: http://l2jdp.com/trac    ##

#################################

 

 

  • 0
Posted

Mou leei to systima den einai se kathorismeni thesi ...

 

#!/bin/bash    <-------- Mhpws einai auto?????

############################################

## WARNING!  WARNING!  WARNING!  WARNING! ##

##                                        ##

## DON'T USE NOTEPAD TO CHANGE THIS FILE  ##

## INSTEAD USE SOME DECENT TEXT EDITOR.  ##

## NEWLINE CHARACTERS DIFFER BETWEEN DOS/ ##

## WINDOWS AND UNIX.                      ##

##                                        ##

## USING NOTEPAD TO SAVE THIS FILE WILL  ##

## LEAVE IT IN A BROKEN STATE!!!          ##

############################################

## Writen by DrLecter                    ##

## License: GNU GPL                      ##

## Based on Tiago Tagliaferri's script    ##

## E-mail: tiago_tagliaferri@msn.com      ##

## From "L2J-DataPack"                    ##

## Bug reports: http://l2jdp.com/trac    ##

#################################

 

 

lol oxi.

 

kane Install k ama sou bgalei error post.

  • 0
Posted

Bale to path tou mysql sou ekei kai ksanadokimase.

 

lol oxi.

 

kane Install k ama sou bgalei error post.

 

auto pige na kanei kai tou ebgale auto to error.

  • 0
Posted

Adenas: 801.00

 

View Inventory

Send Money to teris2

 

 

View Profile Email Personal Message (Online)

 

 

Re: Pos na kanw instal ti Mysql

« Reply #2 on: Today at 09:34:16 PM »

Reply with quoteQuote

re file gia des esy mia edo kanto copy kai xromatise mou tin grami giati den tin briskw

 

 

 

#!/bin/bash

############################################

## WARNING!  WARNING!  WARNING!  WARNING! ##

##                                        ##

## DON'T USE NOTEPAD TO CHANGE THIS FILE  ##

## INSTEAD USE SOME DECENT TEXT EDITOR.   ##

## NEWLINE CHARACTERS DIFFER BETWEEN DOS/ ##

## WINDOWS AND UNIX.                      ##

##                                        ##

## USING NOTEPAD TO SAVE THIS FILE WILL   ##

## LEAVE IT IN A BROKEN STATE!!!          ##

############################################

## Writen by DrLecter                     ##

## License: GNU GPL                       ##

## Based on Tiago Tagliaferri's script    ##

## E-mail: tiago_tagliaferri@msn.com      ##

## From "L2J-DataPack"                    ##

## Bug reports: http://l2jdp.com/trac     ##

############################################

trap finish 2

 

configure() {

echo "#############################################"

echo "# You entered script configuration area     #"

echo "# No change will be performed in your DB    #"

echo "# I will just ask you some questions about  #"

echo "# your hosts and DB.                        #"

echo "#############################################"

MYSQLDUMPPATH=`which -a mysqldump 2>/dev/null`

MYSQLPATH=`which -a 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

  • 0
Posted

file mia erotisi me " ?????

 

Nai. Auto edw prepei na alakseis : $MYSQLBINPATH/mysql

 

ti pack xrisimopheis?

 

Fenetai sto database_installer tou. Den xriazotan na kaneis auto to post.

 

L2J xrhsimopoiei.

  • 0
Posted

MYSQLPATH="C:\Program Files\MySQL\MySQL Server 6.0\bin\mysql.exe" file etc prepei na eiani Verison 6.0 exw

nai.

 

btw @Commodus den to eixa dei.

Guest
This topic is now closed to further replies.


×
×
  • Create New...