MySQL Server

Conectar PowerShell con MySQL

Pasos: 1.Descargar e instalar MySQL Server (https://dev.mysql.com/downloads/mysql/) 2. Descargar e instalar MySQL Connector Net (https://dev.mysql.com/downloads/connector/net/) 3. Utilizar el conector desde PowerShell (la base de datos y las tablas tienen que existir para poder obtener datos al ejecutar una consulta)

mysqlcheck: A Table Maintenance Program

The mysqlcheck client performs table maintenance: It checks, repairs, optimizes, or analyzes tables. Each table is locked and therefore unavailable to other sessions while it is being processed, although for check operations, the table is locked with a READ lock only (see Section 13.3.5, “LOCK TABLES and UNLOCK TABLES Syntax”, for more information about READ and WRITE locks). Table maintenance operations can be time-consuming, particularly for large tables. If you use the –databases or –all-databases option to process all tables in one or more databases, an invocation of mysqlcheck might take a long time. (This is also true formysql_upgrade because that […]

mysqldump: A Database Backup Program

The mysqldump client is a backup program originally written by Igor Romanenko. It can be used to dump a database or a collection of databases for backup or transfer to another SQL server (not necessarily a MySQL server). The dump typically contains SQL statements to create the table, populate it, or both. However,mysqldump can also be used to generate files in CSV, other delimited text, or XML format. Syntax There are in general three ways to use mysqldump—in order to dump a set of one or more tables, a set of one or more complete databases, or an entire MySQL […]

Start/Stop/Restart MySQL Server

If you are using MySQL on Debian/Ubuntu Linux then use following command: Start mysql server

Stop mysql server

Restart mysql server