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:36: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
@@ -61, +62 @@

  /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
  /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
  
+ The following command is used to create the above dump:
+ 
+ shell> mysqldump -u username -p passwd database_name [table];
+ 
+ Detailed information about the "mysqldump" utility can be found at:
+ 
+ http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html
+ 
+ Now, I need to analyze the above dump and make necessary changes to the above statements
so that they can be executed on Apache Derby. Once the translation is done, the database can
be migrated.
+ 

Mime
View raw message