In an urgent situation another person made a backup of all the databases from my webserver to one *.sql file (MySQL dump). Now I have a ~700 Mb file with about 20 different databases. As I only need one of them to restore at the moment, is there an easy way to select the only part I need (one database)? Of course I can try to simply select the needed text from the *.sql file to perform a query in PHPMyAdmin, but it is not so easy as the file is big.
MySQL – Easy Way to Select One DB Dump from Multiple DB Dumps
dumpMySQLmysqldumprestore
Related Solutions
I think using a MySQL gui tool like SQLyog would solve your problem. It has User manager tool where you can set privilege to different users.
Your same question seems to be answered here:
https://stackoverflow.com/questions/2342356/import-single-database-from-all-databases-dump
And as far as an improved backup script, here's what I'm currently using for several years and it rocks:
Related Question
- Expdp with metadata_only gives way too large dump. Why
- MySQL – Restore Dump Ignoring DROP TABLE Statement
- MySQL – Minimum Permissions Required to Restore MySQL Dump
- MariaDB Performance – Slow MariaDB Load of MySQL Dump
- Mysql – restore a MySQL table from a file (non-sql) backup
- MariaDB/MySQL – How to Import from Dump File Remotely via Network
Best Answer
Take the difference between two 'CREATE DATABASE' using
sedoperationeg
https://stackoverflow.com/questions/2342356/import-single-database-from-all-databases-dump
https://stackoverflow.com/questions/3596444/how-do-i-restore-one-database-from-a-mysqldump-containing-multiple-databases
Restoring a single database from mysql enterprise full backup