search

beauraines / server_backup

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

MySQLdump errors not caught #6

Open beauraines opened 9 years ago

beauraines commented 9 years ago

MySQLdump errors not caught by error checking script

mysqldump: Got error: 1049: Unknown database 'scdda@002dprod' when selecting the database
beauraines commented 9 years ago

Needs to remove the SQL table results formatting

mysql -uroot -p -e 'select  schema_name from information_schema.schemata;'
beauraines commented 9 years ago

Without column headers and pretty tables

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