Import Existing PHP Projects to Eclipse

Let’s say you download and extract a project such as Joomla and you want to add it to your namespace.  Intuitively, you would think that you could just copy the extracted folder to your namespace and close and reopen Eclipse and all of a sudden the project magically appears. Guest what?  It does not work that way.

I am not going to curse at Eclipse because simply it is free, but we could benefit from Eclipse having a initialize script that checks for new folder at the root  of the namespace and prompt us to make choice whether or not we want to create a project using this new directory. It is just common sense.

Here are the step that worked for me:
(FYI: eclipse version: 1.2.2.20100216-1730)

1. Copy a .project file from an existing project to your php folder (Joomla in this case)

2. Open .project file and change the name of the project to the new project.

3. Then Open Eclipse and go to File->Import...



4. Select your root folder and then click finish.
That seems to be a lot of work, for something that simple.

The Database Engine Service could not resolve the specified location

The Database Engine Service could not resolve the specified location.
 You are most likely to get this error message, if you try to restore or backup a database from a UNC drive (Mapped drive)
If you deal with large databases you do not have the luxury of moving the files to local drive first then restore from there.
Your best bet is to find a way make it work.

There are many articles on the internet that give advice on how resolve this issue but most of them did not help me. The only solution that works for me countless time is the one below:

1.  Before you run the query below please make sure that the user account running SQL has Sharing  and Folder security permissions on the shared drive that contains your backups files.



(FYI: replace ycsoftware in bold with your own stuffs)

Restore database ycsoftware
from disk='\\ycsoftware\ycsoftware.BAK'
with
MOVE 'ycsoftware_data' to 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\ycsoftware_data.mdf',
MOVE 'ycsoftware_log'  to  'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\ycsoftware_log.mdf'

The only issue with this method is that you will not get a progress bar. You just have to let it rip.

Reference:
Restore SQL Server Database
http://blogs.techrepublic.com.com/window-on-windows/?p=454

MSDN
http://msdn.microsoft.com/en-us/library/ms186858(SQL.90).aspx