Is there a way to create a dump/export/save a temporary MySQL table into a file on disk(.sql file that is, similar to one that is created by mysqldump)?
I know Oracle offers several refreshmode options for their materialized views (on demand, on commit, periodically).
Does Microsoft SQLServer offer the same functions for their indexed views?
If not, how can I else use indexed views on SQLServer if my purpose is toexport data on a daily+
on-demand basis, and want to avoid performance overhead problems? Does a workaround exist?
I have a group of geometries stored in MySQl (as polygon and as well-known text) representing counties.
I can build a table of geometries and color codes after querying some county data (say GDP per capita).
What is the best way toexport this as an SVG map? I cannot find any reference to SVG conversion in the MySQL documentation.
If I have 'export BLA="hey there"' in .profile in my home directory, how can I change this later in other directories just by cd into the other directory?
Also, is there a way to just set a new environment variable when I cd into a directory.
My first attempt was to just make another .bashrc file in the directory where I want the change but apparently that proved less than effective.
I'm on OS X btw.
I want to use HSQLDB in a production environment for stroring some data in memory and for data export using files. Does anybody have experience with using hsqldb in production environments? Is hsqldb treating server resources gracefully and does it cleanup unused resources properly?
When setting ExportFormatType.CharacterSeparatedValues crystal report generates every row of data prefixed with column names (Report Headers). Why it does this? How it could be fixed? Usually it is preferred to have single header. For excel export type - generated report looks ok (only single header for all rows).
I am using crystal reports 11.5.3700.0. Visual studio 2008, .net 3.5 sp1
I have the file: myvars
MONO_PREFIX=/opt/mono
export MONO_PATH=$MONO_PREFIX/lib/mono/2.0
I "use" it, by calling:
source myvars
I want to change /opt/mono to be relative to the location of the myvars file instead of being absolute. How could I do this?
Is there anyway to use atrm command to remove queue job from PHP web application?
I wrote a shell script to remove the queue job but it doesn't work well.
#! /bin/sh
export PATH=/usr/local/bin:$PATH
echo atrm 3700 2>&1
I'm using the post-receive-email script included with git. (Source is here.) It works just fine, but I want each email to be sent from the author of the commits pushed. How do I do it?
My post-receive file currently looks like this, and I want to customize the from-email-address.
#!/bin/sh
export[email protected]
$(dirname $0)/post-receive-email
I've just developed a large database, and am trying to put it online. I want to make sure that all the foreign keys, defaults, constraints, views etc, are preserved. When I try toexport from my development PC using phpMyAdmin and then import on my hosted server, it errors out on all the views. Is there any other way to clone a database?
Hi,
I'm a beginner of ASP. I'm maintaining at ASP 1.0 page and I want to reload the page with an additional parameter when user click client-side URL.
The objective is toexport the table currently display in Excel. So I want to reload the page with a special parameter that would tell the page to change the ResponseType to be Excel data.
Any idea ?
Thanks
I have created freemind maps using the tool, right now in the process of integrating the map with my web application.
I have some questions on the usage of freemind maps
1) Instead of using the freemindbrowser.html and the jar file to integrate a map with a website/ web app, can we do an exportto Javascript from the tool and then integrate that exported file (.html) with the web site?
2) I want to be able to add javascript functions on events like node click, how do I do that?
Thanks in Advance
I have been trying to modify this log4bash implementation but I cannot manage to make it work. Here's a sample:
#!/bin/bash
TRUE=1
FALSE=0
############### Added for testing
log4bash_LOG_ENABLED=$TRUE
log4bash_rootLogger=$TRACE,f,s
log4bash_appender_f=file
log4bash_appender_f_dir=$(pwd)
log4bash_appender_f_file=test.log
log4bash_appender_f_roll_format=%Y%m
log4bash_appender_f_roll=$TRUE
log4bash_appender_f_maxBackupIndex=10
####################################
log4bash_abs(){
if [ "${1:0:1}" == "." ]; then
builtin echo ${rootDir}/${1}
else
builtin echo ${1}
fi
}
log4bash_check_app_dir(){
if [ "$log4bash_LOG_ENABLED" -eq $TRUE ]; then
dir=$(log4bash_abs $1)
if [ ! -d ${dir} ]; then
#log a seperation line
mkdir $dir
fi
fi
}
# Delete old log files
# $1 Log directory
# $2 Log filename
# $3 Log filename suffix
# $4 Max backup index
log4bash_delete_old_files(){
##### Added for testing
builtin echo "Running log4bash_delete_old_files $@" &2
#####
if [ "$log4bash_LOG_ENABLED" -eq $TRUE ] && [ -n "$3" ] && [ "$4" -gt 0 ]; then
local directory=$(log4bash_abs $1)
local filename=$2
local maxBackupIndex=$4
local suffix=$(echo "${3}" | sed -re 's/[^.]/?/g')
local logFileList=$(find "${directory}" -mindepth 1 -maxdepth 1 -name "${filename}${suffix}" -type f | xargs ls -1rt)
local fileCnt=$(builtin echo -e "${logFileList}" | wc -l)
local fileToDeleteCnt=$(($fileCnt-$maxBackupIndex))
local fileToDelete=($(builtin echo -e "${logFileList}" | head -n "${fileToDeleteCnt}" | sed ':a;N;$!ba;s/\n/ /g'))
##### Added for testing
builtin echo "log4bash_delete_old_files About to start deletion ${fileToDelete[@]}" &2
#####
if [ ${fileToDeleteCnt} -gt 0 ]; then
for f in "${fileToDelete[@]}"; do
#### Added for testing
builtin echo "Removing file ${f}" &2
####
builtin eval rm -f ${f}
done
fi
fi
}
#Appender
# $1 Log directory
# $2 Log file
# $3 Log file roll ?
# $4 Appender Name
log4bash_filename(){
builtin echo "Running log4bash_filename $@" &2
local format
local filename
log4bash_check_app_dir "${1}"
if [ ${3} -eq 1 ];then
local formatProp=${4}_roll_format
format=${!formatProp}
if [ -z ${format} ]; then
format=$log4bash_appender_file_format
fi
local suffix=.`date "+${format}"`
filename=${1}/${2}${suffix}
# Old log files deletion
local previousFilenameVar=int_${4}_file_previous
local maxBackupIndexVar=${4}_maxBackupIndex
if [ -n "${!maxBackupIndexVar}" ] && [ "${!previousFilenameVar}" != "${filename}" ]; then
builtin eval export $previousFilenameVar=$filename
log4bash_delete_old_files "${1}" "${2}" "${suffix}" "${!maxBackupIndexVar}"
else
builtin echo "log4bash_filename $previousFilenameVar = ${!previousFilenameVar}"
fi
else
filename=${1}/${2}
fi
builtin echo $filename
}
######################## Added for testing
filename_caller(){
builtin echo "filename_caller Call $1"
output=$(log4bash_abs $(log4bash_filename "${log4bash_appender_f_dir}" "${log4bash_appender_f_file}" "1" "log4bash_appender_f" ))
builtin echo ${output}
}
#### Previous logs generation
for i in {1101..1120}; do
file="${log4bash_appender_f_file}.2012${i:2:3}"
builtin echo "${file} $i"
touch -m -t "2012${i}0000" ${log4bash_appender_f_dir}/$file
done
for i in {1..4}; do
filename_caller $i
done
I expect log4bash_filename function to step into the following if only when the calculated log filename is different from the previous one:
if [ -n "${!maxBackupIndexVar}" ] && [ "${!previousFilenameVar}" != "${filename}" ]; then
For this scenario to apply, I'd need ${!previousFilenameVar} to be correctly set, but it's not the case, so log4bash_filename steps into this if all the time which is really not necessary...
It looks like the issue is due to the following line not working properly:
builtin eval export $previousFilenameVar=$filename
I have a some theories to explain why:
in the original code, functions are declared and exported as readonly which makes them unable to modify global variable. I removed readonly declarations in the above sample, but probleme persists.
Function calls are performed in $() which should make them run into seperated shell instances so variable modified are not exported to the main shell
But I cannot manage to find a workaround to this issue...
Any help is appreciated, thanks in advance!
I created a mail merge using InDesign, and it looked like it went through all of the records but (1) I can't find the option toexporttopdf and (2) I can't find the merged file anywhere on my system at all. Where is it?
I've used virtualenvwrapper, but I'm having problems running it on a new computer. My .bashrc file is updated per the instructions:
export WORKON_HOME=$DEV_HOME/projects
source /usr/local/bin/virtualenvwrapper.sh
But when source is run, I get the following:
bash: /25009.hook: Permission denied
bash: /25009.hook: No such file or directory
This previous post leads me to believe the filename is being recycled and locked because virtualenvwrapper.sh uses $$. Is there any way to fix this?
I have a scenario where I'm moving the contents of a blob stored in a core data entity into a file. I need a way toexport that data during a migration, where I know the entity that's being converted and save the blob to a file, writing the location of that file into the converted entity's appropriate attribute.
I can't seem to find a way to do this. The docs regarding the Three Stage Migration seem to indicate what can be done, but I'm not sure where to define things, or what exactly to define.
The following code prints nothing
CHECK_INCLUDE_FILE_CXX(glog/logging.h GLOG_INCLUDE)
IF(GLOG_INCLUDE)
MESSAGE("YY")
ENDIF(GLOG_INCLUDE)
But I have the following environment variable set:
export CPLUS_INCLUDE_PATH=/usr/local/include
And, "ls /usr/local/include/glog/logging.h" returns the file.
I tried using
include_directories( "/usr/local/include" )
but it doesn't work either.
The problem I've encountered is that I am using a keyboardEventListener to make a movieclip run around. As I'm a college student, I'm creating this for an assignment but we are forced to use as3 classes.
When I run the code in the maintimeline, there is no problem. But when I try to access it from another class (with an 'Export for ActionScript' on the movieclip in question) I get an error he can't address the stage.
this.stage.addEventListener(KeyboardEvent.KEY_DOWN, dostuff);
In Symfony i just have to create models with ORM Designer and export it to symfony as a schema.yml and then use a symfony command to create tables, models and forms.
I wonder if there is an equivalent to the RoR so that you dont have to create models manually by hand?
It saves a lot of time using GUI for this kind of tasks and it is less error-prone.
thanks
Do you know a framework for making presentations using only HTML5 and javascript technologies?
I'm not talking about "export" features of various presentation software (powerpoint or OOo presentation).
Some requirements for the presentations made with this "framework":
take advantage of the latest HTML5 features (audio, video, canvas?)
same with CSS3 (font support, gradient, shadows, transitions and transformations)
If there's no such thing, example of good presentations or pointers on the subject would be appreciated.
My Android application stores all user data in a Sqlite database. What are my options to backup/export/import/copy this data? I know I can easily copy the database to the SD card. I would also like to send the data to a network server. Are there any packages/classes available to facilitate getting sqlite information to/from a network server? Thanks for the help...
I have a Magento installation with around 60 attribute sets. I need to add a new attribute to each of the attribute sets. There doesn't seem to anyway of doing this in the admin control panel.
I am sure I can work it out by manually entering the correct fields into the database, but is there a way of doing this through the API or through the Import / Export profiles?
Any suggestions would be gladly received.
I created a WPF Window and made it a MEF Export.
I can do a ShowDialog once on the MEF Import but the second time it aborts because the MEF component was closed by the first ShowDialog.
What can be done to allow repeats of ShowDialog?
Hi,
I know that there are few open sourced / Free BI projects and I am looking recommendations.
I have a growing Mysql database that i got tired from writing sql queries + gui + filtering over and over again.
if i am not able to find a free one than my budget will be: (1$ - 2500$ )
My needs are:
Mysql 5 Connection.
user permissions
export options
Basic Dashboard
--
nice to have:
Web Based GUI
Development framework integration in PHP