Page 1 of 1

One SQL Injection Full Database

Posted: Thu Aug 01, 2013 12:36 am
by WiiStream
This is full database one file injection. Installing the database takes for ever doing it one by one this way much faster.

This is for Rev 3890

Re: One SQL Injection Full Database

Posted: Thu Aug 01, 2013 8:45 am
by lautan
I don't recommend running this. This will get out of date fast and will cause potential bugs / crashes. I remember seeing a batch script that runs all updated sql files.

Re: One SQL Injection Full Database

Posted: Thu Aug 01, 2013 4:39 pm
by atom0s

Code: Select all

@ECHO OFF
REM =============================================================================
REM =============================================================================
REM ======                                                              =========
REM ====== THis script will drop the DB specificed, then create the DB  =========
REM ====== specified, and then load all .sql tables from its run dir to =========
REM ====== the the DB.                                                  =========
REM ======                                                              =========
REM ====== File needs to be run from within the \dsp\sql folder (same   =========
REM ====== folder with all the .sql files. Please edit as needed. By    =========
REM ====== default it WILL DROP the standard dspdb DB, loosing all      =========
REM ====== accounts and characters. If this is not desired, then update =========
REM ====== the file to load the new DB into a new DB name.              =========
REM ======                                                              =========
REM ====== Update -p with MySQL password. If you password is 'foo',     =========
REM ====== then change '-pMYSQLPASS' to '-pfoo' (3 places).             =========
REM ======                                                              =========
REM ====== If you want to use a different database name, change 'dspdb' =========
REM ====== with a database name of your choosing.                       =========
REM ======                                                              =========
REM =============================================================================
REM =============================================================================
REM ======                                                              =========
REM ====== by Thrydwolf 9/8/2012                                        =========
REM ====== Updated with status by bluekirby0 3/30/2012                  =========
REM ====== Updated by Thrydwolf 9/18/2012                               =========
REM ======                                                              =========
REM =============================================================================
REM =============================================================================

ECHO Creating Database dspdb
mysqladmin -h localhost -u root -pPASSWORD_HERE DROP dspdb

ECHO Creating Database dspdb
mysqladmin -h localhost -u root -pPASSWORD_HERE CREATE dspdb

ECHO Loading dspdb with tables
REM FOR %%X IN (*.sql) DO mysql dspdb -h localhost -u root -pPASSWORD_HERE < %%X
FOR %%X IN (*.sql) DO ECHO Importing %%X & mysql dspdb -h localhost -u root -pPASSWORD_HERE < %%X

ECHO Finished!
Save as a batch in the sql folder. Edit the name/pass/port as needed in all the spots.

Re: One SQL Injection Full Database

Posted: Sat Aug 24, 2013 3:32 pm
by atom0s
Moved to committed since it is not really something that will be added as it is not needed/wanted.