Posted inWordPress

Disable WordPress XCloner Plugin logger in MySQL / phpMyAdmin

If XCloner Logger option is enabled, it will store a log file inside the xcloner-XXXXX folder inside the backup archive. The file is named xcloner-xxxxx.log. This can generate a huge amount of temporary files and log files on your file system. This short article provides you one SQL statement to disable XCloner log directly in your WordPress MySQL database, using phpMyAdmin.
05/01/2021Posted inWordPress
MySQL fix. Image via Flickr by Luis M. Gallardo D
Posted inMySQL

Restore single MySQL table from a full mysqldump backup file

Here are the steps required to restore a single MySQL table from a full mysqldump database backup file on the command-line. If you need to restore a single table from a full MySQL backup, you may find yourself wondering "how do I do that?". There are a few steps required, I outline them here for you to restore the contents of just one table back into the database from the mysqldump using Bash.
21/08/2017Posted inMySQL
Posted inCode base

How to: Test MySQL database connectivity in ASP.NET, PHP, ASP

Test MySQL database connectivity in ASP.NET, PHP, ASP; Simple MySQL connection test from your website with ASP.NET, PHP & classic ASP. Whenever you need a MySQL connectivity test from a website or server, it's handy to have various test scripts nearby. Whether it is because you are setting up a new website or you have just installed a new server and are running your tests.
26/05/2014Posted inCode base
Posted inCode base

Connect to SqlCe (SQL Server Compact) database from ASP

Connect to SQL Server Compacy (SqlCe) database with ASP. Here is how to install the Microsoft.SQLSERVER.CE.OLEDB.4.0 Provider and use classic ASP to connect to an SqlCe (SQL Server Compact) database sdf file, as a Microsoft Access database replacement. For Windows Server IIS. SQL Server Compact (SqlCe), the embedded database engine, is the default database for Visual Studio 2010 SP1 and WebMatrix 3. This means, it's recommended to use SqlCe over Access nowadays.
03/06/2013Posted inCode base