RE: Mysql Upgrade from version 4 to 5

2009-10-21 Thread Gavin Towey
See: http://dev.mysql.com/doc/refman/5.0/en/upgrade.html -Original Message- From: Tharanga Abeyseela [mailto:tharanga.abeyse...@gmail.com] Sent: Wednesday, October 21, 2009 2:34 PM To: mysql@lists.mysql.com Subject: Mysql Upgrade from version 4 to 5 Hi Guys, Iam going to upgrade mysql ve

Re: ad hoc replication for 3 X 40 000 rows

2009-10-21 Thread Don Read
On Wed, 21 Oct 2009 16:48:21 + (GMT) Sydney Puente said: > However sync's from MS SQL to MYSQL are required every 24 hours after the > initial dataload. > And this has me puzzled. > Advice anyone? > Please ;-) If there's a auto-inc key, you can find the last one from the MySQL_table then

Mysql Upgrade from version 4 to 5

2009-10-21 Thread Tharanga Abeyseela
Hi Guys, Iam going to upgrade mysql version 4 to version 5.x on redhat ES4 . is there any particular way to do that ? if i take a mysqldump of the database and simply restore on to version 5 will work ? are there any differences between syntaxes/db structure etc on those 2 versions ? Thanks in ad

Re: ad hoc replication for 3 X 40 000 rows

2009-10-21 Thread kabel
On Wednesday 21 October 2009 12:48:21 Sydney Puente wrote: > Hello, > > I have a task in hand to pull 3 tables of data from a MS SQL db and > populate a mysql 5.x db. So I plan to use perl DBI for yank the data out of > MS SQL and push it into MYSQL. I think I can handle the mysql table > creation

ad hoc replication for 3 X 40 000 rows

2009-10-21 Thread Sydney Puente
Hello, I have a task in hand to pull 3 tables of data from a MS SQL db and populate a mysql 5.x db. So I plan to use perl DBI for yank the data out of MS SQL and push it into MYSQL. I think I can handle the mysql table creation and any tweaking that might be required to carry out the initial da

MySQL University session on October 22: Dual Master Setups With MMM

2009-10-21 Thread Stefan Hinz
Dual Master Setups With MMM http://forge.mysql.com/wiki/Dual_Master_Setups_With_MMM This Thursday (October 22nd, 13:00 UTC), Walter Heck will present Dual Master Setups With MMM. MMM (Multi-Master Replication Manager for MySQL) is a set of flexible scripts to perform monitoring/failover and manage

Re: Prepared statements and printing Queries

2009-10-21 Thread Joeri De Backer
Hello, mysqli_debug will help you, I think. See: http://php.chinaunix.net/manual/zh/function.mysqli-debug.php Joeri On Tue, Oct 20, 2009 at 5:26 PM, Chris W <4rfv...@cox.net> wrote: > > I know this is more a PHP question but no one on the list at news.php.net is > responding.  So I was hoping s