MYSQL backups with timestamp

This was tested in windows using version 5.5.16.

 

for /f “tokens=2-4 delims=/ ” %%a in (‘DATE /T’) do set Date=%%c%%b%%a
for /f “tokens=1-2 delims=: ” %%a in (‘TIME /T’) do set Time=%%a%%b
mysqldump.exe -h blaa -u whoowee -poop dBName >backup_%Date%_%Time%.sql

 

place in folder where you want your backups to end.

How To Launch Control Panel Application From The Command Line

Just remember that you need to type controland then the applet’s name!

Accessibility Options
access.cpl

Add/Remove Programs
appwiz.cpl

Add Hardware Wizard
hdwwiz.cpl

Administrative Tools
admintools

Automatic Updates
wuaucpl.cpl

Bluetooth Properties
bthprops.cpl

Control Panel
panel

Desktop Properties
desktop

Desktop Appearances Properties
color

Display Properties
desk.cpl

Fastfind Properties
findfast.cpl

Firewall Properties
firewall.cpl

Fonts Folder
fonts

Game Controllers
joy.cpl

Infrared Properties
infrared

Internet Options
inetcpl.cpl

iSCSI Initiator
iscsicpl.cpl

Java Control Panel
jpicpl32.cpl

Keyboard Properties
main.cpl keyboard

Licensing Mode
liccpa.cpl

Mouse Properties
main.cpl

Network Connections
ncpa.cpl

Network Setup Wizard
netsetup.cpl

ODBC Properties
odbccp32.cpl

Power Options
powercfg.cpl

Printers Folder
printers

Regional and Language Options
intl.cpl

Scanners and Camera Properties
sticpl.cpl

Schedule Tasks
schedtasks

Sound and Audio Devices
mmsys.cpl

Stored Passwords
keymgr.cpl

System Properties
sysdm.cpl

Telephone and Modem Properties
telephon.cpl

Time and Date Settings
timedate.cpl

User Accounts
nusrmgr.cpl

User Accounts Advances
userpasswords2

User Passwords
userpasswords

Windows Security Center
wscui.cpl

Wireless Link
irprops.cpl

Data & MMS for Jailbroken Devices Iphone 4s 5.1.1 Straight Talk

First of all your phone has to be on 5.1.1 and jailbroken at the time of this writing.

  • 1. On your jailbroken iPhone, launch Cydia
  • 2. Search for TetherMe, then purchase it for $5 and install it
  • (I added ihacksrepo.com to the sources and installed from there.)
  • 3. After TetherMe is installed, exit Cydia and go to your home screen
  • 4. Open Settings/General/Network/Cellular Data Network
  • This is what your settings should look like. Fill in the fields on your iPhone as follows:
    Cellular Data
    APN: att.mvno
    Username:
    Password:
    MMS
    APN: att.mvno
    Username:
    Password:
    MMSC: http://mmsc.cingular.com
    MMS Proxy: 66.209.11.33:80
    MMS Max Size: 1048576
    MMS UA Prof URL:

Note: If you get TetherMe then you don’t need to go to unlockit website as TetherMe allows you to set all the settings.
You need to uninstall that apn profile and then make sure all settings in the TetherMe app are correct.
The unlockit.co.nz profile conflicts with the TetherMe app from Cydia.
The easiest way is Settings > General > Reset > Reset Network Settings

 

Information available from Straight Talk http://www.straighttalksim.com/support.php

The MMS proxy can be replaced with it’s DNSname mms2.tracfone.com:80 and it will also work.

Other repositories

http://repo.biteyourapple.net  —  http://p0dulo.com  —  http://repo.hackyouriphone.org  —  http://repo.icausefx.com  —  http://ihacksrepo.com  —  http://apt.pwncenter.com  —  http://repo.insanelyi.com  —  http://cydia.xsellize.com  —  http://cydia.hackulo.us  —  http://sinfuliphonerepo.com  —

 

copied from http://wiki.howardforums.com/index.php/Straight_Talk_iPhone

Installing rutorrent and rtorrent via a script

I changed directory to /home/user “user is your user name”

then download the script and run.  webmin kept stopping so I skipped webmin and didn’t need the ftp server so I answered no to them and installed webmin manually later.

Ubuntu and Ubuntu clones
cd
wget –no-check-certificate -O autodl-setup http://sourceforge.net/projects/autodl-irssi/files/autodl-setup/download
sudo sh autodl-setup

Installing B4RT on Ubuntu 10.04 updated 2012

Here is a simple copy and paste info for installing b4rt on ubuntu 10.04.  Im sure this will work on many other ubuntu distro’s.  This is not a complete guide for someone who is not familiar with ubuntu command line.  Just a quick reference for copy and paste using windows and putty as the command machine.

apt-get update
apt-get upgrade

apt-get install apache2
apt-get install mysql-server phpmyadmin

apt-get install bzip2 php5-cli php5-gd zip unzip unrar libxml-dom-perl libxml-simple-perl libhtml-parser-perl libdigest-sha1-perl bittorrent bittornado vlc-nox uudeview wget transmission-cli perl python libthreads-shared-perl

(((((((((((  webmin  )))))))))))))

wget http://prdownloads.sourceforge.net/webadmin/webmin_1.580_all.deb
dpkg –i webmin_1.580_all.deb

((((((   if you are missing dependencies  ))))))))))))
apt-get install perl libnet-ssleay-perl openssl libauthen-pam-perl libpam-runtime libio-pty-perl apt-show-versions python

apt-get update
apt-get upgrade

change to a temp directory like /home/temp or something
mkdir command   mkdir /home/temp
cd /home/temp

wget http://prdownload.berlios.de/tf-b4rt/torrentflux-b4rt_1.0-beta2.tar.bz2

(or alternativly from http://gunblade.fakap.net/doc/torrentflux-b4rt_1.0-beta2.tar.bz2)
wget the latest version.

Extract it:

# tar xjvf torrentflux-b4rt_1.0-beta2.tar.bz2

# cd torrentflux-b4rt_1.0-beta2

Copy the “html” folder to the web root:

# cp -R html /var/www/b4rt

Change owner:

# chown -R www-data:www-data /var/www/b4rt/inc/config/

Create a download directory:

# mkdir /var/b4rt/

# chown www-data:www-data /var/b4rt/

4.3 Install torrentflux-b4rt

Open your new torrentflux-b4rt website:

https://xx.xx.xx.xx/b4rt or
http://xx.xx.xx.xx/b4rt

There will be a wizard to guide you threw the installation:

– select type of database: MySQL
– enter your MySQL database settings below: (as created in 3.2)

Host: localhost
Name: b4rt
Username: b4rt
Password:

UNCHECK the “Create Database” option! CHECK the “Use Persistent Connection” option.

Follow the wizard… (next, next, next …)

– Server Settings

User Download Path: /var/b4rt (as created in 4.2)

– Check System Tools

Ignore the “NOT FOUND” on “cksfv”. Continue. Next …

– Setup Completed

Delete the /var/www/b4rt/setup.php:

# rm /var/www/b4rt/setup.php

4.4 Finish the installation

https://xx.xx.xx.xx/b4rt or
http://xx.xx.xx.xx/b4rt

Login with your credentials (user, password).

 

 

Create usb bootable windows install USB Drive

bootable USB guide, here we assume that you are using either Vista or Windows 7 to create a bootable USB.

1. Insert your USB (4GB+ preferable) stick to the system and backup all the data from the USB as we are going to format the USB to make it as bootable.

2. Open elevated Command Prompt. To do this, type in CMD in Start menu search field and hit Ctrl + Shift + Enter. Alternatively, navigate to Start > All programs >Accessories > right click on Command Prompt and select run as administrator.

3. When the Command Prompt opens, enter the following command:

DISKPART and hit enter.

LIST DISK and hit enter.

Once you enter the LIST DISK command, it will show the disk number of your USB drive. In the below image my USB drive disk no is Disk 1.

4. In this step you need to enter all the below commands one by one and hit enter. As these commands are self explanatory, you can easily guess what these commands do.

SELECT DISK 1 (Replace DISK 1 with your disk number)

CLEAN

CREATE PARTITION PRIMARY

SELECT PARTITION 1

ACTIVE

FORMAT FS=NTFS quick

(Format process may take few seconds)
ASSIGN

EXIT

Don’t close the command prompt as we need to execute one more command at the next step. Just minimize it.

5. Insert your Windows DVD in the optical drive and note down the drive letter of the optical drive and USB media. Here I use “D” as my optical (DVD) drive letter and “G” as my USB drive letter.

6. Go back to command prompt and execute the following commands:

6.1. Change directory to the DVD’s boot directory where bootsect lives:
d:
cd d:\boot

6.2. Use bootsect to set the USB as a bootable NTFS drive prepared for a Vista/7 image. I’m assuming that your USB flash drive has been labeled disk G:\ by the computer:
bootsect /nt60 g:

(Where “G” is your USB drive letter)

7. Copy Windows DVD contents to USB.

You are done with your bootable USB. You can now use this bootable USB as bootable DVD on any computer that comes with USB boot feature (most of the current motherboards support this feature).

Note that this bootable USB guide will not work if you are trying to make a bootable USB on XP computer.