DEV Community

# mysql

Posts on tips and tricks, using and learning about MySQL for database development and analysis.

Posts

👋 Sign in for the ability to sort posts by relevant, latest, or top.
Creating a ZFS Image of a MySQL Data Directory

Creating a ZFS Image of a MySQL Data Directory

10
Comments
2 min read
Need a cmd + Z in your database? Transactions to the rescue!

Need a cmd + Z in your database? Transactions to the rescue!

8
Comments 1
1 min read
Beginning MySQL for Data Analysts

Beginning MySQL for Data Analysts

4
Comments
7 min read
Import MySQL to MongoDB in 5 Steps (Plus SQL Server, PostgreSQL, Oracle)

Import MySQL to MongoDB in 5 Steps (Plus SQL Server, PostgreSQL, Oracle)

8
Comments 1
3 min read
Managing MySQL Server Logs: Rotate, Compress, Retain & Delete

Managing MySQL Server Logs: Rotate, Compress, Retain & Delete

5
Comments
4 min read
Toggle NOT NULL constraint with Rails migration

Toggle NOT NULL constraint with Rails migration

10
Comments 1
1 min read
MySQL 8 en Docker de manera fácil y para toda la familia

MySQL 8 en Docker de manera fácil y para toda la familia

10
Comments 4
3 min read
MySQL High Availability Framework Explained – Part III: Failover Scenarios

MySQL High Availability Framework Explained – Part III: Failover Scenarios

11
Comments
5 min read
Create a Web Server and save form data into MySQL database using PHP (Beginners Guide)

Create a Web Server and save form data into MySQL database using PHP (Beginners Guide)

29
Comments 5
5 min read
MySQL/MariaDB: like a Petya ransomware for MySQL and ‘root’@’%’ access

MySQL/MariaDB: like a Petya ransomware for MySQL and ‘root’@’%’ access

9
Comments 2
3 min read
TestRail: QA Test Case Management installation on Linux

TestRail: QA Test Case Management installation on Linux

8
Comments 2
8 min read
Building a file sharing app with Node.js, Vue.js, Cloudinary, and MySQL - Part 2

Building a file sharing app with Node.js, Vue.js, Cloudinary, and MySQL - Part 2

12
Comments
2 min read
Debugging queries - lazy vs eager loading in Laravel

Debugging queries - lazy vs eager loading in Laravel

15
Comments 1
3 min read
AWS RDS dump / restore / view progress

AWS RDS dump / restore / view progress

8
Comments
2 min read
Welcome to SQL 3: Building Relationships and Combining Data Sets

Welcome to SQL 3: Building Relationships and Combining Data Sets

11
Comments 1
10 min read
MySQL vs MySQLi vs PDO Performance Benchmark, Difference and Security Comparison - 2022

MySQL vs MySQLi vs PDO Performance Benchmark, Difference and Security Comparison - 2022

24
Comments 3
6 min read
2019 Database Trends – SQL vs. NoSQL, Top Databases, Single vs. Multiple Database Use

2019 Database Trends – SQL vs. NoSQL, Top Databases, Single vs. Multiple Database Use

32
Comments 1
9 min read
Welcome to SQL 2: Working With Data Values

Welcome to SQL 2: Working With Data Values

12
Comments
7 min read
Changing the MySQL root User from auth_socket to Password Authentication Using Ansible

Changing the MySQL root User from auth_socket to Password Authentication Using Ansible

10
Comments
4 min read
Installing WordPress 5 on ZEIT Now with MySQL Hosting

Installing WordPress 5 on ZEIT Now with MySQL Hosting

17
Comments 9
9 min read
Sequelize Model.update

Sequelize Model.update

4
Comments 5
1 min read
When your mysql image refuses to start on Kubernetes

When your mysql image refuses to start on Kubernetes

11
Comments 1
2 min read
Quickly Spin Up MySQL w/ Docker Compose

Quickly Spin Up MySQL w/ Docker Compose

11
Comments
1 min read
MySQL Tutorial – Understanding The Seconds Behind Master Value

MySQL Tutorial – Understanding The Seconds Behind Master Value

7
Comments
5 min read
MySQL examples for Node.js

MySQL examples for Node.js

10
Comments
5 min read
The best and easy way to handle database migrations (version control)

The best and easy way to handle database migrations (version control)

19
Comments
2 min read
MySQL High Availability Framework Explained – Part II

MySQL High Availability Framework Explained – Part II

4
Comments
7 min read
MariaDB: Backing Up/Restoring Databases On The Command Line

MariaDB: Backing Up/Restoring Databases On The Command Line

11
Comments
2 min read
Tips to use MySQL 8.0 on Kubernetes

Tips to use MySQL 8.0 on Kubernetes

23
Comments 3
3 min read
SQLSTATE[HY000] [2002] Connection refused

SQLSTATE[HY000] [2002] Connection refused

7
Comments 5
1 min read
Need help/tips on hosting a codeigniter application on google cloud platform

Need help/tips on hosting a codeigniter application on google cloud platform

8
Comments 5
1 min read
Start DB Schema Migration with "goose"

Start DB Schema Migration with "goose"

19
Comments 1
4 min read
MariaDB 10.0 On OpenBSD 6.4: Install

MariaDB 10.0 On OpenBSD 6.4: Install

8
Comments
4 min read
Slow MySQL Start Time in GTID? Binary Log File Size May Be The Issue

Slow MySQL Start Time in GTID? Binary Log File Size May Be The Issue

6
Comments
7 min read
MySQL High Availability Framework - Part I

MySQL High Availability Framework - Part I

8
Comments
6 min read
RDBとFirebaseのDB両方使ったっていいじゃない

RDBとFirebaseのDB両方使ったっていいじゃない

3
Comments
1 min read
MySQL: Client and Server Model Databases

MySQL: Client and Server Model Databases

4
Comments
2 min read
Sequelize Model Guide

Sequelize Model Guide

31
Comments
2 min read
MySQL vs. MongoDB

MySQL vs. MongoDB

13
Comments 1
2 min read
ACCESS DENIED: Reset MySQL root user password

ACCESS DENIED: Reset MySQL root user password

32
Comments 10
3 min read
How to buck up mysql's dump to AWS S3

How to buck up mysql's dump to AWS S3

7
Comments 3
1 min read
MySQL : InnoDB : RAM

MySQL : InnoDB : RAM

5
Comments 5
1 min read
MySQL Hosting on Azure, Fully Managed Cloud Database Service Launches at ScaleGrid

MySQL Hosting on Azure, Fully Managed Cloud Database Service Launches at ScaleGrid

4
Comments
3 min read
Step by step React, NodejS and MySQL Simple Full Stack Application 2018 (part: 3)

Step by step React, NodejS and MySQL Simple Full Stack Application 2018 (part: 3)

41
Comments 6
3 min read
Step by step React, NodejS and MySQL Simple Full Stack Application 2018 (part: 2)

Step by step React, NodejS and MySQL Simple Full Stack Application 2018 (part: 2)

22
Comments 2
2 min read
Step by step React, NodejS and MySQL Simple Full Stack Application 2018 (part: 1)

Step by step React, NodejS and MySQL Simple Full Stack Application 2018 (part: 1)

37
Comments
2 min read
MySQL Editor in NodeJS ~ Part Five

MySQL Editor in NodeJS ~ Part Five

12
Comments 1
2 min read
MySQL Editor in NodeJS ~ Part Four

MySQL Editor in NodeJS ~ Part Four

8
Comments
2 min read
MySQL Editor in NodeJS ~ Part Three

MySQL Editor in NodeJS ~ Part Three

23
Comments
3 min read
Worst things you can do, with database architecture

Worst things you can do, with database architecture

12
Comments 1
1 min read
[astuce] Comment utiliser une base de donnée pour stocker tous vos logs personnalisés avec l'API JLog de Joomla 3

[astuce] Comment utiliser une base de donnée pour stocker tous vos logs personnalisés avec l'API JLog de Joomla 3

4
Comments
1 min read
How to compare two databases, identify the diferences and generate the necessary SQL to update the structure of one of them

How to compare two databases, identify the diferences and generate the necessary SQL to update the structure of one of them

10
Comments 1
1 min read
Configuring and Managing SSL On Your MySQL Server

Configuring and Managing SSL On Your MySQL Server

10
Comments
6 min read
Understanding MySQL Multiversion Concurrency Control

Understanding MySQL Multiversion Concurrency Control

8
Comments
6 min read
Creating MySQL 5.6 with Percona in Docker

Creating MySQL 5.6 with Percona in Docker

8
Comments
2 min read
MySQL Editor in NodeJS ~ Part one

MySQL Editor in NodeJS ~ Part one

22
Comments
5 min read
MySQL Editor in NodeJS ~ Part two

MySQL Editor in NodeJS ~ Part two

10
Comments
3 min read
Case Sensitive WHERE Clause

Case Sensitive WHERE Clause

10
Comments
1 min read
How To Import SQL File With PHP

How To Import SQL File With PHP

22
Comments 8
2 min read
Ajax Live Search With PHP And MySQL

Ajax Live Search With PHP And MySQL

27
Comments 3
1 min read
loading...