>>mysql dump<<

[marjune]

>>i know how to dump or back up the entire records of a certain database in mysql,, but my problem is how to dump a single table, any one can help me? thnxxx

[gh0std0g74]

please read the docs of mysqldump

Code: [Select]

mysqldump --opt -u root -p databasename tablename > dumpfile


[r3ynz_t4nz]

mysql - u root -p cssonline.registration > x:\kolokoyz.sql

[Rob Pomeroy]

If you want an easy way to backup MySQL databases on a live/production system on some kind of schedule, try mysqlblasy.