One line? - not really. Write a bash script to run from cron: mysql - show tables > tablefile for... extract table names one by one mysqldump - just the table > tablename.sql That's the bare bones of it - holler if you need more help ;) Cheers, Tony On 21/12/2015, Allan M via skunkworks <skunkworks@lists.my.co.ke> wrote:
Hi guys, I need to configure a cronjob for my new MYSQL database. I already have some backup scripts that do a complete dump. I need a one line script that will do exports for all my tables one-by-one , more or less like the export script for Oracle databases. The reason is, it easier and faster to import a single table. Let me have some help on this end.
-- Regards,
Allan M 0722-266-146
*That I may know Him (Christ), and the Power of His Resurrection....*
-- Tony White