Tools | Learn for Master

How to send email on linux terminal

March 31, 2017 Author: david

No comment yet

You may want to send email using linux terminal.

The easiest way is to use mail tool.

for example, you can use the following command to send an email easily.

echo “content the email” | mail -s “subject of this email” [email protected]

You can also use -a option to attach a file:

echo “content the email” | mail -s “subject of this email” -a ~/filename [email protected]

However, you may want to specify the sender’s email address. Then a good tool is sendEmail.

About SendEmail
SendEmail is a lightweight,

[Read More...]

WordPress database error Table crashed

September 21, 2016 Author: david

No comment yet

For mysql database you may get the following error:

Fix “WordPress database error Table … is marked as crashed and should be repaired”

WordPress database error Table … is marked as crashed and last repair (automatic?) failed.

We can fix this error using the following commands:

[user@server ~/public_html]$ mysql -u user -p
Enter password:
Welcome to the MySQL monitor.&nbsp; Commands end with ; or \g.
Your MySQL connection id is 1120449
Server version: 5.1.48 MySQL Community Server (GPL)

Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show databases;
Connection id:&nbsp;&nbsp;&nbsp; 1120477
Current database: database

> use YOUR_DATABASE;

> show tables;

> use YOUR_TABLE_NAME;

mysql> select * from prefix_posts limit 1;


ERROR 145 (HY000): Table './database/prefix_posts' is marked as crashed and should be repaired
mysql> repair table prefix_posts;
+-----------------------+--------+----------+----------+
| Table&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp; | Op&nbsp;&nbsp;&nbsp;&nbsp; | Msg_type | Msg_text |
+-----------------------+--------+----------+----------+
| database.prefix_posts | repair | status&nbsp;&nbsp; | OK&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |
+-----------------------+--------+----------+----------+
1 row in set (3.56 sec)

mysql> select * from prefix_posts limit 1;
+----+-------------+---------------------+---------------------+--------------+------------+---------------+--------------+-------------+----------------+-------------+---------------+-----------+---------+--------+---------------------+---------------------+-----------------------+-------------+------------------------------------------------------------+------------+------------+----------------+---------------+
| ID | post_author | post_date           | post_date_gmt       | post_content | post_title | post_category | post_excerpt | post_status | comment_status | ping_status | post_password | post_name | to_ping | pinged | post_modified       | post_modified_gmt   | post_content_filtered | post_parent | guid                                                       | menu_order | post_type  | post_mime_type | comment_count |
+----+-------------+---------------------+---------------------+--------------+------------+---------------+--------------+-------------+----------------+-------------+---------------+-----------+---------+--------+---------------------+---------------------+-----------------------+-------------+------------------------------------------------------------+------------+------------+----------------+---------------+
| 12 |           8 | 2008-05-20 10:09:49 | 2008-05-20 15:09:49 |              | 308image1  |             0 |              | inherit     | open           | open        |               | 308image1 |         |        | 2008-05-20 10:09:49 | 2008-05-20 15:09:49 |                       |           0 | http://gaarai.com/wp-content/uploads/2008/05/308image1.gif |          0 | attachment | image/gif      |             0 |
+----+-------------+---------------------+---------------------+--------------+------------+---------------+--------------+-------------+----------------+-------------+---------------+-----------+---------+--------+---------------------+---------------------+-----------------------+-------------+------------------------------------------------------------+------------+------------+----------------+---------------+
1 row in set (0.00 sec)

mysql> exit
Bye
[user@server ~/public_html]$

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

[user@server ~/public_html]$ mysql -u user -p

Enter password:

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 1120449

Server version: 5.1.48 MySQL Community Server (GPL)

This software comes with ABSOLUTELY NO WARRANTY. This is free software,

and you are welcome to modify and redistribute it under the GPL v2 license

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show databases;

Connection id:    1120477

Current database: database

> use YOUR_DATABASE;

> show tables;

> use YOUR_TABLE_NAME;

mysql> select * from prefix_posts limit 1;

ERROR 145 (HY000): Table './database/prefix_posts' is marked as crashed and should be repaired

mysql> repair table prefix_posts;

+-----------------------+--------+----------+----------+

+-----------------------+--------+----------+----------+

+-----------------------+--------+----------+----------+

1 row in set (3.56 sec)

mysql> select * from prefix_posts limit 1;

+----+-------------+---------------------+---------------------+--------------+------------+---------------+--------------+-------------+----------------+-------------+---------------+-----------+---------+--------+---------------------+---------------------+-----------------------+-------------+------------------------------------------------------------+------------+------------+----------------+---------------+

+----+-------------+---------------------+---------------------+--------------+------------+---------------+--------------+-------------+----------------+-------------+---------------+-----------+---------+--------+---------------------+---------------------+-----------------------+-------------+------------------------------------------------------------+------------+------------+----------------+---------------+

| 12 | 8 | 2008-05-20 10:09:49 | 2008-05-20 15:09:49 | | 308image1 | 0 | | inherit | open | open | | 308image1 | | | 2008-05-20 10:09:49 | 2008-05-20 15:09:49 | | 0 | http://gaarai.com/wp-content/uploads/2008/05/308image1.gif | 0 | attachment | image/gif | 0 |

+----+-------------+---------------------+---------------------+--------------+------------+---------------+--------------+-------------+----------------+-------------+---------------+-----------+---------+--------+---------------------+---------------------+-----------------------+-------------+------------------------------------------------------------+------------+------------+----------------+---------------+

1 row in set (0.00 sec)

mysql> exit

Bye

[user@server ~/public_html]$

Fix “WordPress database error Table … is marked as crashed and should be repaired”

[Read More...]

Cache with nginx

August 27, 2016 Author: david

No comment yet

Here are some good resources to use cache a website with NGINX.

NGINX is commonly deployed as a reverse proxy or load balancer in an application stack and has a full set of caching features. It can be helpful for:

Speeding up the website by caching full pages, static files (js, images, css etc.).
Serving g-zipped data to browsers for faster delivery.
Rewrite the urls to make them more human readable and easier to remember.
Adding proper ‘expires header’ to static content so that they can be cached by the browsers.

[Read More...]

Good resources learn how to develop WordPress plugin

August 1, 2016 Author: david

No comment yet

Create a Custom WordPress Plugin From Scratch

This tutorial is from: http://code.tutsplus.com/tutorials/create-a-custom-wordpress-plugin-from-scratch–net-2668

1 Files and folders

WordPress stores its plugins in the wp-content/plugins/ folder. This is the place where we’ll be adding our files as well.

we are going to use two files (one for the main plugin file and one for implementing the administration page) therefore we’ll be putting all our files in a specific folder that we’ll name oscommerce_importer.

2. Creating the plugin file

Now we create our main plugin file. We’ll name it as itoscommerce_importer.php.

[Read More...]

How to create plugins for wordpress

July 30, 2016 Author: david

No comment yet

Here are two good examples to show how to add buttons to wordpress editor by build wordpress plugins.

WordPress has two different editors: TinyMCE editor(i.e., visual editor) and Text editor(i.e., HTML editor).

WordPress also lets us create custom buttons to both of the visual and text(or HTML) editor. To add a button for Text editor we need to use Quicktags API and to add buttons to the TinyMCE editor we have to use JavaScript APIs provided by the TinyMCE library. Here are two articles that will help you to learn these APIs.

Add Buttons to WordPress Text Editor

Here is an example code snippet which adds a button to the WordPress code editor and wraps the selected text using [code][/code] tags.

[Read More...]

automatic text summarizers in python or java

July 21, 2016 Author: david

No comment yet

mohaps/tldrzr Algorithmic summarizer for RSS/Atom Feeds, Web Urls and arbitrary text. Codebase for the application deployed at http://tldrzr.herokuapp.com

KIT-IPE/Kitcube-Status One page display to summarize the status of KIT CUBE

sc3/cookcountyjail A Django app that tracks the population of Cook County Jail over time and summarizes trends.

addthis/stream-lib Stream summarizer and cardinality estimator.

Emergya/redmine_cmi CMI is a Redmine plugin to have a summarized view of the projects. It calculates and shows with graphics different metrics as actual effort,

[Read More...]

python and java libraries to parse wikipedia dump dataset

July 19, 2016 Author: david

No comment yet

Here are some python and java parsers to parse wikipedia dump dataset.

The english wikipedia dump dataset can be downloaded here:
http://dumps.wikimedia.org/enwiki/latest/enwiki-latest-pages-articles.xml.bz2

Name and link
Principal author(s)
Language
Input
Output
Comments / other info
License

Java API (Bliki engine)
axelclk
Java
Markup fragment
HTML, PDF
Java Wikipedia API – (supports ParserFunctions, Lua/Scribunto…)

Mylyn WikiText
David Green
Java
Local files
HTML, DocBook, Eclipse Help, DITA, extensible
Integration with Ant and Eclipse runtime

Sweble Wikitext Parser
Hannes Dohrn
Java
Markup
Abstract syntax tree, XML, HTML
Claims to be very thorough.

[Read More...]

remove alternativ background lines for wp-syntax

July 16, 2016 Author: david

No comment yet

wp-syntax is a power tool to highlight your code, but the alternative background lines can make your code unreadable on some screens.

To remove the alternative background lines feature, we can just overwrite the css by adding the two lines in your theme’s style.css.

You can change the background color to whatever you like.

.wp_syntax pre { background:#FCFCFC !important; }
.wp_syntax td.code { background-image:none; background-color:none; }

1 2	.wp_syntax pre { background:#FCFCFC !important; } .wp_syntax td.code { background-image:none; background-color:none; }

[Read More...]

The most essential Git commands you must know

July 9, 2016 Author: david

No comment yet

Git is the most widely used modern version control system. When you learn git, you may encounter issues to master all the git commands. In this tutorial, we list the essential git commands. After master these commands, you can use git to accomplish most of the version control tasks.

The following two diagrams show how git manages your files.

The four stages of a file in git

Create a Repository
Create a new local repository from scratch

git init [my_project] or cd my_project git init

1
2
3
4
5
6

git init [my_project]

or

cd my_project
git init

Download from an existing repository

git clone remote_reposity_url_on_github

1

git clone remote_reposity_url_on_github
Check your repository
List the files that have not been committed

git status

1

git status

Show the changes to files not staged

git diff

1

git diff

Show full change history

git log

1

git log

Show more detailed change history

git reflog

1

git reflog

show the changes between two commits ids

git diff commit_id1 commit_id2

1

git diff commit_id1 commit_id2
Git Branches
List all local branches

git branch

1

git branch

List all local and remote branches

git branch -av

1

git branch -av

create a new branch

git branch my_branch_name

1

git branch my_branch_name

Switch to a branch

git checkout my_branch_name

1

git checkout my_branch_name

create a new branch using an old branch and switch to the new branch

git checkout old_branch_name git checkout -b new_branch_name or git checkout old_branch_name git branch new_branch_name git checkout new_branch_name

1
2
3
4
5
6
7

git checkout old_branch_name
git checkout -b new_branch_name

or
git checkout old_branch_name
git branch new_branch_name
git checkout new_branch_name

delete a local branch

git branch -d branch_name

1

git branch -d branch_name

delete a remote branch

git push origin :{the_remote_branch} or git push origin --delete the_remote_branch

1
2
3

git push origin :{the_remote_branch}
or
git push origin --delete the_remote_branch

tag a branch

git tag my_tag

1

git tag my_tag

merge branch_a to branch_b

git checkout branch_b git merge branch_a

1
2

git checkout branch_b
git merge branch_a
Add files to repository and do commit
Add a single file to index,

[Read More...]

How to use memcached in WordPress

July 9, 2016 Author: david

No comment yet

What is Memcached?

Memcached is an in-memory key-value store for small chunks of arbitrary data (strings, objects) from results of database calls, API calls, or page rendering.

Memcached is simple yet powerful. Its simple design promotes quick deployment, ease of development, and solves many problems facing large data caches. Its API is available for most popular languages.

You can get more information of memecached from this link: https://github.com/memcached/memcached/wiki

Why do you use Memcached?

By using memcached (properly), you limit the number of queries to the database (because they’ll read the results from memcached instead).

[Read More...]