background preloader

DreamHost tips

Facebook Twitter

Migrate MySQL. This article will help you migrate your MySQL database from your old host to DreamHost.

Migrate MySQL

Throughout this guide you will see parts of commands in Bold - that signifies that you must replace the text there with the correct information for you. This article also assumes that you have already created a database at DreamHost through the DreamHost Web Panel > Goodies > MySQL Databases. One Step Solution It may be possible for you to move your database to DreamHost with one command passed through shell. This solution requires Shell (Telnet or SSH) access to one of the hosts, AND remote access to the "other" database. Mysqldump -h oldhost -u oldusername -poldpassword olddbname | mysql -h newhost -u newusername -pnewpassword newdbname Note: there is no space between "-p" and the password.

Explanation The "mysqldump" command writes a copy of a database to a single file; this is known as "dumping. " A Longer Solution Creating the MySQL Backup Importing Your Data Importing Through phpMyAdmin Testing. Slow site troubleshooting. What to do if your site is running very slowly, is not loading at all, or shows a 500 error or Internal Server Error.

Slow site troubleshooting

Most sites that show errors or run slowly are database-driven sites. Their content is not saved on the web server (unless you have caching enabled for that web application), so it is dynamically created for each visitor by the communication between the web server and the database server. There are a few common things that can go wrong and cause you to see errors. Check version of PHP Most Dreamhost customers are now on PHP5. PHP4 is no longer being updated and is no longer supported by the developers. With the recent updates of the MySQL servers to 5.1, PHP 4 is not longer being supported. Go to Manage DomainsClick on "Edit" under "Web Hosting" for your domain. Check version of installed software If you have installed software through Dreamhost's One-Click Installer, then updating is easy. To see what the Advanced One-Click panel looks like, click on this image.

Shell. Fine Tuning Your WordPress Install. We offer WordPress as a one-click install, and there is a reason for that.

Fine Tuning Your WordPress Install

Right out of the box, WordPress is a highly efficient, easy-to-use blogging platform. However, just like any other piece of web software, things happen and it can run wild on a server. To help prevent issues, we have a few plugins we suggest that customers try out. We have listed these below along and have included a few other hints to boot. Keep in mind that following these suggestions is great if you're running into issues — but actually implementing some of these suggestions is the best way to prevent problems to begin with. Upgrades Staying on top of both plugins and core WordPress upgrades is the single best thing you can do.

If you use our one-click installer, you can request upgrade notifications by clicking on "Email me when upgrade available" next to at least one of your WordPress installs under the advanced upgrade section. Spam Anti-Spam Plugins Notes Caching Web Caching Plugins Other Caching Plugins FastCGI <?