WordPress installation notes

The following steps are required to install a new version of WordPress on Samsung Odroid XU3/4 platform.
1. Install Apache httpd, php, Maria DB, and required support packages (via yum install httpd, mysql, mysql-server, mysql-devel, php-mysql).
2. Untar the new version (tar -xvf wordpress-4.3.tar.gz) to /wordpress.
3. Rename or copy wp-sample.config.php to wp-config.php. Supply the correct database, user, password, and authorization keys (copy from existing installations).
4. dientoan.odroid.us/wp-admin/ to upgrade the database version.

5. Load the database from other/previous installations.
(Export a table from a database)
mysqldump -e –force –quick -uldao -pGodzilla2003 wordpress wp_posts > julia.wordpress.wp_posts.2015.09.12.sql &
(Export an entire database, dvdreplica is about 620 MB).
mysqldump -e –force –quick -uroot -pGodzilla2003 -S/tmp/mysql.sock wordpress > wordpress.2015.09.13.sql &
(Import a table or database)
mysql –force –quick -uldao -pGodzilla2003 -S/tmp/mysql.sock wordpress < planet.wordpress.wp_posts.2015.09.13.sql & Note that the database or table if present will be deleted.

6. Change table wp_options. options_id is 1, 2, or 3. Change the values for record ‘siteurl’ and ‘home’ parameters to http://dientoan.odroid.us.
7. Edit the editor css file to use Monospac821 BT font.
/wordpress/wp-includes/css % vi editor.min.css
Search for ?Consolas and change to Monospac821 BT,Verdana,Consolas at 13px;line-height: 125% to reduce white space.

8. Copy all required folders /images, /php, /plugins, /themes, /upload, etc.
9. (Delete all revisions)
DELETE FROM wp_posts WHERE post_type=”revision”;