I just installed mariaDB on an ubuntu box using the command:

 sudo apt-get install mariadb-server

per the documentation found here: How to install MariaDB?

I have a .sql file that was created on a mysql database server using the command:

mysqldump -u root -p"password" --all-databases > "/var/backups/dbs_$(date +'%Y-%m-%d_%H-%M-%S').sql"

Can I just use the sql file as is to import somehow into mariaDB? Reason I ask is that I see inside the sql file that there's references to the engine type, like this:

ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Column privileges';

Should I just be able run the sql file from the command line?

  • Yes, basically MySQL = MariaDB.
    – Rinzwind
    Commented Jul 9, 2015 at 20:14

1 Answer 1


You can import the file because MariaDB supports the MyISAM storage engine: https://mariadb.com/kb/en/mariadb/myisam-storage-engine/

You get the list of all supported storage engines by invoking SHOW ENGINES: https://mariadb.com/kb/en/mariadb/show-engines/

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .