Questions tagged [database-administration]
296 questions
-1
votes
1 answer
Moving MYSQL database Cache issue?
I moved a mysql (myisam) database using rsync to aother server, I realized after doing this that I forgot to run 'flush tables' before moving the files so not all changes were written to disk I guess.
I did this out of hours but I was wondering how…
Leoric80
- 49
- 1
- 5
-1
votes
2 answers
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using Password:YES)
root@test-2:/usr/local# mysql -u root -H 192.168.x.xxx -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
sivashanmugam
- 37
- 2
- 6
-1
votes
1 answer
Database management
First of all please forgive me if this question is off the topic. I have a developed social networking site where users can upload photos and update status. I thought of hosting in AWS EC2, but to get started it required a credit card which I don't…
Robin
- 109
- 3
-1
votes
1 answer
InnoDB Failure of some kind
I have MySQL 5.5 installed. I tried to install Joolma but it failed. I went into their sql and replace EGNINE=InnoDB with MyISAM and the install worked.
InnoDB is listed under SHOW ENGINES;
Any idea what the cause is or how to fix this so other…
Tiffany Walker
- 6,681
- 14
- 56
- 82
-1
votes
1 answer
MySQL Configuration on my.cnf
[mysqld]
core-file
default-storage-engine=MyISAM
max_connections = 5000
max_user_connections = 5000
key_buffer = 1024MB
myisam_sort_buffer_size = 512M
join_buffer_size = 256M
read_buffer_size = 256M
sort_buffer_size = 256M
read_rnd_buffer_size =…
Nikki Wilson
- 101
- 1
- 7
-1
votes
1 answer
Linking LDAP with other databases — design considerations
There's a company X (a call center) with about 300 workstations and a task to implement LDAP for user authentication. Fine. We put non-volatile user information (UIDs, e-mails, first and last names) to LDAP directory – everything by the book. There…
badbishop
- 928
- 4
- 12
- 21
-1
votes
1 answer
How to manage many identical instances of a MySQL schema over many machines?
I'm working on a project that has a MySQL database schema that's used on three different servers (MySQL databases) into 20 copies of the schema for each server (which are all identical in form but contain different data).... so 60 copies of the same…
user1290173
- 3
- 1
-2
votes
1 answer
how to initiate and maintain mongo shard replica set from mongos server?
I am trying to initiate a mongo shards replica set from mongos server, I want my mongos to maintain replica set and able to add new server to replication if needed.
siva nagi reddy
- 3
- 2
-2
votes
4 answers
will a 100GB database with large tables on MSSQL 2008 server run on a 3GB RAM system?
This will be only for testing and developing.
I have a 100 GB DB I am working on and need a sanbox envorinment.
The only hardware I have is a desktop with 3GB and 32bit.
I am able to install SQL 2008 Ent 32-bit (trial) on XP with no issues.
Will…
user168534
- 1
- 1
-3
votes
1 answer
How should my company bring its product, a line-of-business MVC application, into the cloud?
I am a recently-hired junior software engineer at a small company that develops and sells a normal client/server MVC application to small and mid-level enterprise clients in a particular line of business. (I'm leaving specifics out for anonymity.)…
presidentsandals
- 7
- 1
-4
votes
1 answer
mysql remote server connection fails
I'm working on this for 4 days and I know it is all over google, but I did all the required stuff but still no connection.
I created to 2 vagrant boxes, one for web server and one for mysql.
web: 192.168.50.50
mysql: 192.168.40.40
I edited the…
Tzook Bar Noy
- 155
- 1
- 5