db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Apache Wiki <wikidi...@apache.org>
Subject [Db-derby Wiki] Update of "RaminMoazeni/DailyNotes" by RaminMoazeni
Date Wed, 31 May 2006 09:31:41 GMT
Dear Wiki user,

You have subscribed to a wiki page or wiki category on "Db-derby Wiki" for change notification.

The following page has been changed by RaminMoazeni:
http://wiki.apache.org/db-derby/RaminMoazeni/DailyNotes

------------------------------------------------------------------------------
  http://www.osdbmigration.org:8080/osdb/data_migration
  
  I also looked into the dump utility provided by the MySQL database: "mysqldump". This dump
utility is a backup program that can be used to dump a database or a collection of databases
for backup or for transferring the data. The dump contains SQL statements to create the table
or populate it, or both. An example of a dump output is shown below:
+ -- MySQL dump 10.10
+ -- 
+ -- Host: localhost    Database: testDB
+ -- ------------------------------------------------------
+ -- Server version	5.0.21-community-nt
  
+ /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
+ /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
+ /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
+ /*!40101 SET NAMES utf8 */;
+ /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
+ /*!40103 SET TIME_ZONE='+00:00' */;
+ /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
+ /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
+ /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
+ /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
+ 
+ --
+ -- Table structure for table `example`
+ --
+ 
+ DROP TABLE IF EXISTS `example`;
+ CREATE TABLE `example` (
+   `id` int(11) default NULL,
+   `data` varchar(100) default NULL
+ ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+ 
+ --
+ -- Dumping data for table `example`
+ --
+ 
+ 
+ /*!40000 ALTER TABLE `example` DISABLE KEYS */;
+ LOCK TABLES `example` WRITE;
+ INSERT INTO `example` VALUES (11,'hello');
+ UNLOCK TABLES;
+ /*!40000 ALTER TABLE `example` ENABLE KEYS */;
+ /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
+ 
+ /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
+ /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
+ /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
+ /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
+ /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
+ /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
+ /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
+ 

Mime
View raw message