What is the best way to go about doing a scheduled backup of MySQL databases? I can use phpMyAdmin to do a manual backup, but that isn't practical if I am wanting to do backups of multiple databases twice a week, as I do at present for Access databases (using an FTP program to download the databases to my PC). Also, what do you reckon is better.. one big MySQL database for a site or multiple smaller MySQL databases serving this site? The site could have a few hundred users each with their own set of data for this site (the site displays that user's data). Which is quicker, more efficient, better for the server usage etc? Thanks.