New answers tagged backup-restoration
You can use the --one-database option Ignore statements except those that occur while the default database is the one named on the command line. This option is rudimentary and should be used with care. Statement filtering is based only on USE statements. so mysql -u someone -p somedatabase <all.sql Should work as you want and be reasonably safe ...
Top 50 recent answers are included