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

create 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!

Re: PHP or Perl?

For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] -- Simon Windsor Eml: [EMAIL PROTECTED] Tel: 01454 617689 Mob: 07720 447385 -- This message has been scanned for viruses and dangerous content by MailScanner, http://w

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 | gzip -c > .sql.gz at a quiet time - Copy mysql logs This is essentially, the same process one would use with or

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 thi

Re: Triggers

- > > > MySQL General Mailing List > > > For list archives: http://lists.mysql.com/mysql > > > To unsubscribe: > > > > http://lists.mysql.com/[EMAIL PROTECTED] > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.

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 befo

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

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

e 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 Email: [EMAIL

Re: importing database

;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/unsu

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 every application hooking into MySQL, ie Exim 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 -

Upgrading from 3 to 4

and every application hooking into MySQL, ie Exim 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 -

Re: Optimizing

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

Re: The dreaded move from Oracle to MySQL

t; And (I quote) If one uses sockets to connect to the MySQL server, the > server will open and > read the text file directly. > > As I said, these are ideas & I hope it will at least give you some ideas > too... > > Cheers, > > Andrew > > > > > -Original

Re: The dreaded move from Oracle to MySQL

To unsubscribe, e-mail > <[EMAIL PROTECTED]> Trouble > unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Simon Windsor mail: [EMAIL PROTECTED] tel: 01454 617689 mob: 07720 447385 - Before posting, please ch

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

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 th

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 tm

Re: Speed problems.. Still

Hi To help improve the performance, it would help knowing - table structures, use show create table ; - 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 use a s

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 clien

Replication question

transaactions only, 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

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. http://ww

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. http://ww

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 the > records are there. > > I have tried optimize|repair and the data hasn't re-appeared. &g

Losing data

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

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 Cri

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

__ > Do You Yahoo!? > Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk > or your free @yahoo.ie address at http://mail.yahoo.ie > > --------- > Before posting, please check: >

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

Re: Replication Problems

ds an error on the screen > > ERROR 1188: Error 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 > > Sim

Replication Problems

aster: '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

Replication

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

thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[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:[E

Re: MySQL query problem...

> search_users.Age>=35 AND search_users.Age<=35 ) ORDER BY > search_users.Age > > and I get 45 rows returned for an age range of >=35 and <=35 ! > > The queries are exactly the same except for the age ranges!!! But it is > giving me inaccurate results. > &

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.

e) > > 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 CricInfo http://www.cricinfo.com/ Tel: +44 (0) 1249 700744 Fax: +44

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