InnoDB is a storage engine used by MySQL. It supports commit, rollback and crash-recovery capabilities to protect user data. Very large database are configured on InnoDB due to its maximum efficiency. To maintain data integrity, InnoDB also supports FOREIGN KEY referential-integrity constraints. You can freely mix InnoDB tables with tables from other MySQL storage engines, [...]
Today I’m going to give a little tutorial on how to install LAMP on Ubuntu. I know install LAMP on a Linux box is really elementary, but I have to be honest, the first time I get to play with a Linux box, I have no idea how to use the command. I don’t know [...]
There are situations that require us to reset the mysql root password. Checkout the steps mentioned below. 1. First of all stop the mysql process. # /etc/init.d/mysqld stop 2. Start mysql in safe mode # /usr/bin/mysqld_safe –user=root –skip-grant-tables –skip-networking & Once this command is given, mysql will be running in the background in safe mode. [...]
Hey there, This morning I wanted to give back some valuable information not only the PHP community, however, developers in general. Having stated that, today’s topic is PHP Code Optimization. First and foremost, a common problem I see in PHP coding is the usage/implementation of MySQL. For example, when inserting data into the database some [...]
Dynamic DNS services can be very useful for sites or servers with dynamic IP addresses. Most residential Internet providers will only provide you with a dynamic IP address, making it quite difficult to manage systems remotely. This problem can be remedied with the use of Dynamic DNS where a software client updates the DNS server [...]
