Stack Overflow
Stack Overflow

Questions tagged [database-server]

68 questions
93
votes
8 answers

How to restart remote MySQL server running on Ubuntu linux?

I'm using Ubuntu 12.04 LTS. There is on MySQL server situated remotely. I want to restart it. Can someone please give me in detail step-by-step instructions to restart the MySQL server? Following are the Database server details of MYSQL I got from…
PHPLover
  • 1
  • 51
  • 158
  • 311
13
votes
4 answers

Find out current database name (MSSQL)

If I want to know the server I can use: @@SERVERNAME Is there an equivalent function for getting database/catalog name. I know that we can set it in the script with USE statement but what if it wasnt set and I wanted to query within a sproc what db…
logixologist
  • 3,694
  • 4
  • 28
  • 46
7
votes
2 answers

PostgreSQL: Could not connect to server: TCP/IP connections on port 5432

I have an error with PostgreSQL: SQLSTATE[08006] [7] could not connect to server: Connection refused Is the server running on host "localhost" (::1) and accepting TCP/IP connections on port 5432? could not connect to server:…
Андрей Писарев
  • 151
  • 1
  • 2
  • 9
6
votes
1 answer

PostgreSQL: could not connect to server - Connection refused error

I've failed to set up postgreSQL to work with my Ruby-on-Rails project for the past week. I've tried to uninstall and reinstall, postgreSQL, twice now.But when I try to launch postgreSQL I keep getting the error below: could not connect to server:…
Jonathan Corrin
  • 1,219
  • 4
  • 17
  • 42
5
votes
2 answers

Installing MariaDB with MySQL on Mac

I am trying to install MariaDB on my Mac using brew. However, I am struggling to get this installed due to it conflicting with MySQL. I was wondering whether anyone can advise how to set it up so I have both MariaDB and MySQL as I will need both on…
lky
  • 1,081
  • 3
  • 15
  • 31
4
votes
1 answer

Dropping server on pgadmin 4

Let's say you have added a postgres cluster on pgadmin4. Does using delete/drop actually drop the cluster? or it just drops from pgadmin4? and nothing happens to the actual cluster. I am a superuser, so definitely don't want to try it. I always have…
knightrider
  • 197
  • 2
  • 12
4
votes
3 answers

MongoDB versus CouchDB... And any other "major players"

What are the major differences between MongoDB and CouchDB, and are there any other major NO-SQL database-servers out there worth mentioning? I know that CERN uses CouchDB somewhere in their LHC back-end; huge stamp of approval. What are MongoDB -…
cllpse
  • 21,396
  • 37
  • 131
  • 170
4
votes
1 answer

Can I use an embedded Derby database in a client-server db environment one in future?

Can I use an embedded Derby database as non-embedded one in future? In this case will I need to migration or I will just need to change the driver in jdbc? If it is more complicated what will I have to do?
puk
  • 193
  • 2
  • 13
3
votes
3 answers

Difference between DBMS and Database server

Could someone here please clarify the difference between a 'DBMS' and 'Database Server' please? And also, is 'MySQL', a name of a database query language or a name of a DBMS?
higgs_boson
  • 119
  • 1
  • 6
3
votes
1 answer

Developing a database server: How to send results to a client?

I would like to create my own database server for educational purposes. My problem is, I cannot really find information about how these systems work. Now, I can create databases and tables and get data from it with basic select statements. But,…
stomseven
  • 157
  • 1
  • 2
  • 8
3
votes
1 answer

Xcode 4 and Databases

I am new to programing iPhone applications. I am pretty much done building the interfaces and I built a database using Visual Studio 2008. Now I want to connect my application to that database using a SQL server as a web service (that acts as an…
Haj'
  • 31
  • 1
  • 3
2
votes
1 answer

Getting info from the Postgres stats collector

I'm working on small tool for gathering information about our postgres database and I have been looking at using the postgres Stats Collecter. It seems like there is a lot of info/stats in the table but I am having trouble understanding what exactly…
seadowg
  • 4,215
  • 6
  • 35
  • 43
2
votes
1 answer

What are the best practices for database scaling?

What are the best practices to design a scalable database? If database / tables span on multiple servers, how can I join them? Where can I get more information for this?
Krish
  • 21
  • 1
2
votes
0 answers

How many simultaneous connections can be made to a Firebird database server running on Windows XP Pro?

I have Firebird version 2.1 running as a database server on a Windows XP Pro machine. There are 35 users on my network all using the same FB server. Though not all of them may connect simultaneously I'm pretty sure at least 20 do. Why is this…
Jonathan Elkins
  • 455
  • 5
  • 21
1
vote
0 answers

ads-error 0x745 on twincat database server configuration

I am trying to set a "MS SQL server" using "twincat database server configuration", and always get the following error: "ADS error 0x745: Timeout elapsed" In the picture attach is the configuration settings I'm using, what am I doing wrong?
Gilad Shaul
  • 11
  • 2
1
2 3 4 5