and just run
sqlite3.exe -init yoursqlfile.sql yourdatabasename.db
load an sql file in a sqlite database from command line with macos.
load an sql file in a sqlite database from command line - windows XP.
load an sql file in a sqlite database from command line - windows vista.
load an sql file in a sqlite database from command line - windows 7.
load an sql file in a sqlite database from command line - windows 8.
load an sql file in a sqlite database from command line - Linux.
This is an easy task but I've wasted a lot of time to find it out (ok, I'm not smart guy .... )
right-click on "My Computer" and select "Properties". Select the "Device Manager" tab. Click on Device Manager in the left pane.
Select your device (the "usb 2.0 webcam" with the question mark). right-click and select "Update Driver". This will launch an update Wizard. Choose to install from the local computer (not from the path). Select the "manual" installation. Manually select "composite usb device" that should be listed in the compatible drivers.
You can use most of the applications for webcams. The one that is working for sure with this device is "cyberlink youcam". Example: http://h10025.www1.hp.com/ewfrf/wc/softwareDownloadIndex?cc=it&lc=it&dlc=it&softwareitem=ob-78419-1
If the webcam doesn't show up immediately you need to go in the options and select the device.
Sample query to retrieve a date from mysql and use it directly with a dataset, datatable, datagridview.
Select DATE_FORMAT(mysqldatecolumn, '%Y-%m-%d' ) from mytable
To convert the date in .net
when we wan to retrieve and add the date in the db.
A workaround in mysql is to set those vars for the session. It's not suggested and sometimes the variables are read only.
SET SESSION date_format="%Y/%m/%d";
SET SESSION datetime_format="%Y/%m/%d %H:%i:%s";
Mysql Exception MySql.Data.Types.MySqlConversionException' in MySql.Data.dll
(versione aggiornata dopo l'uscita di fileprotector 5.5 ..... qualche giorno dopo che mi ero lamentato al telefono)
Inserire la penna usb per firma digitale
Assicurarsi di avere installato java 1.5 (per fare prima è consigliabile questa versione) per Fileprotector 5.2 o inferiore (soluzione vecchia)
altrimenti assicurarsi di avere l'ultima versione a 64 bit di java ed installare fileprotect 5.5
Scaricare ed Installare. Eseguire il setup.exe come amministratore)
Scaricare ed installare fileprotector (eseguire il file come amministratore) http://firmadigitale.mps.it/Drivers%5CFP5.exe (5.2)
http://firmadigitale.mps.it/Drivers%5CFP5.5.exe (versione che richiede java 64 bit)
Attivare ed aggiornare il certificato direttamente tramite
Fileprotector inserendo codice fiscale e password di attivazione
ricevuta (inizia con M…
Click on the magnifying glass to search automatically the modem:
Found modem : .B Model : Huawei E585 IMEI : 352398043026808 Serial NR. : M7A4CA1121502022 Firmware : 1026.11.323.02.505sp01 Compile date / time : Dec 14 2010 20:09:05 Hardware ver. : WL1E585HM_E585 Dashboard version : UTPS1.01.01.12_MAC1.01.00.12 Chipset : Qualcomm MSM7625A SIM Lock status : Locked (Card Lock)
if the Firmware version (see the last 505sp01) differs install E585Update_1026.11.64.18.505sp01.exe
Install "Huawei Reader PSAS setup.exe"
Hardware Forensics -> Use Mobile Ports
Choose the Diag Port (QC) Tab In the same window (under Diag Functions (values to be entered have to be in hex)) choose Read EFS and check "Alternative Method". Click on "Let's go" Save the file rapiconfig.xml Open the xml file with notepad or something else
Recover from backup Windows Phone 7
Recover from backup Windows Phone 8
From what I've seen, sometimes, there are (hidden) "Backup" (the name is backup) folders on the SD of the windows Phones. It could happen when you do an update of the system (that's what I've read in a forum).
Inside the folder there's a file with "arc" extension and it could be opened with NbuExplorer with dbshell.
anything below is old and not really working good.
This is an old version but never worked well for me after 3.x.
msiexec /qb! /i PATHTO\LibreOffice_xxx.msi ALLUSERS=1 CREATEDESKTOPLINK=0 IS1033=0 IS1078=0 IS1025=0 IS1101=0 IS1610=0 IS1059=0 IS1026=0 IS2117=0 IS2121=0 IS1150=0 IS1603=0 IS5146=0 IS1027=0 IS32771=0 IS1029=0 IS1106=0 IS1030=0 IS1031=0 IS1604=0 IS2129=0 IS1032=0 IS2057=1 IS7177=0 IS1553=0 IS1034=0 IS1061=0 IS1069=0 IS1065=0 IS1035=0 IS1036=0 IS2108=0 IS1084=0 IS1110=0 IS1095=0 IS1037=0 IS1081=0 IS1050=0 IS1038=0 IS1057=0 IS1039=0 IS1040=0 IS1041=0…
A part of (one of my) a nsis script is following with extra informations in the comments:
; http://www.skype.com/go/getskype-full ; ALLUSERS=1 - install for all the windows users ; /NOIE - No Internet Explorer plugin ; /NOGOOGLE - No Google toolbar ; /verysilent - No installation interface ; /NORESTART - No restart ; /SP- ; /NOCANCEL cannot interrupt ; /SUPPRESSMSGBOXES - avoid message boxes ; /NOLAUNCH' - doesn't start skype after installation
ExecWait "'$EXEDIR\SOFTWARE\x86\SkypeSetupFull.exe ALLUSERS=1 /NOIE /NOGOOGLE /VERYSILENT /SP- /NOCANCEL /NORESTART /SUPPRESSMSGBOXES /NOLAUNCH'" ;removing run at windows startup RegDelete("HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Run", "Skype");
-r recursive to recurse in all the subfolders/pages
-p we get all images needed to display the page -e robots=off - ignore robots.txt rules
-E set as html files with html content
-np don't recurse up to parent folders
-U "Opera/9.80 (Windows NT 6.0) Presto/2.12.388 Version/12.14" - useragent mozilla
--no-check-certificate - do not check ssl certificates for https connections
#random wait, recursive, get all images needed to display the page, #ignore robots.txt rules, set as html files with html content,
#don't recurse up to parent folders, useragent mozilla, #do not check ssl certificates (for https).
batch script - alert with sound for smart hdd probelms fix
smartmontools detect failure at boot
This is a small batch script that starts an alert if a "FAILED" string is found in the smartctl report.
@Echo on SET SMARTBIN=smartmontools\smartctl.exe SET REPORTFILE=smartinfo.txt %SMARTBIN% --scan > smartdrives.txt for /F "tokens=1" %%i in (smartdrives.txt) do %SMARTBIN% -s on %%i > %REPORTFILE% && %SMARTBIN% -i %%i >> %REPORTFILE% && %SMARTBIN% -H %%i >> %REPORTFILE%
findstr /m "FAILED" %REPORTFILE% if %errorlevel%==0 ( sound\cmdmp3win.exe sound\alert.mp3 )
I personally cannot suggest smatmontools "as is" without the parsing of the S.M.A.R.T. data or full test with smartmontools.
After creting this sample script I have faced the reality that my HD smart report was not correct . I prefer to manually check with crystaldisk because it reports as "good" or "problematic" without wasting time and with more ac…
I'm quite ignorant about IIS 7 but after using ii7 manager I've noticed that it's easier than expected to modify the preconfigured mime types and *any* (I don't know exactly what can be modified or not) other configuration by adding/modifying "web.config" in the root directory.
This sample file web.config is a modification for the svg that have a wrong mime type and the svg are not showing correctly.
installare IIS 7 manager for website administration.
I've faced a simple problem regarding an incorrect svg mime type.
The hosting company for a specific website have told me to modify it by myself via iis 7 manager (weird in my opinion).
Trovandomi di fronte al problema di dover modificare il mime type per svg.
L'assistenza dell'azienda di hosting, Aruba (in questo caso), mi ha risposto di fare le modifiche autonomamente tramite ii7 manager. La cosa mi è sembrata strana perché sarebbe stato utile ed immediato fare le modifiche dal pannello di controllo e non tutti gli utenti hanno sistema operativo Microsoft, i requisiti necessari (a volte mancano pacchetti vari da installare a parte come XML) e le idee non chiarissime su come procedere.
Start->Pannello di controlo
Programmi e funzionalità
Attivazione o disattivazione delle funzionalità Windows
simplet batch script to (download) and install, also offline, xamarin studio with mono android, xamarin ios, gtk sharp, android sdk tools, android ndk (I'm not sure if it's the right installation method but I've read it in the installation logs of xamarin).
If you need to just install remove the part related to "wget" in the install batch script.
I've buyed the Asansambox but due to the big waste of time searching for the
right driver I've been unable to install it for more than a week (frustration).
The company told me to use their drivers (there are several links and drivers for the SAME box).
In my case I've to install "smart key" (question mark in the devices manager).
The hardware id hwid (in my case) is SCFILTER\CID_80318065b0831148c883009000
After a search on google I've found a similar product that is the HTI mxkey card (another box?)
I've (simply) set in the inf the hwid as CardName "JCOP41V221". There's no specifi driver needed (in general).
TNS for Linux: Version 188.8.131.52.0 - Production-Oracle Database 11g Enterprise Edition Release 184.108.40.206.0 - 64bit Production
There are too many and mixed up scripting languages and messed up *solutions*.
Read quite any file
SEVERAL possible sql injections (there are too many of them ...)
the errors are so kind to give those informations:
Drop tables of a database from command line (windows or linux). MySQL.
How to drop tables from command line with a mysql database.
--setting a session (not global since we probably don't have enough privileges) with an higher length. Change the number/length as needed.
SET SESSION group_concat_max_len = 90000;
--setting a variable with the group concatenated list of the tables (ex.: table1,tables2;). Change the MYTABLENAMETOCHANGE with your own table
SET @mytables = (SELECT GROUP_CONCAT(table_name) FROM information_schema.tables WHERE table_schema = 'MYTABLENAMETOCHANGE');
--setting a variable so that we can have a full DROP (if table exists) statement
SET @drptables = (SELECT CONCAT('DROP TABLE IF EXISTS ', @mytables, ';'));
-- preparing "droppingtables" the sql statement from the @drptables variable
PREPARE droppingtables FROM @drptables;
-- executing the sql statement "droppingtables"
[function.file-get-contents]: failed to open stream: HTTP request failed! HTTP/1.1 404 Not Found
in /home/subdimen/public_html/elitecop.net/index.php on line 63 Bad URL =
published since they have changed the website and the problems have gone.
Possible remote denial of service (server does'nt respond after several requests) or automatic ban from the webserver (???). Possibility to read data logs. Possibility to read local files on the server except aspx and probably similar files.
sample page (old not working anymore but cached by the search engines) http://www.mfa.gov.il/MFA/HPChannel/President-Peres-+Reply-to-the-Goldstone-Commission-Report-16-Sep-2009.htm
Sometimes, random errors are showing up with the same data. I don't know the cause.
Error num : The process cannot access the file
"D:\Logs\MFA2003_19_11_2012.log" because it is being used by another