Set CentOS Server Time Zone
Posted on | August 8, 2011 | No Comments
# cd /etc
# ln -sf /usr/share/zoneinfo/America/Los_Angeles localtime
# date
Installing WordPress on Linux
Posted on | June 27, 2011 | No Comments
Quick set-up guide for installing WordPress on a virtual host
By Robin Rowe
HOLLYWOOD, CA (LinuxMovies) 6/26/2011 – WordPress is open source PHP and MySQL-based content publishing software. We’ll configure MySQL with wpdb as the user name and a password that isn’t actually ‘password’. We’ll name the database the same name as our website. Then we’ll download, unzip and install the latest WordPress.
- mysql -u root -p
CREATE USER ‘wpdb’@'localhost’ IDENTIFIED BY ‘password’;
CREATE DATABASE linuxmovies;
GRANT ALL PRIVILEGES ON goshtv.* TO “wpdb”@”localhost”;
FLUSH PRIVILEGES;
EXIT; - cd ~
mkdir install
cd install
wget http://wordpress.org/latest.tar.gz
tar xvfz latest.tar.gz
md /var/www/html/linuxmovies.org/
cp -rv ~/install/wordpress/* /var/www/html/linuxmovies.org/
mv /var/www/html/linuxmovies.org/wp-config-sample.php /var/www/html/linuxmovies.org/wp-config.php
chown -R apache /var/www/html/*
chgrp -R apache /var/www/html/* - Edit wp-config.php
Enter db, user, and pwd
Enter secret keys:https://api.wordpress.org/secret-key/1.1/salt/
define(‘WP_DEBUG’, true);
define(‘WP_DEBUG_LOG’, true); - Edit httpd.conf to add virtual host
- Check DNS is set
Virtual Host Apache Settings
<VirtualHost *:80 *:8080>
ServerName www.linuxmovies.org
DocumentRoot /var/www/html/linuxmovies.org
ScriptAlias /cgi-bin/ “/var/www/html/linuxmovies.org/cgi-bin/”
Redirect permanent /webmail http://www.linuxmovies.org/cgi-bin/webmail.cgi
</VirtualHost>
<VirtualHost *:80 *:8080>
ServerName linuxmovies.org
Redirect permanent / http://www.linuxmovies.org/
</VirtualHost>
Install These Plug-ins
- Akismet: Scrape off comment spam.
- Fix Rss Feeds
- Google News Sitemap: Install before posting your first story.
- WP-Stats-Dashboard
- Jetpack: Necessary for WP-Stats-Dashboard. Don’t use abandoned WordPress.com Stats plug-in
- WP YouTube Lyte; Embed YouTube videos easily.
Useful MySQL Commands
show databases;
use linuxmovies;
show tables;
select user from user;
source batch-file;
SHOW COLUMNS FROM City;
select option_name from wp_options;
select option_name from wp_options where option_name like ‘akismet%’;
select option_name, option_value from wp_options where option_name like ‘%key%’;
UPDATE wp_option SET option_value = ‘HP’ WHERE option_value = ‘IBM’;
delete from wp_options where option_name = ‘wpsd_un’;
delete from wp_options where option_name = ‘wpsd_pw’;
Making and Restoring WordPress Backups
mysqldump -v -u root -p wordpress > goshtv.sql
mysqldump -u root -p wordpress_spl > screenplaylab.sql
mysql -u root -p goshtv < goshtv.sql
mysql -u root -p screenplaylab < screenplaylab.sql
mysql -u root -p hollywoodtoday < hollywoodtoday.sql
zip -rv goshtv-images.zip /var/www/html/goshtv.net/wp-content/uploads/
Linux Movies, Hollywood Loves Linux
Posted on | June 26, 2011 | 3 Comments
Linux is #1 in Hollywood
By Robin Rowe
HOLLYWOOD, CA (LinuxMovies) 6/26/2011 – Linux Movies is the source for news and information about Linux being used in the motion picture industry and television. Linux is the most popular operating system for studio animation and visual effects. It’s used by Disney, DreamWorks Animation, ILM, Sony, and just about everywhere else where major movies are made. Where you won’t find much Linux is in TV or smaller films or being used anywhere for editing. Where it’s just a few machines, Windows or Macintosh are typically preferred. Linux is better, faster, cheaper where large numbers of machines are deployed as artist desktops or renderfarm grids.
« go back