List:General Discussion« Previous MessageNext Message »
From:Chris Tate-Davies Date:September 15 2011 8:31am
Subject:Re: Questions about Mysqldump
View as plain text  


When restoring a mysqldump you have the option of which database to restore.

mysql database1 < backup.sql


You might be able to use the --ignore-table command. I'm not sure if 
this would work

mysqldump --all-databases -q  --single-transaction 
--ignore-table=databasetoignore.* | gzip > 


The docs are here for mysqldump, might be worth a read:

HTH, Chris

On 15/09/11 06:29, Adarsh Sharma wrote:
> Dear all,
> Today i backup my all databases (25) by using the below command :-
> mysqldump --all-databases -q  --single-transaction | gzip > 
> /media/disk-1/Server11_MysqlBackup_15September2011/mysql_15sep2011backup.sql.gz
> Now I have some doubts or problems that I need to handle in future :
> 1. Is there any option in restore command ( I use mysql < backup.sql 
> )  to store only specific 1 or 2 databases out of this big backup file.
> 2. While taking mysqldump of all databases , is there any way to leave 
> specific databases , I know there is --databases option , but we have 
> to name other 23 databases then.
> 3. What are the settings that are need to changed in my.cnf to make 
> backup & restore faster.
> Thanks


*Chris Tate-Davies*

*Software Development*
Inflight Productions Ltd
Telephone: 01295 269 680
15 Stukeley Street | London | WC2B 5LT
*Web:* <>


Registered Office: 15 Stukeley Street, London WC2B 5LT, England.
Registered in England number 1421223

This message is for the designated recipient only and may contain privileged, proprietary,
or otherwise private information. If you have received it in error, please notify the
sender immediately and delete the original. Any other use of the email by you is
prohibited. Please note that the information provided in this e-mail is in any case not
legally binding; all committing statements require legally binding signatures.

Questions about MysqldumpAdarsh Sharma15 Sep
  • Re: Questions about MysqldumpChris Tate-Davies15 Sep
    • Re: Questions about MysqldumpCarsten Pedersen15 Sep
      • Re: Questions about MysqldumpAnanda Kumar15 Sep