Mysqldump is a small utility that allows you to export a MySQL database to a text file for backup or transfer between two servers. This utility is very useful, is not always available on shared hosting as it embarks on the command line.
This article therefore discusses how to export a MySQL database in PHP.
Called "export" the fact of formatting in a file (a dump) all the information needed to create the table and populate.
The following code allows for an export of a database in SQL file. The Setup section allows you to configure the connection information to the database (user name, password and server address) and the name of the database ($ dbname).
As you can see, the script regularly dump the memory by recording the information as and in the dump file. This process is required for export of large databases.
Note also that the export of a large BDD can take a long time. If you can, consider raising the maximum execution time of your script at the beginning of file:
set_time_limit (0)
Attached, find the source code of mysqldump.php :http://pastebin.com/nzzn8JAa
No comments:
Post a Comment