How to make your own installer for your database

[aznboy]

@ECHO off
REM ^^^^^^^^^^^^^^^^^^^^
REM MYSQL
REM Configuration
REM ^^^^^^^^^^^^^^^^^^^^
REM ^^^^^^
set user= ( Your MYSQL Username Goes Here )
set pass= ( Your MYSQL Password Goes Here )
set wdb= ( Your MYSQL World Database Goes Here )
set cdb= ( Your MYSQL Character Database Goes Here )
REM ^^^^^^^^^^^^^^^^^^^^^^
REM Do Not Edit
REM BEllow
REM ^^^^^^^^^^^^^^^^^^^^^^
REM ^^^^^
set port=3306
set server=localhost
set devpath=.\Database
set mysqlpath=.\Database
:menu
cls
ECHO.
ECHO.
ECHO (AnyPicture you want to make like a middle finger lol)
ECHO
ECHO
ECHO
ECHO
ECHO.
ECHO
ECHO.
ECHO w =(Name Whatever you want to install)
ECHO.
ECHO.
ECHO.
ECHO.
ECHO.
ECHO x - Exit
ECHO.
set /p l= Enter Letter:
if %l%==Command to go into the installer
if %l%==For Capitalize Letter
if %l%==x goto quit
if %l%==X goto quit
Wanna put something like world or else it would just close by iteself)
CLS
ECHO.
ECHO.
ECHO [Anything go in here that will load it]
ECHO [Importing]Show what you are importing
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\ai_agents.sql (Put as much of these if you have all the single .sql fourm
ECHO [Importing] Importing 100 Finished
ECHO.
PAUSE
GOTO menu
:quit (Need this at the end or else it wont work and stop)

When you are configing. Dont leave any space on there or it wont get the right correct Info to log in.

If you want to see an example. I have the Venice Importer:

@ECHO off
REM                               ^^^^^^^^^^^^^^^^^^^^
REM                                     MYSQL
REM                                 Configuration
REM                               ^^^^^^^^^^^^^^^^^^^^
REM                                     ^^^^^^
set user= ( Your MYSQL Username Goes Here )
set pass= ( Your MYSQL Password Goes Here )
set wdb=  ( Your MYSQL World Database Goes Here )	
set cdb=  ( Your MYSQL Character Database Goes Here )
REM                              ^^^^^^^^^^^^^^^^^^^^^^
REM                                   Do Not Edit 
REM                                      BEllow
REM                              ^^^^^^^^^^^^^^^^^^^^^^
REM                                      ^^^^^
set port=3306
set server=localhost
set devpath=.\Database
set mysqlpath=.\Database
:menu
cls
ECHO.
ECHO.
ECHO		     
ECHO		     
ECHO		     
ECHO		     
ECHO              	    
ECHO.
ECHO		
ECHO.
ECHO		 w =(Name Whatever you want to install)
ECHO.
ECHO.		 
ECHO.		 
ECHO.
ECHO.		 
ECHO		 x - Exit
ECHO.
set /p l=            Enter Letter:
if %l%==w goto world
if %l%==W goto world
if %l%==x goto quit
if %l%==X goto quit
:world
CLS
ECHO.
ECHO.
ECHO [Loading Database ..................... Loading Complete]
ECHO [Importing] Importing 10
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\All-Tables\ai_agents.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\All-Tables\ai_threattospellid.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\All-Tables\creature_formations.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\All-Tables\creature_names.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\All-Tables\creature_proto.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\All-Tables\petdefaultspells.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\All-Tables\npc_gossip_textid.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\All-Tables\npc_monstersay.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\All-Tables\npc_text.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\All-Tables\auctionhouse.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\All-Tables\ItemPetFood.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\All-Tables\Transport_creatures.sql
ECHO [Importing]  Importing 20
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\All-Tables\creatureloot.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\All-Tables\fishingloot.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\All-Tables\itemloot.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\All-Tables\item_randomprop_groups.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\All-Tables\item_randomsuffix_groups.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\All-Tables\objectloot.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\All-Tables\prospectingloot.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\All-Tables\pickpocketingloot.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\All-Tables\skinningloot.sql
ECHO [Importing] Importing 29
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\All-Tables\itempages.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\All-Tables\items.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\All-Tables\vendors.sql
ECHO [Importing] Importing 39
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\All-Tables\gameobject_quest_finisher.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\All-Tables\gameobject_quest_starter.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\All-Tables\creature_quest_finisher.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\All-Tables\creature_quest_starter.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\All-Tables\quests.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\All-Tables\gameobject_quest_item_binding.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\All-Tables\gameobject_quest_pickup_binding.sql
ECHO [Importing] Importing 45
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\All-Tables\reputation_creature_onkill.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\All-Tables\reputation_faction_onkill.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\All-Tables\reputation_instance_onkill.sql
ECHO [Importing] Importing 58
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\All-Tables\playercreateinfo.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\All-Tables\playercreateinfo_bars.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\All-Tables\playercreateinfo_items.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\All-Tables\playercreateinfo_skills.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\All-Tables\playercreateinfo_spells.sql
ECHO [Importing] Importing 59
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\All-Tables\creature_spawns.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\All-Tables\creature_staticspawns.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\All-Tables\creature_waypoints.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\All-Tables\fishing.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\All-Tables\gameobject_spawns.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\All-Tables\gameobject_staticspawns.sql
ECHO [Importing] Importing 62
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\All-Tables\banned_names.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\All-Tables\banned_pharses.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\All-Tables\weather.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\All-Tables\worldmap_info.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\All-Tables\zoneguards.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\All-Tables\transport_data.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\All-Tables\areatriggers.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\All-Tables\recall.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\All-Tables\graveyards.sql
ECHO [Importing] Importing 69
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\All-Tables\spellextra.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\All-Tables\spelloverride.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\All-Tables\spells112.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\All-Tables\spell_disable.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\All-Tables\spell_disable_trainers.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\All-Tables\teleport_coords.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\All-Tables\totemspells.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\All-Tables\trainer_defs.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\All-Tables\trainer_spells.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\All-Tables\trainerspelloverride.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\All-Tables\spell_proc_data.sql
ECHO [Importing] Importing 79
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\All-Tables\gameobject_names.sql
ECHO [Importing] Importing 85
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\All-Tables\creature_names_localized.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\All-Tables\gameobject_names_localized.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\All-Tables\itempages_localized.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\All-Tables\items_localized.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\All-Tables\npc_text_localized.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\All-Tables\quests_localized.sql
ECHO [Importing] Importing 88
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\All-Tables\clientaddons.sql
ECHO [Importing] Importing 89
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\All-Tables\command_overrides.sql
ECHO [Importing] Importing 90
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\All-Tables\map_checkpoint.sql
ECHO [Importing] Importing 92
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\All-Tables\wordfilter_character_names.sql
ECHO [Importing] Importing 98
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\All-Tables\wordfilter_chat.sql
ECHO [Importing] Importing 100 Finished
ECHO.
PAUSE    
GOTO menu
  :quit

[[Blackstorm]]

so..what does this do?

[aznboy]

You know how it is when loading in the database like heldisql or navicat?? and it freeze up your computer while it is loading all that data file.. Well what the installer does is something like that but much easier and it is faster really try it out if you want

[latruwski]

i feel bad for posting this:
http://www.mmowned.com/forums/emulat...db-faster.html
in guides section >< people probably dont read it anymore :-/

[aznboy]

i didnt know u posted this lol i did use search