Airton Lastori alastori
alastori
/ simples.sql
Created
April 28, 2014 13:21
MySQL - teste simples de criação de database e tabela com colunas auto-increment e varchar
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| CREATE DATABASE meudb; | |
| SHOW DATABASES; | |
| USE meudb; | |
| CREATE TABLE simples (id INT AUTO_INCREMENT PRIMARY KEY, texto VARCHAR(200)); | |
| INSERT INTO simples VALUES (NULL, 'Primeiro teste'); | |
| SELECT * from simples; | |
| INSERT INTO simples VALUES (NULL, 'Segundo teste'); | |
| SELECT * from simples; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <link rel="import" href="../core-scaffold/core-scaffold.html"> | |
| <link rel="import" href="../core-header-panel/core-header-panel.html"> | |
| <link rel="import" href="../core-menu/core-menu.html"> | |
| <link rel="import" href="../core-item/core-item.html"> | |
| <link rel="import" href="../core-icon-button/core-icon-button.html"> | |
| <link rel="import" href="../core-toolbar/core-toolbar.html"> | |
| <link rel="import" href="../core-field/core-field.html"> | |
| <link rel="import" href="../core-icon/core-icon.html"> | |
| <link rel="import" href="../core-input/core-input.html"> | |
| <link rel="import" href="../core-icons/core-icons.html"> |
alastori
/ yum-localinstall-MySQL-server-advanced-5.6-output.txt
Last active
August 29, 2015 14:10
MySQL 5.6.21 Server Install on Oracle Linux 7 - sucessful output 4/4
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| [root@ol7-mysql56 packages]# yum -y localinstall MySQL-server-advanced* | |
| Examinando MySQL-server-advanced-5.6.21-1.el7.x86_64.rpm: MySQL-server-advanced-5.6.21-1.el7.x86_64 | |
| Marcando MySQL-server-advanced-5.6.21-1.el7.x86_64.rpm para ser instalado | |
| Resolvendo dependências | |
| --> Executando verificação da transação | |
| ---> O pacote MySQL-server-advanced.x86_64 0:5.6.21-1.el7 será instalado | |
| --> Processando dependência: libaio.so.1(LIBAIO_0.1)(64bit) para o pacote: MySQL-server-advanced-5.6.21-1.el7.x86_64 | |
| --> Processando dependência: libaio.so.1(LIBAIO_0.4)(64bit) para o pacote: MySQL-server-advanced-5.6.21-1.el7.x86_64 | |
| --> Processando dependência: libaio.so.1()(64bit) para o pacote: MySQL-server-advanced-5.6.21-1.el7.x86_64 | |
| --> Executando verificação da transação |
alastori
/ yum-localinstall-MySQL-client-advanced-5.6-output.txt
Last active
August 29, 2015 14:10
MySQL 5.6.21 Server Install on Oracle Linux 7 - sucessful output 3/4
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| [root@ol7-mysql56 packages]# yum -y localinstall MySQL-client-advanced* | |
| Examinando MySQL-client-advanced-5.6.21-1.el7.x86_64.rpm: MySQL-client-advanced-5.6.21-1.el7.x86_64 | |
| Marcando MySQL-client-advanced-5.6.21-1.el7.x86_64.rpm para ser instalado | |
| Resolvendo dependências | |
| --> Executando verificação da transação | |
| ---> O pacote MySQL-client-advanced.x86_64 0:5.6.21-1.el7 será instalado | |
| --> Resolução de dependências finalizada | |
| Dependências resolvidas |
alastori
/ yum-localinstall-MySQL-shared-compat-advanced-5.6-output.txt
Last active
August 29, 2015 14:10
MySQL 5.6.21 Server Install on Oracle Linux 7 - sucessful output 2/4
alastori
/ yum-localinstall-MySQL-shared-advanced-5.6-output.txt
Last active
August 29, 2015 14:10
MySQL 5.6.21 Server Install on Oracle Linux 7 - sucessful output 1/4
alastori
/ mysql57_test_port_conflict.txt
Created
April 27, 2016 14:39
MySQL 5.7 - testing port conflict when trying to configure multiple instances
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| ## Criando 2 diretorios de dados para 2 instancias de teste | |
| mysqld --no-defaults --user=mysql --initialize-insecure \ | |
| --explicit_defaults_for_timestamp --datadir=/tmp/mysqldata1 \ | |
| --log-error=/tmp/mysqldata1/mysqld1.log | |
| mysqld --no-defaults --user=mysql --initialize-insecure \ | |
| --explicit_defaults_for_timestamp --datadir=/tmp/mysqldata2 \ | |
| --log-error=/tmp/mysqldata2/mysqld2.log | |
| ## Inicializando uma instancia mysql na porta 13001: |
alastori
/ provision-mysql-community-57-el7-rpm-tar.sh
Last active
October 22, 2016 16:15
Bash script to provision MySQL 5.7 Community via local RPMs in Enterprise Linux 7.x
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #!/bin/bash | |
| #Bash script to provision MySQL 5.7 Community via local RPMs in Enterprise Linux 7.x | |
| #Copy the TAR with mysql* RPMs into the $PACKAGES_DIR and run this script as root | |
| #You can find the community binaries in http://dev.mysql.com/downloads | |
| #Modify these variables as you wish | |
| DIR_TO_UNPACK=/tmp/packages | |
| PACKAGES_DIR=/home/vagrant/packages #This folder already contains RPMs | |
| MYSQL_PWD="Root#123" |
alastori
/ provision-mysqlutilities-el7-rpm.sh
Created
May 13, 2016 19:34
Bash script to install MySQL Utilities via RPM in Enterprise Linux 7.x
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #!/bin/bash | |
| #Bash script to install MySQL Utilities via RPM in Enterprise Linux 7.x | |
| #Copy the MySQL Utilities and Connector Python RPMs into the $PACKAGES_DIR and run this script as root | |
| #You can find the community binaries in http://dev.mysql.com/downloads and | |
| #commercial binaries in http://support.oracle.com (preferable) or http://edelivery.oracle.com | |
| #Modify these variables as you wish | |
| PACKAGES_DIR=/home/vagrant/packages #This folder already contains RPMs |
alastori
/ provision-meb4-el7-rpm.sh
Created
May 13, 2016 19:36
Bash script to install MySQL Enterprise Backup 4.x via RPM in Enterprise Linux 7.x
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #!/bin/bash | |
| #Bash script to install MySQL Enterprise Backup 4.x via RPM in Enterprise Linux 7.x | |
| #Copy the MEB RPM (meb-4*.rpm) into the $PACKAGES_DIR and run this script as root | |
| #You can find the binaries in http://support.oracle.com (preferable) or http://edelivery.oracle.com | |
| #Modify these variables as you wish | |
| PACKAGES_DIR=/home/vagrant/packages | |
| #Next lines install MySQL Enterprise Backup |
OlderNewer