-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 ChoiSaehoon schrieb: > I tried it, then it gives the following error message > > mysqldump: Can't get CREATE TABLE for table 'ls z*' (Table '(db-name).ls z*' > doesn't exist) > > What does 'ls' mean? (as in linux command 'ls'?)
you have to use the ` sign, not the ' Uwe > > :) > > >> Date: Sun, 19 Apr 2009 08:53:36 -0500 >> Subject: Re: mysqldump syntax - dumping only specific tables starting with a >> certain character. (e.g. z*) >> From: jlyons4...@gmail.com >> To: saeho...@hotmail.com >> CC: mysql@lists.mysql.com >> >> try something like: >> >> mysqldump -u(user) -p (db-name) `ls z*` > (filename) >> >> >> 2009/4/19 ChoiSaehoon <saeho...@hotmail.com> >> >>> Is there a way to dump only specific tables starting with a certain >>> character? >>> >>> >>> >>> For example, I only want to dump tables starting with the character 'z'. >>> >>> The following doesn't work. >>> >>> mysqldump -u(user) -p (db-name) z* > (filename) >>> >>> >>> >>> Do I have to use regular expression here? >>> >>> >>> >>> Please help & thanks in advance. >>> >>> _________________________________________________________________ >>> MSN 메신저의 차세대 버전, Windows Live Messenger! >>> http://windowslive.msn.co.kr/wlm/messenger/ >>> >> >> >> -- >> Jim Lyons >> Web developer / Database administrator >> http://www.weblyons.com > > _________________________________________________________________ > 강력해진 보안성, 아웃룩을 닮아 편리해진 기능들로 무장한 Windows Live Hotmail! 지금 로그인해 보세요! > http://www.hotmail.com -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.7 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iQIVAwUBSes1W0JXG7BUuynnAQJWExAAuzKonpnWPeynnFyvodfGYSP1p9A5ybC6 Azi0j4iGk237HlJ8I8OKh+aBsQGnykzGEQ5eE4xAAaL7bocFlYjHkvaIAhqxzg7c /ZaS9j8k+sGrteAsiA1y8fTj4L3uzLJP+0+crm1yKGKO8Jl9BKxqWl+x3Di6XMYF 1R8OdgBDY1mClUZEqbbBtm0pOs6N/SGcLGyiZNH5xEyRrnXbrh24WY0OQov5pDPj T2G0vC2GpZOZEN1qQeJp5G2ZZ+8gPvZhW+cMElvLNVF3aWkWyd/hEFIxG0cBZ/cR afcreK3AcnAP80ng8150cFN+y5nMR5GExqPDx1j91s9zdW7poMjZiRZKjAOMSqJv Aj+m/MitxGECTOIrCiYo9kP5CyzT6LIng9jyqiNCNR3L2T4sx/LgpLvap+ynwsmz kbqBaLcuPwzCW2f5eIYsfrh5lJMoF86GjTshbFnXXk/EN4etcjTTuFJMiNqPjqvy jonw0b1S17qHRJJPSfLvgk0NEWOB6tYQQuVcWyZyEb0TamfHP04Vdbe9NIKexU04 gafSM5pOBed4DfCsy6qaO9jstrJGMVQlZxxbDzgvsDazMmyh9lTwtup+5TGmxk+I e7HziEFBun8sf1BhDfwm1CJfAQs28lkuD4KctV3DuKyXYqDBftEr0fguxCtqNCtJ 0dTcSkPFzKU= =jim1 -----END PGP SIGNATURE----- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
