mysql:basic
差異處
這裏顯示兩個版本的差異處。
| Both sides previous revision 前次修改 下次修改 | 前次修改 | ||
|
mysql:basic [2009/03/26 19:42] wenpei |
mysql:basic [2016/06/01 10:32] (目前版本) sars [mysqldump] |
||
|---|---|---|---|
| 行 5: | 行 5: | ||
| http://webdesign.enjoyitsimply.com/sql/ | http://webdesign.enjoyitsimply.com/sql/ | ||
| + | |||
| + | ===== Techotopia: MySQL Essentials ===== | ||
| + | http://www.techotopia.com/index.php/MySQL_Essentials | ||
| + | |||
| + | ====== Check table exist or not ====== | ||
| + | 檢查資料表是否存在 | ||
| + | <code> | ||
| + | $tbchk = "SHOW TABLES LIKE '$table' "; | ||
| + | $tbchkres = mysql_query($tbchk); | ||
| + | </code> | ||
| + | |||
| + | $tbchkres 回傳 1 代表存在，回傳 0 代表不存在。 | ||
| + | |||
| + | ====== Create table from other table's structure ====== | ||
| + | 根據已經存在的資料表結構自動建立新資料表 | ||
| + | CREATE TABLE `new_table` LIKE `old_table`; | ||
| ====== mysqldump ====== | ====== mysqldump ====== | ||
| 行 11: | 行 27: | ||
| mysqldump --user=username --password --default-character-set=latin1 database 〉 dump.sql | mysqldump --user=username --password --default-character-set=latin1 database 〉 dump.sql | ||
| + | ===== Ref ===== | ||
| + | * [[https://serversforhackers.com/mysqldump-with-modern-mysql|Mysqldump with Modern MySQL]] | ||
| ====== BigDump: Staggered MySQL Dump Importer ====== | ====== BigDump: Staggered MySQL Dump Importer ====== | ||
| http://www.ozerov.de/bigdump.php | http://www.ozerov.de/bigdump.php | ||
| 行 21: | 行 39: | ||
| http://www.noupe.com/php/10-ways-to-automatically-manually-backup-mysql-database.html | http://www.noupe.com/php/10-ways-to-automatically-manually-backup-mysql-database.html | ||
| + | MySQL 資料庫增量備份 | ||
| + | |||
| + | http://blog.miniasp.com/post/2009/07/How-to-MySQL-Incremental-Backup-using-Binary-Log.aspx | ||
| + | |||
| + | ====== Forgot Root Password ====== | ||
| + | 忘記 MySQL Root 密碼時可重新設定密碼。 | ||
| + | |||
| + | 停止 MySQL Server 後，重新啟動 Server，並增加參數「--skip-grant-tables」 | ||
| + | # mysqld_safe --skip-grant-tables & | ||
| + | |||
| + | 使用無密碼之 root 帳號登入 MySQL | ||
| + | # mysql -u root mysql | ||
| + | |||
| + | 重新設定 root 密碼 | ||
| + | mysql> UPDATE user SET password=PASSWORD('newpassword') WHERE user='root'; | ||
| + | mysql> flush privileges; | ||
| + | |||
| + | 重新啟動 MySQL Server 後即可用新密碼登入。 | ||
| + | |||
| + | Ref: http://www.thegeekstuff.com/2009/07/how-to-reset-forgot-mysql-root-password-on-unix-linux-windows/ | ||
| + | |||
| + | ====== JOIN ====== | ||
| + | {{ :mysql:1512745_645876362117204_338708950_n.png?nolink&800 |}} | ||
mysql/basic.1238067765.txt.gz · 上一次變更: 2009/03/26 19:42 由 wenpei
若無特別註明，本 wiki 上的內容都是採用以下授權方式： CC Attribution-Noncommercial-Share Alike 3.0 Unported
