CSV format?

Post your support requests/solutions for phpMySQLAutoBackup [website]
Josh

CSV format?

Postby Josh » Tue Oct 23, 2007 5:39 pm

It looks like the ability to back up a MySQL database in CSV format is an option, but I can't seem to figure out how to change this.

I can manually back up a database in CSV (or any other format). The AutoBackup always attaches a sql gzipped format though.

How would you change the script to e-mail a .CSV gzipped file instead.

Very nice app by the way. It even works for those of us who aren't that technically inclined.

-josh

davidgwalker
MODS thats what I do that is! But definately NO mod music! It has to be ROCK!
Posts: 1807
Joined: Mon Oct 25, 2004 8:20 pm
Location: Huddersfield, UK
Contact:

Postby davidgwalker » Tue Oct 23, 2007 5:52 pm

Hi Josh,

Yes, edit the file:
\phpMySQLAutoBackup\files\config.inc.php

line 302, change from:

$cfg['Export']['format'] = 'sql';

To:
$cfg['Export']['format'] = 'csv';

Hope that helps

Dave.
nb. but note this feature may not be included in the new version -- unless someone wants to voluntee to code it in following the release...?

Josh

Postby Josh » Tue Oct 23, 2007 6:22 pm

Thanks for the extremely fast response. I think that's just what I need.

davidgwalker
MODS thats what I do that is! But definately NO mod music! It has to be ROCK!
Posts: 1807
Joined: Mon Oct 25, 2004 8:20 pm
Location: Huddersfield, UK
Contact:

Postby davidgwalker » Tue Oct 23, 2007 6:32 pm

Well... you know what they say:

"You pay for what you get!"

:shock: Wait a minutre, you have not paid anything....

Enjoy :)

Josh

Postby Josh » Tue Oct 23, 2007 6:33 pm

Just made that change. Still being e-mailed a gzipped SQL file.

davidgwalker
MODS thats what I do that is! But definately NO mod music! It has to be ROCK!
Posts: 1807
Joined: Mon Oct 25, 2004 8:20 pm
Location: Huddersfield, UK
Contact:

Postby davidgwalker » Tue Oct 23, 2007 6:49 pm

Indeed, thats because it is over-ridden by the later assignment in file:
\phpMySQLAutoBackup\files\phpmysqlautobackup_extras.php

Change this:
$what = "sql";

to:
$what = "csv";


That should do it ;-)


Return to “phpMySQLAutoBackup [forum]”

Who is online

Users browsing this forum: No registered users and 1 guest