[Guide] Executing SQL files faster - Importing DB faster

[latruwski]

Well i see a lot of people use navicat or sqlyog or whatever to import big DBs... This can take verry long with SQL managers :-/
How to make it faster? using a tool.bat !

@ECHO off
REM ############################################################################
REM #
REM #      B A S I C   U S E R   C O N F I G U R A T I O N   A R E A
REM #
REM ############################################################################
set user=root
set pass=root
REM  WorldDB  -  is the World Database
REM If you do not have them seperated then set them to the same values
set WorldDB=ncdb023
REM ############################################################################
REM #
REM #    A D V A N C E D   U S E R   C O N F I G U R A T I O N   A R E A
REM #
REM ############################################################################
set port=3306
set server=localhost
REM ############################################################################
REM #
REM #     D O   N O T   M O D I F Y   B E Y O N D   T H I S   P O I N T
REM #
REM ############################################################################
if %user% == CHANGEME GOTO id10t
if %pass% == CHANGEME GOTO id10t
:menu
cls
ECHO.
ECHO.
ECHO        ####################################
ECHO        #######      Latruwski       #######
ECHO        ######       Database         ######
ECHO        #######     Import Tool      #######
ECHO         ########  www.mmowned.com   ########
ECHO        ####################################
ECHO.
ECHO        Please type the letter for the option:
ECHO.
ECHO         w = Install Full-DB.sql
ECHO.
ECHO         Edited by latruwski - Modified from NCDB tool
ECHO.
ECHO.
ECHO         x - Exit
ECHO.
set /p l=            Enter Letter:
if %l%==* goto error
if %l%==w goto world
if %l%==W goto world
if %l%==u goto update
if %l%==U goto update
if %l%==x goto quit
if %l%==X goto quit
goto error
:world
CLS
ECHO.
ECHO.
ECHO [Importing] World database import Started...
mysql -h %server% --user=%user% --password=%pass% --port=%port% %WorldDB% < Full-DB.sql
ECHO [Importing] Finished
ECHO.
PAUSE    
GOTO menu
:update
CLS
ECHO.
ECHO.
ECHO [Importing] World database update Started...
mysql -h %server% --user=%user% --password=%pass% --port=%port% %WorldDB% < Full-Update.sql
ECHO [Importing] Updated Finished!
ECHO.
PAUSE    
GOTO menu
:error
CLS
ECHO.
ECHO.
ECHO [ERROR] An error has occured, you will be directed back to the
ECHO [ERROR] main menu.
PAUSE    
GOTO menu
:id10t
CLS
ECHO.
ECHO.
ECHO [FAILURE] You did not change the proper directives in this file.
ECHO [FAILURE] Please edit this script and fill in the proper MYSQL Information.
ECHO [FAILURE] When the information is correct: Please Try Again.
PAUSE    
GOTO quit  
:quit

this is basicly a modified version of NCDB tool...
here is how to use:
Copy this to notepad
You need to change the green part to your Database information:
set user=
set pass=
set WorldDB=
to your DB username, password and WorldDB name

If you run you database on localhost then you are done...
Save this as a .bat file
I zipped the tool.bat for localhost here:
Filebeam - Free Fast File Hosting
and you need to put this file in the same directory as Tool.bat:
Filebeam - Free Fast File Hosting
(unzip it first!)

Here is the downloadlink for the 2 files in 1 link:
Filebeam - Free Fast File Hosting

note: this is a .bat file already, to edit the information inside just right click -> open with notepad
just rename the SQL file with the DB to Full-DB.sql and execute tool.bat
(make sure tool.bat, mysql.exe AND the Full-DB.sql are in the same folder )

When the database is not hosted locally you need to change the red part also:
set port=3306
set server=localhost
to the DB host information

same thing to do here... rename the DB SQL file or Update SQL file to Full-DB.sql and execute tool.bat

Why using tool.bat?
You will notice with a bat file importing a DB goes WAY faster then using a SQL manager!
Also it is easy to use!


Important notes!
-> Change the filename of the SQL file you wish to execute to "Full-DB.sql"
-> You can also use this tool to import updates or other sql files
-> All 3 files have to be in the same folder (tool.bat, mysql.exe and Full-DB.sql)

Well i hope this helped to some people

grtz

[latruwski]

*bump*

seriously you got to use this instead of waiting hours for a DB to be imported

grtz

[Sonic Waffle]

Ah, nice one man! +Rep

[latruwski]

Ah, nice one man! +Rep

thx, i hope a lot of people gonna start using bat files instead of sql manager to import a DB ^^

grtz

[jokerjokes]

Yes i used the Ncdb One since i like there releases lol but gj man

[latruwski]

Yes i used the Ncdb One since i like there releases lol but gj man

yea but some people stil lkeep asking why it goes so slow with navicat ><
i dont understand, if there is a guide section people should read it before asking questions :-/ i guess they are "too lazy?"

grtz

[Netzgeist]

Just lol'ed. Not cause the guide (the advice is ok), but of the fact that people still use windows as servers. Noones realising that its a pure waste of capabillities running a desktop enviroment on a server?

[latruwski]

Just lol'ed. Not cause the guide (the advice is ok), but of the fact that people still use windows as servers. Noones realising that its a pure waste of capabillities running a desktop enviroment on a server?

yea but you can use bat files for external DBs also... and hell lot of people like to play on their own private server to be GM and mess arround ^^ not to make it public... (not always)

grtz

[dcarz]

Theres no game if you havent got players on it, its much more funner when you can do events or make many custom stuff that people would like it...

[latruwski]

Theres no game if you havent got players on it, its much more funner when you can do events or make many custom stuff that people would like it...

true but there are people who like to play on their own...
and believe me when i say: hell lot of people wnt a private server for their own to test GM powers xD they think being GM is sooo imba lol

grtz

[dcarz]

I played with
GM powers for about 1 day,
I saw whats good, ive been sucked bored, and then i started makin my server publick and custom and fun so that GM power would grow up....

lol

[dcarz]

Hay can you help me to make that I have good ideas how to make a good public server and how to make money grom it, would you help me, i would make you a moderator in my country , and i would share money with you (from the server),

I ve tried to make it my own but it seems i need an emulator master.

If youre interested post here or write me:

E-mail --> [email protected]

Skype ---> guzas15

MSN ---> [email protected]

[bill45]

This is nice

[Darkhunter123]

having a problem here when i start to run it it says

[Importing] World database import Started...
'mysql' is not recognized as an internal or external command,
operable program or batch file.
[Importing] Finished
Press any key to continue . . .

[latruwski]

having a problem here when i start to run it it says

[Importing] World database import Started...
'mysql' is not recognized as an internal or external command,
operable program or batch file.
[Importing] Finished
Press any key to continue . . .

yep i am sorry... i forgot to add something...
unrar this file and put it in the same folder as tool.bat and Full-DB.sql:
Filebeam - Free Fast File Hosting

grtz

edit: added new downloadlinks to the 1st post