Using the NETSH command
- Set static IP
- Set static WINS
- Set Static DNS
- Reset Network configuration
- Automating the Process
Using the netsh command
MySQL Command Line Examples
Command to log into remote host with username and password.
mysql --user=[username] --password=[password]--host=[computer]
Example:
mysql --user=root --password=mypassword--host=VMYSQL01
Show Databases
show databases;
Run script
mysql --user=root --password=mypassword --database=DB1< myscript.sql
Drupal with 1and1 Hosting
You will need to make some changes to the .htaccess file to get Drupal working with http://www.1and1.com. You will also need SSH access to make the changes.
After extracting your Drupal files, modify the .httacces file and add the following line to the top. Note** You can do this at the root of your shared directory.
AddType x-mapp-php5 .php
To get "clean-urls" working, uncomment the ReWrite.
RewriteBase / mydumpsplitter - Extract tables from mysqldump
http://kedar.nitty-witty.com/blog/mydumpsplitter-extract-tables-from-mysql-dump-shell-script/
#!/bin/sh # http://kedar.nitty-witty.com #SPLIT DUMP FILE INTO INDIVIDUAL TABLE DUMPS # Text color variables txtund=$(tput sgr 0 1) # Underline txtbld=$(tput bold) # Bold txtred=$(tput setaf 1) # Red txtgrn=$(tput setaf 2) # Green txtylw=$(tput setaf 3) # Yellow txtblu=$(tput setaf 4) # Blue txtpur=$(tput setaf 5) # Purple txtcyn=$(tput setaf 6) # Cyan txtwht=$(tput setaf 7) # White txtrst=$(tput sgr0) # Text reset TARGET_DIR="." DUMP_FILE=$1
Dump MySQL Table Information
This command will dump a table into a file without the data.
mysqldump --opt --user=[username] --password=[password] --no-data [database] [table] > [filename]
.
.Dump the data in an XML format
mysqldump --opt --user=[username] --password=[password] --no-data --xml [database] [table] > [filename]
.
. Windows Update
This will show how to write a basic AutoIt program for installing windows updates.It consists of two files
1) UpdateTool.ini
2) The complied AutoIt Program
UpdateTool.ini
[CONFIG] UPDATELOCATION=L:\setups\Kpu\ImagingUpdateTool\WindowsUpdatesHere\
AutoIt Script
$updatelocation = iniRead("UpdateTool.ini","CONFIG","updatelocation","") $search = FileFindFirstFile($updatelocation & "*.exe") If $search = -1 Then MsgBox(0, "Error", "No files/directories matched the search pattern") Exit EndIf While 1 $file = FileFindNextFile($search)
Icons and Icon Creating Software
Free icons and software. High quality and nicely done.
MySQL Update Example with INNER JOIN
UPDATE content_type_geshinode AS g INNER join zztemp AS z ON z.nid = g.nid SET g.field_object_type_value = z.field_object_type_value
Fonts
Great place to get fonts
http://www.dafont.com/
Write an INI file in C#
Add a using statement
using System.Runtime.InteropServices;
Example Code
public class IniWriter { #region | Public Properites /// <summary> /// Gets or Sets the File Path to the settings file. /// </summary> public string FilePath { get; set; } #endregion public const int DEFAULT_SIZE = 255; #region |DLL IMPORTS | [DllImport("kernel32")]