Just a quick tip on how to dump a sql result to a txt file.
mysql -e “select * from [table]” -u[user] -p [database] > sqlresult.txt
For example:
[bash]mysql -e "select * from orders where product_id = 15" -uroot -p > sqlresult.txt[/bash]
Related: Some MySQL cli Syntax Examples – Basic MySQL Performance Monitoring – MySQL Performance Tuning Tips
I updated from Ubuntu 12.04 to Ubuntu 14.04 on a virtual private server.
When you do that update, Apache is updated from 2.2 to 2.4. Certain changes mean that until you update the site-available configuration files no web sites will work.
The quick checklist of what you have to do for each configuration
The upgrade to Ubuntu 14.04 LTS was interrupted (I quit a window using the wrong command – oops). Luckily it wasn’t a big deal. I was able to delete the lock file.
[bash]sudo rm /var/lib/dpkg/lock[/bash]
Then trying to update again
[bash]sudo apt-get dist-upgrade[/bash]
gave a message telling me what command to use to have the upgrade continue.
[bash]sudo dpkg –configure -a[/bash]
which seemed to work fine.
Related: Bash Profile Adjustments, Scrolling History – Checklist: Setting Up a New Domain on VPS – ModSecurity: Adjustments for WordPress
Good reminder and discussion on Hacker News about the danger of copy-paste from a website into terminal.
When copying from a website it is easy for hidden text to be included in the clipboard. If you paste that into terminal it can be executed before you see the code. Including new line commands in the copied text will automatically execute the commands (in most terminal applications).
The best solution is to paste the clipboard content into something to view the text before pasting into clipboard. The best way is probably to recopy it. I use this double copy method to get rid of formatting I don’t want (when the clipboard includes things like font styling info you don’t want – not relavent when pasting into terminal but the pasting [into say vim, which won’t include the extra formatting details] and recopying part is similar). It may be possible to have text hidden (write it in a way where it won’t show up on the screen but is in the clipboard – using some tricky unicode characters or something).
Some people put # before pasting into clipboard but that only protects the first “line.” Any new lines could still be run without you seeing them.
The discussion warns against a malicious website intentionally creating a problem but if you paste in multiple lines there is also just the danger from the lines executing immediately when you wanted to edit the line before it was executed.
Related: Customizing the Command Prompt for Terminal – Bash Profile Adjustments, Scrolling History – Adding a Key to Your Server for SSH Login
The main reason to bother with this is to help search rankings. Sub-domains (for example, www.curiouscat.com and curiouscat.com) are treated as separate websites even if you have entirely the same content displayed for both. If 20% of the links to your site use the www and 80% don’t then your sites ranking by search engines is less than it would be if it was just treated as one site.
You can set the domain to use in Google webmaster tools. But that doesn’t do anything for all the other search engines. Also if you have both, some reports some will keep statistics separately for the non-www and www domain (Google Adsense does this, for example).
For Apache you can place the following code in your virtual hosts file (in the sites-available directory under Apache).
Replace curiouscat.com with your domain name.
[bash]<Directory /srv/www/curiouscat.com/public_html/>
RewriteEngine On
RewriteCond %{HTTP_HOST} ^www.curiouscat.com$ [NC]
RewriteRule ^(.*)$ http://curiouscat.com/$1 [R=301,L]
</Directory>[/bash]
Then you need to capture the update and reload Apache.
Disable the site (in order to enable it with the updates)
[bash]sudo a2dissite curiouscat.com[/bash]
Enable the site
[bash]sudo a2ensite curiouscat.com[/bash]
Reload Apache (new way – Ubuntu 12.04)
[bash]sudo service apache2 reload[/bash]
Old way to reload Apache was > sudo /etc/init.d/apache2 reload
If when you try to reload you get this error message:
“Invalid command ‘RewriteEngine’, perhaps misspelled or defined by a module not included in the server configuration” then enable modrewrite on apache:
[bash]sudo a2enmod rewrite[/bash]
You should then be told to restart apache
[bash]sudo /etc/init.d/apache2 restart[/bash]
Or you can include the following in your .htaccess file
[bash] RewriteEngine On
RewriteCond %{HTTP_HOST} ^www.curiouscat.com$ [NC]
RewriteRule ^(.*)$ http://curiouscat.com/$1 [R=301,L][/bash]
Related: Checklist for Setting Up a New Domain on VPS – Phusion Passenger Tips and Troubleshooting Ideas
If you wanted to force www to be used instead just flip the regular expression around:
[bash]<Directory /srv/www/curiouscat.com/public_html/>
RewriteEngine On
RewriteCond %{HTTP_HOST} ^curiouscat.com$ [NC]
RewriteRule ^(.*)$ http://www.curiouscat.com/$1 [R=301,L]
</Directory>[/bash]
To replace text in all the files in a directory, recursively, you can use grep.
sudo grep -rl texttoreplace /somedirectory/ | sudo xargs sed -i ‘s/repacethis/withthis/g’
[bash]sudo grep -rl oldtext /example/directory/ | sudo xargs sed -i ‘s/oldtext/newtext/g'[/bash]
The g on the end, lets it replace all the instances of the text in each file.
In Rails 2.x
script/generate controller [new controller name] [page you want create]
[code]script/generate controller search index[/code]
In Rails 3.x
[code]rails generate controller search index[/code]
Cut and past php code to determine if it is the wordpress blog home page (and only the home page itself).
[php]<?php if (is_home() && !is_paged()): ?>[/php]
Example, to print john if it is a “homepage” templated page and jill otherwise:
[php]<?php if (is_home(); ?>
<?php
if($name == ‘john’){
echo ‘Hi John’;
}else if($name == ‘jill’){
echo ‘Hi Jill’;
}else{
echo ‘Hi’;
}
?>[/php]
for Rails 2.*
Not for Rails 3
[ruby]./script/generate resource article[/ruby]
[ruby]./script/generate migration add_join_table_for_articles_and_authors[/ruby]
Update to the routes file should be taken care of by generate resource, but might want to check).