by Joel | Jul 9, 2019 | aws, MySQL
We are going to see how we can migrate an existing database on MySQL / MariaDB to an already running RDS Instance on the AWS. Take the MySQLdump of the needed database. mysqldump -u username -p databasename –single-transaction –quick...
by Joel | Jul 15, 2018 | aws, MySQL
The Amazon RDS ( AWS RDS ) – Managed relational database service from aws is a real blessing these days. Since its managed by aws, you don’t have to worry about the patching / administration / backups / restore aspects of it. All you need to do is upload...
by Joel | Apr 28, 2016 | cPanel/WHM, MySQL
You might want to install the the MySQL native driver for PHP (MySQLnd) over the custom MySQL driver provided with the default EasyApache. To enable this manually, you will need to edit the file : /var/cpanel/easy/apache/rawopts/all_php5 and make sure the following...
by Joel | Oct 23, 2015 | cPanel/WHM, MySQL
For someone who upgraded MySQL from versions 5.0.x to something like 5.5.x, this error might be a familiar one : “Cannot load from mysql.proc. The table is probably corrupted” The database activities would not work as expected and hence you will need to...
by Joel | May 11, 2015 | cPanel/WHM, MySQL
When trying to view the databases from the cPanel interface of an account, you might end up with no values at all. However, if you check the backend, you can find that these database folders consumes space. To fix this issue, SSH to the server and open the file :...
by Joel | Aug 31, 2014 | MySQL
When trying to restart the MySQL service, do you happen to find the following error in the logs ? /usr/sbin/mysqld: Can’t create/write to file ‘/tmp/xx’ (Errcode: 122) date InnoDB: Error: unable to create temporary file; errno: 122 date [ERROR]...