Skip to content
veny edited this page Oct 18, 2016 · 15 revisions

Usage

Import/Export

> EXPORT DATABASE /tmp/smevente.export
> IMPORT DATABASE /tmp/smevente.export.gz -preserveClusterIDs=TRUE

Prepare for development

> UPDATE Customer SET phoneNumber='-=NO_SMS=-' WHERE phoneNumber IS NOT NULL AND phoneNumber.length() > 0
> UPDATE Customer SET email='-=NO_MAIL=-' WHERE email IS NOT NULL AND email.length() > 0 AND email <> 'vaclav.sykora@gmail.com'

Login as root into DB

> CONNECT remote:localhost root rootpwd

change password of a user

> UPDATE OUser SET password='pwd_as_plain_text' WHERE name='admin'

Clone this wiki locally