473,397 Members | 2,056 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,397 software developers and data experts.

How to exclude database from dump command while dumping all databases ?

Hi,

I'm using the following command to backup all databases creation only:

mysqldump -u username --password=password --host=host --port=port --all-databases --no-data > D:\all_databases_creation.sql

and I'd like to exclude specific database from those all databases.
Is there any option like --ignore-table but to ignore database ? can I do something like that?

Any suggestions will be appreciated ...
Sep 8 '10 #1
1 1918
JKing
1,206 Expert 1GB
There is currently no mysql functionality to exlucde databases from a dump. What you can do is use the --databases option to include only specific databases.

If you have a large number of databases this may not be ideal but it will work. Another option would be to seek out a third party program that extends mysql functionality.
Sep 8 '10 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: Nabhonil Sinha | last post by:
hi, There is facility to do backup of the database. I can use that facility to backup the database. But before i do a backup i want to check if the disk space available enough to backup that...
2
by: Herbert | last post by:
Hallo colleques, I get during the following error message "SQL1035N No database manager command was issued. SQLSTATE=57019", when issuing the following command on the Command Line Processor:...
3
by: alan_sec | last post by:
Hi everybody, i need some help please. I have installed DB2 UDB 7.2 on Windows and created database and it worked fine (i could access it from control centar nad using eclipse plug-in...
2
by: David Garamond | last post by:
All of my non-superusers are restricted from creating databases. Whenever I upgrade Postgres, I have to hand-edit my dump and change: CREATE USER usr1 WITH SYSID 101 PASSWORD '...' NOCREATEDB...
3
by: Noodle | last post by:
Hi, I want to dump out a database to the screen using mysqldump, like so... <?php echo system('mysqldump -h localhost -u user -p password my_database'); ?> However, it won't accept my...
1
by: pobnospam | last post by:
I am working with several different departmnets on an accounting database I created. It has been in use by one department for several years to track reconciliations. Now several other departments...
2
by: anujs | last post by:
Hi members, Please let me know how to solve the problem while initializing the DB2. the message is - IBM] SQL1032N No start database manager command was issued. SQLSTATE=57019.
0
by: kally | last post by:
Hi, I tried to do ML_upgradation for aix server...but when db2 guys tried to start the service its ending up with error...i have pasted the error below..could anybody suggest me on this..pls ...
3
by: pawanez4u | last post by:
Hi All, I am a PHP programmer, i am using XAMPP software for programming and Mysal as a Database. I want to use my MySql database from command prompt. Help me how to connect,create databases in...
1
by: rohanmehta123 | last post by:
Hi, I have a MS SQL database backup file kept at location "c:\backup_20Aug08.bak". I want to restore the database through command prompt. I am going to create batch file out of these dos...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.