Home » Freebies, News & Articles, Tips & Tricks

mySQL Database Backup without phpMyAdmin

5 October 2009 791 views 2 Comments

exportHi there! :)

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:

  1. How to reset wordpress admin password
  2. TextPad
  3. Download YouTube Videos
  4. Dan Brown – The Lost Symbol
  5. VLC Media Player

2 Comments »

  • Mo said:

    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

  • Wesley said:

    Nice,
    Is it also possible to run the script automatic daily?

Leave your response!

Add your comment below, or trackback from your own site. You can also subscribe to these comments via RSS.

Be nice. Keep it clean. Stay on topic. No spam.

You can use these tags:
<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

This is a Gravatar-enabled weblog. To get your own globally-recognized-avatar, please register at Gravatar.