I wanted a way to replace the numbered bullets in an ordered list with graphical equivalents. Here’s a succinct solution:
The second alpha version of Bible Reader - version 0.12a - is now available for download and testing. Quite a few small bugs have been squashed and a number of small changes have been made to make the application more useable on a daily basis.
Find out more here
Having got the first ‘release’ out the door, I turned my attention to tidying it up and adding a few more features, to improve the overall browsing experience. I about ready to put the second Alpha out, which will hopefully by much more useable. Watch this space!
The very first alpha version of the new Bible Reader software is now available for testing! Remember it’s not complete, so don’t expect everything to work as it should. You will be able to browse the books of the Bible though. Find out more
I use MySQL all the time when building websites. I have a self-built CMS and a number of clients all running off of the system. Here are a few SQL commands that I use regularly:
> mysqldump --quick -all-databases -uadmin -p > alldatabases.db
Dumps all of the databases to a single file. Along with regular server backups I use this to keep copies of everything for my own reference.
–quick == forces MySQL to retrieve and dump the tables a row at a time rather than buffering. Useful for large tables
–all-databases == self explanatory I hope
-uadmin == username admin
-p == ask for password. My installation needs the password to perform any actions
To dump a single database:
> mysqldump --quick -uadmin-p database_name > filename.db
I personally use .db at the end of my files, but they’re simply text files of INSERT instructions and can be named however you like. From a dumped database, you can import all of that content into a new database:
> mysql -uadmin -p database_name < filename.db
This will fail if for example, the keys for a table already exist in both the database and the import file.
I find this really useful. To search and replace words across a table, in a particular field:
mysql> UPDATE table_name SET field_name=REPLACE(field_name_again,
'look for me','change to me) WHERE..
The WHERE part is optional. Leave out any WHERE filter if you want to apply to all records in the table.
More to come…
After a hectic busy year I’m back into coding once again. I hope to release an early Alpha version very soon, which will demonstrate the basic navigation that’s available in the current 0.99 version.
I’m hoping to get feedback from you if you download the early releases so please post your comments (I would NEVER share your email address) and let me know of bugs and features you might be interested in.