Hi
I have a virtual server setup with a remote database in virtualmin. Virtualmin can see and access the database, the all tables and rows, but when I want to backup the database, only first table is in the backup.
Virtualmin is running on Ubuntu 20.04 (MariaDB v. 8) whereas the remote is Ubuntu 18.04 (MySQL version 5.7.31).
If I create a backup directly on the remote database server, through webmin, it is working just fine.
Any idea as what the issue can be?
Content of the backup that failed.
-- MySQL dump 10.13 Distrib 8.0.21, for Linux (x86_64)
--
-- Host: mysql1.xxxxxxx.dk Database: xxxxxxxx_com
-- ------------------------------------------------------
-- Server version 5.7.31-0ubuntu0.18.04.1
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!50503 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `bf_activitylog`
--
DROP TABLE IF EXISTS `bf_activitylog`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `bf_activitylog` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`who` varchar(255) DEFAULT NULL,
`who_id` int(11) DEFAULT NULL,
`what` varchar(255) DEFAULT NULL,
`when` datetime DEFAULT NULL,
`where` varchar(255) DEFAULT NULL,
`where_id` int(11) DEFAULT NULL,
`ip` varchar(20) DEFAULT NULL,
`useragent` varchar(255) DEFAULT NULL,
`meta` text,
`action` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `who` (`who`),
KEY `who_id` (`who_id`),
KEY `when` (`when`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `bf_activitylog`
--
LOCK TABLES `bf_activitylog` WRITE;
/*!40000 ALTER TABLE `bf_activitylog` DISABLE KEYS */;
/*!40000 ALTER TABLE `bf_activitylog` ENABLE KEYS */;
UNLOCK TABLES;