MySQL snapshots and rollbacks

apnscp supports simple MySQL database snapshots as of August 28, 2016. Snapshots are ideal for preserving your database structure before a software update or any situation in which there is risk of loss of data not covered by the nightly backups. Snapshots perform a full database export and stores this file, uncompressed, in your backup directory. Snapshots…

Database appears in MySQL Manager, but not phpMyAdmin

Overview A MySQL database that appears within the control panel under Databases > MySQL Manager does not show in Databases > phpMyAdmin Cause Read permissions have been revoked on that database from the primary user. Solution Visit Databases > MySQL Manager > Change Mode: List Databases & Users within the control panel. Select the database that does…

Creating a database

Overview Additional MySQL databases, used for storing application data, may be created quickly within the control panel via Databases > MySQL Manager. When a database is created, grants are automatically setup to permit the primary user access to the database. In multi-user environments, you may wish to create a separate user to keep your master password confidential.…

Connecting remotely to MySQL

Overview By default, MySQL permissions only permit same-server access for clients. This protects your database by preventing external access, but also precludes desktop database utilities like Navicat, MySQL Workbench, and Eclipse from managing your database schema. Solution Create a new MySQL user within the control panel under Databases > MySQL Manager. Enter a user under Name Remember:…

Handling table crashes

Overview MySQL, despite its ease of use and popularity has a dark side of instability and crashes. Communities have forked MySQL, now an Oracle subsidiary (that was once a Sun subsidiary…), spawning alternatives like Percona, Drizzle, and MariaDB to improve quality and keep MySQL a viable database server. Newer servers (platform version 4.5+) use alternatives like Percona…