search

beauraines / server_backup

Scripts to backup ubuntu servers which include subversion repositories, MySQL databases, websites and minecraft.
2 stars 0 forks source link

MySQL databases with special characters in names not exported #7

Closed beauraines closed 9 years ago

beauraines commented 9 years ago

If a SQL database has "special" characters in the name the db file name is different. Therefore using the find command to come up with the list of databases isn't a good idea.

Need to use MySQL to give the correct schema names.

mysql -uroot -p -BNe 'select  schema_name from information_schema.schemata;'