Allan,

There is no one line solution for dumping all tables in MySQL. As Tony say, you can do a bash script to do that, but if you have PHP running on your server, here is a small elegant PHP script that can do the same. Remember to change the script to work with your environment.

This work well in Linux. If you are using Windows, you can tailor it to work with Windows. The folder structure will be different but I think PHP and MySQL dump will work the same way.

On Mon, Dec 21, 2015 at 10:05 AM, Philip Musyoki <pmusyoki@gmail.com> wrote:
Are you using Linux or Windows?

On Mon, Dec 21, 2015 at 9:45 AM, 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....

_______________________________________________
skunkworks mailing list
skunkworks@lists.my.co.ke
------------
List info, subscribe/unsubscribe
http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks
------------

Skunkworks Rules
http://my.co.ke/phpbb/viewtopic.php?f=24&t=94
------------
Other services @ http://my.co.ke