Common Support Questions
Administrator privileges are not required to install RazorSQL. However, the default setting for the Windows installer is to install RazorSQL in the Program Files directory, which is probably not writeable for your logon id if you do not have administrator privileges. There are two ways to get around this: 1. The easiest is to download the latest razorsql<version>_windows.zip file from https://razorsql.com/download.html to your desktop. Then extract the zip file and navigate to the razorsql<version> directory and launch razorsql.exe or razorsql.bat. 2. The second way is to launch the razorsql<version>_setup.exe Windows installer and when given the choice as to where to install RazorSQL, be sure to change the directory from the Program Files directory to a directory you have write access to such as your desktop.
For newer versions of RazorSQL, RazorSQL ships with "himem" files that can be used to launch RazorSQL with higher memory settings. Listed below are instructions for how to launch RazorSQL with these files: Windows: On Windows, RazorSQL ships with a file called razorsql_himem.exe. Launching RazorSQL with this file quadruples the max memory limits of the normal razorsql.exe file. To launch RazorSQL with the higher memory settings, either launch RazorSQL by double-clicking the following file: <razorsql_install_dir>\razorsql_himem.exe or rename the existing razorsql.exe file to another name and rename the razorsql_himem.exe file to razorsql.exe. macOS: To change settings on newer signed versions of RazorSQL on Mac machines that have Gatekeeper: 1. Copy RazorSQL.app and paste it on your hard drive to something like RazorSQL 2.app 2. Inside the new RazorSQL 2.app folder (right-click and select Show Package Contents), delete the Contents/_CodeSignature folder 3. In the Contents/Info.plist file, there is a line near the bottom that looks like this:
-XX:MaxRAMPercentage=40Change 40 to a higher percentand save the Info.plist file and then re-launch RazorSQL to allow RazorSQL to use more memory on your machine. Older versions of Mac OS X: Older versions of RazorSQL have an "Adjust Memory Settings" option in the Help menu. Use this option to increase RazorSQL's memory settings. For older versions, RazorSQL ships with a custom Info.plist file on Mac OS X that contains higher memory settings. To launch RazorSQL with the higher memory settings, navigate to the following directory: /Applications/RazorSQL.app/Contents To get to this directory, right-click on the RazorSQL.app file and select "View Package Contents". Then open the "Contents" directory. rename the existing Info.plist file to something like Info.plist.old rename the Info.plist_himem file to Info.plist Relaunch RazorSQL and RazorSQL will now use increased memory settings. Linux: RazorSQL ships with a custom shell script launcher called razorsql_himem.sh. Instead of launching RazorSQL with the razorsql.sh script, use the razorsql_himem.sh script to launch RazorSQL. The following instructions contain information on how to change RazorSQL memory settings for older versions of RazorSQL: For Windows machines, the max memory setting is contained in a file called razorsql.bat located in the RazorSQL installation directory. In this file, there is a line containing the text -Xmx384M or -Xmx256M depending on the version of RazorSQL you are using. Increase the number before the M, which stands for MegaBytes, to increase the memory. To take advantage of the change, RazorSQL must be launched by double-clicking razorsql.bat. For Mac OS X machines, right-click on the RazorSQL application file and select "View Package Contents". Edit the Info.plist file. In this file, there is a line that contains either -Xms16m -Xmx256mor -Xms16m -Xmx384mdepending on the version of RazorSQL you are using. Increase the 256 or 384 number to increase the memory. For Linux / Unix machines, edit the razorsql.sh shell script. Increase the number after the -Xmx to increase the available memory for RazorSQL.
There are a couple of ways to save the queries depending on how they were executed. For individual queries, the easiest way to save the query is to press the "Save Query" button located on the query results toolbar or the "Save Query" option located in the right-click menu of the query results tab. You will then be prompted for where to save the query to on your file system. If you typed the query into the sql editor, you can do a File -> Save or File -> Save As to save the editor contents to a file on your computer. If you did not execute the query from the editor, but used the navigator or query builder to execute the query, you can click on the "view query" icon in the query results toolbar or right click on "Query 1" and select "View Query" to see the query that was executed. You can then do a control-A / command-A and control-C / command-C to copy the query to your clipboard. Also, all queries you execute are stored and can be viewed by selecting Connections -> View SQL History or Connections -> View Query Log. The SQL History by default stores 20,000 lines of history. The query log stores the history for the current connection.
For older versions of Mac OS X,
RazorSQL ships with a 32-bit launcher for Mac OS X. This launcher is
compatible with both 32-bit and 64-bit Macs. However, RazorSQL will
be launched in 32-bit mode even if the machine is 64-bit.
The main advantage of launching RazorSQL in 64-bit mode as opposed to 32-bit mode is the maximum amount of memory that can be addressed by RazorSQL is greater in 64-bit mode.
To change the RazorSQL launcher to the 64-bit launcher, use the following instructions:
Open up a terminal window and execute the following commands:
sudo mv /Applications/RazorSQL.app/Contents/MacOS/razorsql /Applications/RazorSQL.app/Contents/MacOS/razorsql32
sudo cp /System/Library/Frameworks/JavaVM.framework/Resources/MacOS/JavaApplicationStub /Applications/RazorSQL.app/Contents/MacOS/razorsql
RazorSQL ships with an exe file on Windows called razorsql_readonly.exe. This file is located in the RazorSQL installation directory. To launch RazorSQL in read-only mode, either launch this file by double-clicking it, or rename the existing razorsql.exe to something else, and rename razorsql_readonly.exe to razorsql.exe and launch via the normal RazorSQL shortcuts.
On a small number of systems, RazorSQL's use of acclerated graphics may cause problems ranging from
flickering windows to instability or crashing. RazorSQL ships with special files for Mac OS X, Windows, and
Linux that allow RazorSQL to be launched with graphic acceleration turned off.
Windows:For older versions of RazorSQL, launch RazorSQL via the razorsql_no3d.exe file located in the RazorSQL installation directory, or rename the existing razorsql.exe file to something else and rename razorsql_no3d.exe to razorsql.exe and launch RazorSQL via the normal shortcuts. For newer versions of RazorSQL, there is an exe file named razorsql_noaccel.exe in the RazorSQL installation directory. Launch RazorSQL with this exe file to completely disable hardware acceleration.
Mac OS X: RazorSQL ships with a custom plist file called Info.plist_no3d. This file is in the RazorSQL.app/Contents/Info.plist_no3d location. To launch RazorSQL without accelerated graphics, rename the existing Info.plist file to Info.plist_normal and rename Info.plist_no3d to Info.plist. You may need to copy the entire RazorSQL.app directory and launch from the copied RazorSQL.app to get the operating system to recognize the changed Info.plist.
Linux: RazorSQL ships with a razorsql_no3d.sh script. Launch RazorSQL via this script to turn off accelerated graphics.