Aug 4, 2016 | PHP/MySQL Database
We will gradually replace MySQL database with MariaDB database. According to Wikipedia MariaDB is a community-developed fork of the MySQL relational database management system intended to remain free under the GNU GPL. It is notable for being led by the original...
Aug 23, 2014 | PHP/MySQL Database
In a few circumstance, customers may be using a Remote MySQL database (for legacy support or other reason). Customer may login to (remote) phpMyAdmin, Issue the following SQL to get the current logged-in username – SELECT CURRENT_USER(); Issue the following SQL...
May 28, 2014 | PHP/MySQL Database, Web Application, Web Hosting
Please refer to the following sample code. <?php # ###################################################################### # ######## MySQL Database Username, Password, and Database Name ######## #...
May 27, 2014 | DirectAdmin Control Panel, Web Application, Web Hosting, Website Builder
In general, you may import database backup via phpMyAdmin. However, in a rare circumstance, your database backup is large, and cannot import via phpMyAdmin. If so, you may use the following way to import it. Upload your MySQL dump output file onto the server Create a...
May 27, 2014 | Web Application, Web Hosting, Website Builder
Some loyal customer may find the MySQL database version is 4.0.27 (but not MySQL 5.x) From our past test upgrade experience, if we directly in-place upgrade the MySQL , as MySQL 4.0 uses 1 collation – Latin1 – to store data, whereas 4.1 (or above) contains...