10 posts
The MySQL or MariaDB Event Scheduler is enabled on Windows and Linux shared servers. Create custom scheduled events using phpMyAdmin or Navicat. Includes explanations, SQL snippets, setup steps, and troubleshooting for effective database automation.
MySQL backups from Database Vault are SQL text files with CREATE and INSERT statements. Restore them using the command line, phpMyAdmin, or MySQL Workbench. This guide details prerequisites, exact commands, step-by-step processes for each tool, common errors, and verification steps to recover your d
Database Vault uses the official mysqldump command line utility to create MySQL database backups. It requires the full path to the mysqldump executable, typically located in the MySQL bin directory. The system also supports backups of remote MySQL servers even without a local MySQL installation on t
Database Vault supports Microsoft SQL Server 2014, 2012, 2008 R2 and Oracle MySQL 5.6.x, 5.7.x. These versions have been fully validated for compatibility. This guide details the supported platforms, explains why using validated versions matters for security and stability, provides queries to check
All ASPnix Microsoft SQL Server and MySQL servers support encrypted SSL connections to secure data in transit. Your client, driver, or application must also support encryption. This guide covers configuration for SSMS, Navicat, our management tools, and code examples for ASP.NET, .NET, and PHP devel
Learn to connect to your MySQL database using code samples for PHP (mysql, mysqli procedural, OO, PDO), Perl with DBI, C# and VB.NET with MySQL Connector, and Classic ASP with MyODBC. Basic examples expanded with context, prerequisites, and best practices for robust implementation.
Our Windows services offer MySQL 5.7 and Linux services offer MariaDB 10.1, with MariaDB comparable to MySQL 5.6 for core compatibility. Supported on web hosting plans and as a Hyper-V add-on. This guide explains the details, provides code samples for connections, and outlines key considerations for
Yes, ASPnix offers web-based tools like phpMyAdmin (https://pma.anaxanet.com) for MySQL and MyLittleAdmin (https://mla.anaxanet.com) / MyLittleBackup (https://mlb.anaxanet.com) for SQL Server. Use them to manage tables, run queries, backup and restore databases without local software. This guide det
ASPnix does not block remote connections to shared MySQL and SQL Server databases. Connect and manage them using tools like Navicat, SSMS, phpMyAdmin, and MySQL Query Browser. This guide details supported applications, connection steps, permission boundaries on shared hosting, common pitfalls, and p
Remote connections to MySQL are enabled by default on Windows shared hosting with no extra configuration required. For Linux MariaDB, use cPanel to add an allow entry for your IP. This guide covers prerequisites, connection examples in command line and .NET code, step-by-step cPanel setup, common er