tested on Oracle XE 10g to make a simple bk from Oracle you can use dbms library like: create or replace directory dumpdir as ‘/home/[youruserpath]/’ /* ESPORTA DATI E METADATI DI UNO SCHEMA */ declare handle number; begin handle := dbms_datapump.open(‘EXPORT’,’SCHEMA’); dbms_datapump.add_file(handle,'[destination_file_name].dmp’,’DUMPDIR’); DBMS_DATAPUMP.add_file( handle => Handle, filename => ‘.log’, directory => ‘DUMPDIR’, filetype => DBMS_DATAPUMP.KU$_FILE_TYPE_LOG_FILE…
Read more
Tested on Ubuntu 18.04 LTS
1 |
sudo nano /etc/apache2/conf-available/phpmyadmin.conf |
1 2 3 4 |
#Restrict phpMyAdmin via IP address Order Deny,Allow Deny from All Allow from 10.1.1.10 |
1 |
sudo /etc/init.d/apache2 restart |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 |
GNU nano 2.2.6 File: /etc/apache2/conf-available/phpmyadmin.conf # phpMyAdmin default Apache configuration Alias /phpmyadmin /usr/share/phpmyadmin An example of a full conf file, whereto we give full access to an entairly network addresses <Directory /usr/share/phpmyadmin> #Restrict phpMyAdmin via IP address Order Deny,Allow Deny from All Allow from 10.0.9.0/24 Options FollowSymLinks DirectoryIndex index.php <IfModule mod_php5.c> AddType application/x-httpd-php .php php_flag magic_quotes_gpc Off php_flag track_vars On php_flag register_globals Off php_admin_flag allow_url_fopen Off php_value include_path . php_admin_value upload_tmp_dir /var/lib/phpmyadmin/tmp php_admin_value open_basedir /usr/share/phpmyadmin/:/etc/phpmyadmin/:/var/lib/phpmyadmin/:/usr/share/php/php-gette$ </IfModule> </Directory> # Authorize for setup <Directory /usr/share/phpmyadmin/setup> <IfModule mod_authn_file.c> AuthType Basic AuthName "phpMyAdmin Setup" AuthUserFile /etc/phpmyadmin/htpasswd.setup </IfModule> Require valid-user </Directory> # Disallow web access to directories that don't need it <Directory /usr/share/phpmyadmin/libraries> Order Deny,Allow Deny from All </Directory> <Directory /usr/share/phpmyadmin/setup/lib> Order Deny,Allow Deny from All </Directory> |
In this August Embarcadero announces the new version of the well-known Interbase report database: Interbase 2019. Interbase is widely used by Delphi developers since in the multi-platform environment (iOS, Android, Windows, Mac OSX, Linux) I believe it is the only relational database that can be distributed even on iOS / Android platforms, the inter-base versions…
Read more
Synaptica has always adopted Firebird as its main database environment for the realization of many solutions from embedded iot products to Web solutions with thousands of daily accesses. Firebird proved to be a great tool, flexible and easy to manage. For this reason we could not miss the appointment to meet the creators (Dmitry…
Read more
1 2 3 4 |
select PK_ID from USERS start with FK_USER_PARENT = PK_USER connect by prior PK_ID = FK_USER_PARENT; |
To enable and disable all triggers of a database i do two procedure : Enabling all database trigger:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 |
create procedure SP_ENABLE_ALL_TRIGGER as begin /* Procedure Text */ update RDB$TRIGGERS set RDB$TRIGGER_INACTIVE=0 where RDB$TRIGGER_NAME in( select A.RDB$TRIGGER_NAME from RDB$TRIGGERS A left join RDB$CHECK_CONSTRAINTS B ON B.RDB$TRIGGER_NAME = A.RDB$TRIGGER_NAME where ((A.RDB$SYSTEM_FLAG = 0) or (A.RDB$SYSTEM_FLAG is null)) and (b.rdb$trigger_name is null) AND (NOT(A.RDB$TRIGGER_NAME LIKE 'RDB$%')) ); suspend; end |
Disabling all database trigger:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 |
create procedure SP_DISABLE_ALL_TRIGGER as begin update RDB$TRIGGERS set RDB$TRIGGER_INACTIVE=1 where RDB$TRIGGER_NAME in( select A.RDB$TRIGGER_NAME from RDB$TRIGGERS A left join RDB$CHECK_CONSTRAINTS B ON B.RDB$TRIGGER_NAME = A.RDB$TRIGGER_NAME where ((A.RDB$SYSTEM_FLAG = 0) or (A.RDB$SYSTEM_FLAG is null)) and (b.rdb$trigger_name is null) AND (NOT(A.RDB$TRIGGER_NAME LIKE 'RDB$%')) ); suspend; end |