We help IT Professionals succeed at work.
Get Started

Restore Of MySQL/MariaDB using MySQLDump does not work

G F asked
Last Modified: 2020-03-01

I'm running MariaDB with HeidiSQL management software, and I want to move my databases to another system, using the same version of MariaDB and Heidi.

I'm using mysqldump to copy the database, and using this command:

C:\Program Files\MariaDB 10.4\bin>mysqldump -u root -p bbb > d:\database\bds2.sql

However when I want to restore, it seems to work okay, the command runs, but when I check Heidi, the tables are not there.  I use this command to restore:

C:\Program Files\MariaDB 10.4\bin>mysqldump -u root -p bbb < d:\database\bds2.sql

The database on the target system has a database named bbb, though a different pw than the original host.
I've restarted the mariadb service and the Heidi software, just in case there was a glitch but there is nothing.

My development system was Windows 10 and the target system is Windows 7.

The size of the backup file is about 27Kb, and in Heidi the empty tables are about 450Kb.

The Mysqldump restore does have an output when run, like a Header with information like the Host and DB server and Maria version number, then it has a couple dozen lines about 'SET'.  It doesn't say anything other than that.

Am I missing something on the backup and restore?  Should I use something different?

Thank you in advance!
Watch Question
Software Engineer
Distinguished Expert 2019
This problem has been solved!
Unlock 1 Answer and 3 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant

An Experts Exchange subscription includes unlimited access to online courses.

Get Started
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE