Need PHP code for exporting *.sql

[tHE DSS]

Yes, you can install it yourself.

But, I do recommend that Mascon over it any day of the week. For 100 reasons... apart from it not being Freeware. But $49 for somthing you'll be well glad you had in your tool box (for a long long time), is a pretty nice investment.

You will need to be taking backups of your database regular anyway. You may aswell have a smooth procedure for doing it.

Anyway, your original problem was that you didn't seem to be stating any connections to a database server, and not selecting a database.

Try somthing like this :

[sql]
$destinationLink = mysql_connect("destinationServerName", "username", "password") or die("Could Not Connect To DESTINATION database");
$connectDestination = mysql_select_db("destinationDatabaseName", $destinationLink) or die ("Could Not Select DESTINATION database");

$sqlEx = "sql"; //
$schema = "vbulletin"; //

$sql = explode(";", implode("", file("./".$schema.".".$sqlEx)));
for ($i = 0; $i < count($sql); $i++) mysql_query($sql[$i], $destinationLink) or die(mysql_error());
[/sql]

... Good luck. :bunny:

[AZone]

Thanks a lot! I did it!

[Bubba]

Some advice on using phpMyAdmin, if you can get the admin to only allow you and the "web user" access to it via file permissions. This prevents another user from being able to read the db password from the config files.

Also, when you're not using it, chmod the whole directory tree to 700. The prevents some random web user from accessing it when you're not using it.

And of course, don't use phpMyAdmin for the folder name......

If anyone knows any other good techniques to help safeguard this app, please let me know

[Sebastian]

I have that Mascon application, how do you schedule backup automatically? i don't see that option, i have the full version.

[DrkFusion]

Also if you have huge databases in phpmyadmin, when you try to import the huge sql file, you will get timeouts errors, you will have to use little snippets that phpmyadmin can digest it.

[tHE DSS]

Originally posted by Sebastian
I have that Mascon application, how do you schedule backup automatically? i don't see that option, i have the full version.

You should be able to either use the application from the command line, or you will have a command line utility supplied with the package.

You can then create a little batch file, or somthing similar.

I got to admit though, the documentation with Mascon isn't all that hot. :ermm:

The developers would supply good support for it though.