Tag: cli

MySQL

How to execute thousand of sql commands using mysql cli

1> Open windows cmd 2> Type: .mysql.exe –user=root –password -e "source C:pathtomysqlfile.sql".mysql.exe –user=root –password -e "source C:pathtomysqlfile.sql" 3> Hit Enter SQL file example: USE `databasename`;   INSERT INTO blah blah; INSERT INTO blah blah; INSERT INTO blah blah;use `databasename`; insert into blah blah; insert into blah blah; insert into blah blah;

Firewall, Windows 7

Configuring windows firewall from the command line

To configure Windows firewall from the command line, you have to open the cmd with administrative rights. Default Rule To deny all incoming connections and allow all outgoing connections: netsh advfirewall set allprofiles firewallpolicy blockinbound,allowoutboundnetsh advfirewall set allprofiles firewallpolicy blockinbound,allowoutbound Enable or Disable firewall To enable firewall: netsh advfirewall set allprofiles state onnetsh advfirewall set …