For a single database: mysqldump –opt –user=root –password database1 > singledb.sql For multiple Backup of databases: mysqldump –opt –user=root –password –databases database1 database2 > multipledb.sql To import a MYSQL .sql file from one location to particular location : source /home/SSI/process_databases_backup.sql
Author: viveik
Groovy Script SQL Connection Bonitasoft
Below is the SQL Connection for a Groovy Script for a SELECT Command in Bonitasoft BPM import groovy.sql.Sql;def host = “localhost”;def user = “bonita”;def pass = “bpm”;def schema = “bonita_journal”;def query = “SELECT * FROM BN_USER where USER_PRO_EMAIL_=’${email_Address__}’ limit 1”;def list=[];sql = providedscripts.BonitaSql.newInstance(“jdbc:mysql://${host}/${schema}”,user, pass, new com.mysql.jdbc.Driver())sql.eachRow(query,{row-> list.add(row.USER_USERNAME_)}); IdentityAPI api = apiAccessor.getIdentityAPI();User userObj = api.findUserByUserName(list[0]);User manager1 […]
Fixed Floating sidebar using HTML and CSS
By using simple HTML and CSS you will get Fixed Floating Right side bar and you can also make customization to it. Copy the code from the below Textarea box and see <br /> <br /> <html><br /> <head><br /> <br /> <script type=”text/javascript”><br /> function load()<br /> {<br /> document.getElementById(‘abc’).style.right=’25px’;<br /> }<br /> </script><br […]
Browser or Client Side Scripting Languages Vs Server Side Scripting Languages
What are the Client Side and Server Scripting Side Languages Client Side Scripting Server Side Scripting HTML ASP DHTML PHP CSS JSP JAVASCRIPT ADO AJAX RAZOR JQUERY JSON E4X