Skip to main content

Exclude or Include table(s) during creating backup from MySQL

 To exclude tables when you are creating database backup from MySQL, execute below query.

mysqldump -u root -p<Password> DATABASENAME --ignore-table=DATABASENAME.TABLENAME > BACKUPFILENAME.sql


 To include tables when you are creating database backup from MySQL, execute below query.

mysqldump -u root -p<Password> DATABASENAME TABLENAME1 TABLENAME2 > BACKUPFILENAME.sql

Take note that there is no whitespace between -p and the password..

Labels:

Comments

Post a Comment

Popular posts from this blog

T-SQL to set Max memory in MSSQL

 To set max memory for Microsoft SQL server, use the below Transact SQL. USE master EXEC sp_configure ''show advanced options'', 1 RECONFIGURE WITH OVERRIDE GO --To set a maximum memory limit, type the following, pressing Enter after each line: USE master EXEC sp_configure ''max server memory (MB)'', <MaxServerMemory> RECONFIGURE WITH OVERRIDE GO --MaxServerMemory is the value of the physical memory in megabytes (MB) that you want to allocate. --To hide the maximum memory setting, type the following, pressing Enter after each line: USE master EXEC sp_configure ''show advanced options'', 0 RECONFIGURE WITH OVERRIDE GO exit
Post a Comment
Read more

Get all constraints in Oracle

 To get all the constraints created in Oracle database, use below query.              SELECT * FROM USER_CONSTRAINTS; If you want to get the constraints  created for a particular user then use below SQL query.              SELECT   *   FROM  USER_CONSTRAINTS where owner = 'userName';
1 comment
Read more