Useful OpenX SQL Snippets
- Dump the database without locking
mysqldump -uroot -p \
--complete-insert \
--extended-insert \
--single-transaction \
--skip-add-locks \
--skip-disable-keys \
--no-autocommit \
--quick \
db_name > db_name.sql
SELECT ox_preferences.preference_id, ox_preferences.preference_name, ox_account_preference_assoc.account_id, ox_account_preference_assoc.value
FROM ox_preferences JOIN ox_account_preference_assoc ON ox_preferences.preference_id = ox_account_preference_assoc.preference_id
WHERE account_id IN (1, 2)
AND preference_name like '%foo%'
ORDER BY preference_name;
CategoryOpenX
