Advertisement

PMDStyles RegistrationPMDStyles Recommends DreamHost
How to Move Your phpMyDirectory Site to a New Server PDF Print E-mail
If you've been running a website for a while, you have probably already accumulated quite a bit of content and several 3rd party components and/or modules, and you do not want to start fresh with a new phpMyDirectory installation. This article explains how you can move your phpMyDirectory from your old server to a new server.

Why not use a fresh install?

You will want to move your phpMyDirectory installation rather than re-install if you fit one or all of the following parameters:
  • Your site has accumulated a large amount of data in the database over time (categories, locations, contacts, listings, etc.).
  • Your site uses multiple 3rd-part modules already configured and/or customized for your site.
  • You just feel like trying it out to see if you can do it.
Step 1: Backup everything!

Backup all files within your phpMyDirectory installation. Create a folder on your local system, and download all files to that folder using your ftp client application.

Step 2: Export your database

Note: For this step, it really helps if you have phpMyAdmin installed on your server. Most hosting companies have phpMyAdmin already installed. If you are unsure, ask your hosting provider.

The second thing you need to do is export your phpMyDirectory database. The best thing to do is to export it into an SQL file, which makes importing it easier in a later step. An SQL file will contain all of the necessary SQL commands for creating your database tables and filling them with your data. Be sure you export the entire database.

Step 3: Modify defaults.php

This step is very important. Go to the folder on your local system to which you downloaded all of your phpMyDirectory files. In the first level folder, you will find the file named "defaults.php". Open this file with a text editor and make the necessary changes. At the very least, you will probably need to change the following parameters:
  • $BASE_URL - This is the website url of your new phpMyDirectory installation. Do not include folder names in BASE_URL.
  • $DB['HOST'] - This is the location of the server that hosts your MySQL database. For most instances, this value will be "localhost". If you are unsure, ask your hosting provider.
  • $DB['USER'] - This is the name of your MySQL database.
  • $DB['PASS'] - This is the database user name. Make sure this user has all privileges on your database.
  • $DB['NAME'] - This is the password for your MySQL database user.
Step 4: Upload all of your files to your new server

Using an ftp client application, upload all of your files to the location on your new server where you want to install phpMyDirectory.

Step 5: Import your database to your new MySQL server

Using phpMyAdmin (or console commands if you are an advanced database administrator) and the SQL file you generated in step 2, import your old database into your new database.

Step 6: Test your new installation

Your move should now be complete. Test your site to make sure that everything is working the way you expect it to.

If you are uneasy or uncomfortable with this process, we strongly recommend that you hire a professional to do this for you.
Thursday, 08 May 2008
 
[ Back ]

Latest News

Viva Template Series
Corporate Business type websites are interestingly popular, however not usually because of their design. Business websites have a stereotype to be simple without any fancy features. The same concept has been used for our latest phpMyDirectory template. The template VIVA was created to provide a beautiful design focused on elegance, variety and typography. It makes a great basis for any site that ...
Frescos Template Series
We look out for our customers requests, and we heard many members interested in a artistic template. PMDStyles presents an artistic yet professional template 'Frescos'. Frescos helps us to see how beautiful a phpMyDirectory template can be. Frescos features a fresh, stylish new look and also a CSS based template that uses minimal tables to control the layout, this allows for increased perform...
Nova Template Series
Are you looking for a good template for your personal directory or a business directory? Our new template Nova has been released. The design team keep it came in a simple and clean way, simple to use and simple to customize. The boring phpMyDirectory traditional homepage has been completely replaced by neat and eye-catching CSS based layout. Nova is a very clean design that really shows off th...
Neon Template Series
PMDStyles unleashes the next powerful Web 2.0 template: Neon! Neon comes packed with a lot of new eye-catching features. This exciting new template features a clean and simple design and plenty of PMDStyles horsepower under the hood. Maximum flexibility and a plethora of typography and module variations give this subtle design the power needed to make any content look amazing. Neon is has bee...
Edge Template Series
The much awaited "Edge" is now ready for its debut. You will find "Edge" to be sleek, highly appealing and on the cutting "Edge" of technology. Due to some technical issues in the text color changer, we had to abandon this feature at this time so as to get this outstanding template off and running. We will keep working on the issues for the color changer and perhaps release it in the next templa...

Client Login

Forgot Password? | Signup Now!