problems with directadmin systems backups

[freakie]

a customer made this database: hfg_pkm-prod

we use the directadmin systembackup to make backups

the database is 1.2GB and the databasedump only contains this:


-- MySQL dump 10.15 Distrib 10.0.38-MariaDB, for Linux (x86_64)
--
-- Host: localhost Database: hfg_pkm@002dprod
-- ------------------------------------------------------
-- Server version 10.0.38-MariaDB

/*!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 */;
/*!40101 SET NAMES utf8 */;
/*!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 */;

Does anyone have clue how to fix this other then creating a database without the minus sign?

 

[floyd]

What happens when you try to dump the database from the command line?

 

[freakie]

i have started to backup the mysql databases using my own scripts and they work just fine. so normal mysqldumps work fine.

i have already disabled mysql in the sytem backups

so directadmin is the problem here, bu i would like to know why.

 

[Active8]

Maybe the size of the database is the problem, we never have problems with restoring sites or databases
I must admit all of the databases where under 200 mb

 

[floyd]

If you want to know why:

Host: localhost Database: hfg_pkm@002dprod

DA is changing the - to 002d. DA uses Unicode encoding. A dash is represented by 002d. I can see that in the sql file. https://www.fileformat.info/info/unicode/char/2d/index.htm

On a side note system backup is not recommended since there is not way to do an automatic restore. Admin Backup/Transfer is what is recommended now since it does have a restore function.