Get solutions under one roof
MySQL and MariaDB support strict modes that allow the controlling and handling of invalid or missing values in data-changing queries. This has the following statements INSERT, UPDATE, and CREATE TABLE. When strict mode is enabled in MySQL then invalid or missing data may cause warnings or errors when trying to move the query. When strict mode is disabled, a similar […]
» Read more
To Create a MySQL Database MySQL is an open-source relational database management system. It is one of the best RDBMS being used for developing web-based software applications. You have access to root user, you can easy create any database using mysql. In this article will give you how you can easily create a new database from your cPanel. Follow the steps and create […]
» Read more
To uninstall MySQL Governor. Run the following command to uninstall MySQL Governor: /usr/share/lve/dbgovernor/install-mysql.py –delete yum erase db-governor db-governor-mysql
» Read more
Installing LAMP (Linux, Apache, MySQL and PHP) On Linux Mint. LAMP stands for Linux, Apache, MySQL, PHP. How to install Linux the L of LAMP. Install Apache To start off we will install Apache. 1) Open up the Terminal (Applications > Accessories > Terminal) 2) Copy/Paste the following line of code into Terminal and then press enter sudo apt-get install […]
» Read moreIf you are getting error like Can’t create new tempfile: ‘tablesname.TMD file error while repairing corrupted database tables please try use following command to fix it. Solution : You need to just run below command on the shell. # myisamchk -r -f tables.MYI Thats all.
» Read more