MySQL Dump PHP Script
Did you ever need to backup a database/table in a remote server and all you had is an FTP account?
If that’s your case, here’s a cool solution. This PHP script, originally written by Kai Huang, allows you to connect to a database and get the information stored in either a single table (in CSV format) or in the whole database (in SQL format).
All you need to do is FTP the script to a folder in the remote server, run it from a browser, then enter the database connection details and you’re on your way.
The script has some interesting options, such as choosing whether to issue DROP TABLE or CREATE TABLEs statements (for SQL dumps), whether to include field names and choosing the field delimiter (in CSV dumps). You can download the script here. Enjoy!
Tags: Content, CSV, Free Tools, FTP, MySQL, PHP, SQL, Wordpress, ZIP
Loading ...
1 user commented in " MySQL Dump PHP Script "
Follow-up comment rss or Leave a TrackbackHey! This script is awesome. I’d like to add something, though. You don’t need to FTP the script if the database server accepts remote connections. However, this will increase traffic between the remote server and yours. So you should only use it with small databases or when the site usage is low.