mysqldump option: --all-databases vs --all-tablespaces

Follow

testjetco

• December 18, 2018 02:06

What is the difference between using --all-databases and --all-tablespaces when using mysqldump command to back up MariaDB/mysql db?  For me, they are the same, aren't they?

0

• 

  Vishal Kasle

  • December 18, 2018 03:55

  Hello,

         The options of mysql dump that you have mentioned have different uses and are not the same. The --all-databases option as you can see from the following references:

  https://mariadb.com/kb/en/library/mysqldump/#options
  https://dev.mysql.com/doc/refman/8.0/en/mysqldump.html#option_mysqldump_all-databases

  will dump all the databases in the instance with the create database statements for each database.

  Whereas in mariadb the --all-tablespaces will dump all the table spaces of the instance. 

  Unlike MariaDB in Mysql the --all-tablespaces will dump any sql statements which are required to create tablespaces specifically for NDB tables. 

  For more information check:

  https://dev.mysql.com/doc/refman/8.0/en/mysqldump.html#mysqldump-ddl-options
  https://mariadb.com/kb/en/library/mysqldump/#options

   

  Regards,

  Vishal 

  0

  Comment actions Permalink
• 

  testjetco

  • December 18, 2018 08:40

  If I specify --all-databases, will all the tablespaces be backed up?

  0

  Comment actions Permalink
• 

  testjetco

  • December 21, 2018 02:06

  From the URL: https://mariadb.com/kb/en/library/create-tablespace/

  it said...

  "The CREATE TABLESPACE command is not supported in MariaDB. It is only used in MySQL Cluster and in MySQL InnoDB 5.7."

  Does it mean the CREATE TABLESPACE statement is not valid in MariaDB?  So when defining '--all-tablespaces' with mariabackup, will there be no effect?

  0

  Comment actions Permalink

Please sign in to leave a comment.