You have to create two scripts, one for export and one for import. Data you get from database don't have to be in specific format, as long as you store whole information at all times.

You will have to make an export script, that basically SELECTs all the data of all tables you want to backup. Those data can be stored for example in a TXT file. It is very important that you save all the information about a data (e.g. from which table these data come from, what is the data context, and so on).

When you need to import data to a new database, you can read a TXT file, create a database structure using SQL function CREATE TABLE and then import read data using SQL command INSERT.

It's considered the best solution to encapsulate export and import features into functions.

Simple way to connect to mysql server using PHP..

$hostname = 'localhost';

$username = 'root';

$password = 'anypassword';

//Connecting to mysql server..

$connect = mysql_connect($hostname, $username, $password);

if(!$connect)

{

die('Connection Failed'. mysql_error());

}

//Selecting the database..

$select = mysql_select_db('any_database_name');

if(!$select)

{

die('Database not Selected'. mysql_error());

}

?>

• A database coordinates the physical and logical access to the data; a file-processing system only coordinates physical access to the data
• A DBMS reduces the amount of data duplication
• A DBMS is designed to allow flexibility in what queries give access to the data, where a file-processing system only allows pre-determined access to data (by specific compiled programs)
• A DBMS is designed to coordinate and permit multiple users to access data at the same time. A file processing system is much more restrictive in simultaneous data access

: http://www.answers.com/in%20dbms%20difference%20between%20file%20processing%20and%20database%20system

In VHDL, entity is the keyword for defining a new object. In SGML and its derived markup languages HTML and XML, an entity is a named body of data associated with a document. Once defined, an entity can be referenced any number of times within the document, via entity references. An entity typically consists of a sequence of one or more characters, either encapsulated within a declaration of the entity's existence, or encoded and stored externally in a text file. Such entities and their references are comparable to macros and include files in programming languages. However, entities don't necessarily have to contain parseable text; they may also be binary files that are included in a document only by reference, with the entity name as the value of an ENTITY-type attribute.

Answer:

An entity is something that has a distinct, separate existence, though it need not be a material existence. In particular, abstractions and legal fictions are usually regarded as entities. In general, there is also no presumption that an entity is animate. Entities are used in system developmental models that display communications and internal processing of, say, documents compared to order processing.

An entity could be viewed as a set containing subsets. In philosophy, such sets are said to be abstract objects.

Sometimes, the word entity is used in a general sense of a being, whether or not the referent has material existence; e.g., is often referred to as an entity with no corporeal form, such as a language. It is also often used to refer to ghosts and other spirits. Taken further, entity sometimes refers to existence or being itself. For example, the former U.S. diplomat George F. Kennan once said that "the policy of the government of the United States is to seek . . . to preserve Chinese territorial and administrative entity.

Answer:

An entity is a legally recognized and formally structured grouping of people focused on some common cause or objective.

Examples

Here are some examples of entities:

SIL

an SIL branch

UNESCO

Oracle includes numerous data structures to improve the speed of Oracle SQL queries. Oracle includes many new indexing algorithms that dramatically increase the speed with which Oracle queries are serviced like b-tree index, bitmap indexes, function-based indexes, and index-only tables (IOTs

Oracle uses indexes to avoid the need for large-table, full-table scans and disk sorts, which are required when the SQL optimizer cannot find an efficient way to service the SQL query. I begin our look at Oracle indexing with a review of standard Oracle b-tree index methodologies.

It all depends on the type of MySQL database you wish to use and also the operating system the server has. Most of the restraints are due to the max file size the operating system can store. The limits are done by table size rather than the database size as a whole.

• Win 32 w/ FAT/FAT32 - 2GB/4GB
• Win 32 w/ NTFS - 2TB (possibly larger)
• Linux 2.2-Intel 32-bit - 2GB (LFS: 4GB)
• Linux 2.4+ - (using ext3 file system) 4TB
• Solaris 9/10 - 16TB
• MacOS X w/ HFS+ - 2TB
• NetWare w/NSS file system - 8TB

InnoDB tables are often split up into multiple files to allow larger tables, this is known as a tablespace. The maximum table space is 64TB.

MyISAM tables default size is at 4GB, but this can be changed to a maximum of 65,536TB.

Different types of attributes in DBMS are:

• Key or non key attributes

• Required or optional Attributes

• Simple or composite Attributes

• Single-valued and multi-valued Attributes

• Stored, Coded or derived Attributes