Comments - Restoring MariaDB Backu

You don't give enough details to be useful, but a few things:

• You have the restore and backup commands backwards. mysqldump is used to backup, and mysql to restore.
• Does the file produced by mysqldump contain the correct data? View the sql file to see. If not, you need to find why not. If it does, you need to look what's happening in mysql when restoring. Examine the error logs and see what you can find.
• Are you restoring on the same server/version?

Even restored the Linux same backup on windows machine and restored successfully and table have data , but donot know the reason tables shows empty while restoring on backup server.

Thanks

You need to look into the error log and see what's causing it to fail.

Restoring Backup on Backup server,

PROD Server Version : DB : Server version: 10.1.48-MariaDB MariaDB Server BACKUP Server Version : DB : Server version: 10.9.3-MariaDB-log MariaDB Server

Thanks

Thanks for your repose, Please see below server info and command i am using at both end, backup restored successfully but tables showing empty

########### PRODUCTION-SERVER OS: CentOS Linux release 7.9.2009 (Core) DB : Server version: 10.1.48-MariaDB MariaDB Server Backup : mysqldump -ubackup_admin -pOracle123 smart > /opt/mysql_backup/smart.sql

########### BACKUP-SERVER OS: CentOS Linux release 7.6.1810 (Core) DB: Server version: 10.9.3-MariaDB-log MariaDB Server Restore : mysql -u root -p -D smart < /opt2/mysql_backup/smart.sql

Thanks