You've just run into a peculiarity of psql on Windows.
In my comment I just wanted to exclude the possibility that you really didn't have the necessary permission. Then it turned out that even on Windows, you have to use 'normal' slashes instead of backslashes, that is:
\i 'C:/Users/Work/Desktop/School Work/load_database.sql'
should work fine ...
(Note: Not much of this is relevant to readers using PostgreSQL 9.2 or above from the EDB installers, which now have a greatly simplified default install using the NETWORK SERVICE, though you can still configure other accounts).
I have used net user postgres postgres
to reset the password for my database but instead of a success message I am getting "...
SQL Server instances have separate sets of binaries for each installation. For the base engine, you will have separate SQL Server and SQL agent services that can run under separate accounts. They each have their own configurations and users. This is also true for other components like Analysis Services and Reporting Services if you install them.
In MySQL 5.6, ibdata1 includes 5 InnoDB in the mysql schema.
mysql> select table_name from information_schema.tables
-> where table_schema='mysql' and engine='InnoDB';
| table_name |
| innodb_index_stats |
| innodb_table_stats |
| slave_master_info |
| slave_relay_log_info |
Looking at the my.ini, I have two suggestions
I would bump up the following settings in your my.ini
This will make some joins and sort stay in memory. Of course, once a JOIN or an ORDER BY needs more than 4M, it will page to disk as a MyISAM table.
If you cannot login as root@localhost, then restart ...
What made my SQL server listen for TCP connections on port 1433 was the following...
Configuration Tools / SQL Server Configuration Manager
click the instance name in SQL Server Network Configuration
enable TCP communication
Right-click the TCP communication entry, choose Properties
Click the IP addresses tab
Enable all non-VMnet IP addresses and enter 1433 ...
Think of the data file as a container, like your fridge. The fridge doesn't tell you when the milk is bad (ok, maybe the Jetsons' fridge does) - you need to check inside.
For SQL Server, the timestamp in Windows has nothing to do with the data you are changing inside the file; it has to do with the last time the file itself has changed, such as a service ...
Open up a command prompt
Start -> Run -> "cmd.exe"
Start sqlplus as administrator
sqlplus / as sysdba
There's a system stored procedure called get_env for retrieving the value for ORACLE_HOME, thanks Sabdar Syed for the query.
SQL > var OHM varchar2(100);
SQL > EXEC dbms_system.get_env('ORACLE_HOME', :OHM) ;
SQL > PRINT OHM
Should return ...
Is there any reason NOT to use the approach you've defined? Absolutely.
Imagine you had bought a car - a car that when you hit 50MPH the engine starts to overheat. Would your reaction to this situation be to artificially limit the car to 49MPH, or to find out what the fault is with the engine?
Why should you limit your car to 49MPH? The manufacturer stated ...
this bug is reported in MySQL Forums (67179) and the solution is mentioned here. please note that you should do clean-up, before creating tables
temporary fix for problem with windows installer for MySQL 5.6.10 on Windows 7 machines.
I did the procedure on a clean installed MySql, and it worked for me, at least it stopped
lines of innodb errors in ...
Locate your postgresql.conf in the datadir
Find the section that looks like this
# ERROR REPORTING AND LOGGING
# - Where to Log -
#log_destination = 'stderr' # Valid values are ...
I answer my own question here for completeness
I will select @RolandoMySQLDBA as the preferred answer because it gave me the most hints even though it didn't actually solve my problem.
Below are the results of my investigation
MySQL on Windows just creates lots of temporary tables and tuning MySQL by modifying the content of the configuration ...
Why 52395 instead of 1433
Named instances listen on dynamic ports. Is the job of the Sql Server Browser Service to inform the clients of the actual port. The Sql Browser listens on UDP 1434 and answers questions of the form 'what is the listenning port of instance "foo"?'. Sql Server Browser service is required for both TCP and named pipes protocols. ...
SIDs in the form of 0x01020000000000052000000021020000 are not "SQL Server" SIDs. That is simply the underlying binary value of the SID. Another form it can take (and still be the same value) is the "string" form (SID String Format Syntax), which looks like S-1-5-32-545 (referred to as being the "SDDL" format in some MSDN documentation, though SDDL covers ...
While I agree with Rolando's recommendation to change innodb_flush_method, I wasn't 100% clear what you meant by:
it did not make the actual MySQL setting changed
I want to point out the caveat that making a change to the GLOBAL variable affects any new connections, but does not modify the current session (emphasis mine):
The global variable change ...
There is nothing MySQL has that will indicate the progress of OPTIMIZE TABLE;.
You may have to go the OS using Windows Explorer and look for a growing tmp table. Hint: Temp table are MyISAM tables that do not have a .frm file with the name #sql-9999.MYD and #sql-9999.MYI. While these two fle exist, the query would be considered in progress. To know how far, ...
Erik Darling mentioned the biggest practical reason for not using WSRM in a comment on your question:
...there's no reciprocal limiting of CPU use in other processes. SQL Server may not use those two cores, but other things may use the other 30 SQL Server is using. It's a crapshoot, really.
If this is working for you, then stick with it - we're all busy, ...
Since you're on Windows and are probably starting PostgreSQL as a Windows service, you'll need to edit postgresql.conf (inside your data directory) to set the new port there, then restart the postgresql service using the Services control panel or (as an Administrator) the net service command.
You can use a programmatic text editing tool to change postgresql....
I was having this issue on Windows 7 64-bit and the following solution is what worked for me (via http://igordcard.blogspot.com/2012/03/unable-to-write-inside-temp-environment.html):
To understand why this error was happening, I went to my TEMP folder and read the log from the PostgreSQL installer: C:\Users\myuser\AppData\Local\Temp\bitrock_installer....
You can disable MySQL service from the Command Line (make sure you Run it as Administrator).
To disable service start on Windows startup (this will not stop the service if it is currently running):
sc config mysql start = manual
To stop the service:
net stop mysql
Open Windows CLI as Administrator and Shutdown MySQL
net stop mysql
Copy the Data to D:\ProgramData\Data
xcopy /s C:\ProgramData\MySQL\MySQL Server 5.6\data D:\ProgramData\Data
Create or edit C:\ProgramData\MySQL\MySQL Server 5.6\my.ini
Add this to the my.ini
datadir = D:/ProgramData/Data
net start mysql
If you can not execute ...
Here is a start, if I can guess that by row you actually mean column:
[table] = QUOTENAME(OBJECT_SCHEMA_NAME([t.object_id])) +'.'+ QUOTENAME(t.name),
[column] = c.name
FROM sys.tables AS t
INNER JOIN sys.columns AS c
ON t.[object_id] = c.[object_id]
ORDER BY t.name, c.column_id;
This doesn't provide exactly the output you want, but surely your ...
There are a number of options and please don't limit yourself to my answer here. In particular you may find array-native databases to be of help. My answer is going to be specifically about your questions on SQL-based databases.
It sounds to me like this is a question of geospacial information. SQL-based databases are in fact used in such fields quite ...
Long shot perhaps, but worth checking file
\Program Files\Microsoft SQL Server\100\DTS\Binn\MsDtsSrvr.ini
or the equivalent on your setup. You may have to manually edit it with the instance name. Otherwise SSIS connections might be looking for an msdb of a default SQL instance that doesn't exist.
Bit of a carbon copy of a previous answer...
Personally, I disable it at both ends of the pipe but the problem usually manifests at the database end (due to the comparatively high traffic). As described in this MSDN blog post, I would start with disabling in the OS with:
netsh int ip set chimney DISABLED
It may be necessary to disable the features at the ...
Replication setup on a windows server is equivalent to doing it in other systems: The official manual provides you a detailed guide. In short:
Configure on both servers a different server-id, and activate the binary log on the master. If it is not already done, the most typical way to do that is modify the my.ini file and restart the service (net restart ...
I may be running a more recent version of MySQL, but what I had to do to disable this was:
Run the MySQL Installer (located at C:\Program Files (x86)\MySQL\MySQL Installer for Windows)
Click the wrench icon
Un-check the box to check for updates
Honestly, sa or a disabled SQL Server account with absolutely minimum permissions is the best choice. As to why? Well, I could write out three or four paragraphs on that, or I can share my favorite article on What account should own the databases and why. A very thorough explanation covering all the bases. Highly recommended.
Here's a core excerpt: (Edited ...
go to ..\PostgreSQL\9.0\data and open the file postgresql.conf in text editor/notepad
search for port parameter .eg: port = 5433
edit this to your port number.
go to run type services.msc and restart postgresql service.
you can check wether the parameter is set or not via query tool. just execute show port query. it will display your current port ...