for years I've been using mysqldump without much trouble. Recently I joined a project that is using "MySQL dump 10.14 Distrib 5.5.52-MariaDB, for Linux (x86_64)" and when I attempt to do a dump it includes all of the create table statements, and the routines if I include --routines, but it doesn't contain any of the data. There are no INSERT statements in the file at all.
I've tried on multiple databases within this DBMS instance, and I've tried using several different user accounts, including root. I've checked that the users I'm using have access to the data, and if I log directly into mysql from those usernames I can browse the data.
I've been unable to find any help information on the web because all posts seem to assume that the insert data will just be there (which I think it right). Has anyone seen something like this before or is there a suggestion of what I might try to get a real database backup?
I recognize this is a very old MariaDB version, I'm new to the team and I'm willing to update it, but not until after I know the data is successfully backed up somewhere.
Thanks in advance for your help, this is really confusing me.
Here's what I'm trying:
/usr/bin/mysqldump -u root -p --all-databases > dbbackup-dump-$(date +\%Y-\%m-\%d).sql /usr/bin/mysqldump -u root -p -d databasename > dbbackup-dump-$(date +\%Y-\%m-\%d).sql