I have all MySQL databases backup dump file (50 Databases) with in a server, and i want to restore a single database from this dump file.Is that possible? Any suggestions? Thanks in Advance

  • It mostly depends on the format of your backup. What does your backup look like?
    – lgeorget
    Mar 22, 2017 at 10:35
  • Do you use mysqldump for the backup? Do you do one for each database?
    – Kusalananda
    Mar 22, 2017 at 10:36
  • 1
    Assuming you've used mysqldump with the option --all-databases then you can import a single database using mysql -u root -p --one-database My_DB_NAME < all_databases_dump.sql Mar 22, 2017 at 10:39
  • @val0x00ff that is a somewhat dangerous operation for an inexperienced user to attempt. Mar 22, 2017 at 11:34
  • @lgeorget its like full_backup.sql Mar 22, 2017 at 12:20

1 Answer 1


Yes Just copy your full-backu.sql into C:\xampp\mysql\bin then open cmd.exe (command prompet ) with administrator account then run : cd c:\xampp\mysql\bin mysql.exe -u root -p --one-database destdbname < full-backu.sql


  • This seems to be a windows solution.
    – jesse_b
    May 26, 2018 at 13:25

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .