SQL
From Organic Design wiki
{{#security:*|admin}}
Contents
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>
Some SQL queries executable by admin (need fixing to work in new MW1.9.3 environment)
- Tables
- Drop
- Info
- Select User
- CL
- CUR
- OLD
- Delete
- Update
- IW
- IW-Update
- IW-Insert
- RC
- UR
- makeBot
- Reset Password
- Owner-Old
- Owner-Cur
- Sys:User articles
- xwAdmins
Documentation
MySQL News & Information
- Falcon Overview - the new MySQL 6 Falcon storage engine
