MySQL insert or update – one of the most common problems when it comes to database. We want to check if the record exists in the database, if not we want to update it. Let’s take statistics example. We would like to insert IP Address if it’s not in database or update view’s count if […]
Hi guys! Today I would like to tell you a bit more about MySQL query logging. It’s very useful to preview all queries that goes to your database. Sometimes you don’t have to access to direct query that is generated by ORM, but you have to check what’s going on? Not a problem. Enable logging […]
I want to present you very useful tool, which not every developer uses: mysqldump – application for database backups. It’s very useful tool when you want to export (backup) your database. Of course you can use well known phpMyAdmin, but when it comes to export very large database it becomes pretty useless (long export time, […]