MySQL Replication and Backup tutorials
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.
Related Tutorials
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 And Restoring Your MySQL Database
If you've been using MySQL database to store your important data, it is imperative that you make a backup of your data to prevent any loss of data. This article shows you how to backup and restore data in your MySQL database. This process can also be used if you have to move your data to a new server.
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.
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.
Introduction to MySQL
MySQL is the most popular open source SQL database management system, is developed, distributed, and supported by MySQL AB. MySQL AB is a commercial company, founded by the MySQL developers.
Developing Database Applications Using MySQL Connector/C++
This tutorial will show you the essential steps to build and install MySQL Connector/C++ driver, with simple examples to connect, insert, and retrieve data from a MySQL database.
MySQL Database Instructions
You can create up to 4 MySQL databases using the "Add MySQL Database" function of your Control Panel.
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.
Introduction to MySQL database
MySql is a powerful database. This tutorial will explains an introduction of MySQL database.
MySQL 5.4: Up To 90% Faster Response
Sun Microsystems, Inc. today announced MySQL 5.4, a new version of the world's most popular open source database, designed to deliver significant performance and scalability improvements to MySQL applications.
What is MySQL
MySQL is a open source Relational Database Management System. MySQL is very fast reliable and flexible Database Management System. It provides a very high performance and it is multi threaded and multi user Relational Database management system.
Build Your Own Database Driven Website Using PHP & MySQL: Part 4
you'll learn how to take information stored in a database and display it on a Web page for all to see. So far you have installed and learned the basics of MySQL, a relational database engine, and PHP, a server-side scripting language. Now you'll see how to use these two new tools together to create a true database-driven Web site!.
Using a MySQL database with PHP
It's time to add some dynamic content to your website. The best choice for ease-of-use, price and support is the combination of PHP and MySQL. This article introduces the beginner to using MySQL with PHP.
Improve The Performance Of Your MySQL Server
MySQL is a rock solid, lighting fast database server which has been designed for two factors speed and performance. It is the Ferrari of databases: Light weight, fast and Built for the high speed tracks! Learn how to get the best performance from you MySQL database server.
What is MySQL?
MySQL is a freely available open source Relational Database Management System [RDBMS], a database engine of sorts that uses Structured Query Language (SQL). SQL is the most popular language for adding, accessing, and processing data in a database, and is most noted for its rapid processing, proven reliability, and ease and flexibility of use.
Optimize MySQL tables for speed
MySQL logo Just like you need to defrag and check your file system, it's important to do the same thing with MySQL tables. If you don't, you might end up with slow and corrupted database tables. Follow this easy tutorial to set up an automatic optimization for your db.
Optimize MySQL tables simple
Just like you need to defrag and check your file system, it's important to do the same thing with MySQL tables. If you don't, you might end up with slow and corrupted database tables. Follow this easy tutorial to set up an automatic optimization for your db. Speed in MySQL is all about how fast the...
MySQL and SQL
In this tutorial, we cover the following topics:A short introduction to relational databases and relational modeling, A quick start guide to the winestore database and its full entity-relationship model, The MySQL command interpreter and the basic features of MySQL, Using SQL to create and modify databases, tables, and indexes, Using SQL to insert, delete, and update data, The SQL SELECT statement for querying, with examples of simple and advanced queries, Functions and operators in SQL and MySQL, Advanced features, including managing indexes and keys, tuning the MySQL DBMS, security, and the limitations of MySQL.
Getting to Grips with mySQL
This tutorial will show you how to create and query a database using SQL and the mySQL command terminal.
Open Tools for MySQL Administrators
The MySQL distribution provides several tools for database developers and administrators, but they don't always work everywhere. Fortunately, the worldwide MySQL community has produced plenty of useful tools.
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 Upgrade from MySQL v 3.x to MySQL 4.x
This tutorial will walk you through step by step to upgrade your MySQL database to version 4.x on a Windows Machine. We are going to assume to that you already have MySQL version 3.x or earlier installed on your Windows machine.
MySQL Basics
This MySQL tutorial is a guide for new MySQL users, providing a reference of very basic, step by step, instructions on how to get started. This MySQL help page also gives more advanced users assistance in upgrading and running multiple versions of MySQL on a computer at the same time.
MySQL Made Easy With MySQL Front
MySQL Front allows anyone to easily create and manage their MySQL databases. In this tutorial see how to get up and running with MySQL Front.
MySQL SELECT query from PHP script
This tutorial will show you how to use MySQL querys to database in your PHP scripts.
Mysql Sub Queries, introduction
Mysql icon Mysql now offers sub queries/sub selects. They can help you write faster and shorter code. You don't need to do that much programming in PHP, just let mysql do the work :-)
Creating Users and Setting Permissions in MySQL
MySQL is an extremely powerful database, but in order to properly maximize its potential you may need to learn how to set up users and their respective permissions. In this article take a look at using the MySQL console application to create users and grant permissions to them. We also shows us how to grant permissions from remote hosts, how to reduce user privledges and more. MySQL is an extremely powerful database, but in order to properly maximize its potential, you may need to learn how to set up users and their respective permissions.
MySQL Optimization Hints
Every programmer loves to optimize, even when we know we shouldn't. To satisfy your cravings MySQL has several keywords that can be placed in your SQL statement to give the database server an explicit optimization instruction.
MySQL create user
In this MySQL create user article I try to summarize how you can add a new user to your MySQL database.
Understanding Various MySQL Executable Files
Learn how to the execute mysql file. MySQL Provide the executable file and uses the MySQL Client interactive file by this command "shell> mysql db_name ".
Build Your Own Database Driven Website Using PHP & MySQL: Part 2
This second installment covers an introduction to databases, logging on to MySQL, defining SQL, inserting data in a table, and modifying stored data.
Create Database and Table
Basic steps on how to setup a mysql database. Includes creating a tables, adding tables, and exporting a database.
Introduction to MySQL
Modern day web sites seem to be relying more and more on complex database systems. These systems store all of their critical data, and allow for easy maintenance in some cases. The Structured Query Language (SQL) is a very popular database language, and its standardization makes it quite easy to store, update and access data. One of the most powerful SQL servers out there is called MySQL and surprisingly enough.
Create New MySQL Database
You need to use mysqladmin to create MySQL database.
MySQL System Architecture
In this article, we're going to take a look at MySQL internals. It will be a fun, informative examination of how all the different pieces and parts of the MySQL server operate together.
Build Your Own Database Driven Website Using PHP & MySQL: Part 3
In this chapter, we'll introduce the PHP server-side scripting language. In addition to the basic features we'll explore here, this language has full support for communication with MySQL databases.
Writing Syslog Messages to MySQL
In this tutorial, I describe how to write syslog messages to a MySQL database.
Installing MySQL on Windows
In this section you will learn how to install MySQL 5.0 on windows system. The MySQL 3.21 was the first version for the windows. Windows installer of MySQL includes auto installer with Configuration Wizard that support for easy installation.
Introducing the MySQL Librarian
The MySQL Librarian is a collection of community-generated and cross referenced content related to MySQL. It's a place where the community, collaboratively, builds and maintains MySQL content.
Writing Syslog Messages to MySQL
Learn how to write syslog messages to a MySQL database.
 
Categories