how to backup php mysql site data

help me please

[AjiNIMC]

Hi,

Recently I lost all my forum, as I never use to take the backup, now I want to take the backup regularly, I am using php and mysql, phpmyadmin has a limit of 2 mb.

How to take the bakup, I will prefer some softwares, please help me out, your help will be highly appreciated.

Thanks in Advance.
Aji

[DaveAtIFG]

Are you using a Windows based server or *nix based?

[AjiNIMC]

I am on windows though my server(where I hosted my site) is linux based, I am looking for php based backups softwares , which one is the most common and most effective one.

Thanks a lot
Aji

[nadsab]

Try - [navicat.com...]

[AjiNIMC]

Right now it is not opening for me, let me search for navicat. Thanks a lot for the link.

Aji

[HappyMeal]

You could backup your database regularly via cron job. All you have to do on your part is download it to your computer via FTP when you want.

[bartek]

Not exactly php-based, but I think sysbk is worth mentioning - I use it without any problems. It will not only backup your mysql databases but also other stuff that you designate. Free (as in beer) too:

[rfxnetworks.com...]

[AjiNIMC]

thanks for the help , I will try all this , I am still looking for a better and easy solution through php based program.

Thanks
Aji

[hiker_jjw]

In the php.ini you can set the following:

; Maximum allowed size for uploaded files.
upload_max_filesize = 2M

If you don't have access to your php.ini file, try using the ini_set() function to set the limit. I believe it would look something like this:

ini_set('upload_max_filesize', '2M');

Maybe by placing that line in the phpMyAdmin 'config.inc.php' file, you can make a larger transfer.

Cheers,
Jeff

[The Contractor]

there are lots of free MySQL backup scripts out there. Did you do a search for: mysql backup script

[AjiNIMC]

Thanks , I have checked few and I am trying one after the other and hope I get the one I am looking for.

Thanks again
Aji

[quebrada]

I came across an article in sys admin magazine that addresses what you want to do. Unfortunately it isn't an online article. It is worth reading Oct issue 2004.

Q

[ArmedGeek]

mysqldump?

[AjiNIMC]

Thanks again , for the time being I am just taking weekly backups without cron . I am not getting time to try other scripts.

Thanks
AjiNIMC