The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
0answers
21 views

Combining 2queries: One filtered Users on Role, One Select users with only one specific role

First query: Selects All users with specific rid ( 3 or 4 or 19 or ...). SELECT u.uid AS uid, u.name AS name, fn.field_full_name_value AS field_full_name_value FROM users u LEFT OUTER ...
0
votes
1answer
25 views

Count(*) as rolecount, filter by rolecount = 1

How can i filter out the rows who only got rolecount = 1? WHERE rolecount = 1 gives an error. Can't really figure out how to do it. SELECT u.uid AS uid, u.name AS name, u.picture AS picture, ...
1
vote
0answers
210 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
52 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
41 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
604 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
103 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
188 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
78 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
131 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
105 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 ...