Mysql Dump import export restore

Submitted by Anonymous (not verified) on Fri, 09/04/2009 - 15:14

Dont mix mysqldump and mysql commands when you try to import/restore. Following shell command gives no error but creates just an empty file.

mysqldump -u USERNAME -pPASSWORD YOUR_DATABASE_NAME < YOUR_DB.sql
Enter password:
-- MySQL dump 10.11
--
-- Host: localhost    Database: YOUR_DATABASE_NAME
-- ------------------------------------------------------
-- Server version       5.0.51a-3ubuntu5.4

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;

Language_List and default language as selected option on Drupal 6x

Submitted by Anonymous (not verified) on Thu, 07/23/2009 - 12:08

Just add global $language to function locale_form_alter and change line 278 on locale module:

change:

'#default_value' => (isset($form['#node']->language) ? $form['#node']->language : ''),

with:

'#default_value' => (!empty($form['#node']->language) ? $form['#node']->language : $language->language),

Mysql update table if field exists

Submitted by Anonymous (not verified) on Mon, 07/20/2009 - 22:45

I am searching -google, mysql-man, forums- for a solution for more than four hours but could not find anything. I need simply a function+
condition to update hundreds of tables.

This query stopped on first error:

update ignore table1 set id2=id1;
update ignore table2 set id2=id1;
...

Any idea?

FREE SHOPPING CARTS

Submitted by Anonymous (not verified) on Sun, 07/12/2009 - 07:58

Can anyone tell me which of the free shopping carts has a one-page checkout or at least allows customers to checkout without creating an account? I am looking for one that is also templated and displays products in a grid format with multiple categories and cross selling. Any suggestions appreciated.