Exporting Multiple MySQL Databases

Discussion in 'MySQL' started by Agent_Smith, Feb 5, 2011.

0
  1. #1
    Hello,

    I have to move around 1500 databases form one mysql server to another.

    Just wondering if you can export multiple databases with given names into one file via ssh or an equal method?

    Thanks!
     
    Agent_Smith, Feb 5, 2011 IP
  2. moads

    moads Member

    Messages:
    115
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    28
    #2
    Yes, from SSH it's "mysqldump -u root -p --all-databases > outputfile.sql"
     
    moads, Feb 5, 2011 IP