[臬榜: W- Y3 C5 [7 Y1 s( L; a Z
mysqldump -u userid -e -p db_Name > xxxxx.sql+ F" m- p: u7 ?& c8 h2 ~$ b
臬箔table:mysqldump -p -u userid dbname tablename > 52avtv_dzx20.201506242307.sql: C& F: P/ V+ T% F- ]. L
臬箸鞈摨: mysqldump -p -u userid --all-databases > all-database.sql
6 }; u- j1 j+ Z$ H$ l( ` 雿,臬啁桃鞈摨怎雿輻刻撣唾撖蝣潭憿,隞仿舀鞈摨怠交,雿輻刻撣唾銋亙臬箸頛摰3 f( L& v, M! c' w0 g9 S) e
[芸臬箇瑽] : https://iter01.com/206843.html
# V, @9 i5 U. j9 p" hmysqldump--opt-d鞈摨怠-uroot-p>xxx.sql
9 m+ c/ k n0 ]" \* B8 z[芸臬箄]4 I0 M8 _: {& ]! p3 z2 v9 t) O' T' W
mysqldump-t鞈摨怠-uroot-p>xxx.sql5 x9 N% j o2 F% q q8 w, o T
/ M% A' Z+ r5 M ^* z7 j
瘜冽: 嗡誑銝餈唳隞文隞賣蝬脩箇 "502 bad gateway",敶梢踹迸ginx,芾 --single-transaction --quick 撠勗末鈭,憒銝:
/ _/ q3 N1 T" ^: j8 X' z0 f& Omysqldump -u userid -e -p --single-transaction --quick db_Name > xxxxx.sql
( j; t- [9 @( K( c* C( i6 e8 w憿:mysqldump: Got error: 1017: Can't find file: 'pre_forum_rsscache' (errno: 2) when using LOCK TABLES
; \7 I2 ]# n# l. E7 Q! G9 wSol: 芾皂ysqldump銝--lock-tables=false撠勗臭誑閫瘙箏憿
: A7 R: D( q! z5 B T, P% t亥箇: mysqldump: Couldn't execute 'show create table `pre_forum_rsscache`': Can't find file: 'pre_forum_rsscache' (errno: 2) (1017),隞叼hpmyadmin餃交亦餌pre_forum_rsscache 雿輻其葉ls /var/lib/mysql/52avtv_dz/pre_forum_rsscache* 潛曉芣 pre_forum_rsscache.frm 1瑼獢 ,甇撣豢閰脰3瑼:
1 a) i9 H) y F5 M D B-rw-rw---- 1 mysql mysql 8852 Jun 3 16:05 pre_forum_rsscache.frm
2 u. A7 Q) m( s5 Q% D-rw-rw---- 1 mysql mysql 0 Jun 3 16:05 pre_forum_rsscache.MYD
+ k* [+ U7 ? o+ x3 g) M5 G-rw-rw---- 1 mysql mysql 1024 Jun 3 16:05 pre_forum_rsscache.MYI+ S. q# X, c& N1 J Y6 N- x
Sol: 7 J0 @: a5 D: o8 F0 k) r/ @
私hpmyadmin ==SQL 銝隞:
6 A0 J/ N0 \ x( T1 T- DROP TABLE IF EXISTS pre_forum_rsscache;
- CREATE TABLE pre_forum_rsscache (
- lastupdate int(10) unsigned NOT NULL DEFAULT '0',
- fid mediumint(8) unsigned NOT NULL DEFAULT '0',
- tid mediumint(8) unsigned NOT NULL DEFAULT '0',
- dateline int(10) unsigned NOT NULL DEFAULT '0',
- forum char(50) NOT NULL DEFAULT '',
- author char(15) NOT NULL DEFAULT '',
- `subject` char(80) NOT NULL DEFAULT '',
- description char(255) NOT NULL DEFAULT '',
- guidetype char(10) NOT NULL DEFAULT '',
- UNIQUE KEY tid (tid),
- KEY fid (fid,dateline)
- ) ENGINE=MYISAM DEFAULT CHARSET=utf8
銴鋆賭誨蝣 & ?' n: D6 I }5 N
隞賢停甇撣訾' } I& d" y. X, w) U3 X
憿: 嗡蝙皂ariadb 5.5.68 隞賣箇頡rror:mysqldump: Couldn't execute 'SHOW TRIGGERS LIKE 'pre\_portal\_topic\_pic'': Can't read dir of './db_name/' (errno: 24) (1018)1 m) H& B2 _) }, g. c5 {
Sol: open_files_limit(default=962) 憭芸,寧4096,望澆撅祆廝ead-only,/etc/my.cnf 9 R' F3 _& E) U( M7 Q* F
嗅 service mariadb restart
% M2 b% E" U" X" R f3 P- i& L8 W# i3 e* d4 L* M9 |4 _( P$ k
[璇隞嗅臬榜
) r4 i& S4 t; i4 C, u$ `mysqldump -u撣唾 -p撖蝣 -h銝餅 鞈摨 鞈銵 -w "sql璇隞" > 箄撓頝臬瑼獢
" }+ M. A F/ P+ u靘:
( ]; y" j; A+ A# ]$ u* bmysqldump -uroot -p123456 -hlocalhost -e AREA_UTF8 city -w "c_id<10 " > /home/web/a.txt
9 a9 X; z4 |: F, n' w3 o5 T& A
0 A; Z% R1 i% l- u1 U c5 Y; G--no-create-info嚗-t
6 b! V% R9 d9 b2 J; k. h. A% @芸箄嚗銝瘛餃 CREATE TABLE 隤伐憒撠箸澆搴QL隤伐芣insert into典5 x- w5 X+ p0 x% D& a- J r
--no-data嚗-d$ u0 S* y& U- E j! o
銝撠箔遙雿鞈嚗芸箄摨怎瑽8 `3 X! t! z" t& u2 @5 N
--quick嚗-q
* u; u; H+ S( m* h% _典箏之鞈敺剁撘瑕嗅 MySQL Server 亥岷敺閮湔亥撓綽銝臬敺閮敺摮刻園銝准
. D( D+ p, z# R' b& |# z9 H
2 {/ ~6 c$ ~% Y5 [5 A0 S# w' Q
6 e' m3 |3 H8 D+ \[臬包
2 f/ w! P; }( W5 y& kmysql -u userid -p [-h localhost] db_Name < xxxxx.sql$ g2 B/ f; Y1 l$ @* h; z( P: Z: `
臬交鞈摨: mysql -u userid -p < all-database.sql
& v: |2 n4 V* ~5 N% e0 B* F: ~( M臬乩table :( F% e2 O0 \7 _8 Y2 {) [4 J9 j
mysql -u userid -p -D dbname < cc5278_dzx20.ip2c.201506242307.sql
& F+ |7 [9 K5 P3 m6 }P.S憒臬交憭芸之憒7GB,臬交獢銋瑁銝隞:
6 G& Q; _$ U$ L) G' c4 rmysql -uroot -p -e "set global net_buffer_length=1000000; set global max_allowed_packet=1000000000;"5 ?/ q4 O; U6 ^
$ ~% v& c( ] ^" m# r3 Q
[臬箏蝡喳臬亙啣虫唬蜓璈]7 g) Q; s1 U' g4 X: ^8 Y
mysqldump -u [SOURCE_userid] -h [SOURCE_IP] -e -q --password=[SOURCE_PASSWORD] SOURCE_db_Name | mysql -u [DISTANCE_userid] --password=[DISTANCE_PASSWORD] -h [DISTANCE_IP] DISTANCE_db_Name
! J) P& E5 Z, X5 `2 J0 d[閮剖臬乩(批2Mb) by phpmyadmin]/ n. P7 y, {+ A! u7 e
http://www.av4u.info/forum.php?m ... e=1&extra=#pid203484 a# B7 Y% ]* x6 d* n) S& D. ^
5 C8 d @( h% Q' R0 ^) E. c
( r4 h: |# A5 {8 X7 U, O% U1 n1 |4 |/ p8 P: W1 k% a
& N/ ~0 r: q4 W7 Z8 X% ]' p
0 U% w: ?0 P$ ^6 |* w6 S
0 ^# B4 g" c4 Z2 w# N% [3 q7 F* h/ Z
1 ]) Q! k. N6 ]: F
3 J; }4 n, Z4 e) L3 q0 a( s) Z
3 E1 R& c& ?2 [$ I& x( b4 S' g9 R: }! ^ t- G1 l* G* `; i. j7 f! [8 }
$ {2 Y$ Z0 l, G" b/ ]; C, ^5 }, w
5 n$ p7 g0 ^! V+ l! K7 o
. O) p+ e- b0 Y" x+ ^/ ` J |
|