export a sngle mysql table with php

[jasondavis]

I need to export a single mysql table to a sql file, I have tried with phpmyadmin but it times out instantly the table is only like 12mb though

[MarkR]

1. Log into your shell
2. Use mysqldump to dump the table
3. (if required) transfer the file to some other machine where you want it.

Using PHP, or phpmyadmin to download an entire table is guaranteed to fail, because they will hit a limit or timeout. In MySQL, tables can be very large (Our application uses ones as big as 4 Gb).

mysqldump is shipped with mysql and does the job correctly. They've tested it. Use it.

Mark

[jasondavis]

can you recomment any good sites to show me how to move to a new machine through shell