Hi, system provided database initialization scripts are loaded only once at database creattion time. User-specific SQL scripts can be loaded via mclient at any time. Stefan On Wed, Dec 05, 2012 at 12:09:22AM +0530, swapnil joshi wrote:
Hi ,
My SQL Script is loaded only one's, When i am creating new database using following command I have copy and paste my terminal command
swapnil@swapnil-lp:~$ sudo monetdb create test5 [sudo] password for swapnil: Sorry, try again. [sudo] password for swapnil: created database in maintenance mode: test5 swapnil@swapnil-lp:~$ sudo monetdb release test5 taken database out of maintenance mode: test5 swapnil@swapnil-lp:~$ sudo monetdb start test5 starting database 'test5'... done swapnil@swapnil-lp:~$ mclient test5 Welcome to mclient, the MonetDB/SQL interactive terminal (Jul2012-SP1) Database: MonetDB v11.11.7 (Jul2012-SP1), 'mapi:monetdb://swapnil-lp:50000/test5' Type \q to quit, \? for a list of available commands auto commit mode: on sql>
After that if i am checking merovingian.log (Monetdb log file) 2012-12-04 17:57:20 MSG test2[11694]: # SQL catalog created, loading sql scripts once 2012-12-04 17:57:20 MSG test2[11694]: # loading sql script: 09_like.sql 2012-12-04 17:57:20 MSG test2[11694]: # loading sql script: 10_math.sql 2012-12-04 17:57:20 MSG test2[11694]: # loading sql script: 11_times.sql 2012-12-04 17:57:20 MSG test2[11694]: # loading sql script: 12_url.sql 2012-12-04 17:57:20 MSG test2[11694]: # loading sql script: 13_date.sql 2012-12-04 17:57:20 MSG test2[11694]: # loading sql script: 14_inet.sql 2012-12-04 17:57:20 MSG test2[11694]: # loading sql script: 15_history.sql 2012-12-04 17:57:20 MSG test2[11694]: # loading sql script: 16_tracelog.sql 2012-12-04 17:57:20 MSG test2[11694]: # loading sql script: 17_compress.sql 2012-12-04 17:57:20 MSG test2[11694]: # loading sql script: 18_dictionary.sql 2012-12-04 17:57:20 MSG test2[11694]: # loading sql script: 19_cluster.sql 2012-12-04 17:57:20 MSG test2[11694]: # loading sql script: 20_vacuum.sql 2012-12-04 17:57:20 MSG test2[11694]: # loading sql script: 21_dependency_functions.sql 2012-12-04 17:57:20 MSG test2[11694]: # loading sql script: 22_clients.sql 2012-12-04 17:57:20 MSG test2[11694]: # loading sql script: 23_skyserver.sql 2012-12-04 17:57:20 MSG test2[11694]: # loading sql script: 24_zorder.sql 2012-12-04 17:57:20 MSG test2[11694]: # loading sql script: 25_debug.sql 2012-12-04 17:57:20 MSG test2[11694]: # loading sql script: 40_geom.sql 2012-12-04 17:57:20 MSG test2[11694]: # loading sql script: 80_udf.sql 2012-12-04 17:57:20 MSG test2[11694]: # loading sql script: 99_system.sql
How will i manually Lode this script because if i have change in any *.sql file each time I need to create new database How will i avoid this manual work?
Please help me!!!!
:)
-- Regards, Swapnil K. Joshi
_______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list
-- | Stefan.Manegold @ CWI.nl | DB Architectures (INS1) | | http://CWI.nl/~manegold/ | Science Park 123 (L321) | | Tel.: +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) | _______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list