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 ...
0
votes
3answers
195 views
What database server will benefit from 4 CPUs
I use MySQL server on Debian GNU/Linux machine with 4 CPUs (Linode 4096) and there are performace issue on havy load (in the middle of the day) but machine is not overload only queries are slow.
What ...
-3
votes
1answer
43 views
The two devices which facilitate storage over a network [closed]
I have been ask for specifically 'THE TWO' devices which facilitate storage over a network, powerful in addressing, failures and redundancy.
Could anyone figure out which devices these are? It seems ...
1
vote
2answers
32 views
Possible to regularly export MS-SQL tables to another DB format on Linux without complete dumps?
We have a production server running SQL-Server, which holds our backend data, e.g., customer information, sales invoices etc. The nature of this data is that "old" data can change, e.g., a customer ...
0
votes
0answers
15 views
Schedule replication of MSSQL Views to MySQL Remote database
I have a Microsoft SQL Server 2005 Database inhouse i've to publish some information on the internet and i can't (for security policy) query this database from the web server.
So i come up with the ...
2
votes
3answers
58 views
MySQL permits passwordless logins, wont let me run anything
I was attempting to allow remote logins to MySQL, so i changed /etc/mysql/my.cnf to bind to 0.0.0.0 instead of 127.0.0.1 (I was gonna put it right back, I promise!), but it didn't work so I attempted ...
2
votes
1answer
43 views
raid with replication
We are planning to buy two servers which will going to host an SQL database(PostgreSQL). The second server will work as a live replication of the first database server (hot standby). The question I'm ...
2
votes
1answer
38 views
Want to establish what MySQL DBs are “old”
I want to put some (minimal) logging on our MySQL server, with the aim of determining which DBs on the server aren't being regularly accessed. We intend to log for approximately a month, and any DBs ...
0
votes
1answer
32 views
Dedicated server probability
I have 4 websites and i plan to move them on two dedicated servers. This is the config of the dedicated servers:
Core2Duo E8400 3.0 GHz
8 GB DDR2-800 SDRAM
250 GB SATA HDD (7200 RPM)
2 TB Bandwidth
10 ...
0
votes
3answers
69 views
using NAS Server as MySQL DB server?
we are small web develepment company with 4-5 workstations. We use one of the PCs as a webserver and DB server. We are considering option to buy some NAS server (like ...
0
votes
1answer
41 views
database data lost / mysql
I reformatted my pc and reinstalled my xampp installation but never overwritten the mysql folder (option in xampp install) and did not back up my database table thinking this is safe! (what was i ...
1
vote
1answer
32 views
Create dump of database schema remotely
I have a connection to remote Mysql database. (i'm using MySQL Workbench).
I'd like to copy whole structure of the database, (without data) to create identical structure on my local machine. Is it ...
0
votes
0answers
37 views
can't connect to local MySQL server through socket 'var/lib/mysql/mysql.sock' (2)
I'm having the error 'can't connect to local MySQL server through socket 'var/lib/mysql/mysql.sock' (2)' when trying to log into mysqladmin and my sites have database connection errors.
Here's the ...
0
votes
0answers
18 views
How to setup the slave database server in a PostgreSQL database cluster?
I want to setup a PostgreSQL Cluster in an Active/Hot-Standby setup. If the active one fails, the database migrates to the Hot-Standby using Pacemaker and DRBD. No problem until this point.
I also ...
-1
votes
2answers
60 views
MDB database file moved off-site
A large client that uses my MDB based application has moved the MDB file off-site so that my application connects to it over a WAN.
How can I convince them to put the MDB file back on-site on to the ...
1
vote
2answers
45 views
Database of services and related information for various Linux distributions
I am looking for a database/list of common services and related information dovering various linux distributions. For instance for MySQL, the list would indicate that the init script is at ...
0
votes
0answers
33 views
inLoox is unable to connect to SQL Server
I just installed InLoox and configured a connection to our MS SQL Server 2005. The connection should be fine - telnet works and I can connect to the inLoox database with my query analyzer. My ...
0
votes
3answers
50 views
Assign a timeout period for MySQL queries
At the moment on our server, my boss has shell access and runs SQL directly through the mysql application, but sometimes he creates a bad query and the MySQL DB dies until i can kill it (or wait out ...
0
votes
0answers
24 views
Java: Accessing online database
I made a Java program which accesses a database. During the development phase I used a local database (XAMPP with MySQL), but when I tried to access 2 different online databases (a commercial and a ...
-3
votes
1answer
65 views
How to setup a mail proxy which logs all emails to a database?
I'd like to setup a POP/SMTP proxy which logs all emails to a database. Nginx does support POP3 and SMTP but I didn't find any possibility to log the mails to a database.
Unfortunately the existing ...
2
votes
1answer
54 views
Is it safe to modify innodb_data_file_path value for mysql 5?
I recently experienced data corruption after changing the value of this parameter in my.cnf from :
innodb_data_file_path = ibdata1:10M:autoextend:max:128M
to :
innodb_data_file_path = ...
1
vote
0answers
41 views
PhpMyAdmin Missing parameter:
Everything was working fine until this moment I want to create a new database and I'm receiving this error
db_create.php: Missing parameter: new_db (FAQ 2.8)
Also when I was trying to export my ...
1
vote
2answers
27 views
Cherry pick and import tables from remote mysql database into local?
I have a local mysql database called intranet_production, and on a remote server (which I have root access to the server and mysql) there is a database called 'extranet`.
Within the remote extranet ...
0
votes
1answer
31 views
Not all the table in mysql show in phpadmin
I recently accidently dropped my whole database for Wordpress, but luckily I've backed with Time Machine.
The problem now is when I copy the database file back to the path where I store all the ...
-1
votes
1answer
49 views
How Do I Configure SQL Server 2005 Backend?
I am trying to develop an inventory/payroll system for a factory. The information will be stored on a server, Windows Server 2008 R2, and SQL Server 2005. I'm going to store the records on the server, ...
1
vote
2answers
27 views
How to have oracle database accessible remotely
I can connect to my oracle database using localhost:1521. However, connecting to the IP address does not work.
I'm trying to do this because I am trying to connect to my database using another ...
2
votes
2answers
23 views
What limits are imposed for mysql user creation?
MySQL 5.1.x
What is the cost of an account on disk when it is created in MySql? Also, what is the max number of accounts you can create?
-1
votes
2answers
118 views
My MySQL database is getting hacked nonstop [closed]
Possible Duplicate:
My server's been hacked EMERGENCY
My MySQL database is getting hacked daily.
Hackers are uploading shell and files in others cpanel to the server,
and getting the ...
0
votes
1answer
80 views
Connect to Oracle Database that is hosted in a Virtual Machine from the host machine
Good day,
I've just setup a Virtual Machine (using VirtualBox) of Oracle Linux with Oracle Database in it. After setting it up, I can verify that I can connect to it using sqlplus (sqlplus of the ...
1
vote
4answers
79 views
How to load large SQL file into mysql
I have a database backup of a MySQL database that is about 250MB. I made it with mysqldump
I was trying to load it on another server like so:
mysql -u xxxx -pxxxx data_mirror < dbdump.sql
I was ...
0
votes
2answers
70 views
Setting up Oracle Database in Oracle Linux
Good day,
I am trying to install Oracle Database in Oracle Linux. However, it is looking for some dependencies. Anybody knows where I can get them?
Package: gcc-3.4.6 FAILED
Package: ...
1
vote
1answer
35 views
MySQL connection issue with error 2003 / 111
I'm running a mysql server using the following command:
mysqld --no-defaults --user=root --port=3310 --bind-address=0.0.0.0 --skip-grant-tables &
My understanding is that this command starts ...
4
votes
3answers
285 views
What is more important for a database server? Mem? Mem speed? Cores?
I am going to be moving my database server to somewhat better new hardware. The current database server does not have any problems except that it is running Centos 4. The current hardware is 2 quad ...
1
vote
1answer
50 views
how to decompress a local drive?
I have local drive in my system. The file system in my drive is NTFS. Some days ago I compressed my drive by disk cleanup for releasing free space.
But when I want to attached my sql database with ...
1
vote
1answer
47 views
Database Server Hardware components (order of importance), CPU speed VS CPU cache vs RAM vs DISK
I am new to database world and would like to know what are crucial hardware specs when it comes to database performance. I have searched the internet and found this so far (In order of decreasing ...
0
votes
0answers
17 views
How to set maximum size limit of sql2008 database?
Is there any way to set maximum size limit of a database in sql server 2008 without writing sql script? I have a dedicated sql server in which more than 20 databases are hosted. I want to limit all ...
-3
votes
1answer
81 views
How do you host a big data web application? [closed]
Affordable alternative to Linode.
I am using linode to serve my web application. The application serves, what I consider big data using ~ 30GB for our model US State and we serve a few hundred ...
0
votes
1answer
74 views
What prevents banks from creating money in their database? [closed]
I was wondering: If banks store all the account balances in a database, what keeps them from going into said database and "creating" money by changing the data (Replacing 10 000 $ with 100 000 $ is ...
0
votes
1answer
62 views
Restoring MySQL dump - ERROR 2006 (HY000)
I am just trying to restore a mysql dump. Below are the command and error message.
Can anybody give me some clues how to approach this?
10:54:16 Restoring ...
1
vote
2answers
64 views
How to leave only e.g. TOP 100 records in ALL TABLES in database (SQL SERVER 2005)
I'm having a huge database over 100GBs and I need to burn an application (for demonstration purposes) on CD or DVD which uses this huge database... is there a way how to leave for example only first ...
2
votes
1answer
24 views
Formatting data from management database
I've got some data that goes like this:
Config_Name Question Answer
Cisco WAN Sensitivity: High
Cisco WAN Authorized Users: Brent, Charles
Cisco WAN Last Audited: n/a
...
1
vote
1answer
66 views
How does Oracle Database Standard Edition (One) benefit from running on a dual CPU server?
I am evaluating the impact of additional CPUs on Oracle database performance.
I am looking to license Oracle Standard Edition One (SEO, being most cost effective) or Oracle Standard Edition (SE). As ...
1
vote
0answers
110 views
mysql error : "cant connect to local mysql server through socket
Taps Server Error: Mysql::Error: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
I get this error whenever I try to push my local mysql to heroku postgres. It ...
0
votes
1answer
43 views
How to create one update query (mysql) on multiple databases
I have several DBS on the same mysql server.
The DBS's structure and schema are exactly the same (only data is different)
the query on certain db works well like this (written in phpmyadmin)
UPDATE ...
0
votes
1answer
37 views
HP Proliant Servers DL380 G3
I've bought 2 hp G3 servers with Smart Array 5I Storage Controller, how can I install the MYSQL on the array storage so that the linux on both server can read the DB, I'm kinda lost here.
This is ...
1
vote
1answer
52 views
MySQL master-master replication between database running on 3 different server
I am trying to implement a master-master replication between 3 MySQL Databases running on 3 different servers.
I implemented master-master replication for 2 servers, but can't figure out how can I ...
0
votes
1answer
52 views
MS SQL Server not running on Win7
I have installed all of the available components of "MS_SQL_05" as a named instance on Win-7. I had a default instance running of MSSQL08. While installing the MSSQL05 instance I choose to use windows ...
1
vote
3answers
31 views
database replication for new user signup
I have a database that stores the users of my application. When a new user signs up, a record is inserted into the database for that user. I have a replicated version (slave) of this database (using ...
0
votes
1answer
35 views
Can't save DB password in BDE Admin v5.01 (c. 1998)
I have a legacy version of Goldmine running which uses BDE to connect to an SQL2005 server. I'm moving the goldmine application and its database onto a new server and all is fine with the exception of ...
1
vote
4answers
145 views
Is 2-5 ms between web and database server appropriate? (Different Datacenters)
I currently have a dedicated web and database server running in datacenter (DC) 1. Im about to expand with yet another web server in datacenter 2 that will talk to the db in DC 1.
The latency ...
2
votes
1answer
34 views
Performance issues with securing remote database connection
I am involved in creating a system where the web application and the database won't be hosted on the same LAN or WAN, i.e. data will be transferred across public network. The web server and database ...
Community Bulletin
Related Tags
mysql× 302sql-server× 142
linux× 73
postgresql× 73
sql× 72
oracle× 64
backup× 56
database-administration× 51
sql-server-2008× 44
sql-server-2005× 33
replication× 32
performance× 32
webserver× 24
database-performance× 24
security× 22
windows× 19
php× 19
ubuntu× 18
mysql-replication× 17
restore× 16
scalability× 16 mysqldump× 15
innodb× 14
raid× 13
connection× 13
