On Sat, 2003-08-30 at 05:33, Michelle wrote: Not really FreeBSD specific..but.. :)
Advertising
> I ran mysqldump -A > backup-file.sql and then upgraded the mysql port, > but now when I try to restore the backups using mysql "database name" > < backup-file.sql, It states unknown database. I also have a > mysqlhotcopy backup of all my databases. Am I doing something wrong > when trying to recover multiple databases? How can I recover them from > the mysqlhotcopy rather then the dump if something went wrong with the > dump? mysqldump -A will save all databases, so when restoring you only need: mysql < backup-file.sql not: mysql "database name" < backup-file.sql This will try to restore only one database (which you need to create first). This ways is only needed if you do a mysqldump "databasename" > backup.sql. -- "Optimized, readable, on time; Pick any two." FreeBSD 5.1-CURRENT i386 11:45PM up 1 day, 1:43, 4 users, load averages: 1.33, 1.47, 1.41
signature.asc
Description: This is a digitally signed message part
