Backup a mysql database and download as a file

by

A very simple solution would be something like (first example):
http://www.php-mysql-tutorial.com/wikis/mysql-tutorials/using-php-to-backup-mysql-databases.aspx

Naturally this will only make a Data dump of the table.

What you could do is use this code:

http://snipplr.com/view/173/mysql-dump/

What this code does is actually gets a description of the table (i.e its structure), creates all the tables and pushes data. pretty much like any other tool does.

Then its just a matter of saving it from string to a file (file_put_contents() for instance or something similar, depending on your preference and need)

More Related Contents:

  1. What to put in database columns when creating registration/login system? (xampp)
  2. How to properly set up a PDO connection
  3. Search with comma-separated value mysql
  4. How to do this in Laravel, subquery where in
  5. PHP MySQLI Prevent SQL Injection [duplicate]
  6. mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in [duplicate]
  7. LOAD DATA LOCAL INFILE forbidden in… PHP
  8. How get all values in a column using PHP?
  9. Why does this return Resource id #2? [duplicate]
  10. In PHP with PDO, how to check the final SQL parametrized query? [duplicate]
  11. Insert current date in datetime format mySQL
  12. select within 20 kilometers based on latitude/longitude
  13. How can I do a migration in laravel 5.5?
  14. Best way to store IP in database?
  15. Which is fastest in PHP- MySQL or MySQLi?
  16. How to backup MySQL database in PHP?
  17. PHP Laravel: No connection could be made because the target machine actively refused it
  18. Auto Increment skipping numbers?
  19. Create PHP array from MySQL column
  20. SQL Query with binary data (PHP and MySQL)
  21. PDO bindParam into one statement?
  22. UNION syntax in Cakephp
  23. How do I format numbers to have only two decimal places?
  24. php (fuzzy) search matching
  25. How to use cURL to fetch specific data from a website and then save it my database using php
  26. UTF-8 not working in HTML forms
  27. SPARQL query to get all parent of a node
  28. Using mysql concat() in WHERE clause?
  29. Check if laravel model got saved or query got executed
  30. Connect to a MySQL server over SSH in PHP

Leave a Comment