Editing massive files on Windows
I you need to edit a MySQL dump which is 2.5Gb and you are unfortunately running Windows, I’ve found a…
A bunch of ramblings about PHP programming, JQuery, MySQL and other 'stuff'
I you need to edit a MySQL dump which is 2.5Gb and you are unfortunately running Windows, I’ve found a…
Databases, by their own nature, become large beasts. This is a fact of life and whilst a lot of databases…
We had an odd thing today, whilst performing a apply-db-changes we received the error: You have an error in your…
Have had some serious problems getting this working, but after a 4 hour head bashing session, we’ve cracked it. CREATE…
If you have forgotten your root password for MySQL, then don’t panic. Although, if you don’t have root shell access,…
When you installed MySQL, you would have been asked for a root password. If you were testing or something similar,…
This inbuilt part of MySQL allows you to look closely at queries run – per session. And you can use…
Using mysqldump to back up a database If you want to make a super quick backup of a MySQL database,…
Having MySQL dumping out binary logs is a very good failsafe for backup redundancy. But, how do you get any…
Ever wanted to sort a resultset of data, by value, but I wanted a couple of exceptions to appear at…