Not only will mysqldump allow you to work on a specific table, but it will also allow you to dump directly from one table into another. Sounds like exactly what your looking for. You'll need to use the correct syntax to keep it from adding CREATE TABLE statements, but it's all clear on this page. http://www.mysql.com/doc/m/y/mysqldump.html
Cary query >I was considerign using mysqldump, but I only want to reload one table in >a database, and I'm not sure the mysqldump syntax for specific tables. > >Thanks > >Paul --------------------------------------------------------------------- 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