MySQL
This group mission is to address MySQL related issues in Drupal modules development process or discuss efficient use of MySQL within Drupal based projects.
Drupal Developer, 6 month contract, UK | LinuxRecruit
LinuxRecruit are looking for a Drupal Developer for a Drupal consultancy in the UK. Possibility of remote working (must be UK based)
Call 020 8432 2232 or email tony.chapman@linuxrecruit.co.uk for full details.
Referrals very welcome and we have a very generous referral scheme
Custom search results
Hi everyone
I have been messing with Drupal and other CMSs for a while (3+ years). But I chose Drupal and stack with it since then no matter how hard the learning curve was.
So far whenever I had issues either I figure it out or search Drupal.org site for any possible solutions time being sacrificed. But now I want to save time and be efficient expediting my projects getting direct help from all my groups. Most issues being discussed here are grabbing my attentions because they are very important that's why I joined so many groups.
Senior Drupal Developer | LinuxRecruit
Drupal Developer - Senior, London
Creative Digital organisation in London are looking for a Drupal Developer on a 6 month contract.
You will be an experienced Drupal Developer and have been working with for a number of years.
We're looking for someone who has extensive PHP, Drupal, MySQL Experience.
If you're interested in discussing further please contact Tony Chapman on tony.chapman@linuxrecruit.co.uk or 020 8432 2232
How to seach text from .txt file
i need this help on drupal.
i have a text file and file name is C:\wamp\www\mysite\sites\default\files\abc.txt. in this file is;
aaaaa bbb
ccccc ddd
eeeee fffff
if i type aaaa in the search box and hits enter means the output should come with the node containing the word aaaa and this this text document also.
This will be shown in search output
is there any module available for that?
thanks.
PHP Developer | Capital Markets Placement
Client: Fortune 500
Location: Herndon, VA
US residents only (incl. H1B visa holders)
Candidate should have more than 8 years of professional and software design and development experience. The candidate should also have extensive experience in designing the architecture and managing future enhancements for an enterprise wide web based solutions. Further, the candidate should have proven track record of proposing system innovations and advancement in order to keep up with the new technology.
General Experience:
- Web development in LAMP architecture
- Fluent in PHP including 5.3.x
MySQL DBA | Brill Street + Company
Requirements:
Responsible for the MySQL and other open source database servers, including production, test, and development.
Assist in support of all other databases and be part of a dynamic and fast paced team
Improve the performance and reliability of the databases and customer experiences.
This job is approximately 75percent database config & sysadmin responsibilities.
The other 25percent is understanding of the underlying data to ensure that the database and data are optimized for the best overall performance..
Qualifications:
Lead Web Development Manager | World Trade Group
Lead Web Development Manager (PHP) - You will be responsible for the development of new web & mobile applications using open source CMS platforms, leveraging an extensive CRM system. Reporting to our Global Head of Web Development in the planning of overall company strategy, you will manage and coach an expanding team of web developers.
Database development prior to MySQL
I am seeking advice about what might be the best database program to use to create a large pre-MySQL database, from which I will select the content to export/import/enter into a Drupal MySQL database.
I am developing my first Drupal site -- a web portal where information will be organized by relevance to various generations. The site will launch with a Baby Boomer orientation, with information organized for various baby boomer niches, and then expand to serve more generational niches.
slow term_data and term_node queries
Hello,
I've been trying to figure out why our drupal site is going slow . . . this has ranged from disabling modules (update status and statistics) to looking into the slow queries log.
When I look into the log, the overwhelming majority of the entries are from term_data or term_node
E.g:
SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid = v.vid WHERE r.vid = 169 ORDER BY v.weight, t.weight, t.name
and
Porting drupal's database to MySQL Cluster possible?
Hi guys, my organization is running a MySQL Cluster 7.x. I have been quite comfortable to port some of our MySIAM type tables to MySQL Cluster's NDB type.
I found that drupal uses innoDB, so I am wondering if it's possible to port it to NDB type?
FYI, MYSQL Cluster NDB doesn't support few things in innoDB include foreign key constraints.
http://dev.mysql.com/doc/refman/5.0/en/faqs-mysql-cluster.html
Any opinion will be welcomed.
Derrick
SQL select query for returning all roles and permissions
Hi everybody,
I want to create a select query to return a list of all roles and their related permissions directly from a MySQL database. Does anyone have a good one for that?
Thanks,
Thermal
Move MySQL databse & Show the Ropes | The Ouverson Group, Inc.
I need help with 2 things:
- I need help moving MySQL database from one host to another. Maybe even clean-up the database after the move.
- I need person to "show me the ropes" so I can do 2nd, 3rd, etc.
I am savvy to LAMP stack and Drupal, but have never done a mysqldump, migration, etc. and am under time constraint so I'm willing to pay for help.
I need someone who is super-savvy to MySQL and Drupal.
Please feel free to call me on my cell: 239-249-2842 or email: doug@ouverson.com
SQL ICE Demo for Drupal Users - Webinar Tues, March 22
SQL ICE Demo - How to Use SQL ICE to Access Your Drupal Data
Join us for a Webinar on Tuesday, March 22, 10am Central
Reserve your Webinar seat now at:
https://www1.gotomeeting.com/register/882042968
Are you a Drupal user and do you know SQL? If you answered "yes", then SQL ICE could be a useful tool to have on your desktop.
In this session, we will demonstrate how you can use SQL ICE to access your Drupal data, using the same version of SQL ICE (v.1.1.1) that is available as a free download from our site, to run queries against the data from our live Drupal site.
search option in particular table
I'm a newbie to drupal and i need to search data from a particular table. Can any one give me solution to my question. Idea needed ASAP.
Greatly Appreciated to the answering guys!!!!
Post-installation: Default Data Scripts
Hi Techies--
I've installed Drupal on 2 different servers. On one I remembered to click on the checkbox for installing the default data. On the other, I did not. Other than that, the installation went fine. Does anyone know which script dumps the default stories, menus, etc. into the mySQL data schema? I'd hate to re-run an install script if I could just run a *.sql script from phpAdmin or a *.php from cpanel.
Thanks--
SQL ICE - New Tool for Drupal Users who know MySql
Business Integration Technology has just released SQL ICE, the Internet Computing Environment for SQL Experts. Although SQL ICE can do a lot of things, one that may be of interest to Drupal Users is the ability to connect to your Drupal database and write MySQL queries to get reports that can be displayed, downloaded, and shared with other users.
All you need to do is add a Connection to the target database and write a query in SQL. The data is exposed as an XML document accessed by a REST Web service. For example, a simple query like:
Select
Question on MYSQL INNER JOIN
SELECT node.nid AS nid, node_data_field_article_image.field_article_image_fid AS node_data_field_article_image_field_article_image_fid, node_data_field_article_image.field_article_image_list AS node_data_field_article_image_field_article_image_list, node_data_field_article_image.field_article_image_data AS node_data_field_article_image_field_article_image_data, node.type AS node_type, node.vid AS node_vid, node.title AS node_title, node.nid AS node_nid, nodequeue_nodes_node.position AS nodequeue_nodes_node_position FROM node node
DB Management with multiple data centers
Hi there,
We had a second site in the cloud that has all of our sites set up and ready to go with a quick DNS change. MySQL is kept up to date with replication over an SSH tunnel, and we use lsync to keep the files in sync. The problem that I'm seeing is that, if we switch to the disaster recovery/second site and new data starts to be written to MySQL on the slave server, what would be the best workflow for returning this data back to the primary site?
Please help with tables
I have the following issue;
table node contain rough 200k entries;
I would like to use view which select "node.created, node.title" where node is published, belongs to term (not multiple), and content-type = news. Order by created desc.
Here is query: 255.44ms
SELECT node.nid AS nid, node.title AS node_title, node.created AS node_created FROM node node INNER JOIN term_node term_node ON node.vid = term_node.vid WHERE (node.type in ('news')) AND (node.status <> 0) AND (term_node.tid = 6) ORDER BY node_created DESC LIMIT 0, 10Programmer | tng worldwide
The Programmer provides leadership, coordination, development and implementation of business applications. This role provides strategic direction in platform selection, code management, application architecture and implementation. They also provide application support to internal stakeholders delivering 100% customer success by managing the quality and stability of delivered applications.
DUTIES:
Web Development:
• Develop and deploy web applications in accordance with department processes
• Deploy Content Management Systems
• Conduct cross-browser compatibility testing





