Databases

From Kb

Revision as of 23:19, 1 August 2011 by Jonathan (Talk | contribs)
(diff) ←Older revision | Current revision (diff) | Newer revision→ (diff)
Jump to: navigation, search

SQL

-SQL Query Examples


MySQL


OpenLDAP

slapcat -l /path/database.ldif
  • Importing a database ( slapadd )
    • Stop the ldap process
/etc/init.d/slapd stop
    • Add any custom schemas to the slapd.conf file
    • Remove everthing from the database directory except for "DB_CONFIG"
cd /var/lib/ldap
rm alock __db.00* *.bdb log.0000000001
slapadd -l /root/mediarain-09jul2009.ldif
    • Restart the ldap process
/etc/init.d/slapd start

Alternative ( ldapadd )

ldapadd -f /path/database.ldif
ldapadd -f entries.ldif -x -D "cn=username,dc=example,dc=com" -y passwordfile