Stack Overflow
Stack Overflow

Questions tagged [database-server]

64 questions
72
votes
6 answers

How to restart remote MySQL server running on Ubuntu linux?

I'm using Ubuntu 12.04 LTS on my machine. 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…
PHPFan
  • 4,000
  • 11
  • 50
  • 104
5
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
  • 131
  • 1
  • 6
4
votes
1 answer

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:…
Андрей Писарев
  • 111
  • 1
  • 1
  • 8
4
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…
heady12
  • 674
  • 1
  • 10
  • 21
4
votes
2 answers

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
  • 839
  • 3
  • 13
  • 37
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
  • 20,270
  • 35
  • 127
  • 168
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
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
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,033
  • 6
  • 32
  • 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
  • 333
  • 2
  • 18
2
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'
  • 21
  • 1
  • 3
1
vote
1 answer

How to safeguard my mysql_connect password (My database server's password)?

*This question is for NON-local host's. *I am using a web-host service. NOT my personal server. To use mysql_connect, to connect to a database's server, one needs to create a php file and save it in the web host's server. This file must have (within…
Omar
  • 11
  • 1
1
vote
1 answer

DB Server Requirements Advice

I am building a MySQL database with a web front end for a client. The client and their staff will use this webapp on a daily basis, creating anywhere from a few thousand, to possibly a few hundred thousand records annually. I just picked up a second…
Garfonzo
  • 3,488
  • 6
  • 37
  • 70
1
vote
2 answers

how to config apache point to another index in different server?

I am configuring 3 tiers setup(webserver, database server, and application server). I want to separate everything into 3 three servers. I have already separated between the application server and the database server. Regarding to webserver and…
Kimly Vith
  • 53
  • 5
1
2 3 4 5