Profile cover photo
Profile photo
Aamir Shahzad
629 followers -
Aamir Shahzad Warraich
Aamir Shahzad Warraich

629 followers
About
Posts

Post has attachment
How to backup every table from a database to separate file by using mysqldump in mysql or mairadb
How to backup all the tables form a database to separete files in mysql or mairadb by using mysqldump The below script can be used to backup all the tables from a database in mysql or mairadb. The script will create a new directory "DatabaseName_Date_T_Time...
Add a comment...

Post has attachment
How to take a backup of single table in MySQL or MairaDB by using mysqldump
How to backup single table in MariaDB by using  mysqldump Often as DBAs have to run delete, update or insert statements on a table, it is always good idea to take the backup of a table before running any DML statements. Below syntax can be used to take the ...
Add a comment...

Post has attachment
How to see create table definition of a table in mySQL or mairaDB
Sometime you need to see the definition of table in Mysql or mairadb to understand the data types which the table is using for different columns to store the data OR you might need to create a new table exactly like the one you have already created, To see ...
Add a comment...

Post has attachment
Create Zip Backup files for each Database by using mysqldump in MySQL or MairaDB
mysqldump is used to take logical backups of database/databases in MairaDB and Mysql. Below script will create a directory with timestamp and then create zip backup file for each database in MySQL or MairaDB. # Provide the user name that you want to use for...
Add a comment...

Post has attachment
How to take backup of specific databases in MySQL or MariaDB
mysqldump is used to take logical backups of database/databases in MairaDB and Mysql. If you would like to exclude some of the databases you can change the query "Select distinct Table_schema from information_Schema.tables" according to your requirement. Le...
Add a comment...

Post has attachment
Take backup of each DB in newly created timestamp directory by using mysqldump for MairaDB /MySQL
mysqldump is used to take logical backups of database/databases in MairaDB and Mysql. In this post we are going to cover the scenario in which you have to write the script that should create a directory by using date time and then take the backup of all the...
Add a comment...

Post has attachment
How to perform backup of a database in MairaDB/MySQL by using mysql dump
mysqldump is used to take logical backup of database/s in MairaDB and MySQL. It works great if the database size is small. If your database size is huge, consider taking hot backups. Let's follow below steps to take the backup of TechBrothers Database. 1) C...
Add a comment...

Post has attachment
How to Apply and Search Labels in TFS 2015 - Team Foundation Server 2015 Tutorial
In this video we will learn following:
1. How to Apply and Search Labels in TFS 2015?
2. Why is it important o apply Labels in TFS 2015?
3. Searching using Labels in TFS 2015
4. Limitations in applying labels in TFS 2015?
5. Applying Labels using Visual S...
Add a comment...

Post has attachment
Work Items Overview in TFS 2015 - Team Foundation Server 2015 Tutorial
In this video we will learn following:
1. Work Items available in TFS 2015?
2. Different types of Team project template overview in TFS 2015?
3. What are the work item types available in Scrum Template of TFS 2015?
4. What are the work Item types available ...
Add a comment...

Post has attachment
How to configure Team Project Collection Report Folder in TFS 2015 - TFS 2015 Tutorial
In this video we will learn following:
1. How to configure Team Project Collection Report Folder in TFS 2015?
2. How to check report folder configuration using TFS 2015 Administration Console?
3. Prerequisites to configure Report Folder in TFS 2015?
4. Ste...
Add a comment...
Wait while more posts are being loaded