If you have a configured mysql dumps to be prepared regularly via cronjob
and you happen to experience crash or lost of data and need to restore only a certain
database from a whole bunch of MySQL data SCRIPT file letes say mysql-fulldump.sql, you might be wondering how.
Here is how:
# sed -n '/^-- Current Database: `DATABASE_NAME`/,/^-- Current Database: `/p' mysql-fulldump.sql > DATABASE_NAME.sql
Change DATABASE_NAME with whatever your required database name is.
mysql-fulldump.sql – is the name of whole database file dump file
DATABASE_NAME.sql – will contain the extracted database from complete SQL dump.
TThat's all, now import new dump to MySQL and Enjoy 🙂
If you're new here, you may want to subscribe to my RSS feed. Thanks for visiting!
Hey long time now see, thanks for dropping back again! 🙂
More helpful Articles
- Make MySQL existing users to have access from any or particular host after SQL migration
- Allowing MySQL users access from all hosts – Fixing mysql ERROR 1045 (28000): Access denied for user ‘root’@’remote-admin.com’ (using password: YES)
- List and get rid of obsolete program core dump files and completely disable core files on FreeBSD
- How to auto restart CentOS Linux server with software watchdog (softdog) to reduce server downtime
- How to enable AUTO fsck (ext3, ext4, reiserfs, LVM filesystems) checking on Linux boot through /etc/fstab
- How to check and repair broken MySQL ISAM tables
- Reboot Safely a frozen (hanged up) Linux Server with Magic SysRQ Key combination
- How to list and exclude table names from a database in MySQL (exclude table names from an show tables in MySQL) by using information_schema
- Installing the phpbb forum on Debian (Squeeze/Sid) Linux
- How to dump table from a selected database in MySQL
- How to automatically reboot (restart) Debian GNU Lenny / Squeeze Linux on kernel panic, some general CPU overload or system crash
- Optimize, check and repair tables in MySQL, howto improve work with tables in MySQL
- Few MySQL helpful commands in MySQL maintenance (MySQL rename Table, Empty MySQL Table Contents / Null Table records, Get info about variables in a Table, Change record in existing MySQL table, Get MySQL table privileges info, Some basic commands for MySQL issues debugging)
- 7th of July The Feast of Saint Nedelya Kyriakia one of the most honored woman saints in Bulgarian Orthodox Church and few words of the history of Sofia Second biggest Cathedral Church St. Nedelya
Download PDF
Tags: crash, database name, mysql database, script file
This entry was posted on Tuesday, February 12th, 2013 at 11:41 pm and is filed under MySQL, System Administration, Web and CMS. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.