or u can use "for loop", have only the database to be exported and use that variable in --database and do mysqldump of each database.
On Thu, Sep 15, 2011 at 6:27 PM, Carsten Pedersen <cars...@bitbybit.dk>wrote: > On 15-09-2011 10:31, Chris Tate-Davies wrote: > >> Adarsh, >> >> 1) >> >> When restoring a mysqldump you have the option of which database to >> restore. >> >> mysql database1 < backup.sql >> > > Admittedly, it's been a few years since I last used mysqldump, but I > suspect that it will contain USE commands - as such, it will restore to > whatever database data was dumped from. > > You'll want to have "--one-database" on the cmd line too. > > > >> 2) >> >> 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 > >> /media/disk-1/Server11_**MysqlBackup_15September2011/** >> mysql_15sep2011backup.sql.gz >> > > or create a short script that asks mysql> for all databases, greps away > those you don't want to dump, and runs mysqldump on the rest. > > / Carsten > > > >> 3) >> >> The docs are here for mysqldump, might be worth a read: >> >> http://dev.mysql.com/doc/**refman/5.1/en/mysqldump.html<http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html> >> >> >> 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 >>> >>> >>> >> > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/mysql?**unsub=anan...@gmail.com<http://lists.mysql.com/mysql?unsub=anan...@gmail.com> > >