February 25, 2009
vBProductMaker intended to help vBulletin product developers and make it little easy to manage their products and corresponding components. The skill level of users using this tool can vary from novice to advanced web programmers. It is combining code editor with syntax coloring, vBulletin-aware management console and XML builder, in order to produce final XML file which can be imported into vBulletin.
vBProductMaker is using internal file type in order to store and retrieve all information related to your vBulletin product. The file type is defined as .vbu . You can save your product as .vbu file and then later load it, modify and finally export to vBulletin XML product.
As the help contains most of information one can need, I will show several screenshots below.
This is public beta version, feel free to test and report issues.
Requirements: .NET framework 2.0 or later
Download vBProductMaker 1.5.1
January 29, 2009
I’ve been given a small task to backup our issue database on daily basis, for which I created a tiny backup file and would like to share with you.
The script below will do the following
- Create MySQL dump of your database using configuration set
- Compress files and MySQL dump into single archive file and copy to destination folder
- It will always create old backup so you always have previous version
- Copy both old and new backups to network shared resourse
REM ----------- START OF CONFIGURATION HERE
REM ----------- END OF CONFIGURATION HERE
%MYSQL_FOLDER%mysqldump.exe -u %MYSQL_DB_USER% -p%MYSQL_DB_PASS% %MYSQL_DB_NAME% >%BACKUP_DB_FILENAME%
ECHO DB Done
rar a %BACKUP_FILENAME% @files.lst > NUL
@del %DESTINATION_FOLDER%%BACKUP_FILENAME_OLD% 2>NUL
@rename %DESTINATION_FOLDER%%BACKUP_FILENAME% %BACKUP_FILENAME_OLD% 2>NUL
copy %BACKUP_FILENAME% %DESTINATION_FOLDER% > NUL
ECHO Files Done
@del %BACKUP_FILENAME% 2>NUL
@del %BACKUP_DB_FILENAME% 2>NUL
ECHO Removing Temporary Files Done
ECHO Accessing Network...
net use %NETWORK_PATH% %NETWORK_PASSWORD% /user:%NETWORK_USERNAME%
copy %DESTINATION_FOLDER%%BACKUP_FILENAME% %NETWORK_PATH% > NUL
copy %DESTINATION_FOLDER%%BACKUP_FILENAME_OLD% %NETWORK_PATH% > NUL
ECHO Network Copy Done
ECHO All Done
To make backup regular I’ve used Cron NT service for Windows because I honestly don’t like Windows Scheduler and always disable it 😉
10 23 * * * cmd /c C:\wamp\backup\backup.bat
Here is the crontab line that suits my needs.
This will backup my stuff every day at 23:10.
That’s pretty much it.