MySQL Create Database and Add User

Posted on July 19, 2012 by zzz_zwp

Here’s a quick overview of the commands involved in creating a MySQL database, creating a user and adding them to the database and importing an sql backup into the newly created database. *This assumes you already have some way to … Continue reading →

Gallery

Posted on July 19, 2012 by zzz_zwp

This gallery contains 1 photo.

findvegan: Courgette skewers

mediterranean eggplant and barley salad | smitten kitchen

Link

mediterranean eggplant and barley salad | smitten kitchen

Batch Renaming Files From the Command Line with Bash.

Posted on July 18, 2012 by zzz_zwp

This is a simple example of renaming a number of files with one shell command. Start by opening the terminal. For this example there’s a number of images from a digital camera with names like DSC_283.jpg. The goal is to … Continue reading →

Read the masters

Link

Read the masters

What are the most intellectually stimulating sites you know of?

Link

What are the most intellectually stimulating sites you know of?

Git Tip: git stash

Posted on July 6, 2012 by zzz_zwp

Using the “git stash” command is helpful if you need to change branches and have some uncommitted changes you want to preserve. It saves the changes in a ‘buffer’ where you can access the stashed changes in the future. To … Continue reading →

Easy Stir Fry Sauce Recipe | Yummly

Link

Easy Stir Fry Sauce Recipe | Yummly

Ingredients
2-3 tbsps cornstarch or arrowroot powder
14 cup brown sugar (packed) or maple syrup
14 tsp ground ginger (bit of fresh minced)
2 cloves cloves garlic (minced)
12 cup tamari soy sauce
14 cup cider vinegar (white)
12 cup water
112 cups vegetable broth (beef broth or chicken broth i use chicken broth if my stir fry will have chicken) if available.

Directions
1 Combine all ingredients in a large glass jar with a lid.
2 Screw lid on.
3 Shake well.
4 Can store in fridge up to 2 weeks.
5 Shake well before using.
6 To use sauce: stir fry your vegetables and meat as desired, add appropriate amount of sauce, bring to a boil, boil for 1 minute or until slightly thickened.
7 Serve.

Gallery

Posted on July 1, 2012 by zzz_zwp

This gallery contains 1 photo.

findvegan: Lemon Parsley Millet & Couscous Salad with Lemon-Ginger Beets

SELECT option_name, option_value FROM wp_options WHERE option_name IN ('_site_transient_wp_theme_files_patterns-521ceac6f7ea50d1f2c96a08a1af8fc4','_site_transient_timeout_wp_theme_files_patterns-521ceac6f7ea50d1f2c96a08a1af8fc4')

SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts WHERE 1=1 AND ( ( YEAR( wp_posts.post_date ) = 2012 AND MONTH( wp_posts.post_date ) = 7 ) ) AND ((wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish'))) ORDER BY wp_posts.post_date DESC LIMIT 0, 10

SELECT DISTINCT t.term_id, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag', 'post_format') AND tr.object_id IN (52, 53, 56, 57, 58, 59, 60, 61, 62) ORDER BY t.name ASC

SELECT wp_posts.* FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) WHERE 1=1 AND ( wp_term_relationships.term_taxonomy_id IN (468) ) AND wp_posts.post_type = 'nav_menu_item' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.menu_order ASC

SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_parent = 53 AND (wp_posts.post_mime_type LIKE 'image/%') AND wp_posts.post_type = 'attachment' AND ((wp_posts.post_status <> 'trash' AND wp_posts.post_status <> 'auto-draft')) ORDER BY wp_posts.menu_order ASC LIMIT 0, 999

SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_parent = 62 AND (wp_posts.post_mime_type LIKE 'image/%') AND wp_posts.post_type = 'attachment' AND ((wp_posts.post_status <> 'trash' AND wp_posts.post_status <> 'auto-draft')) ORDER BY wp_posts.menu_order ASC LIMIT 0, 999

SELECT wp_comments.comment_ID FROM wp_comments JOIN wp_posts ON wp_posts.ID = wp_comments.comment_post_ID WHERE ( comment_approved = '1' ) AND wp_posts.post_status IN ('publish') ORDER BY wp_comments.comment_date_gmt DESC LIMIT 0,5

SELECT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM wp_posts WHERE post_type = 'post' AND post_status = 'publish' GROUP BY YEAR(post_date), MONTH(post_date) ORDER BY post_date DESC

[0] => themes/twentyeleven/inc/theme-options.php [1] => themes/twentyeleven/inc/widgets.php [2] => themes/twentyeleven/archive.php [3] => themes/twentyeleven/header.php [4] => themes/twentyeleven/searchform.php [5] => themes/twentyeleven/content.php [6] => themes/twentyeleven/content-gallery.php [7] => themes/twentyeleven/content-link.php [8] => themes/twentyeleven/sidebar.php [9] => themes/twentyeleven/footer.php [10] => themes/twentyeleven/sidebar-footer.php

$_SERVER = array ( 'SERVER_SOFTWARE' => 'Apache', 'REQUEST_URI' => '/2012/07/', 'LSPHP_ENABLE_USER_INI' => 'on', 'PATH' => '/usr/local/bin:/usr/bin:/bin', 'TEMP' => '/tmp', 'TMP' => '/tmp', 'TMPDIR' => '/tmp', 'PWD' => '/', 'HTTP_ACCEPT' => '*/*', 'HTTP_ACCEPT_ENCODING' => 'gzip, br, zstd, deflate', 'CONTENT_LENGTH' => '0', 'HTTP_HOST' => 'www.zzzzzzzzz.net', 'HTTP_REFERER' => 'https://zzzzzzzzz.net/2012/07', 'HTTP_USER_AGENT' => 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', 'HTTP_X_HTTPS' => '1', 'REDIRECT_UNIQUE_ID' => 'Z4sLPzyTAq5o6BY5V6QgAgAAcTg', 'REDIRECT_QS_ConnectionId' => '173716563141440784537163', 'REDIRECT_SCRIPT_URL' => '/2012/07/', 'REDIRECT_SCRIPT_URI' => 'https://www.zzzzzzzzz.net/2012/07/', 'REDIRECT_HTTPS' => 'on', 'REDIRECT_SSL_TLS_SNI' => 'www.zzzzzzzzz.net', 'REDIRECT_HTTP2' => 'on', 'REDIRECT_H2PUSH' => 'off', 'REDIRECT_H2_PUSH' => 'off', 'REDIRECT_H2_PUSHED' => '', 'REDIRECT_H2_PUSHED_ON' => '', 'REDIRECT_H2_STREAM_ID' => '1', 'REDIRECT_H2_STREAM_TAG' => '537163-1558-1', 'REDIRECT_STATUS' => '200', 'UNIQUE_ID' => 'Z4sLPzyTAq5o6BY5V6QgAgAAcTg', 'QS_ConnectionId' => '173716563141440784537163', 'SCRIPT_URL' => '/2012/07/', 'SCRIPT_URI' => 'https://www.zzzzzzzzz.net/2012/07/', 'HTTPS' => 'on', 'SSL_TLS_SNI' => 'www.zzzzzzzzz.net', 'HTTP2' => 'on', 'H2PUSH' => 'off', 'H2_PUSH' => 'off', 'H2_PUSHED' => '', 'H2_PUSHED_ON' => '', 'H2_STREAM_ID' => '1', 'H2_STREAM_TAG' => '537163-1558-1', 'SERVER_SIGNATURE' => '', 'SERVER_NAME' => 'www.zzzzzzzzz.net', 'SERVER_ADDR' => '192.185.137.117', 'SERVER_PORT' => '443', 'REMOTE_ADDR' => '18.189.182.15', 'DOCUMENT_ROOT' => '/home1/zzz/public_html', 'REQUEST_SCHEME' => 'https', 'CONTEXT_PREFIX' => '', 'CONTEXT_DOCUMENT_ROOT' => '/home1/zzz/public_html', 'SERVER_ADMIN' => 'webmaster@zzzzzzzzz.net', 'SCRIPT_FILENAME' => '/home1/zzz/public_html/index.php', 'REMOTE_PORT' => '39986', 'REDIRECT_URL' => '/2012/07/', 'SERVER_PROTOCOL' => 'HTTP/2.0', 'REQUEST_METHOD' => 'GET', 'QUERY_STRING' => '', 'SCRIPT_NAME' => '/index.php', 'PHP_SELF' => '/index.php', 'REQUEST_TIME_FLOAT' => 1737165631.4212939739227294921875, 'REQUEST_TIME' => 1737165631, 'argv' => array ( ), 'argc' => 0, );

0.3641	`SELECT option_value FROM wp_options WHERE option_name = 'GOTMLS_nonce_array' LIMIT 1`
0.1662	`SELECT option_value FROM wp_options WHERE option_name = 'GOTMLS_definitions_array' LIMIT 1`
0.1771	`SELECT option_value FROM wp_options WHERE option_name = 'GOTMLS_scan_log/18.189.182.15/1737165631.4353' LIMIT 1`
0.1650	`SELECT option_value FROM wp_options WHERE option_name = 'gzipcompression' LIMIT 1`
0.2241	`SELECT option_value FROM wp_options WHERE option_name = 'rsssl_encryption_keys_set' LIMIT 1`
0.2489	`SELECT option_value FROM wp_options WHERE option_name = 'rsssl_le_certificate_generated_by_rsssl' LIMIT 1`
1.1919	`SELECT option_value FROM wp_options WHERE option_name = 'rsssl_ssl_activation_active' LIMIT 1`
0.9561	`SELECT option_name, option_value FROM wp_options WHERE option_name IN ('_site_transient_wp_theme_files_patterns-521ceac6f7ea50d1f2c96a08a1af8fc4','_site_transient_timeout_wp_theme_files_patterns-521ceac6f7ea50d1f2c96a08a1af8fc4')`
0.5929	`SELECT option_value FROM wp_options WHERE option_name = 'preload_cache_counter' LIMIT 1`
1.2150	`SELECT ID, post_name, post_parent, post_type FROM wp_posts WHERE post_name IN ('2012') AND post_type IN ('post','attachment')`
9.3038	`SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts WHERE 1=1 AND ( ( YEAR( wp_posts.post_date ) = 2012 AND MONTH( wp_posts.post_date ) = 7 ) ) AND ((wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish'))) ORDER BY wp_posts.post_date DESC LIMIT 0, 10`
0.3431	`SELECT FOUND_ROWS()`
0.4880	`SELECT wp_posts.* FROM wp_posts WHERE ID IN (52,53,56,57,58,59,60,61,62)`
0.9770	`SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (52,53,56,57,58,59,60,61,62) ORDER BY meta_id ASC`
1.2550	`SELECT DISTINCT t.term_id, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag', 'post_format') AND tr.object_id IN (52, 53, 56, 57, 58, 59, 60, 61, 62) ORDER BY t.name ASC`
0.6430	`SELECT t., tt. FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE t.term_id IN (52,68,11,69,63,74,67,58,6,7,70,72,71,75,73,1)`
0.4461	`SELECT * FROM wp_posts WHERE ID = 1716 LIMIT 1`
0.3622	`SELECT option_value FROM wp_options WHERE option_name = 'https_migration_required' LIMIT 1`
0.3529	`SELECT option_value FROM wp_options WHERE option_name = 'site_logo' LIMIT 1`
0.4261	`SELECT t., tt. FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE t.term_id = 468`
1.0011	`SELECT wp_posts.* FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) WHERE 1=1 AND ( wp_term_relationships.term_taxonomy_id IN (468) ) AND wp_posts.post_type = 'nav_menu_item' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.menu_order ASC`
0.6440	`SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (1670,1671,1672,1681,1682) ORDER BY meta_id ASC`
0.4489	`SELECT wp_posts.* FROM wp_posts WHERE ID IN (1542,1534,1579,1544)`
0.5140	`SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (1542,1534,1579,1544) ORDER BY meta_id ASC`
0.7741	`SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (1) ORDER BY umeta_id ASC`
0.5419	`SELECT * FROM wp_users WHERE ID IN (1)`
0.9971	`SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_parent = 53 AND (wp_posts.post_mime_type LIKE 'image/%') AND wp_posts.post_type = 'attachment' AND ((wp_posts.post_status <> 'trash' AND wp_posts.post_status <> 'auto-draft')) ORDER BY wp_posts.menu_order ASC LIMIT 0, 999`
0.6030	`SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (54) ORDER BY meta_id ASC`
0.5651	`SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_parent = 62 AND (wp_posts.post_mime_type LIKE 'image/%') AND wp_posts.post_type = 'attachment' AND ((wp_posts.post_status <> 'trash' AND wp_posts.post_status <> 'auto-draft')) ORDER BY wp_posts.menu_order ASC LIMIT 0, 999`
0.2389	`SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (63) ORDER BY meta_id ASC`
0.3519	`SELECT wp_posts.ID FROM wp_posts WHERE 1=1 AND wp_posts.post_type = 'post' AND ((wp_posts.post_status = 'publish')) ORDER BY wp_posts.post_date DESC LIMIT 0, 5`
4.5400	`SELECT wp_posts.* FROM wp_posts WHERE ID IN (1771,1734,1728,1725,1721)`
0.3350	`SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (1771,1734,1728,1725,1721) ORDER BY meta_id ASC`
0.7131	`SELECT DISTINCT t.term_id, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag', 'post_format') AND tr.object_id IN (1771, 1734, 1728, 1725, 1721) ORDER BY t.name ASC`
0.5331	`SELECT t., tt. FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE t.term_id IN (489,490,478,484,492,483,479,480,485,486,481,482,14,37,491,82)`
0.4730	`SELECT wp_comments.comment_ID FROM wp_comments JOIN wp_posts ON wp_posts.ID = wp_comments.comment_post_ID WHERE ( comment_approved = '1' ) AND wp_posts.post_status IN ('publish') ORDER BY wp_comments.comment_date_gmt DESC LIMIT 0,5`
2.9309	SELECT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM wp_posts WHERE post_type = 'post' AND post_status = 'publish' GROUP BY YEAR(post_date), MONTH(post_date) ORDER BY post_date DESC
0.6931	`SELECT t.term_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy IN ('category') AND tt.count > 0 ORDER BY t.name ASC`
0.4568	`SELECT t., tt. FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE t.term_id IN (475,474)`

z z z z z z z z z

z z z z z z z z z

Monthly Archives: July 2012

MySQL Create Database and Add User

Gallery

mediterranean eggplant and barley salad | smitten kitchen

Link

Batch Renaming Files From the Command Line with Bash.

Read the masters

Link

What are the most intellectually stimulating sites you know of?

Link

Git Tip: git stash

Easy Stir Fry Sauce Recipe | Yummly

Link

Gallery