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 '17 at 10:35
  • Do you use mysqldump for the backup? Do you do one for each database? – Kusalananda Mar 22 '17 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 – Valentin Bajrami Mar 22 '17 at 10:39
  • @val0x00ff that is a somewhat dangerous operation for an inexperienced user to attempt. – Michael - sqlbot Mar 22 '17 at 11:34
  • @lgeorget its like full_backup.sql – Srinu Dasari Mar 22 '17 at 12:20

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 '18 at 13:25

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.