creating mysqldump log file

Hi, Is there any way to create a log file for mysqldump just like oracle export log file i.e what tables exported no of rows exported like that Thanks in advance Anil -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Trying to download database

I've downloaded the database from several different servers today and each time I try to uncompress the file, I get the error message that the file is not a valid archive. I've tried using the built in compression tools in win 2003, and I've also tried downloading WinZip 9.0 eval to attempt the

RE: Are these variables healthy?

hi you can find mysql recommendations of my.cnf parameters based on on RAM size in /usr/local/mysql/support-files with file name my-huge.cnf go through those files and set parameters accordingly for most of databases it will work fine. Anil -Original Message- From: Fagyal Csongor

Subqueries

Hello, I'm using MySQL 4.1.7 and want to use subqueries (very useful !). All the queries i'm trying (with subqueries) give the correct results, but have so bad performances that it is impossible to use it. I did many tests, and it seems to be a general comportement for MySQL, not particular to

RE: One of my tables seems to repeatedly hang for 30-180 seconds

Well as usual this turned out to be fairly simple - once the reason was found. Staring at the process list until this occured again revealed the following situation: 1. An RSS subscription to an infrequently used list results in a very heavy query (worst case almost 200 seconds), that has to do

Re: Restore help! been going 2 weeks

Almost all my MYD files are more than 4 gig I was not aware of this limitation I tested with InnoDB and found it horribly slow for what we do Anil Doppalapudi wrote: check your .myd file size. if table type is myisam and it it is more than 4 GB then convert it to InnoDB. --Anil -- MySQL

Debian package of MySQL 4.1

Hello all: I am running Debian woody and am using the Debian package for MySQL 4.1. I am trying to set the root password but nothing appears to work. Apparently I managed to set it but now I cannot login with what I set it to. So I have followed the directions to reset a root password

Mysql client that does export and import

Hello I have looked at MySql browser and MySqlAdministration and then in the mysql lists but I could not find what I was looking for. A developper is working with one of the many databasees we have. We want to allow him to import and export data from this database throught a window client

Re: Mysql client that does export and import

When you install MySQL you get several tools (not just the command-line client and the various server versions). Two of them are mysqldump and mysqlimport. The docs for all of them can be linked to from here: http://dev.mysql.com/doc/mysql/en/Client-Side_Scripts.html Shawn Green Database

Re: Mysql client that does export and import

I use SQLyog everyday at my job. Check out http://www.webyog.com Karam --- [EMAIL PROTECTED] wrote: When you install MySQL you get several tools (not just the command-line client and the various server versions). Two of them are mysqldump and mysqlimport. The docs for all of them can

Full Text Search - Limits?

I've looked in the documentation but didn't see any indication of the limits of Full-Text Search in terms of how many characters/words it can process per row. For example, if I have a column with 4,000 character strings in it, can I use it effectively in Full-Text Searching? What if the

Re: AUTO_INCREMENT working

Hello. There were several bugs in older versions of MySQL related to 'duplicate entry' errors. Do you use latest release? In documentation it is said that AUTO_INCREMENT works correctly with replication. Please also take a look in the documentation at these links:

Re: Double conversion error

Hello. Can you send complete test for your problem (i.e SHOW CREATE TABLE on your tables, buggy sql statement...)? On my 4.1.7 instance of MySQL everything looks fine: mysql desc v1; +---+-+--+-+-+---+ | Field | Type| Null | Key | Default | Extra |

General query question

Hi, Mysql 4.0.14 In a seconrio, some reocrds are missing from a child table. If we run this query it returns the missing records: select a.field1, b.field2 from table1 a left join table2 b on (a.field1 = b.field1) where b.field1 is null I want to create entries in the child table (table2)

RE : DBI-connect does not work in crontab but works interactively

Thank you very much. That solves my problem -Message d'origine- De : Dan Nelson [mailto:[EMAIL PROTECTED] Envoyé : 13 décembre 2004 12:03 À : Duhaime Johanne Cc : [EMAIL PROTECTED] Objet : Re: DBI-connect does not work in crontab but works interactively In the last episode (Dec 13),

Doubt about query optimization

Hello, Supposing I have 2 tables: product == - id - name price = - id - product_id - sell_price - rent_price If I want to make a SELECT for the products having the rent_price between 300,00 and 500,00, so I use the query: SELECT rent_price FROM product LEFT JOIN price ON (product.id =

Re: One of my tables seems to repeatedly hang for 30-180 seconds

Hjalmar Gislason wrote: Now, from time to time (even several times per hour) one of my tables seems to hang for 30 - 180 seconds, and as this is a key table in the application it basically brings everything to a halt. The interesting thing is that I can not see a pattern in the web server logs of

RE: No connect to mysql

The reason that you cannot connect is that your MySQL server is not running. Make sure that you have run `#/usr/local/mysql/bin/safe_mysqld ` First and then try to run mysqladmin. The other option is to run `#/usr/local/bin/mysqladmin status` to check to see if the server is running. J.R.

RE: Deleting redundant rows

create a unique key on city,cc columns with ignore option of alter table it will keep the first row and deletes redundant rows. check the below link for alter table syntax http://dev.mysql.com/doc/mysql/en/ALTER_TABLE.html Anil -Original Message- From: Walter Pucko [mailto:[EMAIL

Re: timezones in 4.1/5.0

Hi! --- Michael Kofler wrote: --- I read Trudy Pelzer's article on Temporal Functionality in MySQL 4.1. http://dev.mysql.com/tech-resources/articles/4.1/time.html A few open questions to time zone internals remain: (1) How are DATETIME and TIMESTAMP columns saved internally? I would

RE: Epoch seconds

Thanks for the responses Regards John Berman -Original Message- From: Weaver, Walt [mailto:[EMAIL PROTECTED] Sent: 14 December 2004 14:43 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: Epoch seconds Here's a SQL statement that converts dates to epoch time in Oracle. I'm too

Re: Mysql client that does export and import

Duhaime Johanne said: Hello I have looked at MySql browser and MySqlAdministration and then in the mysql lists but I could not find what I was looking for. A developper is working with one of the many databasees we have. We want to allow him to import and export data from this database

Re: Debian package of MySQL 4.1

Hi Ryan, (B (BJust making sure : (B (BIts not an issue with old style and new style passwords like between (Bversion 3.x and 4.1.x ? (B (B(I asume you did upgrade from an older version and did run the tables (Bupgrade script ) (B (BSoory for the insulting question, but this came straight

DBI-connect does not work in crontab but works interactively

hello, i have a shell script with 6 programs. if i run it directly as : sh first.sh all progrms with get executd and everything works fine. but if i give this script in crontab using 0 10 * * * /two/three/name.sh Only progs without database connection will get executed . but database

Re: DateTime ISO format not accepted in Myql 4.1.7

Hi, Jan! --- Jan Pfeifer wrote: --- hi all, I've just upgraded one of the replicate servers from 4.0.22 to 4.1.7, just as a test before upgrading all the others. Apparently I had just this problem: datetime data inserted in ISO format is not accepted -- strings like '20041210T104201'