WordPress Admin Interface not styled properly

I believe the wordpress URL and site URl are not set right. Please try to edit your wp-config.php adding these lines: define(‘WP_HOME’,’http://example.com’); define(‘WP_SITEURL’,’http://example.com’); Is your index on same folder as wp installation? if not, you need to place it there. I’m talking about placing the URL in the above lines, not the index on the … Read more

How to perform WordPress backups using wp-cli?

You can use the WP-CLI command wp db export <filename> Run the command from within the home directory for the install. Now, you have a database included in your files. Zip up the directory and move it aside. Now you can perform the upgrade, and if something breaks, replace with the old site and import … Read more

How to backup and restore configurations

You must export all table beginning with your WordPress prefix. Open your phpmyadmin panel. Then open your wordpress database. Click “export” from top menu. Select “Export Method:” as custom. Select your all tables beginning your prefix. Then go to bottom of page click “go”. You got your SQL file. Move all files to new directory. … Read more

What is the best method to export local WordPress installation and import to live server?

I’ve seen a bunch of ways of doing this, but here are a couple: Use a plugin, like BackupBuddy (paid): http://pluginbuddy.com/purchase/backupbuddy/ Export your whole DB using phpMyAdmin and run a search-and-replace tool that properly deals with the serialized data, e.g. https://interconnectit.com/products/search-and-replace-for-wordpress-databases/ (I use this, and it works just fine). Then on the live server, create … Read more

What is a better way to backup files than FTP?

(assuming that FTP is slow due to amount of files) I use SSH to remotely give command to compress WP directory in single archive and then fetch that file. On Windows this is relatively easily scriptable with WinSCP ( scripting documentation ). This method greatly speeds up transfer, makes it secure, requires no plugins server-side, … Read more

Postgresql 9.2 pg_dump version mismatch

You can either install PostgreSQL 9.2.1 in the pg_dump client machine or just copy the $PGHOME from the PostgreSQL server machine to the client machine. Note that there is no need to initdb a new cluster in the client machine. After you have finished installing the 9.2.1 software, remember to edit some environment variables in your .bash_profile file.