MySQL Server | Scripting and security

Conectar PowerShell con MySQL

(2 votes, average: 5.00 out of 5)

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)

[void][System.Reflection.Assembly]::LoadWithPartialName("MySql.Data")
$Connection = New-Object MySql.Data.MySqlClient.MySqlConnection
$ConnectionString = "server=" + "localhost" + ";port=3306;uid=" + "root" + ";pwd=" + ";database="+"estado"
$Connection.ConnectionString = $ConnectionString
$Connection.Open()

$Query='select PersonID,Estado from Persons'
$Command = New-Object MySql.Data.MySqlClient.MySqlCommand($Query, $Connection)
$DataAdapter = New-Object MySql.Data.MySqlClient.MySqlDataAdapter($Command)
$DataSet = New-Object System.Data.DataSet
$RecordCount = $dataAdapter.Fill($dataSet, "data")
$DataSet.Tables[0]
$Connection.Close()

[void][System.Reflection.Assembly]::LoadWithPartialName("MySql.Data")

$Connection = New-Object MySql.Data.MySqlClient.MySqlConnection

$ConnectionString = "server=" + "localhost" + ";port=3306;uid=" + "root" + ";pwd=" + ";database="+"estado"

$Connection.ConnectionString = $ConnectionString

$Connection.Open()

$Query='select PersonID,Estado from Persons'

$Command = New-Object MySql.Data.MySqlClient.MySqlCommand($Query, $Connection)

$DataAdapter = New-Object MySql.Data.MySqlClient.MySqlDataAdapter($Command)

$DataSet = New-Object System.Data.DataSet

$RecordCount = $dataAdapter.Fill($dataSet, "data")

$DataSet.Tables[0]

$Connection.Close()

mysqlcheck: A Table Maintenance Program

(No Ratings Yet)

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

(3 votes, average: 5.00 out of 5)

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

(1 votes, average: 5.00 out of 5)

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

/etc/init.d/mysql start

1	/etc/init.d/mysql start

Stop mysql server

/etc/init.d/mysql stop

1	/etc/init.d/mysql stop

Restart mysql server

/etc/init.d/mysql restart

1	/etc/init.d/mysql restart