Thanks Uwe,
I used ` now. It says ls: z*: no such file or directory exists then, when I enter the password it dumps all the tables. (instead of tables starting with 'z') Yes, I'm a newbie. (I didn't know to use ` instead of '...) But please help me. Plz tell me what I've done wrongly this time. :) > Date: Sun, 19 Apr 2009 16:29:48 +0200 > From: m...@kiewel-online.ch > To: saeho...@hotmail.com > CC: mysql@lists.mysql.com > Subject: Re: mysqldump syntax - dumping only specific tables starting with a > certain character. (e.g. z*) > > -----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=saeho...@hotmail.com > _________________________________________________________________ MSN 메신저의 차세대 버전, Windows Live Messenger! http://windowslive.msn.co.kr/wlm/messenger/