phpmyadmin automatic backup

@Marcus_MaximusFeb 15.2010

HI, I am currently running a manual backup using phpmyadmin but am wondering is there a way to automate this using phpmyadmin or a batch file of some sort. Any ideas.

Currently my site is hosted on a shred hosting package and i manually download all website files using filezilla and do a manual backup of phpmyadmin.

I know i can download all files using FTP command in a batch file but don’t want to write this unless i find a solution to automate the database backup.

Thanks

to post a comment

PHP

@MindzaiFeb 15.2010 — #You would usually use cron to do this. For example: http://paulbradley.tv/38/

@Mr__GeekAug 13.2015 — #Any ideas.[/QUOTE]

Nope. These are some scripts for backing up MySQL, but phpMyAdmin seems too ugly for just this task. It is regretful, as it is a very valuable tool in most other areas. But for backup, the most reasonable solution is to use the third-party software. (Please read about my new personal headache: http://www.handybackup.net/backup_terms/phpmyadmin.shtml)

@ginerjmAug 13.2015 — #Your hosting service doesn't do this for you?

@janefirstAug 19.2015 — #You can also use [B]Export[/B] functionality in phpmyadmin. I use this for taking backup of databases. When you click on Import link then a file with .sql extension will downloaded and save it in your download folder. Now cut this file from your download folder and save it in your backup folder.

Remember the name of the database and its .sql file. Whenever you [B]Import[/B] the database you must have to first create the database under same name.

For example, if your database name is 'mysite' then when you export it its name is changed by default and it will something like this 'mysite_db.sql'. If your database is lost somehow, then you have to create the database of same name as it was previously i.e. 'mycode'. Now rename the database file as 'mycode.spl' and import it into your phpmyadmin and it will automatically import your all tables you have had made into the database some time ago.

phpmyadmin automatic backup

4 Comments(s) _↴

Also in #PHP _↴

Success!

Social

Version

phpmyadmin automatic backup

4 Comments(s) ↴

Also in #PHP ↴

Success!

The web is an endless sea of information. Don't miss the boat... Subscribe!

Social

Version

4 Comments(s) _↴

Also in #PHP _↴