WHAT'S NEW?
Loading...
Showing posts with label file. Show all posts
Showing posts with label file. Show all posts
To block a website, we need to simply map a domain name or URL of that website to our localhost (127.0.0.1).
On Windows The host file is located here C:\Windows\System32\Drivers\etc\hosts 
You just need to add a new line with the localhost address to the domain name that you want to block.
Let’s say you wish to block facebook.com, so you need to add this line at the end of the file.
127.0.0.1 www.facebook.com
To automate this task, you can download 
SysMate – Host File Walker helps you edit, backup, restore and delete the Windows Hosts file.

https://sourceforge.net/projects/sysmate-hosts-file-walker/?source=typ_redirect
  1. Create your table:
    mysql> create table foo(id INT, mytext TEXT, sparkle DECIMAL(9,4));
    Query OK, 0 rows affected (0.02 sec)
  2. Create your data file, put this in foo.txt, note tabs delimit the 3 columns
    1   twilight sparkle is best pony!  6.6 
    2   pinkie pie is best pony!    3.3 
    3   derpy hooves is best pony!  1.1 
  3. Then import the file:
    mysqlimport --fields-terminated-by='\t' 
                --columns=id,mytext,sparkle 
                --local -u root -ppassword your_database foo.txt
    yourdatabase.foo: Records: 4  Deleted: 0  Skipped: 0  Warnings: 3
  4. Look in the table.
    mysql> select * from foo;
    +------+-------------------------------+---------+
    | id   | mytext                        | sparkle |
    +------+-------------------------------+---------+
    |    1 | twilight sparkle is best pony |  6.6000 |
    |    2 | pinkie pie is best pony       |  3.3000 |
    |    3 | derpy hooves is best pony     |  1.1000 |
    +------+-------------------------------+---------+
    4 rows in set (0.00 sec)
The rows were loaded.