THIS ARTICLE IS OUT DATED. Please see: http://www.TheCodeCave.com/EasyWPUpdate for the current release.
Well I’ve gotten some good feed back from all of you. And I want to say Thanks!
I do have a new version of the script that has some improvements.
- Fixed extra directory levels in the backup
- Improved use of quotes
- Local file location did not untar the file
- Removed “verbose” from cp to make messages clearer
- $CommonRootPrefix no longer requires trailing ‘/’
- Added comment “DO NOT PUT A SLASH AFTER ANY OF THESE VARIABLES”
- Added a list of directories to backup
- Changed long backup section into a loop of the directories
- Changed to tmp directory before performing wgets
- Added a few more update steps for forward compatiblity
- Added SQL backup code
- Added Zip of backups
I’m doing local testing on these changes and will probably release this more publicly Wednesday or Thursday.
In the mean time, I would like to ask for your help.
What is the most optimized version of this line that we can come up with:
grep “define(‘DB_NAME’, ‘” wp-config.php|sed -e ‘s/define(.DB_NAME….//g’|sed -e ‘s/.); .. The name of the database//g’
That line, run from any blog directory, returns the DB_Name in a way I can pass it to MYSQLDump. It is neither, pretty, nor optimized, nor resiliant.
What is the most optimized way YOU can think of to write that bash statement?
SED problem is solved. Thanks to GoldFish on the #SED channel of FreeNode.