re: RE: mysqldump query
Mark, Thursday, November 21, 2002, 5:01:51 PM, you wrote: MC> I should have been more specific in my previous post. I am actually after MC> the syntax to get the data out of a table and into a file. I couldn't quite MC> work this out from the stuff I read in the manual. What exactly do you want to do and what exactly couldn't work? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com - 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
Re: RE: mysqldump question
Bill, Tuesday, July 23, 2002, 11:04:27 PM, you wrote: BB> Also, do you happen to know how old is 3.23.21-beta-log? Our MYSQL is BB> old, but I can't find out how old, is there a version history online BB> anywhere? Check MySQL manual: http://www.mysql.com/doc/index.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com - 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
Re: Re: MySqlDump
Terence, Wednesday, June 12, 2002, 1:22:09 PM, you wrote: T> merge/union...which i guess is the problem? is it not fully supported by T> mysqldump yet? MERGE tables only since 4.0 support INSERTs. If you look into dump file you can see INSERTs for your MERGE table. http://www.mysql.com/doc/M/E/MERGE.html http://www.mysql.com/doc/C/R/CREATE_TABLE.html T> - Original Message - T> From: "Egor Egorov" <[EMAIL PROTECTED]> T> To: <[EMAIL PROTECTED]> T> Sent: Wednesday, June 12, 2002 5:33 PM T> Subject: Re: MySqlDump T> Terence, T> Wednesday, June 12, 2002, 10:20:03 AM, you wrote: T>> ERROR 1031 at line 5167: Table handler for 'total' doesn't have this T> option T>> I am trying to use mysqldump to backup my server to another. Can anyone T> tell T>> me what the above error means? Is it a column name or perhaps some data T>> that's conflicting? T> What is the type of table 'total'? T>> Rgds T>> Terence -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com - 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
Re: Re: mysqldump -A >dump.txt
Eric, Monday, June 03, 2002, 1:49:24 AM, you wrote: EF> I didn't get that deeply into why exactly, but it seems that when I removed EF> the mysql database from the file, that the rest went fine with EF> mysql -u -p http://www.mysql.com/doc/m/y/mysqldump.html EF> I got an error about the column_prv field already existing I believe. Sorry, EF> I should have been much more specific. I appreciate your answering even EF> though I was vague. EF> I think mostly I learned my lesson, and I should export one database at a EF> time, with --tab= EF> Thanks, EF> Eric -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com - 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
Re: RE: mysqldump
hi, i did follow what as follow ..
c:\mysql\bin\mysqldump samp_db > c:\archieves.mysql
but, it shows error as follow :-
mysqldump: Got error: 1045: access denied for user: 'ODBC@localhost'
when trying to connect.
why ? How ?
Original Message-
>Hello
>
>It's simple, if you installed mysql in folder c:\mysql just type this string in
>command promt (or START->RUN):
>
>c:\mysql\bin\mysqldump samp_db > c:\archieves.mysql
>
> -Original Message-
> From: Alice [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, June 05, 2001 12:51 PM
> To: MySQL
> Subject: mysqldump
>
>
> i saw % myswldump samp_db > /usr/archieves.mysql.samp_db.1999-10-02 syntax in the
>Paul Dubois mySQL book,
> but this is command for unix, how abt windows syntax ??
>
/---\
Confidential and/ or privileged information may be contained in this
e-mail and any attachments transmitted with it ('Message'). If you are
not the addressee indicated in this Message (or responsible for
delivery of this Message to such person),you are hereby notified that
any dissemination, distribution, printing or copying of this Message or
any part thereof is prohibited. Please delete this Message if received
in error and advise the sender by return e-mail. Opinions, conclusions
and other information in this Message that do not relate to the
official business of this company shall be understood as neither given
nor endorsed by this company.
This mail is certified Virus Free by *ProtectNow! (InternetNow Sdn Bhd)
*Scanner Engine powered by Norman Virus Control
\--/
-
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
