SQL executes taking for ever

[LJN]

I am executing the new project silvermoon DB. IT will take 30min to only insert 5000 of 162034. Does any one know why? And dont say "Because its big?" Because thats not the reason +Rep

[Spartansp]

try closing all programs running and let only your SQL manager to work... maybe thats the prob

[LJN]

Nope and btw weres the cracked navicat on mmowned? Im going to see if that will work.

[LJN]

Please some one help +Rep x4 no joke!

[Spartansp]

ok here is a download link for navicat plus crack http://w13.easy-share.com/1114598.html

[2dgreengiant]

this isnt a warez forum and it may be your comp

[Tom_2001]

I agree with nano this seems like your pc is F****ing up..

[C.C.]

Use SQLYog? Its executes faster.

-Bloodkip

[Ophie]

Try opening the sql file and delete the comments. It worked for me in the past. Oh and use SQLyog.

[Steph]

Its the difference between SQL dumps and importing seperate tables like NCDB.

Personally, as this has only been happening with the last couple of weeks of dumps its either:

A) a problem with the mysql programs dumping the files in the first place
B) an update to the databases themselves which causes a problem with the import

I honestly dont know what it is, but it's affecting lots of people, where as a few weeks ago, I never noticed it.

[latruwski]

try using a tool.bat file !
(get it from ncdb svn)
change the info inside the bat file with notepad and the DB will be executed way faster then any SQL manager

grtz

[LJN]

Ok can you help me a little tho

[latruwski]

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        #######     Next Chapter     #######
ECHO        ######        Database        ######
ECHO        #######     Import Tool      #######
ECHO        ####################################
ECHO.
ECHO        Please type the letter for the option:
ECHO.
ECHO         w = Install Full-DB.sql
ECHO.
ECHO         Edited by latruwski
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

if you are running your DB on localhost then you only need to change the upper part (in green) with password and username for your DB... then rename the SQL file (DB you wnt to import) to Full-DB.sql

save this as a .bat file for example tool.bat

then just execute it and select "import world DB"

grtz

note, i edited the tool.bat for u:
Filebeam - Free Fast File Hosting

so you can use this if your DB is on localhost... just edit this txt file i uploaded and change your DB info (posted above between code tags in green)
set user=root
set pass=root
set WorldDB=ncdb023
change that to your info... username, password and databasename
rename the tool.txt to tool.bat and execute !

[Spartansp]

always helping latruwski hope that helped you out nightmare

[LJN]

Woot you rule +rep x4

EDIT: Dang it can't got to spreed rep around