Silent database import installer - Revision history

ConversionBot: Adding new author and category links.

2005-06-24T13:50:25Z

Adding new author and category links.

â† Older revision		Revision as of 13:50, 24 June 2005
Line 1:		Line 1:
	{~~\|align=right~~		{{PageAuthor\|sunjammer}}
	~~\|<small>Author: [[~~{~~{ns:2}}:sunjammer~~\|sunjammer~~]] ([[{{ns:3}}:sunjammer\|talk]], [[{{ns:-1}~~}~~:Contributions/sunjammer\|contrib]])</small>~~
	\|}
	~~<br style="clear:both;">~~
	== Description ==		== Description ==
	This was an installer I created to import the NSIS Archive database contents into my own local database. Anyone wanting to use the nsExec plugin should find this interesting:		This was an installer I created to import the NSIS Archive database contents into my own local database. Anyone wanting to use the nsExec plugin should find this interesting:
Line 30:		Line 28:
	SectionEnd</highlight-nsis>		SectionEnd</highlight-nsis>

	[[~~{{ns:14}}~~:Code Examples]]		[[Category:Code Examples]]

ConversionBot: Added category links.

2005-04-30T20:46:11Z

Added category links.

â† Older revision		Revision as of 20:46, 30 April 2005
Line 29:		Line 29:
	Delete '$EXEDIR\dbfile.sql.out'		Delete '$EXEDIR\dbfile.sql.out'
	SectionEnd</highlight-nsis>		SectionEnd</highlight-nsis>

			[[{{ns:14}}:Code Examples]]

ConversionBot: Updated author links.

2005-04-30T03:03:49Z

Updated author links.

@@ Line 1: / Line 1: @@
 == Description ==
 This was an installer I created to import the NSIS Archive database contents into my own local database. Anyone wanting to use the nsExec plugin should find this interesting:
@@ Line 25: / Line 29: @@
    Delete '$EXEDIR\dbfile.sql.out'
 SectionEnd</highlight-nsis>

ConversionBot: Updated author and download links, and changed format of some pages.

2005-04-23T12:17:59Z

Updated author and download links, and changed format of some pages.

â† Older revision		Revision as of 12:17, 23 April 2005
Line 26:		Line 26:
	SectionEnd</highlight-nsis>		SectionEnd</highlight-nsis>

	Page author: sunjammer		Page author: [[User:sunjammer\|sunjammer]]

ConversionBot: Wikipedia python library

2005-04-09T19:11:57Z

Wikipedia python library

New page

== Description ==
This was an installer I created to import the NSIS Archive database contents into my own local database. Anyone wanting to use the nsExec plugin should find this interesting:

== The Script ==
<highlight-nsis>OutFile importdb.exe
SilentInstall silent
Section
nsExec::Exec 'plink -ssh -batch sunjammerx@nsis.sourceforge.net "~/dump_mysql > ~/dblocation"'
nsExec::Exec 'pscp sunjammerx@nsis.sourceforge.net:~/dblocation .'
FileOpen $0 '$EXEDIR\dblocation' 'r'
FileRead $0 $1
FileClose $0
Delete '$EXEDIR\dblocation'
StrCpy $1 $1 -1
nsExec::Exec 'pscp sunjammerx@nsis.sourceforge.net:$1 "$EXEDIR\dbfile.sql"'
nsExec::Exec 'plink -ssh -batch sunjammerx@nsis.sourceforge.net "rm -f dblocation $1"'
Delete '$EXEDIR\dbfile.sql.out'
nsExec::Exec 'bzip2 -d dbfile.sql'
nsExec::Exec 'c:\mysql\bin\mysql -e "drop database nsisweb"'
nsExec::Exec 'c:\mysql\bin\mysql -e "create database nsisweb"'
nsExec::Exec 'cmd /C c:\mysql\bin\mysql -D nsisweb < dbfile.sql.out'
nsExec::Exec 'c:\mysql\bin\mysql -D nsisweb -e "delete from nsisweb_sessions"'
Delete 'e:\src\sunjammer.net\archive\engine\sessions\*.*';
Delete '$EXEDIR\dbfile.sql'
Delete '$EXEDIR\dbfile.sql.out'
SectionEnd</highlight-nsis>

Page author: sunjammer