Thanks and How DO I RESTORE IT ??? -----Original Message----- From: Tyler Longren [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 29, 2001 9:43 AM To: ROGGER ALEXIS VASQUEZ MARTINEZ; [EMAIL PROTECTED] Subject: Re: NewBie Question; Backups?
mysqldump -uusername -ppassword -hhostname dbname > dbname.sql That will dump the database 'dbname' into the file 'dbname.sql' Tyler Longren ----- Original Message ----- From: "ROGGER ALEXIS VASQUEZ MARTINEZ" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, November 29, 2001 9:40 AM Subject: NewBie Question; Backups? > How do I make a Backup of a MYSQL database ,,, > It is simple as just copying the files of each table ? > or exists a command to make backup ( including TEXT Fields ) ? > > Thanks > > -----Original Message----- > From: Michael Widenius [mailto:[EMAIL PROTECTED]] > Sent: Thursday, November 29, 2001 10:51 AM > To: [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: Re: Proposal for two (or more) new time and date functions > > > > Hi! > > >>>>> "Jeremy" == Jeremy Zawodny <[EMAIL PROTECTED]> writes: > > Jeremy> On Wed, Nov 28, 2001 at 01:30:42PM -0800, [EMAIL PROTECTED] > wrote: > >> > >> I think while you've got the hood up, a better method of doing the > >> difference between two dates should be derived. > >> > >> Unless I'm going about this all wrong, the only way to get the time > >> difference between two values currently is: > >> > >> UNIX_TIMESTAMP(end_datetime) - UNIX_TIMESTAMP(start_datetime) > >> > >> Wouldn't something like SECONDS_DIFF(start,end) make more sense? Or > >> perhaps TIME_DIFF(start,end)? > > Jeremy> It's not the only way, but none of them are as simple as a > > Jeremy> SELECT date1 - date2 > > The problem with implementing the above simple expression is that you > can easily run into problems because of the automatic convert of > strings to numbers. For example: What should we do if one of the > strings is a date and the other is a number or a string ? > > If we would do the above, then we would also be able to handle: > > SELECT "2001-01-01" - date from table_name; > > SELECT "2001-01-01" - "2000-01-01"; > > One simple solution is to to only do this if both columns are of type > DATE. You can always 'cast' a column to date with: > > SELECT DATE "2001-01-01" - DATE "2000-01-01"; > > How would this sound? > > Regards, > Monty > > > --------------------------------------------------------------------- > Before posting, please 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 > > > --------------------------------------------------------------------- > Before posting, please 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 > --------------------------------------------------------------------- Before posting, please 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