SitePoint Sponsor |
|
User Tag List
Results 1 to 2 of 2
Thread: restore all databases at once
-
May 14, 2002, 12:46 #1
- Join Date
- Dec 2000
- Posts
- 85
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
restore all databases at once
I took backup of all databases at once by using
--all-databases option of mysqldump
I don2t know how to restore all databases because by now, I used to get backup of only one database at once.
Thank you
-
May 16, 2002, 15:32 #2
- Join Date
- Jul 2001
- Location
- Missouri
- Posts
- 3,428
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
this should work
Code:mysql -uuser -ppass < /path/to/dump.sql
- Matt** Ignore old signature for now... **
Dr.BB - Highly optimized to be 2-3x faster than the "Big 3."
"Do not enclose numeric values in quotes -- that is very non-standard and will only work on MySQL." - MattR
Bookmarks