Do I need tablespaces for routine WordPress database dumps?

Viewing 3 replies - 1 through 3 (of 3 total)
  • Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    4 years, 5 months ago

    On my MariaDB system, I get the same dump whether or not I use that option.

    [sdstern@sds-desk download]$ mysqldump -u root -p --no-tablespaces wplocal > wplocal.sql.notab
Enter password: 
[sdstern@sds-desk download]$ mysqldump -u root -p  wplocal > wplocal.sql
Enter password: 
[sdstern@sds-desk download]$ diff wplocal.sql wplocal.sql.notab 
410c410
< -- Dump completed on 2021-12-02 11:00:15
---
> -- Dump completed on 2021-12-02 11:00:00
    Thread Starter wyclef

    (@wyclef)

    4 years, 5 months ago

    I was getting the following error but it didn’t seem to be impacted the DB as far as I could tell either.

    Access denied; you need (at least one of) the PROCESS privilege(s) for this operation' when trying to dump tablespaces

    So should I go with it is not a problem to not include tablespaces in a routine DB dump?

    • This reply was modified 4 years, 5 months ago by wyclef.
    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    4 years, 5 months ago

    It shouldn’t be a problem for WP databases.

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Do I need tablespaces for routine WordPress database dumps?’ is closed to new replies.