Themes

1 0

How to restore a database from backup?

Within the administration, the user can restore the entire database directly to the DB server, or download a dump of the selected backup to the _sql…

3 0

How to restore web hosting from backup?

Within the administration, the user can restore the webhosting directly from the WH edit area, where you can browse the backup content and choose to…

1 0

How to connect to database (phpMyAdmin, phpPgAdmin, adminer)

Mainly 3 tools are used for database management, phpMyAdmin, phpPgAdmin and adminer. We will show you how to connect to the database using these two…

11 0

How to install MySQL server 5.5.62 on Debian, Ubuntu

This tutorial also works on other versions of MySQL server in branch 5.5.x. Uninstall any existing version of MySQL sudo rm /var/lib/mysql/ -R …

11 0

Import MySQL database using SSH

Tutorial assumes that you already have your .sql file on the server. If you haven't uploaded it yet, you can do so via sftp: sftp server-ip@host get…

20 0

Export and import MySQL database

Are you moving your websites, web application, or creating a backup and need to create a copy of the original database? Exporting or copying data…

-6 0

Nginx, MySQL, PHP installation - Debian 9

LEMP is a software bundle used to provide dynamic web pages and web applications. LEMP stands for a Linux operating system with an Nginx web server,…

9 0

Creating a database in ISPConfig

We will add a database for our domain, as we did it here. Creating a Database User To add a database, first, we need to create a database user. In…

4 0

Using an admin on web hosting

An alternative option for managing a MySQL database is the free tool Adminer, which has a simple and clear interface, functional features, and a…

15 0

MySQL Installation and Operation Basic Instructions

MySQL is an open-source database server that follows the relational database model and was created by the Swedish company MySQL AB, now owned by…

3 0

A trick to delete a large MySQL table in InnoDB

Truncating large tables, with millions of rows, in InnoDB can be very tedious. Fortunately, there is a little trick to speed up the process. This…

30 0

How to install MySQL server 5.6 or 5.7 on Debian 7 and 8

Debian provides MySQL server 5.5 with both wheezy and jessie but the latest GA (Generally Available) releases are 5.6 and 5.7 with some enhancements…

21 0

How to backup multiple MySQL or MariaDB databases automatically

We'll show you how to back up MySQL or MariaDB, which are on the same server, using your own bash script and cron. Database Backup(s) We'll assume…