Databases

Mysql database tutorials and tricks. Errors and fixes with php mysql databases, mysql server configurations and many other good information.


How to do a batch insert in MySQL?

mysql feature

How to do a batch insert in MySQL? In this tutorial, I will present you how to do a batch insert in mysql. Let’s say you want to insert some informations from an array into the database. In order for this to work efficient, you should have more than one information in that array. Why

Disable temporary a foreign key constraint in MySQL

snippets

Disable temporary a foreign key constraint in MySQL Were you in the situation of having a mysql table and wanted to delete some records from it, but you were not allowed due to the constraints of that table? Don’t worry, me too. Or if you use foreign keys in your database tables, you’ll probably have problems

The controller for URI is not callable in symfony

snippets

The controller for URI is not callable in symfony This is a very common error for symfony starters, and it happened to me also when I first tried the framework, so you have to follow two steps in order to debug this: First check First step is to make sure that your controller is actually

How to fix mysql server has gone away error

How to fix mysql server has gone away error

How to fix mysql server has gone away error Today I thought about right something about this particular error which pops up in certain specific cases Mysql server has gone away I’ve seen this a couple of times on some of my clients and they all thought that this issue was a direct cause of

How to set apache server status using mod_status

Apache web server

How to set apache server status using mod_status What is apache server status? Normally only server administrators would have access to this section, they would look at this specific page to lookup more information on their current server activity in an easily readable form. The current information you can view from this page are: The

MongoDB PHP Tutorial

mongodb php tutorial

MongoDB PHP Tutorial I’ve been thinking that a tutorial about using MongoDB with PHP would be needed, a few days ago I went and showed you how to install MongoDB and also to get the php extension for MongoDB installed. So in this article I’m going with a MongoDB php tutorial and trying to get

Mysql server optimization for InnoDB and MyISAM

Mysql server optimization In my other articles I showed you how to install a mysql server on Centos or on Debian / Ubuntu and the process wasn’t that hard right? Well that’s how it should be, installing things on a server is a basic thing really, configuring and optimizing it for your needs its the

Mysql sample configuration for InnoDB 4GB ram

Mysql_real_escape example

This particular mysql sample configuration file is for large server setup with heavy queries, you need at least 4GB ram, specifically for InnoDB only with few connections.

Mysql sample configuration with 512M ram

Mysql_real_escape example

On this page you will find a mysql sample configuration for servers with 512M ram, usually small to medium mysql server setup for medium websites with moderate usage.

Mysql sample configuration for less than 64M

Mysql_real_escape example

Mysql sample configuration file for server configuration with less than 64M ram, usually a small mysql server setup for small websites with less usage.

 

Request an article ←