Re: mysqldump syntax - dumping only specific tables starting with a certain character. (e.g. z*)

2009-04-19 Thread Jim Lyons
actually, that was stupid of me - you need a list of tables not files. I think the only to do this, and the way we do it, is to run some command like: mysql -e"show tables in db-name like 'z%'" >tabnames Note the use of double-quotes and single-quotes. then use a loop to read the file "tabnames"

Re: mysqldump syntax - dumping only specific tables starting with a certain character. (e.g. z*)

2009-04-19 Thread Uwe Kiewel
>> 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*) >> >> -BEGI

RE: mysqldump syntax - dumping only specific tables starting with a certain character. (e.g. z*)

2009-04-19 Thread ChoiSaehoon
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

Re: mysqldump syntax - dumping only specific tables starting with a certain character. (e.g. z*)

2009-04-19 Thread Uwe Kiewel
s' 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.

RE: mysqldump syntax - dumping only specific tables starting with a certain character. (e.g. z*)

2009-04-19 Thread ChoiSaehoon
-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*` &g

Re: mysqldump syntax - dumping only specific tables starting with a certain character. (e.g. z*)

2009-04-19 Thread Jim Lyons
try something like: mysqldump -u(user) -p (db-name) `ls z*` > (filename) 2009/4/19 ChoiSaehoon > > 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 syntax - dumping only specific tables starting with a certain character. (e.g. z*)

2009-04-19 Thread ChoiSaehoon
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 hel