How many times have all you command line warriors out there been working with MySQL and backed up or moved a database with the trusty old mysqldump command? I know I use it all the time. But! What if you want to dump just the schema or structure of the database, and not all the data? Like going from DEV to TEST or PROD for example? You want to get the database setup, but you certainly don’t want all that data.
Category Archives: How To
Add an Open With option to the global context menu
Have you ever wanted to add an option to that ornery right click context menu so you could open whatever file you just clicked on with whatever the heck you please? I know I have, and here is a quick tip to do just that! Whether it’s your favorite text editor, or another app that you want for some reason, you can easily add an Open With option to the context menu by modifying and then importing this registry file.
Ubuntu on a flash drive
How cool is that? I found this article when I was pondering the idea of running Ubuntu inside of Windows. I have Ubuntu on several machines around the lab, but I thought it would be cool to hit an icon and bring up Ubuntu in a window like I have done with DSL (Damn Small Linux). Welp, here I found this article on using QEmu to get Ubuntu running on a USB drive, a USB hard drive in my case. The install went off without a hitch, just like the article spelled out. Try it out and have yourself a Linux inside of Windows fun time too!
How to generate htpasswd compatible passwords with PHP
Sometimes we have to generate passwords in our code, no problem. But what about when you need to generate a password that is compatible with the htpasswd command, as in the password is the same as what would be generated by htpasswd? Well, if you are using PHP, you can use this function that I posted in the forums. Check it out …
Solarum’s Solaris Reference
Good news, there is a new article up in the Library! I have posted a Solaris reference that covers lots of common basic tasks that new system administrators look to do, and us old system administrators lookup to remember how to do! I’ll be adding more and revising as time goes on, so check it out and see what you think. Enjoy!
Creating MySQL database tables
A while back I posted an article on creating MySQL databases from the command line (see here). I am a command line junkie, and usually prefer it to a GUI. I thought I would add to that last database post by sharing how I work with MySQL, designing databases and their structure in the initial phases of application development. Keep in mind, what I am going to go over in this post is strictly for quick and easy database structure design, possibly with test data, from the command line. This is not for mangling your database after you have real data in it, or else you will mangle your data! Continue reading