The tag has no wiki summary.

learn more… | top users | synonyms

1
vote
0answers
70 views

What to do with unused RAM on a MySQL database server?

For years I have been running dedicated servers with more or less limited ressources, resulting in unsatisfying performance of the web application (Drupal). Tools like Matthew Montgomery's MySQL ...
0
votes
0answers
37 views

Mysql, performance problems with big database

I am running on Windows 7 64 bit with 4 GB RAM (used for Drupal based website). I have database dump of about 1.5 GB. After re-installing my XAMPP server, my MySQL server began working too slow. I ...
0
votes
0answers
34 views

Probable database replication issue in LAMP setup with Master/Master MySQL replication

I have been facing issues in my high availability failover (on WAN links) LAMP setup hosting a Drupal CMS based site, approximately after every 2 months both servers suddenly stop responding to http ...
0
votes
1answer
311 views

My database keeps crashing on startup how can i repair it without it running?

I've got some problems with my database. I hope somebody can help me out. Problem: The database keeps crashing on startup. In my log i see a couple off these errors: [ERROR] /usr/libexec/mysqld: ...
0
votes
1answer
85 views

Combine results from two queries?

I need to combine the results from two queries into one result set and order them altogether. This is the working, raw SQL code I have: SELECT * FROM ( SELECT t1.id AS entity_id, ...
0
votes
0answers
42 views

Drupal database differential restore mysql

I have several Drupal sites hosted on my shared hosting server. Each site has a dev, test and production instances, with separate Docroots and Apache Vhosts and separate mysql db instances. ...
0
votes
0answers
168 views

Drupal database doesn't work after MySQL restart

I've installed Drupal 7x on my local XAMPP 1.8.3 Server. Everything went fine but after adding some modules, changing the drupal theme and restarting the MySQL Server, the MySQL Server is dropping ...
0
votes
0answers
73 views

Query take a long time! Is that server issue?

When Query runs on Server (shared-server) it takes (2.5332 sec) But when I run the same Query on another Server (dedicated-server), it takes only (0.0205 sec). I don't know where is the issue! Is ...
1
vote
2answers
119 views

What is proper database design for a drupal table with an order field?

I am adding a custom widget to an instance of Drupal 6.x & MySQL 5.5 and came across a problem with updating rows. I have a table of recipe ingredients where multiple ingredients are tied to a ...
0
votes
1answer
98 views

Why does copied MySQL database have different data than source?

I am trying to migrate database A to database B. I have tried various methods for this, including... Using Navicat, do Tools > Data Transfer, copying structure and data from A to B Using Navicat, ...
1
vote
1answer
2k views

mysqldump: Got error: 1017: Can't find file: 'drupal_install_test' (errno: 2) when using LOCK TABLES

I'm trying to backup a drupal site database but I'm having some issues. When I ran the following command: mysqldump -uroot -p drupaSite > drupaSite.sql I get the following error: mysqldump: Got ...