mySQL Database Backup without phpMyAdmin
If you are a website owner who has a blog or some other kind of dynamic website which utilizes a mysql database, but you don’t have (or you don’t know how to use) phpMyAdmin then you need a very easy way to backup and export your mysql database, right?
Well I also faced this problem recently, one of my client sites didn’t have phpMyAdmin installed and he needed a quick and easy method to download the backup. So here is a script that solved my client’s problem, and now am releasing it so it solves yours problem as well
How to use:
1)
Download mySQL Backup script (1.17 KB)
2) Extract all files
3) Edit database details in index.php (5 lines in the top, it’s commented properly for your convenience)
4) Upload it to your server
5) Launch it: http://www.yourdomain.com/export/
and you are done
Let me know if you face any problems.
Features in queue for next version:
1) Have the database information added via a form directly. No need to edit .php files
2) Have the option of saving file on server.
3) Have the option of emailing the file.
4) Add instructions for CRON Job.
Download mySQL Backup script (1.17 KB)
-Salman
Related posts:


If you have SSH access, you can use mysqldump -u username -p databasename > database.sql.
Even better you can assign this to a cron job and get automated backups, which is what I do
.
Mo
Nice,
Is it also possible to run the script automatic daily?
Leave your response!
Get Updates in Your Inbox
Recent Comments
Categories
Tags
Friends