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]
Copy a file from your local computer to a remote host using secure copy, scp (which uses ssh for data transfer and provides the same security as using ssh).
scp [filename] [username]@remotehost:[location]
[bash]scp file_to_copy.txt username@example.net:/some/remote/directory[/bash]
copy a directory to your home computer from the remote computer.
[bash]scp -r directory_to_copy username@example.net:[/bash]
copy a directory from a remote server to the current directory on your computer.
scp -r folder [username]@remotehost:[location] .
[bash]scp -r username@example.net:/some/remote/directory .[/bash]
If you don’t have automated keys setup you will be asked for the password for that user.
An example for copying a MySQL database. Including the : without a location puts the file in the home folder.
[bash]mysqldump database_name -uroot > database_dump.sql
scp database_dump.sql user@example.net:[/bash]
Then ssh into the remote server and open the mysql prompt
[bash]mysql -uroot -p
mysql> create database database_name;
mysql> exit[/bash]
Then run the mysqldump file
[bash]mysql database_name -uuser -p < database_dump.sql[/bash]
Remember to create the database user on the new machine (this has to match what is in the wp-config.php file).
[bash]sudo mkdir new_directory[/bash]
rm [name]
[bash]rm -i file_to_remove.txt[/bash]
Using -i prompts you to confirm the deletion.
Remove directory and all of its contents without having to confirm. Obviously be careful.
[/bash]sudo rm -r directory_to_remove[/bash]
mv [name] [new_location]
[bash]mv file.txt new_sub_directory/file.txt[/bash]
Rename a file (similar to moving)
mv [name] [new_name]
[bash]mv file.txt new_file_name.txt[/bash]
cp -r [folder]/* [new_location]
[bash]cp -r folder/* /some_place/else/[/bash]
If you want to stop your SSH sessions from being shut down you can add the following line to /etc/ssh/ssh_config on your local machine.
[bash]sudo gedit /etc/ssh/ssh_config[/bash]
Then add:
[bash]ServerAliveInterval 30[/bash]
This does remove the security feature of closing your session in case you leave your computer, but you may decide to take that risk. This sends a SSH package every 30 seconds so your server doesn’t close the connection due to inactivity.
Set the DNS name server to use for your machine.
[bash]sudo nano /etc/resolv.conf[/bash]
Then you can use for example (8.8.8.8 is Google public DNS, 208.67.222.222 is OpenDNS):
[bash]nameserver 208.67.222.222
nameserver 8.8.8.8[/bash]
[bash]sudo lshw[/bash] will provide infor on your system, CPU types, 32 v 64 bit…
A checklist for moving an existing WordPress site to a new VPS web host, when you have full admin rights over the server.
a2enmod rewrite
/etc/init.d/apache2 restart
Related: create a new database and run .sql file – Display text based on if it is the WordPress blog home page
If WordPress is up to date you could also just copy over everything for steps 1 and 2. I am using this for several sites I have had for years, I figure starting with a clean install of WordPress is a good idea, but it is not necessary.
location
~/.bash_aliases
format
alias foo=’whatever you want to actually run’
examples
[bash]alias alogin = ‘ssh user@example.com’
alias rm = ‘rm -i'[/bash]
The second one forces rm (remove) to prompt you to verify. This makes is less likely you delete something by mistake.
Keywords: shortcuts, macro
How to create a MySQL database and import tables, data… from a sql file.
[bash]mysql -u<username> -p[/bash]
[sql]mysql -uroot -p
mysql> create database some_database;
mysql> use some_database;
mysql> source some_database.sql;[/sql]
The third line runs the named sql file for the database you names.
[sql]mysql -uroot -p
mysql> USE ‘some_database’;
mysql> CREATE USER ‘new_user’@’localhost’ IDENTIFIED BY ‘user_password’;
Query OK, 0 rows affected (0.00 sec)
mysql> GRANT SELECT,INSERT,UPDATE,DELETE ON some_database.* TO ‘new_user’@’localhost’;
[/sql]
For some reason MySQL chooses to say 0 rows affected, when it succeeds and ads a row for the user. Anyway if you get that message, it worked.
[sql]mysql -uroot -p
mysql> SET PASSWORD FOR ‘username’@’localhost’ = PASSWORD(‘new_password’);[/sql]
Restart mysql: [bash]sudo /etc/init.d/mysql restart[/bash]
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).