Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [database]

System that handles large amounts of data in an organised fashion

A database is a system of handling and organising large amounts of data that can be easily created, reference or edited.

SQL (Structured Query Language) is a database computer language that is designed for managing the data in a relational database management system.

Some popular database systems include:

  • FileMaker Pro
  • IBM DB2
  • Microsoft Access
  • MySQL
  • Microsoft SQL Server
1684 questions
9
votes
1 answer

Which binlog format to use for MySQL Replication?

Just about to start using MySQL replication and I'm wondering what kind of binlog format is the best to use? There's Row, Statement and Mixed. I'm going to be using 5.1.49. Row is winning at the moment but I'm just wondering why I should use mixed…
delenda
  • 91
  • 1
  • 1
  • 2
8
votes
2 answers

Converting Filemaker to SQL or another database system

Currently at work we have a Filemaker database running on Filemaker Server 7 on a Windows Small Business Server 2003. I would like to change from using Filemaker to a different database, one with a web based front-end. It doesn't have to be MySQL,…
Will3265
  • 123
  • 1
  • 1
  • 5
8
votes
7 answers

How to avoid being scraped?

We have a searchable Database(DB) , we limit the results to 15 per page and only 100 results yet still get people trying to scrape the site. We are banning sites that hit it fast enough. I was wondering if there is anything else that we can do.…
Randin
  • 183
  • 4
8
votes
2 answers

How to raise max no of file descriptors for daemons running on Debian Jessie?

I'm playing with pgBouncer as a connection pooling system for PostgreSQL. My system is a 12-core with 64GB RAM and 1Gbps network interface running Debian 8.1. Now I want to raise the limit for open socket connections up to, say 10.000 concurrent…
LBC
  • 91
  • 1
  • 1
  • 6
8
votes
1 answer

Maintenance of tables: do I need to REINDEX a table after truncating and repopulating?

I have a table with about 2 million rows in it of transactional data that we use for analytics. Every week we reload this with new data, so we've been using TRUNCATE to clear it out and then inserting new rows. There are a couple of indexes on the…
JamesF
  • 195
  • 1
  • 2
  • 5
8
votes
4 answers

PostgreSQL service initdb doesn't work

I installed PostgreSQL 9.1.2 on my fedora 16 in a method similar to mentioned here, and tested it, which means that my installation is working fine. But when I do: service postgresql initdb or even service postgresql-9.0 initdb I get the…
c0da
  • 181
  • 1
  • 1
  • 2
8
votes
3 answers

Best practices for backing up databases

I asked this on stackoverflow, but someone pointed out it would be better to ask here. Let's assume Subversion and MySQL on a RAID NAS. What are the best practices for backing up data? I was thinking putting mysqldumps under subversionn control, and…
Matthew
  • 273
  • 1
  • 2
  • 10
8
votes
3 answers

Is it possible to have complete backup of mysql database server from command line?

$ mysqldump -h localhost -u username -p database_name > backup_db.sql I can use the line above but it is just for one db in the server, can i have a complete backup of the all databases into one backup file? Or is there some command which…
Sinan
  • 227
  • 3
  • 6
8
votes
5 answers

Best way to make sure a MySQL database is fully in UTF8

After some problems with UTF8 and none-UTF8 strings, we're standardising on UTF8. One thing I need to do is check that everything is in UTF8 in the MySQL database? What do I need to check? Server default characterset Default character set of each…
Amandasaurus
  • 31,471
  • 65
  • 192
  • 253
8
votes
1 answer

Is it possible to Managing 20 TB data using MySQL?

I am working in a project and my job is to build a database system to manage about 60,000,000,000 data entries. The project background is I have to do real-time storage for large number of messages that read from about 30,000 RFID readers every…
lemuria
8
votes
9 answers

How do you usually back up your database?

I am using mysql How often do you back up your database? How do you normally backup your database? Export all data into sql or cvs format and keep it in a folder??
mrwhy2009
8
votes
4 answers

How to restore/import an Oracle database from dmp file?

I've recently received the dump file of the soon to be migrated Oracle Database. I've installed Oracle 10g and now I need to restore the original database. Can anyone give me a step by step procedure for how to restore it from the *.dmp file ?
Paul
  • 714
  • 2
  • 6
  • 19
8
votes
2 answers

Open source DNS server with database backend

I'm looking for free opensource DNS server that can keep all the data in DB backend. Currently I found next solutions: MyDNS-ng (looks OK - fork from MyDNS) PowerDNS (looks like OK) Bind9 with DLZ (additional patches, can be tricky to configure,…
Mike
  • 374
  • 1
  • 3
  • 13
8
votes
3 answers

how to imp whole database and replace current data?

I have two database, says A and B. They are same, expect the data records are newest or old. I want to exp from the newest one (A) and imp to the older one (B). when I import to the old one by the following command imp username/password file=xxx.dmp…
jasonfungsing
  • 405
  • 2
  • 4
  • 6
8
votes
7 answers

DHCP server with database backend

I have been looking around for something to replace my (ancient) ISC-DHCPd server. A DHCP server with a database backend sounds like a great idea to me, as I could then have a nice, friendly web interface to my server. Surprisingly, I can't any…
Cory J
  • 1,568
  • 5
  • 19
  • 28
1 2 3
…
99 100