Updating a Project in TortoiseSVN 1.4.7

To get any changes made whilst you were away, you right-click the local folder and select SVN Update.

Context Menu

Selecting SVN Update from the Windows Explorer context menu.

My authentication details were automatically re-used from the first SVN Checkout. This was convenient.

Progress Window

SVN Update window appears.

A window pops up to show progress. It contains an empty Listview with 3 columns.

Completed

.

When finished, it adds a Completed to the Listview and says how much data was transferred.

A Show log... button becomes visible, too. This should be Show Log... because:

Grab the Server Database

. Now you must grab any changes to the database. I go to the Dreamhost Web Panel page, shown in the screenshot.

phpMyAdmin

. About halfway down the page is the link to manage the database.

Select Database

.

The one we want is Joomla15. You select it from a dropdown list on the left-hand side.

This could a normal navigation list. Then you could see which are available at a glance. Selecting one would take a single click.

View Database

.

After selecting the database, you get this screen. I click the Export tab.

Export Database

. .

Arrive at a huge set of options, shown in the screenshot.

I skip all these and click Go.

Copy the Database

. .

Select All the text, then Copy it.

Update Local Database using phpMyAdmin

.

Going to http://localhost/ when WAMP is running shows this admin page.

Near the bottom is the link to manage the database.

Select Database

.

The local database is named Joomla15 to match the server’s database.

Drop Database

.

I click the Drop tab to destroy my local copy of the database.

Are you Sure?!

.

It brings up a warning message, which is a good idea. It says:

You are about to DESTROY a complete database!

Do you really want to :

DROP DATABASE `joomla15`

Weird capitalisation and punctuation as original.

It has an OK button and a Cancel button. I click OK.

Dropped

.

Database has been dropped.

Recreate the Database

.

At the local phpMyAdmin page, I enter Joomla15 in the Create New Database box. I then click Create.

The database is now ready for the server’s SQL from the Export.

The SQL tab opens the page to do that.

Paste SQL

. .

Paste into the box, then click Go.

Done!

.

The local database now matches the server’s database.