Databases

From Kb

SQL

-SQL Query Examples

MySQL

• INT(M) - The M is only meaningful when using zerofill.
• Troubleshooting

OpenLDAP

• Exporting a database ( slapcat )

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