z z z z z z z z z

z z z z z z z z z

Main menu

Skip to primary content
Skip to secondary content
  • Home
  • Bookmarklet Generator
  • Business Name Generator
  • What is my IP address?
  • Whois Lookup

Monthly Archives: April 2017

Daily Backup Sqlite3 Database Shell Script

Posted on April 5, 2017 by zzz_zwp

Here’s a basic script to generate database backups for an Sqlite3 database. Simply copying the .sqlite3 database file may work but there may be issues and data corruption if the database is locked or actively being used. The better option … Continue reading →

Posted in Shell Scripts | Tagged backup, cron, date, script, sqlite3

Shopify for Ecommerce

Use Shopify for ecommerce

WP Engine

Use WP Engine for WordPress Hosting




Recent Posts

  • Here’s a list of handy Vim commands
  • Uses This Product Listing
  • Postgresql Commands to Import / Export (pg_restore, pg_dump) databases
  • mkdir(1) – Linux manual page
  • Ruby on Rails Infinite Scroll Patterns

Recent Comments

    Archives

    • March 2023
    • December 2018
    • November 2018
    • October 2018
    • September 2018
    • May 2017
    • April 2017
    • February 2015
    • January 2015
    • November 2014
    • October 2014
    • July 2014
    • June 2014
    • May 2014
    • January 2014
    • November 2013
    • August 2013
    • June 2013
    • May 2013
    • April 2013
    • March 2013
    • January 2013
    • December 2012
    • November 2012
    • October 2012
    • September 2012
    • August 2012
    • July 2012
    • June 2012
    • May 2012
    • April 2012
    • March 2012
    • February 2012
    • January 2012
    • December 2011
    • November 2011
    • October 2011
    • September 2011
    • August 2011
    • July 2011
    • June 2011
    • May 2011
    • April 2011
    • March 2011
    • February 2011
    • January 2011
    • December 2010
    • November 2010
    • October 2010
    • September 2010
    • August 2010
    • July 2010
    • June 2010
    • May 2010
    • April 2010
    • March 2010
    • February 2010
    • January 2010
    • December 2009
    • November 2009
    • October 2009
    • September 2009
    • August 2009
    • July 2009
    • June 2009
    • April 2009
    • May 2008

    Categories

    • Coding
    • Editors
    • Hotkeys
    • MacOS
    • Shell Scripts
    • Uncategorized
    • Vim

    Meta

    • Log in
    • Entries feed
    • Comments feed
    • WordPress.org
    © zzzzzzzzz
    Toggle Console (1)
    Unknown
    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 6121 in file /home1/zzz/public_html/wp-includes/functions.php
    Profiler (0 ms)
    No entries found.
    SQL (35 queries | 45.90 ms)
    0.5209
    SELECT option_value 
    FROM wp_options 
    WHERE option_name = 'GOTMLS_nonce_array' 
    LIMIT 1
    0.5159
    SELECT option_value 
    FROM wp_options 
    WHERE option_name = 'GOTMLS_definitions_array' 
    LIMIT 1
    0.5820
    SELECT option_value 
    FROM wp_options 
    WHERE option_name = 'GOTMLS_scan_log/216.73.216.148/1749950685.8375' 
    LIMIT 1
    0.5610
    SELECT option_value 
    FROM wp_options 
    WHERE option_name = 'gzipcompression' 
    LIMIT 1
    0.5732
    SELECT option_value 
    FROM wp_options 
    WHERE option_name = 'rsssl_encryption_keys_set' 
    LIMIT 1
    0.7000
    SELECT option_value 
    FROM wp_options 
    WHERE option_name = 'rsssl_le_certificate_generated_by_rsssl' 
    LIMIT 1
    0.4210
    SELECT option_value 
    FROM wp_options 
    WHERE option_name = 'rsssl_ssl_activation_active' 
    LIMIT 1
    0.7770
    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.5112
    SELECT option_value 
    FROM wp_options 
    WHERE option_name = 'preload_cache_counter' 
    LIMIT 1
    0.8881
    SELECT ID, post_name, post_parent, post_type 
    FROM wp_posts 
    WHERE post_name IN ('2017') 
    AND post_type IN ('post','attachment')
    6.3729
    SELECT SQL_CALC_FOUND_ROWS wp_posts.ID 
    FROM wp_posts 
    WHERE 1=1 
    AND ( ( YEAR( wp_posts.post_date ) = 2017 
    AND MONTH( wp_posts.post_date ) = 4 ) ) 
    AND ((wp_posts.post_type = 'post' 
    AND (wp_posts.post_status = 'publish'))) 
    ORDER BY wp_posts.post_date DESC 
    LIMIT 0, 10
    0.4439
    SELECT FOUND_ROWS()
    0.6361
    SELECT wp_posts.* 
    FROM wp_posts 
    WHERE ID IN (1683)
    0.8790
    SELECT post_id, meta_key, meta_value 
    FROM wp_postmeta 
    WHERE post_id IN (1683) 
    ORDER BY meta_id ASC
    1.3061
    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 (1683) 
    ORDER BY t.name ASC
    0.5820
    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 (470,471,472,473,474,469)
    0.8519
    SELECT * 
    FROM wp_posts 
    WHERE ID = 1716 
    LIMIT 1
    0.6080
    SELECT option_value 
    FROM wp_options 
    WHERE option_name = 'https_migration_required' 
    LIMIT 1
    0.6061
    SELECT option_value 
    FROM wp_options 
    WHERE option_name = 'site_logo' 
    LIMIT 1
    0.7620
    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.6530
    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
    1.1990
    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.6900
    SELECT wp_posts.* 
    FROM wp_posts 
    WHERE ID IN (1542,1534,1579,1544)
    0.7291
    SELECT post_id, meta_key, meta_value 
    FROM wp_postmeta 
    WHERE post_id IN (1542,1534,1579,1544) 
    ORDER BY meta_id ASC
    1.6398
    SELECT user_id, meta_key, meta_value 
    FROM wp_usermeta 
    WHERE user_id IN (1) 
    ORDER BY umeta_id ASC
    0.7789
    SELECT * 
    FROM wp_users 
    WHERE ID IN (1)
    1.2560
    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
    8.6150
    SELECT wp_posts.* 
    FROM wp_posts 
    WHERE ID IN (1771,1734,1728,1725,1721)
    0.6630
    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.0211
    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.8378
    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,1,491,82)
    1.0729
    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
    4.8580
    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
    1.3020
    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.4861
    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)
    Templates
    [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/sidebar.php
    [7] => themes/twentyeleven/footer.php
    [8] => themes/twentyeleven/sidebar-footer.php
    Globals
    $_GET = array (
    );

    $_POST = array (
    );

    $_COOKIE = array (
    );

    $_SESSION = array (
    );

    $_SERVER = array (
      'SERVER_SOFTWARE' => 'Apache',
      'REQUEST_URI' => '/2017/04/',
      '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/2017/04',
      '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' => 'aE4g3TQpopTDSlVSfoypcwAAc3k',
      'REDIRECT_QS_ConnectionId' => '174995068580427761118258',
      'REDIRECT_SCRIPT_URL' => '/2017/04/',
      'REDIRECT_SCRIPT_URI' => 'https://www.zzzzzzzzz.net/2017/04/',
      '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' => '3',
      'REDIRECT_H2_STREAM_TAG' => '118258-391-3',
      'REDIRECT_STATUS' => '200',
      'UNIQUE_ID' => 'aE4g3TQpopTDSlVSfoypcwAAc3k',
      'QS_ConnectionId' => '174995068580427761118258',
      'SCRIPT_URL' => '/2017/04/',
      'SCRIPT_URI' => 'https://www.zzzzzzzzz.net/2017/04/',
      'HTTPS' => 'on',
      'SSL_TLS_SNI' => 'www.zzzzzzzzz.net',
      'HTTP2' => 'on',
      'H2PUSH' => 'off',
      'H2_PUSH' => 'off',
      'H2_PUSHED' => '',
      'H2_PUSHED_ON' => '',
      'H2_STREAM_ID' => '3',
      'H2_STREAM_TAG' => '118258-391-3',
      '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' => '34519',
      'REDIRECT_URL' => '/2017/04/',
      'SERVER_PROTOCOL' => 'HTTP/2.0',
      'REQUEST_METHOD' => 'GET',
      'QUERY_STRING' => '',
      'SCRIPT_NAME' => '/index.php',
      'PHP_SELF' => '/index.php',
      'REQUEST_TIME_FLOAT' => 1749950685.8148529529571533203125,
      'REQUEST_TIME' => 1749950685,
      'argv' => 
      array (
      ),
      'argc' => 0,
    );

    Close