MySQl vs 4.1 -- mysqldump

Hi I have recently upgraded from mysql vs 4 to 4.1 and have noticed that the output format in mysqldump has changed a lot, using a single insert statement to populate a table. Is there anyway I can use mysqldump to produce a single insert statement for each row? Many thanx Simon -- Simon

RE: Newbie

an empty copy I hope this helps Simon Windsor Eml: [EMAIL PROTECTED] Tel: 01454 617689 Mob: 07960 321599 -Original Message- From: Cameron Ortis [mailto:[EMAIL PROTECTED] Sent: 16 February 2004 21:35 To: Bing Du Cc: [EMAIL PROTECTED] Subject: Re: Newbie Thanks for the quick reply! As root, I

Re: PHP or Perl?

PROTECTED] This account is only for lists to which I've subscribed. Any spammers invite the worst revenge I think I can get away with. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- Simon Windsor

Re: Backup conventions

Hi Backups/recovery procedures for MySQL are very simple, and efficient. The approach I take, is to - Implement a replicated dual master and - Flush mysql db logs - Use mysqldump db | gzip -c db.sql.gz at a quiet time - Copy mysql logs This is essentially, the same process one would use

Re: replication: 2 masters and 1 slave

Hi This is no problem To do this, 1 - Duplicate database A, creating second database B, ensuring that both have separate serve IDs. 2 - Configure both A+B to replicate each other, but enable log-update on database A. This will allow database A to act as a master to both databases. 3 - Create

Re: Triggers

[EMAIL PROTECTED] 525 Camino de los Marquez, Ste 6 http://www.predict.com Santa Fe, NM 87505 -- Simon Windsor Tel: 01454617689 Mob: 07720 447385 Email: [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

External clients with MySQl 3.23 on Redhat 8.0

Hi I am having problems setting up an ODBC client on Windows XP for a Redhat server running MySQL 3.23-54. I have seen some references to other people having this problem. Does anyone know about this, and a fix? I don't want to rebuild the server with Debian/Suse (where I have done this

MySQL on windows

- - Visual C++ + ODBC - - Visual C++ + MySQL++ can anyone advice me on the best to use, for stability, and no memory leaks etc. Many thanks Simon - -- Simon Windsor Email: [EMAIL PROTECTED] Tel: 01454 617689 Mob: 07720 447385 -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (GNU/Linux

Re: InterBase vs. Mysql

and enjoy the speed. All the best Simon - -- Simon Windsor Email: [EMAIL PROTECTED] Tel: 01454 617689 Mob: 07720 447385 -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (GNU/Linux) iD8DBQE+UkbNSJvgVrMNWjYRAiNzAKDT+k7vzCYnwUmSJzYmKN2SYM6VqwCgzs2v TOC3NALEzeSgUnqHpN5VK+M= =+OEQ -END PGP SIGNATURE

Re: Need Help With MySQL Query

/unsubscribe.php -- Simon Windsor Email: [EMAIL PROTECTED] Tel: 01454 617689 Mob: 07720 447385 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive

Re: importing database

) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Simon Windsor Email: [EMAIL PROTECTED] Tel: 01454 617689 Mob: 07720 447385

Mail Problems

in 4.0.10 Yesterday 12:40:40 am and they arrived 24 hours after being sent! Simon -- Simon Windsor Email: [EMAIL PROTECTED] Tel: 01454 617689 Mob: 07720 447385 - Before posting, please check: http://www.mysql.com/manual.php

Upgrading from 3 to 4

and Apache. The price of MySQL being such a good product. Any advice would be appreciated Many thanx Simon -- Simon Windsor Email: [EMAIL PROTECTED] Tel: 01454 617689 Mob: 07720 447385 - Before posting, please check: http

Upgrading from 3 to 4

and Apache. The price of MySQL being such a good product. Any advice would be appreciated Many thanx Simon -- Simon Windsor Email: [EMAIL PROTECTED] Tel: 01454 617689 Mob: 07720 447385 - Before posting, please check: http

Re: Optimizing

PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Simon Windsor Email: [EMAIL PROTECTED] Tel: 01454 617689 Mob: 07720 447385 - Before posting, please check

MySQL 4 for Mandrake 9

Hi Can anyone recommend a binary source for Mandrake 9, or the correct options to compile and install the latest version of MySQL on Mandrake 9. I appreciate that the 'standard' Redhat 386 binaries will work, but I would rather stick to Mandrakes specific (pentium) version. Simon -- Simon

Re: The dreaded move from Oracle to MySQL

:[EMAIL PROTECTED]] Sent: Wednesday, 20 November 2002 20:24 To: Simon Windsor; [EMAIL PROTECTED] Subject: RE: The dreaded move from Oracle to MySQL Well, it looks like Simon has the best possible answer so far. I did a test dump into a delimited file from Oracle and imported that using the LOAD

MySQL on windows

Hi I have been asked to support/bug-fix a Windows based web site using MySQL. I have used MySQL on Linux/FreeBSD for 3/4 years, but never on Windows. How does MySQL compare on Linux and Windows for stability and performance ? Simon -- Simon Windsor mail: [EMAIL PROTECTED

Re: The dreaded move from Oracle to MySQL

check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Simon Windsor

Transaction processing

Hi I've been using mysql for a couple of years now, and until now had no real need of transactions. The could list recommend BDB or InnoDB to implement transatcions. On a small system, which one is faster, and handles load better ? Do they both offer foreign key constraints ? Do they fix

Re: REPAIR TABLE

Hi Try create table tmp_zinutes select * from zinutes; alter table tmp_zinutes add primary key (id), key hid(hid)); if tmp_zinutes has all rows, then drop table zinutes; rename table tmp_zinutes to zinutes; Be carefull, DO NOT DROP TABLE zinutes unless all data has successfully copied to

Re: Speed problems.. Still

Hi To help improve the performance, it would help knowing - table structures, use show create table name; - how many records in each table - have all the tables being analyzed/optimized recently Inner joins whilst very useful, do impact on performance. In some cases it is more efficient to

Debian (Woody/Testing) version of MySql

Hi We have just moved out test server from RedHat to Debian. We have used the backup tapes to recover the data, and all went well to until we tried to connect via a host name. For example mysql test -utest_user -ptest_passwd works fine, but mysql -hserver -utest_user -ptest_passwd reports

Replication and temporaray tables.

Hi I appear to be having problems with replication and temporary tables. Up until last week, we have had replication working without any serious problems for 3/4 months; then one of the developers decided to use two temporary tables as work areas. Immediately, replication stopped on the

Replication question

, or will I get into a loop of a machine applying its own transactions back on to itself ? Thanx Simon -- NameSimon WindsorTel 0(44) 454 617 689 Email [EMAIL PROTECTED] Fax 0(44) 454 610 709

PHP and pconnect

Hi The I have noticed that the number of Aborted Clients and Aborted Connections has increased sharply recently on our two production servers, but not on our development server. Yesterday we started getting a number of blocked host errors, which we had to clear up with flush hosts.

PHP and pconnect

Hi The I have noticed that the number of Aborted Clients and Aborted Connections has increased sharply recently on our two production servers, but not on our development server. Yesterday we started getting a number of blocked host errors, which we had to clear up with flush hosts.

Losing data

Hi I appear to have lost several records, but on doing mysqldump db the records are there. I have tried optimize|repair and the data hasn't re-appeared. Any ideas ? Simon - Before posting, please check:

Re: Losing data

? Simon On Monday 12 November 2001 5:20 pm, Simon Windsor wrote: Hi I appear to have lost several records, but on doing mysqldump db the records are there. I have tried optimize|repair and the data hasn't re-appeared. Any ideas ? Simon

Error logs

Hi Is it possible to remove MySql's error log file without restarting the server. With other db's, ie Oracle, errors are just appended to the end of the log file. Is this the same with MySql, or does MySql permenantly hold the file open ? Thanx Simon -- Simon Windsor CricInfo http

Re: Inserting 307,284 lines. Is this ok?

[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Simon Windsor CricInfo http://www.cricinfo.com/ Tel: +44 (0) 1249 700744 Fax: +44 (0) 1249 700725 Email: mailto:[EMAIL PROTECTED] This email message is for the sole use of the intended recipient(s

Query Execution Time

Hi Within mysql, all queries return the time taken to execute, ie 20 rows in set (0.77 sec) 35 rows in set (1.33 sec) etc. Is it possible within perl, or C for that matter, to get the time taken for the MySql server to get the data ? Thanx Simon -- Simon Windsor CricInfo http

Replication Problems

: 'Access denied for user : ' and in mysql.err 010529 092358 fetch_nx_table: failed on create table Does anyone have an idea what might be causing this error ? Thanx Simon -- Simon Windsor CricInfo http://www.cricinfo.com/ Tel: +44 (0) 1249 700744 Fax: +44 (0) 1249 700725 Email: mailto:[EMAIL

Re: Replication Problems

From master: 'Access denied for user : ' and in mysql.err 010529 092358 fetch_nx_table: failed on create table Does anyone have an idea what might be causing this error ? Thanx Simon -- Simon Windsor CricInfo http://www.cricinfo.com/ Tel: +44 (0) 1249 700744 Fax: +44 (0) 1249 700725

Replication

by using this approach for all tables with the database ? Thanx Simon -- Simon Windsor CricInfo http://www.cricinfo.com/ Tel: +44 (0) 1249 700744 Fax: +44 (0) 1249 700725 Email: mailto:[EMAIL PROTECTED] This email message is for the sole use of the intended recipient(s) and may contain

Re: bug report

: http://lists.mysql.com/php/unsubscribe.php -- Simon Windsor CricInfo http://www.cricinfo.com/ Tel: +44 (0) 1249 700744 Fax: +44 (0) 1249 700725 Email: mailto:[EMAIL PROTECTED] This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged

Slow Update Log

Hi When did the option log-slow-queries become available. It works on my 3.23.33 setup, but not on a 3.22.32 Thanks Simon -- Simon Windsor CricInfo http://www.cricinfo.com/ Tel: +44 (0) 1249 700744 Fax: +44 (0) 1249 700725 Email: mailto:[EMAIL PROTECTED] This email message is for the sole

Memory footprint

one server is 7MB bigger than the other. Simon -- Simon Windsor CricInfo http://www.cricinfo.com/ Tel: +44 (0) 1249 700744 Fax: +44 (0) 1249 700725 Email: mailto:[EMAIL PROTECTED] This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged

Re: EXPLAIN with unexpected result.

EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Simon Windsor CricInfo http://www.cricinfo.com/ Tel: +44 (0) 1249 700744 Fax: +44 (0) 1249 700725 Email: mailto:[EMAIL PROTECTED] This email message is for the sole use of the intended recipient(s) and m

Replication

stategy. The only way I can see doing this with a single backup server is to use multiple mysql configuartions, one for each production database. Does anyone know if it is possible to allow a single client to read from multiple masters ? Simon -- Simon Windsor CricInfo http://www.cricinfo.com/ Tel

ReisserFS

Hi Has anyone user MySql on a ReisserFS file system ? Where any problems encountered ? and do you have any pearls of wisdom that you are willing to share ? Thanks Simon -- Simon Windsor CricInfo http://www.cricinfo.com/ Tel: +44 (0) 1249 700720 Fax: +44 (0) 1249 700725 Email: mailto