MYSQL dump and save 2

[solex]

i need to make a script that will make a dump of the layout of tables and the data in them, and save this to a text file.

Is this possible?

thanx in advance

solex

 

[sleipnir214]

You don't have to write a script to do that. MySQL provides an app, mysqldump, to do just that.

http://www.mysql.com/doc/en/mysqldump.html

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[DRJ478]

This is a great way to make a nightly backup of the databases and content. You can put it in as a cron tab in any kind of *nix/linux context or write a little perl script that also rotates/gzips/etc.

 

[solex]

i may sound stupid asking this, but how di i use the commands, in the web page you gave, in php?

thanx solex

 

[DRJ478]

You can execute the command through PHPs execute function.
There are several caveats here, since there is always a risk with executing shell functions from PHP through the web.
Another caveat is to be careful with not exposing the MySQL username and password through the code since you will have to hardcode it. You could also create a MySQL user that has just read privileges and is restricted to the server's IP as connection point.

If you don't worry about security concerns just use the command string in the exec() function.

 

[solex]

ok, so if i connect to the data bace and do

$mysqldump = exec("mysqldump"

it should work?

how can i save the contence of $mysqldump in to a text file?

thanx for all your help the 3 of you.

SOLEX

 

[DRJ478]

You need not connect to the db for this.
ALl you need is execute it exactly the same way you would on the command line:

<?php
  exec(&quot;mysqldump -h hostname -u username -p password databasename > textfile.sql&quot;);
?>

Again, I would create a user that has only access privileges from localhost and SELECT privileges. Put the textfile with the path of the filesystem where you want it stored.
You can then later access is with FTP or PHPs file handling functions.

 

[solex]

thanx DRJ478