by İsmail Baydan · Published 15/06/2018
MySQL stores given relation data in tables. While using tables we generally need to check and list existing tables. We can use different ways to list tables. In this tutorial we will learn how to use show tables and Select table_name in order to list and print table names. Connect MySQL Interactive...
by İsmail Baydan · Published 30/05/2018
MySQL is free and opensource database server which is very popular in opensource community. MySQL is used by alot of applications and companies like Facebook, Google etc. In this tutorial we will learn how to install MySQL into deb or apt based distributions like Ubuntu, Debian, Mint and Kali. This guide can...
by İsmail Baydan · Published 13/02/2018
MySQL service provides different connection methods. We generally prefer TCP/IP way where connection is established over Network Socket. There is alternative way named Socket which is connected over local system. During connection we may get error like Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ . In this tutorial we...
by İsmail Baydan · Published 13/02/2018
MySQL is very popular database in the opensource community. While developing applications or connecting MySQL database we need to specify the MySQL port implicitly or explicitly. In this tutorial we will learn MySQL default port number and alternative port numbers. TCP 3306 The default port for the MySQL service is...
by İsmail Baydan · Published 11/07/2017
MySQL is very popular and open source database server. Python is old but lately discovered language. In this tutorial we will look how to use this popular techs in our applications in order to run sql queries. Install Python MySQL Connector In order to connect MySQL database from Python application...
by İsmail Baydan · Published 04/07/2017 · Last modified 23/04/2018
Backup and Restore operations are important part of the database administration. mysqlimport command is used to load data in file into Mysql or Mariadb servers. Mysql import is generally used by providing SQLfile. Syntax Syntax of mysqlimport is like below. mysqlimport OPTIONS DBNAME FILE OPTION is used provide detailed configuration DBNAME is the...
by İsmail Baydan · Published 27/03/2017
MySQL database is very popular database server used by a lot of small and big companies. In this tutorial we will look the basics of MySQL server like creating database and tables, populating data into tables. MySQL installation can be done with the following tutorial for Linux operating systems. How...
by İsmail Baydan · Published 13/03/2017 · Last modified 22/04/2018
One of the most important task of a database administrator is backing up and restoring databases. MySQL is a popular database server and provides tool named mysqldump for backup and restore operations. We will look different usage types of mysqldump in this tutorial. Syntax
1 2 3 4 5 | mysqldump [OPTIONS] database [tables] OR mysqldump [OPTIONS] --databases [OPTIONS] DB1 [DB2 DB3...] OR mysqldump [OPTIONS] --all-databases [OPTIONS] |
Help
1 | $ mysqldump --help |
Connect Remote Database Server...
by İsmail Baydan · Published 22/12/2016 · Last modified 17/06/2017
MySQL is very popular opensource database it is used by a lot of different type and size companies. In this post we will look how to drop or delete MySQL databases? Drop Database Dropping/Deleting/Removing a database in MySQL server is simple and fast solution which will delete data as well...
by İsmail Baydan · Published 10/12/2016 · Last modified 10/02/2018
MySQL database server have users to connect and use databases and tables. Users provides security for database operations. MySQL server comes with default users or in the operations a lot of users are created. In this post we will look how to list these users. Connect To Database We will...
