Using a .php file to generate a MySQL dump

by

You can use the exec() function to execute an external command.

Note: between shell_exec() and exec(), I would choose the second one, which doesn’t return the output to the PHP script — no need for the PHP script to get the whole SQL dump as a string : you only need it written to a file, and this can be done by the command itself.

That external command will :

  • be a call to mysqldump, with the right parameters,
  • and redirect the output to a file.

For example :

mysqldump --user=... --password=... --host=... DB_NAME > /path/to/output/file.sql

Which means your PHP code would look like this :

exec('mysqldump --user=... --password=... --host=... DB_NAME > /path/to/output/file.sql');

Of course, up to you to use the right connection information, replacing the ... with those.

More Related Contents:

  1. Php mysql tabs don’t output [closed]
  2. Update Mysql except when field not null
  3. How can I prevent SQL injection in PHP?
  4. UTF-8 all the way through
  5. SQL injection that gets around mysql_real_escape_string()
  6. Can I mix MySQL APIs in PHP?
  7. jQuery Validate remote method usage to check if username already exists
  8. MySQL query to get column names?
  9. PDO get the last ID inserted
  10. Pagination using MySQL LIMIT, OFFSET
  11. How to call a MySQL stored procedure from within PHP code?
  12. Best way to check if mysql_query returned any results?
  13. mysql_fetch_array return only one row
  14. Laravel 5.2 – Use a String as a Custom Primary Key for Eloquent Table becomes 0
  15. Insert multiple rows with PDO prepared statements
  16. a better approach than storing mysql password in plain text in config file?
  17. mysql query result in php variable
  18. mysql_real_escape_string is undefined
  19. Unknown database error in PHP but it exists in PHPMyAdmin
  20. Can I blindly replace all mysql_ functions with mysqli_?
  21. How do detect that transaction has already been started?
  22. return multiple response data in one response
  23. CakePHP Database connection “Mysql” is missing, or could not be created
  24. How to get primary key of table?
  25. MySQL Alter Table Add Field Before or After a field already present
  26. mysql error ‘TYPE=MyISAM’
  27. Storing datetime as UTC in PHP/MySQL
  28. Difference between mysql_fetch_array and mysql_fetch_row?
  29. 500 Internal Server Error?
  30. Aggregated query without GROUP BY

Leave a Comment