database

At IDEIA we are currently working on a new (simple) staging solution.
I have evaluated many systems like : Features, Drush, StrongArm, Context, Patterns, DBScript, Migraine, Deploy, Node_Import, Feeds, Staging, etc...
The common problem encountered with theses modules are :
* they are compatible with few modules
* needs many manual operations and double checking
* handle only content, or config but not both of them

The only "global" solution is DBscript, but it's not a real module, not easy to configure (you must describe all foreign keys of your DB in a config file).

So we came to a new method, based on MySQL auto_increment_offset. These ID pattern allow to know from which DB came any content of any table in the DB.
For example, if we choose that ID terminated by 1 are "prod server", ID terminated by 2 are "test server", and ID terminated y 3 are "dev server".
So merging dev / test / prod is rather simple with some basic SQL UPDATE and DELETE for each table.

Hey all,
I've been scouring the web & forums for a foolproof method to merge databases from multiple developers. If I have developer 'A' working on theming certain parts of a site and developer 'B' working on theming others, I need a way to keep all changes in sync.

I have an SVN repository set up to handle web files. This works great for files but I cannot find a similar system for keeping my databases in sync.

I know there are several modules out there to assist with this (DatabaseScripts, Deploy etc) but none of these seem to offer a full, comprehensive solution.

Hello,

My website (shared hosting) is growing bigger.

Usually I backup using MySQLDumper (http://www.mysqldumper.net/)

It will backup fine, also no error when restoring. Then, when browse the site, some post will missing (not found), but the link to that missing posts still there. I have no idea whats going on. When looking at the database by checking the tables and compare it to the original database, it looks like no data loss, with same number of lines.

I dont really like idea of dump database. MySQLDumper is just best choice for shared hosting.

I'm trying to deal w/ script "2_person_groups.sql" and I'm having a devil of a time getting through parts of this one (and I'm sure it'll happen again later on too).

I don't understand why there's a line CONCAT("Facil import: tblPerson.PersonID=", PersonID)   AS description, -- it seems to me that this pulls in a user ID number from a member and uses it as the group description. But that line makes sense in a subsequent script, so I think it might be an error due to copy and paste.

Also, the script doesn't work, at least for me at Boston.

Jag vill göra en ol li lista med "gruperingar".
Det verkar som det är omöjligt med Drupal! Kanske är vanligt uttryck hos nybörjare...

Jag håller på att göra en navigerings meny som jag vill ska se ut:
Frukt
1. Banan
2. Päron
Kött:
3. Julskinka
4. fläskfilé
5. revbenspjäll
6. Wallenbergare
Mejeri
7. Mu-mjölk
8. Turkisk yoghurt
osv....

hur får jag till detta?
Har kollat på lösningar med hjälp av bok, taxonomi och meny men inte fått det att fungera tillfredsställande.
Tror jag har en idé hur jag skall lösa det.
På "page" sidan så kan man välja en taxonomi tex "Frukt".

Hej sitter och klurar på views databasfråga ex:

SELECT node.nid AS nid,
node.title AS node_title,
term_data.name AS term_data_name,
term_data.vid AS term_data_vid,
term_data.tid AS term_data_tid
FROM node node
INNER JOIN term_node term_node ON node.vid = term_node.vid
LEFT JOIN term_data term_data ON term_node.tid = term_data.tid
WHERE (node.type in ('page')) AND (term_node.tid = 3)

Kan man och hur gör man denna fråga direkt i page-front.tpl.php
eller ändra den manuellt i view?

är nybörjare på drupal och php.

Vill lära mig ALLT! :)

I have been attempting to make a local version of a client's site for development. I was able to export a .gzip using phpmyadmin, but when I import it locally and compare to the live version, a lot of the tables are missing or are quite a bit smaller than the live version. A .zip export was only 4k so I assumed it was no good. The uncompressed database is around 117mb. I exported and downloaded it, and set the file size parameters in php.ini so that I don't get a "this database is too big" error.

Greetings, after days of trying to set up my site I decided to start over with a new hosting service. Installation went 100% better with the new host. Now would like to set up a multi-site configuration. I have been reading some of the posts and have gained some valuable information but I am still confused about how to set it up

I have my domain example.com, and two sub domains example1.example.com and example2.example.com. I have redirected the subdomains to http://example1 and http://example2

Is there an easy way of finding out what db tables are changed for each module?
I'm asking because I'm trying to figure out how to deploy and maintain my website. The live version is a community website, so users will be adding content. On the development side, I'll be making changes. I need to figure out if there's a way to only deploy the setting changes to the live version, so I don't clobber data the users have added. I'd rather not put the live site into maintenance mode as I fiddle with changes, and I certainly would like to avoid making changes to the live site while its live.