Re: A good US Hosting Site?

2009-04-19 Thread Pete Wilson
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 wrote: > From: Cameron Rogers > Subject: A good US Hosting Site? > To: mysql@lists.mysql.com > Date: Sunday, Apri

Re: A good US Hosting Site?

2009-04-19 Thread Chaim Rieger
Dreamhost is decent Sent via BlackBerry from T-Mobile -Original Message- From: Cameron Rogers Date: Sun, 19 Apr 2009 20:42:27 To: Subject: 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 opti

A good US Hosting Site?

2009-04-19 Thread Cameron Rogers
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: Is Temporary table right approach

2009-04-19 Thread Moon's Father
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=

RE: Need help with mysql prob

2009-04-19 Thread abdulazeez alugo
> 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 valu

Re: Need help with mysql prob

2009-04-19 Thread Tom Nugent
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 this

Re: Need help with mysql prob

2009-04-19 Thread Andy Shellam
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 inser

RE: Need help with mysql prob

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

Re: Need help with mysql prob

2009-04-19 Thread Andy Shellam
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 INS

Need help with mysql prob

2009-04-19 Thread abdulazeez alugo
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 ho

MySQL Community Server 5.1.34 has been released

2009-04-19 Thread Jonathan Perkin
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 April

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
-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 p

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

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

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

2009-04-19 Thread Uwe Kiewel
-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 th

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

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

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