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