MySQL Replication and Backup

Home » MySQL (562) » Replication and Backup (16)

Import - Export MySQL Databases using the terminal
Learn how to Import - Export MySQL Databases using the terminal in Ubuntu Linux

How to Backup Databases Using mysqldump Tool
In this tutorial, you will learn how to backup databases by using mysqldump client tool provided by MySQL.

Import or Restore Databases
There are two simple ways in MySQL to load data into MySQL database from a previously backed up file.
Importing Data with LOAD DATA
Importing Data with mysqlimport

Backup or Export Databases
Learn the different methods to backup or export a MySQL database.

MySQL Command Line and SSH: Importing and Exporting Database
There are times when using a GUI-based client, such as phpMyAdmin, for managing MySQL databases is not enough. Limitations include issues with importing databases and lack of security for MySQL sessions. You can get around these limitations if you're willing to use the command line. This article introduces the use of the command line in MySQL management.

Backing Up and Restoring A MySQL Database
In this lession you will learn how to take MySQL Database backup and restore the same.

MySQL Backup Done Easily
One thing that comes up a lot on sites like Stackoverflow and the like is how to backup MySQL databases.The first answer is usually use mysqldump. This is all fine and good, till you start to want to dump multiple databases. You can do this all in one like using the –all-databases option however this makes restoring a single database an issue, since you have to parse out the parts you want which can be a pain.

Is it possible to recover data destroyed by unintentionaly confirmed DROP DATABASE command? This tutorial answers this question and offers step-by-step procedure how to do it, if possible.

Backup your mySQL Database
To backup your database, you will need to use phpMyAdmin. Most hosts have this script pre-installed. If you can't find it, contact your host.

How To Back Up MySQL Databases Without Interrupting MySQL
This article describes how you can back up MySQL databases without interrupting the MySQL service.

Backup and Restore MySQL Databases
It is a good idea to backup your MySQL data occasionally as a precautionary measure. It is also a good idea to create a backup before making any major changes, incase something goes wrong and you need to revert to the unmodified version. Database backups can also be used to transfer your database from one server to another if you change web hosts.

Backing Up Your MySQL Databases With MySQLDump
MySQL includes several ways to backup your important data. In this article learn how to backup our databases using the mysqldump utility that comes with MySQL.

Backing Up/Restoring MySQL Databases
If you happen to have data stored in a MySQL database, it is good for you to learn how to backup and restore the database.

Advanced MySQL Replication Techniques
MySQL Cluster is a powerful peering system to add high availability and replication across multiple database servers. It's not perfect, though. Using features of MySQL 5.0 and 5.1, it's possible to build a master/slave replication system with fail-over.

How To Set Up Database Replication In MySQL
This tutorial describes how to set up database replication in MySQL. MySQL replication allows you to have an exact copy of a database from a master server on another server (slave), and all updates to the database on the master server are immediately replicated to the database on the slave server so that both databases are in sync.

Replication in MySQL
This chapter describes the various replication features provided by MySQL. It introduces replication concepts, shows how to set up replication servers, and serves as a reference to the available replication options.

Home » MySQL (562) » Replication and Backup (16)