Re: preferred way to backup a 20GB MySQL database

What about the MySQL Administration backup routine, which can be scheduled for a convenient time? No-one has mentioned this one. We use it but perhaps there is something I should know...? Thanks Jonathan Trahair - Original Message - From: B. Keith Murphy To: Dan Buettner Cc:

MySQL University session on November 29

Hi, this Thursday, Brian Aker will give a MySQL University session on: S3 and EC2 Please register for this session by filling in your name on the session Wiki page that you can find here: http://forge.mysql.com/wiki/EC2 Registering is not required but appreciated. Thanks! That Wiki page

Problem recovering from mysqldump

Hi, I want to copy some databases to a new server and I have tried to backup my databases with mysqldump in the old server, then copy those files to the new server and recover them with mysqldump again. The problem is that when doing, mysqldump -u root -p mydb mydb_backup.sql the message that

RE: Problem recovering from mysqldump

Hi , U Can try using this option. Login into database Type as :- \. /tmp/mydb_backup.sql Hope this will help you out. -Original Message- From: Alicia Amadoz [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 28, 2007 5:27 PM To: mysql@lists.mysql.com Subject: Problem

Current month's start day and end day

Hi, How can i get current month's start day and end day using mysql query. Thanks -- View this message in context: http://www.nabble.com/Current-month%27s-start-day-and-end-day-tf4888220.html#a13991390 Sent from the MySQL - General mailing list archive at Nabble.com. -- MySQL General

Re: Current month's start day and end day

Solved it SELECT date_format(date_sub(curdate(), interval 0 month), '%Y-%m-01') AS a, date_sub(date_format(curdate(), '%Y-%m-'+LAST_DAY(CURRENT_DATE)), interval 0 day) AS b Thanks mmfarhan wrote: Hi, How can i get current month's start day and end day using mysql query. Thanks --

Re: Current month's start day and end day

this will get you the start day mysql select DATE_FORMAT(CONCAT(SUBSTR(NOW(),1,8),'01'),'%a'); this will get you the end day mysql select DATE_FORMAT(LAST_DAY(NOW()),'%a'); Is there a reason why you dont want to use a programming language for this task? M-- - Original Message - Wrom:

Re: Problem recovering from mysqldump

On Wed, 28 Nov 2007 12:57:25 +0100 (CET) Alicia Amadoz[EMAIL PROTECTED] wrote: Hi, I want to copy some databases to a new server and I have tried to backup my databases with mysqldump in the old server, then copy those files to the new server and recover them with mysqldump again. The

Re: Determining Table Storage Engine Type on Crashed Table

FYI, this did not work :) Thanks though! Rich(ard) On Nov 23, 2007 3:37 AM, Paul McCullagh [EMAIL PROTECTED] wrote: Maybe this will work: SHOW CREATE TABLE table_name; On Nov 21, 2007, at 9:42 PM, Richard Edward Horner wrote: Hey everybody, Hopefully some of you are already

Re: Current month's start day and end day

Because i am writing a report using iReport (which is a JasperReport's Designer) and I thaught Query is an easy way to get these values. mgainty wrote: this will get you the start day mysql select DATE_FORMAT(CONCAT(SUBSTR(NOW(),1,8),'01'),'%a'); this will get you the end day mysql

Re: Determining Table Storage Engine Type on Crashed Table

Can you look at the directory where the data files are (e.g., in debian its: /var/lib/mysql/{databasename})? For the problem table you should see {tablename}.MYD and ...MYI files it he engine is myisam. Hope this helps On Wed, November 28, 2007 09:34, Richard Edward Horner wrote: FYI, this did

Replication Falls Out Of Sync With LOAD DATA

We have replication set up for 1 master and 4 slaves. When resynced everything appears to work fine. Come back a couple hours later and the machines are out of sync. The only thing I can think of that could cause this is that we are inserting some data on the master

Re: Replication Falls Out Of Sync With LOAD DATA

What versions of MySQL are you using on both the master adn the slaves? Keith Michael Stearne wrote: We have replication set up for 1 master and 4 slaves. When resynced everything appears to work fine. Come back a couple hours later and the machines are out of sync. The only thing I can think

Re: preferred way to backup a 20GB MySQL database

The MySQL Administration backup routine is just a front end for mysqldump On Nov 28, 2007 12:51 AM, J Trahair [EMAIL PROTECTED] wrote: What about the MySQL Administration backup routine, which can be scheduled for a convenient time? No-one has mentioned this one. We use it but perhaps there

Re: Replication Falls Out Of Sync With LOAD DATA

What do you mean by falls out of sync? LOAD DATA INFILE hasn't been a problem for me, and I use it a LOT. It's so simple that I suspect something else. But then again, I don't know what you mean by out of sync :) On Nov 28, 2007 4:32 PM, B. Keith Murphy [EMAIL PROTECTED] wrote: What versions

Re: Replication Falls Out Of Sync With LOAD DATA

The reason I asked about version is that it looks like there is problem replcating a load data infile command from some versions of 4.x to 5.x slaves. Baron Schwartz wrote: What do you mean by falls out of sync? LOAD DATA INFILE hasn't been a problem for me, and I use it a LOT. It's so

RE: Mysql Table partitioning

Hope this helps Data is stored in the RANGE partition that the partition key falls into regardless if its an insert or update. One of the benefit of this is partition pruning. By specifing the partitioned field in a where cluase the optimizer know that it only needs to look into those