hi
mysqldump -u (username) -h (hostname) -p databasename tablename>filename
password
then upload the same whereever required
mysql -u (username) -h(hostname) -p databasename<filename.
........Ashwin
> > 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 result in an error ... i can dump the whol database but
not the table
> > studenttable
>
> mysqldump database_name table_name >myfile.txt
>
> / Carsten
> --------
> Carsten H. Pedersen
> Keeper and maintainer of the bitbybit.dk MySQL FAQ
> http://www.bitbybit.dk/mysqlfaq
>
>
> ---------------------------------------------------------------------
> 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