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:http://lists.mysql.com/[EMAIL PROTECTED]
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 unzip. Neither work. Please advise.
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 [mailto:[EMAIL PROTECTED] Sent: Monday, December 13, 2004 5:36 AM To: [EMAIL PROTECTED] Subject: Are these variables healthy? Hi, I am running an instance of MySQL 4.0.16, mostly using MyISAM tables on a 18G 10kRPM SCSI drive w/ ext3, the server having 2G RAM and a 2.8G HT P4, on a RedHat 9 install. Would some of you experts be so kind to take a look at the variables I have, and tell me if anything is wrong? I think the server is using a little too much I/O, but I am not sure... maybe I could tune something? my.cnf (only the relevant parts): skip-locking wait_timeout = 1800 interactive_timeout = 1800 max_connections=300 key_buffer=32M max_allowed_packet=1M table_cache=1024 sort_buffer=2M record_buffer=1M myisam_sort_buffer_size=4M thread_cache=4 log=/var/log/mysqld-query.log log-slow-queries=/var/log/mysqld-slow.log tmpdir=/tmp/ query_cache_limit=128k query_cache_size=16M query_cache_type=1 STATUS: Threads: 51 Questions: 967003 Slow queries: 2 Opens: 135 Flush tables: 1 Open tables: 125 Queries per second avg: 81.016 SHOW STATUS: +--+---+ | Variable_name| Value | +--+---+ | Aborted_clients | 1406 | | Aborted_connects | 1 | | Bytes_received | 7285 | | Bytes_sent | 319972773 | | Com_admin_commands | 668953| | Com_alter_table | 1 | | Com_analyze | 0 | | Com_backup_table | 0 | | Com_begin| 0 | | Com_change_db| 4675 | | Com_change_master| 0 | | Com_check| 0 | | Com_commit | 0 | | Com_create_db| 0 | | Com_create_function | 0 | | Com_create_index | 0 | | Com_create_table | 0 | | Com_delete | 211 | | Com_delete_multi | 0 | | Com_drop_db | 0 | | Com_drop_function| 0 | | Com_drop_index | 0 | | Com_drop_table | 0 | | Com_flush| 0 | | Com_grant| 0 | | Com_ha_close | 0 | | Com_ha_open | 0 | | Com_ha_read | 0 | | Com_insert | 17890 | | Com_insert_select| 0 | | Com_kill | 0 | | Com_load | 0 | | Com_load_master_data | 0 | | Com_load_master_table| 0 | | Com_lock_tables | 1 | | Com_optimize | 0 | | Com_purge| 0 | | Com_rename_table | 0 | | Com_repair | 0 | | Com_replace | 64| | Com_replace_select | 0 | | Com_reset| 0 | | Com_restore_table| 0 | | Com_revoke | 0 | | Com_rollback | 0 | | Com_savepoint| 0 | | Com_select | 162423| | Com_set_option | 0 | | Com_show_binlog_events | 0 | | Com_show_binlogs | 0 | | Com_show_create | 0 | | Com_show_databases | 28| | Com_show_fields | 3926 | | Com_show_grants | 0 | | Com_show_keys| 20| | Com_show_logs| 0 | | Com_show_master_status | 0 | | Com_show_new_master | 0 | | Com_show_open_tables | 0 | | Com_show_processlist | 0 | | Com_show_slave_hosts | 0 | | Com_show_slave_status| 0 | | Com_show_status | 4 | | Com_show_innodb_status | 0 | | Com_show_tables | 140 | | Com_show_variables | 0 | | Com_slave_start | 0 | | Com_slave_stop | 0 | | Com_truncate | 0 | | Com_unlock_tables| 0 | | Com_update | 31543 | | Connections | 14178 | | Created_tmp_disk_tables | 0 | | Created_tmp_tables | 8708 | | Created_tmp_files| 0 | | Delayed_insert_threads | 0 | | Delayed_writes | 0 | | Delayed_errors | 0 | | Flush_commands | 1 | | Handler_commit | 0 | | Handler_delete | 178 | | Handler_read_first | 37| | Handler_read_key | 25041603 | | Handler_read_next| 83330028 | | Handler_read_prev| 28| | Handler_read_rnd |
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 my datas. It is for me a big problem, as it is not possible to write every useful query without using subqueries. Some examples : 1) IN I have 2 very simple requests that MySQL executes very fast. select id from table2 where ... (0.00 sec) select * from table1 where col1 in ( result of above query, hardcoded ); (0.00 sec). If i write this in a single query select * from table1 where col1 in (select id from table2 where ...); it takes lot of times (many seconds !). It is difficult for me to understand that it can take more than the sum of the alone queries. How can MySQL takes 1000x this time ? 2) exist I take 2 single tables. The 2 requests seems to me as identical (col1 is unique). select * from t1 where exists(select col1 from t2 where t1.col1=t2.col1 and t2.col2=myValue); select * from t1,t2 where t1.col1=t2.col1 and t2.col2=myValue; The first one (with subquery) takes again many seconds, while the second is absolutely straightforward (0.00 sec). In the second case, MySQL reads t2 first (uses the where and the index), then t1. With subqueries, MySQL seems to always scan the first table, and then go to the second. It then must scan all my t1 table :-( Can somebody explain this ? Can this be considered as bugs in MySQL ? Can we hope this to be fixed soon ? I naturally can give more details, give content of tables that have the problem, ... but the patterns i wrote seems to always have the problem. You only have to avoid too little table, so that you can see something. Thank you.
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 a full table scan of approximately 1 million rows + grouping and sorting (http://www.spurl.net/discover/hot.php will give you the idea). It obtains a readlock for the whole time. 2. During this time somebody tries to add to, or edit one of the two tables involved in the query mentioned in (1). It tries to obtain a write lock, but has to wait it's turn, i.e. for (1) to complete. 3. As the write lock in (2) has higher priority than any subsequent query. All following queries have to wait for (1) AND (2) to finish before they can read from the table. Fairly basic stuff and explained well in the MySQL documentation here: http://dev.mysql.com/doc/mysql/en/Table_locking.html (compare the first bulleted list to points 1-3 above). There are several ways to work around this - in my case a more clever use of caching was the way to go. Other, and more SQL-esque methods are explained in the Table locking chapter, linked above. Despite the simple solution, I decided to post this anyway if it would be of help to anyone else having similar problems. Thanks to Victor and Ian for the tips! Best, -hjalmar -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 (start MySQL with --skip-grant-tables and use mysqladmin to reset the password). I have been using MySQL for a couple of years and this method has always worked. Has anybody else encountered this problem with the Debian MySQL 4.1 package? It is 'experimental', after all. And yes, I would much rather use the Debian package than install a MySQL binary, for a number of reasons. Thanks, Ryan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 (mysql in on a unix machine). Can someone suggest something? Thank you in advance Johanne Duhaime IRCM
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 Administrator Unimin Corporation - Spruce Pine Duhaime Johanne [EMAIL PROTECTED] wrote on 12/14/2004 03:03:03 PM: 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 (mysql in on a unix machine). Can someone suggest something? Thank you in advance Johanne Duhaime IRCM
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 be linked to from here: http://dev.mysql.com/doc/mysql/en/Client-Side_Scripts.html Shawn Green Database Administrator Unimin Corporation - Spruce Pine Duhaime Johanne [EMAIL PROTECTED] wrote on 12/14/2004 03:03:03 PM: 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 (mysql in on a unix machine). Can someone suggest something? Thank you in advance Johanne Duhaime IRCM __ Do you Yahoo!? Send a seasonal email greeting and help others. Do good. http://celebrity.mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 column holds gigabytes of text in each row? My mind is probably stuck in an indexing paradigm, but I'd like to know where the limits (of Full Text search) are, if any. Can anyone advise? [Thanks!] Eric Pederson -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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: http://dev.mysql.com/doc/mysql/en/example-AUTO_INCREMENT.html http://dev.mysql.com/doc/mysql/en/InnoDB_auto-increment_column.html http://dev.mysql.com/doc/mysql/en/Replication_Problems.html Can anybody tell me how AUTO_INCREMENT works in MySQL especially when we are using DB Replications. At times I get duplicate key error though taken care that the insertions and updations are done in the master db. Mitul Bhammar [EMAIL PROTECTED] wrote: -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 | +---+-+--+-+-+---+ | v | int(11) | YES | | NULL| | +---+-+--+-+-+---+ select * from v1; +--+ | v| +--+ | 237 | +--+ mysql select * from v1 where v=2.37000e+002; +--+ | v| +--+ | 237 | +--+ update v1 set v=11 where v=2.37000e+002; select * from v1; +--+ | v| +--+ | 11 | +--+ I have a query where I perform an update where (CALL_ID = 2.37000e+002); This query updates nothing, even though my CALL_ID column has an id of 237. If I change the end of this query to read: where (CALL_ID = 237);, then the row with CALL_ID=237 is updated. Is there a reason why the double value 2.37000e+002 is not evaluating to 237? Regards, -Brett Berry Berry, Brett C [EMAIL PROTECTED] wrote: -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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) for the missing records. In table2 the primary key is of type Integer, for each new entry it should be Max(table2.PrimaryKeyfield) + 1. How can I do this in one sql command (or is it possilbe at all)? something like: Insert into table2 (primarykeyfiled, field1, field2) Max(table2.priamrykeyfield) + 1 select a.field1, a.field2 from table1 a left join table2 b on (a.field1 = b.field1) where b.field1 is null regards ___ ALL-NEW Yahoo! Messenger - all new features - even more fun! http://uk.messenger.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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), Dan Nelson said: In the last episode (Dec 13), Duhaime Johanne said: I have a script that check the status of all innodb tables. It works fine interactively. But not from the crontab tab. Here is the error message and also a list of the environment variables from the crontab The message is about libz.so that does not exit: but: l /usr/local/lib/libz.so lrwxrwxrwx 1 root other 13 Nov 23 16:26 /usr/local/lib/libz.so - libz.so.1.2.1* Actually libz.so should be in /usr/lib as well on Solaris 9 (it's part of the SUNWzlib package). You can use the 'crle' command as root to add /usr/local/lib to the ld.so searchpath. This will add 3 common library paths: crle -l -u /usr/local/lib:/usr/local/ssl/lib:/usr/sfw/lib Oops. Swap the -l and -u :) crle -u -l /usr/local/lib:/usr/local/ssl/lib:/usr/sfw/lib -- Dan Nelson [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 = price.product_id) WHERE rent_price BETWEEN 300.00 and 500.00 My doubt is if the table product will be optimized. Will optimization process be done over all rows from the product table or only the rows related to the price table? In other words: If table price has other columns and LEFT JOIN is needed anyway, even that would be better to move the columns sell_price and rent_price to the product table? My table has so many columns, and, for structural and maintainance reasons it would be better to divide the columns in two tables, but I can´t compromisse the application performance because of it. Thanks, Ronan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 anything special going on at these times. - one possibility could be DNS refreshes taking place... Do you have the web server's name and IP in the hosts file on the database server? - ian -- +---+ | Ian Sales Database Administrator | | | | eBuyer http://www.ebuyer.com | +---+ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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. -Original Message- From: sasa [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 14, 2004 6:42 AM To: [EMAIL PROTECTED] Subject: No connect to mysql Hi, I have a problem with mysql 4.0.22 on fedora core 2. ..when I try: #/usr/bin/mysqladmin -u root password '' /usr/bin/mysqladmin: connect to server at 'localhost' failed error: Can't connect to local MySQL server through socket '/var/lib/mysql.sock (2)' Check that mysql is running and that the socket: '/var/lib/mysql.sock' exists ! .. the file mysql.sock not exists but I can to resolve ? .. thanks and sorry for my banal question. Salvatore. -- 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.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 PROTECTED] Sent: Monday, December 13, 2004 10:04 PM To: [EMAIL PROTECTED] Subject: Deleting redundant rows Hello there, I do have a table in mysql 4.x with redundant info. Only the autoincrement ID is different. Example: ID citycc 2559756 Witkop SF 2559757 Witkop SF This turns to be a huge problem since I cant find a way to delete the redundant rows with a mysql query. Is there a solution for that? I tried it with distinct, but that does not work, with subselects but this seems not to be supported. I am lost here, maybe someone with better sql knowledge can help out. Thank you for any help, Merlin -- GMX ProMail mit bestem Virenschutz http://www.gmx.net/de/go/mail +++ Empfehlung der Redaktion +++ Internet Professionell 10/04 +++ -- 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.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 guess, UTC. One could also interpret the 4.1.3 changelog this way. http://dev.mysql.com/doc/mysql/en/News-4.1.3.html That is, values stored in such a column are normalized towards UTC and converted back to the current connection time zone when they are retrieved from such a column. But I found no way to make this really sure. Datetime values stored in TIMESTAMP columns internally saved as number of seconds since the Unix Epoch (1970-01-01 00:00:00 UTC). So yes, one can say that they saved in UTC. Unlike for values stored in TIMESTAMP columns, date values stored in DATETIME columns are simply packed into 8-byte integers. For example datetime value '2004-12-14 19:00:02' is saved as 20041214190002. Values stored in such fields are not converted from session's time zone to UTC and backwards... In fact they are not affected by session's @@time_zone variable at all! Such conversion is done ONLY for TIMESTAMP columns. For example: mysql set @@time_zone:='Europe/Moscow'; Query OK, 0 rows affected (0.07 sec) mysql select now(); +-+ | now() | +-+ | 2004-12-14 19:20:57 | +-+ 1 row in set (0.00 sec) mysql create table t1 (dt datetime, ts timestamp); Query OK, 0 rows affected (0.00 sec) mysql insert into t1 values (now(),now()); Query OK, 1 row affected (0.00 sec) mysql select * from t1; +-+-+ | dt | ts | +-+-+ | 2004-12-14 19:21:43 | 2004-12-14 19:21:43 | +-+-+ 1 row in set (0.00 sec) mysql set @@time_zone='America/New_York'; Query OK, 0 rows affected (0.00 sec) mysql select * from t1; +-+-+ | dt | ts | +-+-+ | 2004-12-14 19:21:43 | 2004-12-14 11:21:43 | +-+-+ 1 row in set (0.00 sec) So I won't talk about DATETIME columns further... (2) If DATETIME/TIMESTAMP values are internally saved UTC, what does mysqldump do with these values? Convert it to the timezone mysqldump is executed? It does nothing :) All time zone related conversions are done on server side (this is true for any MySQL client). mysqldump is relatively simple MySQL client which just connects to MySQL server and gets information about tables using standard queries... Since it does not specifies connection's (aka session's) time zone expicitly default session's time zone is used (Which is specified by setting global @@time_zone variable or using MySQL server's --default-time-zone=... option, or is 'SYSTEM' time zone if nothing was touched...). Server converts TIMESTAMP values from UTC to this time zone and sends them to mysqldump which simple stores data... To allow database migration between different timezones, it might be safer if mysqldump would deliver UTC times (or if there were at least another option for this). Good point. But I think that it is more sensible just add SET @@time_zone:='default-time-zone-of-source-server' statement at the beginning of mysqldump's output. This will ensure that same time zone is used for saving/restoring of TIMESTAMP values to/from dump. (3) With system, server and client timezones: How does the client know in which timezone it is running? How does it report this information to the MySQL Server? Has the C API a function to set the timezone? (I found none.) I made a small experiment: - My MySQL server (5.0.2) runs on Linux, system_time_zone=CET, global.time_zone=SYSTEM. - As a client, I used Windows 2000 set to time zone GMT-5 (New York) - Now I used mysql.exe (from MySQL 5.0.2, time zone set to New York) to connect to the MySQL Server (Linux, time zone CET). The time zone information form the client was not reported to the server. @@session.time_zone is SYSTEM (obviously wrong). This means: The time zone is not reported automatically, at least not in all cases. Yes, you are right. Client does not know in which time zone it runs and thus it indeed does not set session's time zone when connection is established automatically. BTW, here are some good reasons for not doing this: 1) Mapping between client's time zones and server's time zone may be non-trivial ... (e.g. imagine Windows client and MySQL's server which default time zone descriptions are Unix based). 2) Doing so will break compatibility with previous MySQL's versions. 3) Actually I think user's time zone and not client time zone is what important. Yes in case of some kind of GUI client they are the same
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 lazy to convert it to MySQL but it should give you a start.
select 86400 * ( to_date('14-feb-2000 10:38:39', 'dd-mon-
hh24:mi:ss')
- to_date('01-jan-1970', 'dd-mon-') )
from dual;
--Walt
-Original Message-
From: John Berman [mailto:[EMAIL PROTECTED]
Sent: Monday, December 13, 2004 9:51 AM
To: [EMAIL PROTECTED]
Subject: Epoch seconds
Importance: High
Hi
I have a table that has start_date and expire_date in the
format: 2004-12-31
I also have a start field and expire field
I need to convert the start_date to Epoch seconds and place
in start and
convert the expire_date and place in expire.
I'm unsure how to convert and how to do this in one go via a query
Help appreciated.
Regards
John Berman
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/mysql? [EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 throught a window client (mysql in on a unix machine). Can someone suggest something? Thank you in advance Johanne Duhaime IRCM Is he at a fixed IP. If so, create a username @ that IP with proper permissions. He can install myodbc on the windows box and then use access. The firewall's (if any) will have to be adjusted so that traffic on the correct port is allowed from only that IP. Just a thought. -- William R. Mussatto, Senior Systems Engineer Ph. 909-920-9154 ext. 27 FAX. 909-608-7061 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 into my head when (BI read your question, especially as you said you could set the root (Bpassword. (B (BActually, I would need much more detail to really troubleshoot your (Bproblem, but its an educated geuss what I am doing here ;-) (B (B (BBest regards (B (BNils Valentin (BTokyo / Japan (B (Bhttp://www.be-known-online.com (B (B (B Hello all: (B (BI am running Debian woody and am using the Debian package for MySQL (B 4.1. I am trying to set the root password but nothing appears to work. (B Apparently I managed to set it but now I cannot login with what I set (B it to. So I have followed the directions to reset a root password (B (start MySQL with --skip-grant-tables and use mysqladmin to reset the (B password). I have been using MySQL for a couple of years and this (B method has always worked. Has anybody else encountered this problem (B with the Debian MySQL 4.1 package? It is 'experimental', after all. (B And yes, I would much rather use the Debian package than install a (B MySQL binary, for a number of reasons. (B (B Thanks, (B Ryan (B (B (B -- (B MySQL General Mailing List (B For list archives: http://lists.mysql.com/mysql (B To unsubscribe: (B http://lists.mysql.com/[EMAIL PROTECTED] (B (B (B (B (B-- (BMySQL General Mailing List (BFor list archives: http://lists.mysql.com/mysql (BTo unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 tables will be empty . nothing will come to database. i m using mysql database with linux. can anybody help me? why is that so . before i used to run it using crontab only it was working fine. but now it is not working. Kavitha -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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' when inserted get silently translated to -00-00 00:00. One of my tables uses this as a primary key, so I only got the error when it complained about duplicate keys. ... Any ideas how to overcome this problem ? Is this a bug ? (I'd be happy to report if that's the case). This is definitely a bug, which I have reported to MySQL bug-system as: http://bugs.mysql.com/bug.php?id=7308 Meanwhile you can try to use STR_TO_DATE() function as temporary work-around. Thanks for noticing this! -- Dmitri Lenev, Software Developer MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
