TheSkyNet

Weather Icons

TheSkyNet

sudo mysql -uroot -ppassword  -e "show databases" |
grep -v Database | 
grep -v mysql|
grep -v information_schema| 
grep -v test | 
gawk '{print "drop database " $1 ";"}' | 
mysql -uroot -ppassword

TheSkyNet

 /**
   * @return bool
   * @throws Exception
   */
  public function isAuthenticationRequired()
  {
    return false;
  }

TheSkyNet

#FIND

#SELECT id,state,command,time,left(replace(info,'\n','<lf>'),120)
#FROM information_schema.processlist
#WHERE command <> 'Sleep' 
#AND info NOT LIKE '%PROCESSLIST%'
#ORDER BY time DESC LIMIT 50;

host="octopus-read-1"
password=XXXXXXX

TheSkyNet

SET @oldsite='http://oldsite.com'; 
SET @newsite='http://newsite.com';
UPDATE wp_options SET option_value = replace(option_value, @oldsite, @newsite) WHERE option_name = 'home' OR option_name = 'siteurl';
UPDATE wp_posts SET post_content = replace(post_content, @oldsite, @newsite);
UPDATE wp_links SET link_url = replace(link_url, @oldsite, @newsite);
UPDATE wp_postmeta SET meta_value = replace(meta_value, @oldsite, @newsite);

/* only uncomment next line if you want all your current posts to post to RSS again as new */
#UPDATE wp_posts SET guid = replace(guid, @oldsite, @newsite);

TheSkyNet

# ----------------------------------------------------------------------
# ROOT/ folder .htaccess
# ----------------------------------------------------------------------
# Laravel Note:
# Note: Laravel is designed to protect your application code,
# and local storage by placing only files that are necessarily
# public in the public folder. It is recommended that you either
# set the public folder as your site's documentRoot (also known as a web root)
# or to place the contents of public into your site's root directory
# and place all of Laravel's other files outside the web root.