SQL
From Organic Design wiki
{{#security:*|admin}}
Common MySQL queries
- Insert into interwiki
- <sql>INSERT INTO interwiki (iw_prefix,iw_url,iw_local) VALUES('example','http://www.example.org/$1',0);</sql>
- Backup and compress DB & FS
- <bash>mysqldump awg -u db --password='password' | 7za a -si backupfile.sql.7z</bash>
- <bash>tar cf - directory | 7za a -si backupfile.t7z</bash>
