Exporting mySQL data as a .TXT or .SQL file for backup

[spacepoet]

Hello:

 

I have a question and I think this is where to ask it.

 

I want to add a feature in my admin panel that is a link that - when click - will export all the data from a mySQL database as a .TXT or .SQL (preferred) and open it in a "Save As" prompt box so the admin can save a copy to his or her computer.

 

Basically, I want the admin to download a copy of the database each time they make an update so he or she has a current copy of the database stored as a backup on his or her local machine.

 

Can this be done? If so, how?

 

My GOOGLE searches have not produced any results for this.

 

Thanks.

[fugix]

SELECT ... INTO OUTFILE 'file_name'

[spacepoet]

Hi:

 

Thanks for the reply, but I'm not sure what you mean.

 

Something like:

 

Export.php

<?php

SELECT myDataBase INTO OUTFILE 'file_name' 

?>

Admin.php

<a href="Export.php">Export Database</a>

 

??

 

Sorry, a little confused ..

 

 

 

 

 

 

 

 

 

[fugix]

yes so you might have

$table_dump = mysql_query("select table_name INTO OUTFILE '/example/path/file.txt'") or die("unable to move data");

 

[spacepoet]

OK, I see what you mean .. but what if I want to do all the tables, not just one.

 

Meaning, I want to export the whole database as one file.

 

Also, is there a trick to add the date and time to each file, so it can be easy to find by date and time.

 

Thanks very much!

[fugix]

to dump all of your tables into a file you would write

$table_dump = mysql_query("select * INTO OUTFILE '/example/path/file.txt'") or die("unable to move data");

 

change the table_name to *...teling it to select all of the tables instead of specified ones..hope this helps

[spacepoet]

Hi:

 

Maybe I am not understanding it properly ..

 

Do I need to do soemthing like this:

<?php

include('../include/myConn.php');

$table_dump = mysql_query("SELECT * INTO OUTFILE 'DataBaseBackUp.txt'") or die("unable to move data");

while($result=mysql_fetch_array($query))

echo ". $result().";

?>

 

Just using the one line produced "unable to move data" ..

 

As does the above code ...

 

Do I somehow need to write it out into the file?

[fugix]

Does it work when you love a specified table?

[spacepoet]

Hi:

 

No, I tried it that was as well ..

 

Don't know what to do ..

 

[fugix]

well to put you in the right direction so that you can figure this out...I will gibe you a link

here

[fugix]

sorry about above  here is the link