Jason | 21st July 2013
MySQL terminal We are going to create a new database, user and password and grant that user access to the new database. Let’s first login to MySQL in the terminal. 1$ mysql -uadmin -ppassword Hit return and that will log you in, provided your credentials are valid! Note that there is no gap after the […]
Jason | 24th June 2013
MySQL 5.1.69 Modern web applications place a massive load on the database. I’ve been working extensively with Magento lately and the demand on the database is enormous. We could argue all day about which language is easier on the database in terms of access routines and read/write cycles. Ruby (Sinatra)? Regardless of the application’s structure, […]
Jason | 30th November 2012
Mac OS X (10.6.8), CentOS, Linux Do you perform regular database backups? Maybe you take copies of your live database and push that data somewhere else (like, your staging site)? And maybe you’ve accidentally overwritten your live database coz you typed something wrong? Yeah, well I have. And after the second time, I decided to […]
Please fill out the form below and I will reply ASAP. I aim to answer all emails in 48 hours or less.