Knowledgebase

Introduction If you are configuring backups of a server, you need to know what data to back up....

This is an advanced tutorial. It can sometimes be useful to enable remote connections to MySQL....

Introduction Normally, you access each MySQL database using a separate database user. In some...

Introduction MySQL provides a command line utility, mysqldump, for exporting databases as raw...

If you forgot your database password, it's easy to reset it in ServerPilot. First, open your app...

Many PHP apps require a MySQL database to function, and these databases can be created quickly in...

If your app was written for older versions of MySQL and is not compatible with strict SQL mode in...

There are two ways to export a database with phpMyAdmin depending on the version installed on...

If you're not familiar with using SSH, it's easier to export a database using Adminer. However,...

Adminer is an alternative to phpMyAdmin that runs as a single PHP file to manage your apps'...

In this tutorial, we'll show you how to install phpMyAdmin. This tutorial assumes you have...

One copy of phpMyAdmin installed on a single app on your server will allow you to access all of...

Adminer is an alternative to phpMyAdmin that runs as a single PHP file to manage your apps'...

This is an advanced tutorial. Introduction For applications you are building where you've...

Don't upgrade unless you need to! Database upgrades are risky. If something goes wrong during...

Introduction MySQL is a database server that your apps such as WordPress use to store data. In...