mysql -u username -p -h newdbname < dbname.sql
-Original Message-
From: ROGGER ALEXIS VASQUEZ MARTINEZ [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 29, 2001 3:51 PM
To: Tyler Longren; ROGGER ALEXIS VASQUEZ MARTINEZ; [EMAIL PROTECTED]
Subject: RESTORE ??? RE: NewBie Question; Backups?
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
-
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
