Showing entries 1 to 10 of 54
10 Older Entries »
Displaying posts with tag: How To (reset)
How to Restore a MySQL Database with Command Line or Restore Tools

The article gives a deep insight into how to restore MySQL database from a backup file using the mysqldump utility and third-party backup and restore tools, such as dbForge Studio for MySQL, MySQL Workbench, and phpMyAdmin. Contents Use the mysql command to restore a database from the command line Create the database Restore the database […]

The post How to Restore a MySQL Database with Command Line or Restore Tools appeared first on Devart Blog.

Different Ways to Back up MySQL Databases and Tables

The article provides an overview of the backup types available in MySQL and describes how-to examples of using the mysqldump command-line utility to take a backup of the database, tables, data, or schema and to restore the MySQL database. In addition, you can view how to generate a database backup with MySQL Workbench and how […]

The post Different Ways to Back up MySQL Databases and Tables appeared first on Devart Blog.

How to Connect to MySQL Server Databases Remotely

Distributed environment is hardly a new notion in the world of software. For one, you no longer need to host MySQL servers and databases on the same local machine. Now you can have a dedicated server that can deliver the required level of security and performance. With the help of root/sudo user privileges, you can […]

The post How to Connect to MySQL Server Databases Remotely appeared first on Devart Blog.

How to Rename a Table in MySQL in Different Ways

The article explores a bunch of popular methods to rename a MySQL table and provides handy worked examples that could be of utility to both beginning and experienced users. In one of our previous articles, we looked in detail at how to rename a database in MySQL. In this article, we are going to focus […]

The post How to Rename a Table in MySQL in Different Ways appeared first on Devart Blog.

What Is InnoDB in MySQL? Tutorial with Examples and Performance Tuning Tips

There is a number of powerful MySQL storage engines at our disposal, and InnoDB is undoubtedly one of the most popular ones. It is highly reliable and efficient, so it is no wonder that it has become a default storage engine for all MySQL versions from 5.5 on. Let us take a look at its […]

The post What Is InnoDB in MySQL? Tutorial with Examples and Performance Tuning Tips appeared first on Devart Blog.

How to Create a View in MySQL

This article will show you how to create and manage views in MySQL. A view is a virtual table that does not store its own data but rather displays data that is stored in other tables. Essentially, a view is a result of SQL query execution, which returns the required rows of data from one […]

The post How to Create a View in MySQL appeared first on Devart Blog.

How to Create a New User Account in MySQL and Grant Permissions on a Database

This article provides a complete overview of how to create a new user account in MySQL and grant different types of privileges on a MySQL database. Learn the basics of user account management and find hints. Introduction First, let’s figure out why we need users and privileges. When you install MySQL Server on your system […]

The post How to Create a New User Account in MySQL and Grant Permissions on a Database appeared first on Devart Blog.

Creating a New Database in MySQL: Tutorial with Examples

The article provides a detailed overview of how to create a database in MySQL using different methods and tools (including the Command Line, Workbench, and dbForge Studio for MySQL). MySQL is a relational database management system based on SQL. It is developed, distributed, and supported by the Oracle Corporation. MySQL is free and open-source software […]

The post Creating a New Database in MySQL: Tutorial with Examples appeared first on Devart Blog.

MySQL JOINs Tutorial with Examples

The article presents a detailed tutorial on MySQL JOINs. In it, you will learn about different types of JOINS that are supported in MySQL, their syntax, and how to use them. Introduction to MySQL JOINsDifferent types of JOINs in MySQL1. MySQL INNER JOIN clause2. MySQL OUTER JOINs2.1 MySQL LEFT JOIN clause2.2 MySQL RIGHT JOIN clause3. […]

The post MySQL JOINs Tutorial with Examples appeared first on Devart Blog.

How to Rename a MySQL Database?

Eventually, it appears necessary to change the name of a database in MySQL. For that purpose, we used to apply a simple RENAME DATABASE command that existed in earlier versions of MySQL. However, it became no longer available in the newer versions as it posed risks. The reason was that the RENAME DATABASE query could […]

The post How to Rename a MySQL Database? appeared first on Devart Blog.

Showing entries 1 to 10 of 54
10 Older Entries »