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'?) :)
> 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