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

Function _load_textdomain_just_in_time was called incorrectly. Translation loading for the gotmls domain was triggered too early. This is usually an indicator for some code in the plugin or theme running too early. Translations should be loaded at the init action or later. Please see Debugging in WordPress for more information. (This message was added in version 6.7.0.) on line 6131 in file /home1/zzz/public_html/wp-includes/functions.php

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 comment_type NOT IN ('note') 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://www.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' => 'aauZy5NTCYLEP4V_Kvkv5wAAPwo', 'REDIRECT_QS_ConnectionId' => '177285370750193038618697', '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' => '27', 'REDIRECT_H2_STREAM_TAG' => '618697-390-27', 'REDIRECT_STATUS' => '200', 'UNIQUE_ID' => 'aauZy5NTCYLEP4V_Kvkv5wAAPwo', 'QS_ConnectionId' => '177285370750193038618697', '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' => '27', 'H2_STREAM_TAG' => '618697-390-27', 'SERVER_SIGNATURE' => '', 'SERVER_NAME' => 'www.zzzzzzzzz.net', 'SERVER_ADDR' => '192.185.137.117', 'SERVER_PORT' => '443', 'REMOTE_ADDR' => '216.73.216.148', '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' => '23122', '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' => 1772853707.5098140239715576171875, 'REQUEST_TIME' => 1772853707, 'argv' => array ( ), 'argc' => 0, );

0.4661	`SELECT option_value FROM wp_options WHERE option_name = 'GOTMLS_nonce_array' LIMIT 1`
0.5929	`SELECT option_value FROM wp_options WHERE option_name = 'GOTMLS_definitions_array' LIMIT 1`
0.7129	SELECT * FROM `wp_posts` WHERE post_type = 'gotmls_results' AND post_name = 'ee884a1a11954f81548669432aeed7b3'
0.4630	`SELECT option_value FROM wp_options WHERE option_name = 'gzipcompression' LIMIT 1`
0.5538	`SELECT option_value FROM wp_options WHERE option_name = 'rsssl_encryption_keys_set' LIMIT 1`
0.2618	`SELECT option_value FROM wp_options WHERE option_name = 'rsssl_le_certificate_generated_by_rsssl' LIMIT 1`
0.2801	`SELECT option_value FROM wp_options WHERE option_name = 'rsssl_ssl_activation_active' LIMIT 1`
0.6821	`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.3409	`SELECT option_value FROM wp_options WHERE option_name = 'preload_cache_counter' LIMIT 1`
1.0691	`SELECT ID, post_name, post_parent, post_type FROM wp_posts WHERE post_name IN ('2012') AND post_type IN ('post','attachment')`
6.3610	`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.2880	`SELECT FOUND_ROWS()`
0.6800	`SELECT wp_posts.* FROM wp_posts WHERE ID IN (52,53,56,57,58,59,60,61,62)`
0.6480	`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.7350	`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`
1.1079	`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.3850	`SELECT option_value FROM wp_options WHERE option_name = 'mwp_communication_key' LIMIT 1`
0.2429	`SELECT option_value FROM wp_options WHERE option_name = 'mwp_communication_keys' LIMIT 1`
0.5240	`SELECT option_value FROM wp_options WHERE option_name = 'can_compress_scripts' LIMIT 1`
0.8149	`SELECT * FROM wp_posts WHERE ID = 1716 LIMIT 1`
0.3400	`SELECT option_value FROM wp_options WHERE option_name = 'https_migration_required' LIMIT 1`
0.4470	`SELECT option_value FROM wp_options WHERE option_name = 'site_logo' LIMIT 1`
0.5841	`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.3371	`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.6402	`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.3700	`SELECT wp_posts.* FROM wp_posts WHERE ID IN (1542,1534,1579,1544)`
0.3102	`SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (1542,1534,1579,1544) ORDER BY meta_id ASC`
1.1570	`SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (1) ORDER BY umeta_id ASC`
0.6979	`SELECT * FROM wp_users WHERE ID IN (1)`
1.6580	`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.5360	`SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (54) ORDER BY meta_id ASC`
1.0278	`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.6270	`SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (63) ORDER BY meta_id ASC`
1.1928	`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`
6.4418	`SELECT wp_posts.* FROM wp_posts WHERE ID IN (1771,1734,1728,1725,1721)`
0.6950	`SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (1771,1734,1728,1725,1721) ORDER BY meta_id ASC`
1.4131	`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`
1.0850	`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)`
1.0450	`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 comment_type NOT IN ('note') AND wp_posts.post_status IN ('publish') ORDER BY wp_comments.comment_date_gmt DESC LIMIT 0,5`
10.6080	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.8910	`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.4990	`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