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
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
-
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
(usually called bridging) table,
any company or industry can appear multiple times, but no combo can
appear more than once.
PB
http://www.artfulsoftware.com
-
ChoiSaehoon wrote:
I'm a complete newbie, so please feel free to help me here!
I simplified my problem as below
Thanks for the resource! Arthur.
SIC seems to be great for most industries, but not for high-tech industries.
(e.g. it doesn't have Internet or software etc) Still a great tip, though.
Thanks again! :)
Date: Fri, 27 Mar 2009 19:13:51 -0500
Subject: Re: Data structure for matching for
I'm a complete newbie, so please feel free to help me here!
I simplified my problem as below:
1. Thousands of companies (i.e. company names)
2. 200 industries. Each company has tree-type(?) industry info. (Industry,
Sub-industry. Say, each industry has 10 sub-industry information. (10X20))