hi
mysqldump -u (username) -h (hostname) -p databasename tablename>filename
password
then upload the same whereever required
mysql -u (username) -h(hostname) -p databasename > hi
> >
> > i want to dump the contents of one table into a text
> > file ... can you tell me what i've done wrong ?
>
> hi
>
> i want to dump the contents of one table into a text
> file ... can you tell me what i've done wrong ?
>
> i tried :
>
> mysqldump --opt --tables studenttable > myfile.txt
> mysqldump --opt --databases [studenttable] > myfile.txt
> mysqldump --opt database [studenttable] > myfile.txt
ROTECTED]>
To: "mySQL Mailing List" <[EMAIL PROTECTED]>
Sent: Friday, January 12, 2001 17:30
Subject: mysqldump of one table?
hi
i want to dump the contents of one table into a text file ... can you tell
me what i've done wrong ?
i tried :
mysqldump --opt --tables studentt
hi
i want to dump the contents of one table into a text file ... can you tell me what
i've done wrong ?
i tried :
mysqldump --opt --tables studenttable > myfile.txt
mysqldump --opt --databases [studenttable] > myfile.txt
mysqldump --opt database [studenttable] > myfile.txt
but all these resul