Data Days: November 12-14, 2024 | Pre-Register Now! →

KB Category: Database

Truncate and Drop Database

Kailash Chander June 15, 2026 No Comments

Truncate Database Select Database -> More Database Operations -> Truncate Database (Shift+Del) to truncate (make the tables empty) all the tables of a database (however, the Tables and other objects (Stored Procedures, Views…

Transactions

Kailash Chander June 15, 2026 No Comments

SQLyog provides GUI controls for executing transactional command. The controls available are a menu category and 3 buttons for executing most common transactional commands. Set Autocommit: If it is checked…

Database Schema

Kailash Chander June 15, 2026 No Comments

Select Database -> Create Schema For Database in HTML (Ctrl+Shift+Alt+S). This is useful for documentation of database as you may print the schema nicely with appropriate page breaks, formatting etc. Select the…

Empty Database

Kailash Chander June 15, 2026 No Comments

Select Database -> More Database Operations -> Empty Database to drop all the tables and other type of objects (Stored Procedures, Views etc.) of a Database. However the Database itself is not…

Execute SQL Script

Kailash Chander June 15, 2026 No Comments

SQLyog allows you to execute a batch file of any size (yes….any size – limited by the OS) created using mysqldump or SQLyog’s Export Database As Batch Script option. Select Tools…

Backup Database as SQL Dump (Batch Scripts)

Kailash Chander June 15, 2026 No Comments

You can dump a database for backup or for transferring the data to another SQL server (not necessarily a MySQL server). The dump will contain SQL statements to create the…

Copy Database To Different Host/DB

Kailash Chander June 15, 2026 No Comments

Select the Database you want to copy and then Select Database -> Copy Database to different Host/DB to copy a database (with all or selected items of its table structure as well as the…

Alter Database

Kailash Chander June 15, 2026 No Comments

This option lets you change the default charset and collation for a database. New tables created after that will be created with the selected charset and collation unless otherwise specified.…

Create Database

Kailash Chander June 15, 2026 No Comments

SQLyog provides all the tools you need to manage and navigate databases. Note that to start working with databases in SQLyog you need to connect to a MySQL server. Select Database ->…

COMPANY

About Us Careers Legal Privacy Policy EULA

RESOURCES

MONyog Documentation SQLyog Documentation Blog Videos Deploy on AWS

Become a Partner Request a Quote Contact Us