MySQL replication and reverse replication?

2010-09-14 Thread Machiel Richards
Good day all I am hoping everyone is well. Can someone perhaps assist me with some resources on the following topic one of our clients are running a MySQL 5 master/slave replication setup. There is a DR test schedule during next month, however they want the slave

Re: Unique ID's across multiple databases

2010-09-14 Thread Johnny Withers
I may have missed what you are trying to do here. NoSQL is really a bad name and should really be renamed to NoREL instead. NoSQL implementations are not used just because of limitations of traditional RDBMS when it comes to sheer traffic volume, they are also used because they scale horizontally

Capitalize Input via Auto Complete?

2010-09-14 Thread Carlos Mennens
I am new to MySQL coming from PostgreSQL noticed a really annoying issue. When I select a database, and try to auto complete in MySQL, it doesn't capitalize the MySQL statements. It's irritating to me to only be able to auto complete statements like 'SELECT', 'ALTER', 'INSERT' only if I hold

RE: Crashed Table - How to report/prevent?

2010-09-14 Thread Gavin Towey
Innodb doesn't suffer from corruption issues nearly as often as myisam tables, and it is able to recover on its own in many cases (crash recovery.) In my experience, if innodb does get corrupted, it's most often because of hardware problems. You could consider using it instead. -Original

RE: no success (was: hard disk crash: how to discover the db?)

2010-09-14 Thread Gavin Towey
With PHP, a blank page usually means it's generating an error, but not displaying it in the browser; this is often disabled for security reasons, but makes debugging harder. First step should be to get PHP to spit out the actual error. There should probably be a setting in the mediawiki

RE: Capitalize Input via Auto Complete?

2010-09-14 Thread Daevid Vincent
Get this tool: http://sqlyog.com/ it rocks. There is also http://www.quest.com/toad-for-mysql/ which is pretty great. -Original Message- From: Carlos Mennens [mailto:carlosw...@gmail.com] Sent: Tuesday, September 14, 2010 9:03 AM To: MySQL Subject: Capitalize Input via Auto

Re: Capitalize Input via Auto Complete?

2010-09-14 Thread george larson
Daevid Vincent wrote: Get this tool: http://sqlyog.com/ it rocks. There is also http://www.quest.com/toad-for-mysql/ which is pretty great. Alternatively, there is MySQL WorkBench. Some of the guys around here use SQLYog but, since it is a LAMP environment, I like that WorkBench is

Re: Capitalize Input via Auto Complete?

2010-09-14 Thread Carlos Mennens
On Tue, Sep 14, 2010 at 2:24 PM, Daevid Vincent dae...@daevid.com wrote: Get this tool: http://sqlyog.com/ it rocks. There is also http://www.quest.com/toad-for-mysql/ which is pretty great. I can't use any graphical or 3rd party add-on's. I was hoping MySQL had this native / built in. I guess

Re: Capitalize Input via Auto Complete?

2010-09-14 Thread george larson
Carlos Mennens wrote: On Tue, Sep 14, 2010 at 2:24 PM, Daevid Vincent dae...@daevid.com wrote: Get this tool: http://sqlyog.com/ it rocks. There is also http://www.quest.com/toad-for-mysql/ which is pretty great. I can't use any graphical or 3rd party add-on's. I was hoping MySQL had this

Re: Capitalize Input via Auto Complete?

2010-09-14 Thread Steve Staples
On Tue, 2010-09-14 at 15:45 -0400, george larson wrote: Daevid Vincent wrote: Get this tool: http://sqlyog.com/ it rocks. There is also http://www.quest.com/toad-for-mysql/ which is pretty great. Alternatively, there is MySQL WorkBench. Some of the guys around here use SQLYog

RE: Capitalize Input via Auto Complete?

2010-09-14 Thread Daevid Vincent
-Original Message- From: Carlos Mennens [mailto:carlosw...@gmail.com] Sent: Tuesday, September 14, 2010 12:54 PM To: MySQL Subject: Re: Capitalize Input via Auto Complete? On Tue, Sep 14, 2010 at 2:24 PM, Daevid Vincent dae...@daevid.com wrote: Get this tool: