Export Sql database with php

[driveflexfuel]

Many of you may have read my post about uploading a large sql file. My new issue is I am unable to export it using phpmysql without getting a timeout error or the browser freezing due to the size of the export.

I was wondering if there is a php code that would allow me to export or create an sql file.

If anyone has any suggestions please feel free to help me out.

 

[marshian]

Use queries with limit and offset to receive your data. Same works too for uploading large databases, if they are in the sql format.

 

[Twinkie]

Export certain tables at a time to evenly distribute file size using the check list on your top-left of the phpmyadmin export page.