* Take dump of all databases: # mysqldump --skip-lock-tables -A > alldb.sql * * Check where MySQL keeps its files(in my case it's /var/lib/mysql/): # mysql -NBe "SELECT @@datadir" * /var/lib/mysql/ * * Stop MySQL # mysqladmin shut * * Move old MySQL files to safe place # mv /var/lib/mysql /var/lib/mysql.old * * Create new system database # mkdir /var/lib/mysql * # sudo apt-get install mysql-server * * Start MySQL # /etc/init.d/mysql start * * Restore the dump #...
Read More
sudo -i service mysql stop killall -KILL mysql mysqld_safe mysqld apt-get --yes purge mysql-server mysql-client apt-get --yes autoremove --purge apt-get autoclean deluser --remove-home mysql delgroup mysql rm -rf /etc/apparmor.d/abstractions/mysql /etc/apparmor.d/cache/usr.sbin.mysqld /etc/mysql /var/lib/mysql /var/log/mysql* /var/log/upstart/mysql.log* /var/run/mysqld updatedb exit...
Read More
If it's HTML 5, then check if you have <meta charset=utf8 /> under the <head> tag. If you are using <meta http-equiv="Content-Type" content="text/html; charset=utf8" /> under your <head> tag....
Read More
To disable access to author page (author archive), simply add this code snippet to functions.php file: // Disalbe access to author page add_action('template_redirect', 'my_custom_disable_author_page'); function my_custom_disable_author_page() { global $wp_query; if ( is_author() ) { $wp_query->set_404(); status_header(404); // Redirect to homepage // wp_redirect(get_option('home')); } } add_action( 'template_redirect', 'remove_author_pages_page' );...
Read More
I am running Apache 2.4.6, and I had to add the following directives in the Apache2 SSL conf file to get it working: SSLEngine On SSLProxyEngine On SSLProxyVerify none SSLProxyCheckPeerCN off SSLProxyCheckPeerName off SSLProxyCheckPeerExpire off Restart apache after the conf update. ...
Read More