Backup/Restore Mysql database ShowBackup/Restore Mysql database
Backup
Restore your database
Note
A simple approach on how to backup and restore MySQL databases.
Backup
To save an existing database it is recommended that you create a dump.
To dump all...
Connect a database (MDB) to excel Show[VBA] Connecting a database (MDB) to excel
Below is a tips of how to connect an Access database (MDB) in an application excel
Add reference
Microsoft DAO object librairy X.X
In a general module (eg Module1) paste the code below...
Automatic backup of a Database in SQL EXPRESS 2005 ShowAutomatic backup of a Database in SQL EXPRESS 2005
If you want to automate a backup of a database in SQL Server Express, there is a simple solution using a .bat. file.
Create a new text file. This file should contain the following...
Download Database Editor ShowThe database management is a complex task, for the experimented users in general. For a specific task, specific tools are needed.
Database editor is a tool allowing fast and easy access to any sorts of database. It will help database developers and...
Database administrator ShowDatabase administrator
A database administrator (or DBA for short) is in charge of maintaining and operating the databases which form a company's information system. Skills
Given the critical nature of the data he/she is in charge of, the...
Introduction - Databases ShowWhat is a database?
A database (abbreviated DB) is an entity in which data can be stored in a structured manner, with as little redundancy as possible. Different programs and different users must be able to use this data. Therefore, the concept of...
Database Replication ShowIntroduction to Replication
Replication consists in ensuring data availability by synchronising copies of a data source on different servers.
Replication is mainly used for database management systems that manage thousands or even millions of...