Text1
Hi all,
Is there any way to do a mysql dump in which each table is dumped into a
separate file. I know I can use the --tables option to specify a table,
but this means I have to type out each table name (and there are a lot
of them). Is there any way to get mysql to automatically iterate
through all the table names and dump each table to a separate file. The
reason for this is that the db is BIG and we don't want to have to lug
200+mb files around. Plus mysql seems to have a real issue with dumping
large dbs into one file. We've tried about 5 - 10 times and we keep
getting corrupted data in the file.
Thanks
---
Rob
**************************
Rob Cherry
mailto:[EMAIL PROTECTED]
+27 21 447 7440
Jam Warehouse RSA
Smart Business Innovation
http://www.jamwarehouse.com
**************************
All information contained in this email is confidential and may be used by the
intended recipient only.
AdmID:99B3219F743413F896891151CEA36E03
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
