I have a managed server with only one MySql database. So the only way to differentiate tables is to prefix them with the name of the application that is accessing them. For instance all of my PHPbb files are prefixed with phpbb3_.
How can I backup only the phpbb3_ tables without having to list each one. There are a bunch of them. I tried the wildcard approach and it didn't work.
mysqldump -h hostName -u userName -p databaseName phpbb3_* > backupFileName.sql
got this error:
mysqldump: Couldn't find table: "phpbb3_*"
Is there another way? Maybe piping a mysql command or something.
Any help appreciated.