Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2010
    Location
    Orlando, FL
    Posts
    311
    Provided Answers: 1

    Question Unanswered: Recovering Dump On New Server

    I had a MySQL 5.1 server completely crash due to hardware issues. We have a new server and I've installed a new instance of MySQL 5.1 and I have the MySQL dump which was created with the --all-databases switch. My question is can I simply just import that dump to the server including the 'mysql' and 'information_schema' databases w/o destroying the new installation?

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by CarlosinFL View Post
    ... can I simply just import that dump to the server including the 'mysql' and 'information_schema' databases w/o destroying the new installation?
    i would exclude them, i think mysql created them automatically when you installed the new server
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Jan 2012
    Posts
    3

    Recovering Dump On New Server

    You can restore the dumps.
    In Windows : Press windows+R => cmd

    Use the following command to restore the dumps:

    c:\>mysql -u < mysql user > -p< mysql password > -D <database name> < <filename of dump>

    Ex: c:\>mysql -u root -p -D information_schema < mydump.dat

    Check out My Blog

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •