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

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

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

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

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

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

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 `

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

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

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

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 ChoiSaehoon schrieb: Thanks Uwe, I used ` now. It says ls: z*: no such file or directory exists You need to use the path full qualified, e.g. ls /var/lib/mysql/db/z*, or wherever your mysql installation live. then, when I enter the

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

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 -eshow 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 and

MySQL Community Server 5.1.34 has been released

Dear MySQL users, MySQL Community Server 5.1.34, a new version of the popular Open Source Database Management System, has been released. MySQL 5.1.34 is recommended for use on production systems. MySQL 5.1.34 will be the final release of MySQL 5.1 for AIX 5.2, which will be EOL'd from 30th

Need help with mysql prob

Hi guys, I'm having a really terrible problem with my mysql coding and I'ld appreciate any help I can get on this cause it's really driving me crazy. I have two tables and I've succeeded in creating a one to many relationship between both table but the problem I'm having is that I dont know

Re: Need help with mysql prob

Hi, Now I have successfully created a relationship between the two tables but how do I make sure the value of tbl1_id in tbl1 is equal to the value of tbl1_id in tbl2??? MySQL handles this for you. Simply INSERT the value into tbl1, then INSERT the value of tbl1_id in tbl2. Then try

RE: Need help with mysql prob

Date: Sun, 19 Apr 2009 22:50:20 +0100 From: andy-li...@networkmail.eu To: defati...@hotmail.com CC: mysql@lists.mysql.com Subject: Re: Need help with mysql prob Hi, Now I have successfully created a relationship between the two tables but how do I make sure the value of tbl1_id

Re: Need help with mysql prob

Hi Alugo, Hi Andy, Thanks for your prompt response. However, since tbl1_id has an auto_increment value in tbl1, mysql is actually generating the values for it automatically. Ah, I see your point. I'm guessing by your code you're using PHP? If so call mysql_insert_id() after you've

Re: Need help with mysql prob

Hi Abdul- you may want to check this thread out regarding the same issue... http://www.webmasterworld.com/php/3565843.htm On Apr 19, 2009, at 3:23 PM, abdulazeez alugo wrote: Hi guys, I'm having a really terrible problem with my mysql coding and I'ld appreciate any help I can get on

RE: Need help with mysql prob

Date: Sun, 19 Apr 2009 23:19:56 +0100 From: andy-li...@networkmail.eu To: defati...@hotmail.com CC: mysql@lists.mysql.com Subject: Re: Need help with mysql prob Hi Alugo, Hi Andy, Thanks for your prompt response. However, since tbl1_id has an auto_increment value in tbl1,

Re: Is Temporary table right approach

Thanks for your comments. I just gave him a sample value. On Fri, Apr 17, 2009 at 11:10 PM, Andrew Braithwaite andrew.braithwa...@lovefilm.com wrote: If you can not eliminate your temporary tables, you have to adjust the following parameters in my.cnf [mysqld] max_heap_table_size=1G

A good US Hosting Site?

Hi everyone. I am starting my first web site. I have a temporary contract with godaddy but know there are better options out there. The only problem is, I don't know reliable sources to research which hosting program to use. Any recommendations on a hosting sight or some good resources to find

Re: A good US Hosting Site?

Dreamhost is decent Sent via BlackBerry from T-Mobile -Original Message- From: Cameron Rogers cameronl...@gmail.com Date: Sun, 19 Apr 2009 20:42:27 To: mysql@lists.mysql.com Subject: A good US Hosting Site? Hi everyone. I am starting my first web site. I have a temporary contract

Re: A good US Hosting Site?

http://www.kionic.com I've been a very active and heavy customer for years and very satisfied. -- Pete Wilson http://www.pwilson.net/ --- On Sun, 4/19/09, Cameron Rogers cameronl...@gmail.com wrote: From: Cameron Rogers cameronl...@gmail.com Subject: A good US Hosting Site? To: