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"
>> 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
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
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.
-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
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.
>
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
