Database Archives - Page 2 of 4

Database

Alter Table Statement in MySQL : How to Rename Table

In this article I will show you how to rename table in MySQL. RENAME TABLE IN MYSQL Syntax Follow...

Database

If you are trying to access your database server remotely and getting below error during MySQL...

Database

There are lots of online tutorials for setting up a slave replication database include dumping the...

Database

PhpMyadmin is used to administrate MySQL server. It is an open source tool. Using phpMyAdmin you...

Database

Percona XtraBackup is free and available for download, it is open source hot backup utility for...

Database

If you are using command line interface to access your Mysql server and getting “Mysql...

Database

PostgreSQL (pronounced “post-gress-Q-L”). PostgreSQL is an open source object...

Database

If you are getting MySQL connection error ” Host ” is blocked because of many...

Database

MySQL is an open source relational database management system (DBMS) which is much of the time...

Database

I had a task to migrate full data from MySQL 5.6 AWS RDS instance to Softlayer dedicated MySQL 5.6...

Database

XtraBackup package is available on the Percona XtraBackup software repositories. Percona yum...

Database

On the off chance that you take general backups utilizing mysqldump, you’ll realize that...

Database

What is GTID? GTID (Global Transaction Identifier) is a unique identifier created and associated...

Database

Each data modification such as INSERT, UPDATE, DELETE and data definition like ALTER, ADD, DROP...