I have just received a new book: “Apprenticeship Patterns“: Skimming through the first pages I noticed the words in the 3rd column extending from the points in the 2nd column and thought, ‘Hmm, I have heard about these 2nd column points’…
The following table popped up in my mind, which I would like to share with you:
Software development practices:
|processes and tools
||Individuals and interactions
||but also a community of professionals
||but also well-crafted software
||but also productive partnerships
|following a plan
||Responding to change
||but also steadily adding value
Any ideas for a 4th column? Looking forward to actually reading the book…
We have just had the case of having ftp access to a site on a shared hosting LAMP webspace but needed also the database and mainly the database scheme to setup our own development-system for the app. This is actually very straight forward using the following snippet uploaded and executed on the webserver:
exec( 'mysqldump -h dbXXX.1und1.de -u dboYYY -pZZZ dbYYY > dump.sql', $ret );
This is what you do:
- Find the configuration with the db-credentials in the source of the application and replace
- dbXXX.1und1.de with the hostname,
- dboYYY with the username,
- ZZZ with the password (notice there is NO blank between the option -p and the password!),
- dbYYY with the database you would like to backup.
- Save the snippet as file with extension .php and copy it via ftp to the webspace.
- Find the URL to execute the script.
- If it worked, there should be a new file dump.sql in the same directory, download it, it contains the db-schema and all data.
- Delete both files to wipe your traces.
If it does not work try something like “exec(‘ls -la’);”. If you see the contents of the directory you can use the exec-function and the problem is something else.