John Hughes wrote: > Please allow me to broaden this thread to include backup for mySQL > users who have accounts with ISPs. > In my case I have mySQL access on a Web server where I have NO access > to the server-level options. What is my best option of making a > backup of the database and tables that I use?
if you can use PHP in your site, then you would use phpMyAdmin. Thats a really handy piece of software. You just put it somewhere in your web via ftp like your other web pages and off you go. Preferably you put it in a password protected directory. It has an interface to mysqldump and lets you down- and upload database-dumps. There is just one problem. Some ISPs limit the run time of a PHP action. This might timeout the script before it can finish the dump. > Also, what is my best option if I want to move this database and its > tables from one ISP to another? mysqldump can include in the dump all commands to rebuild the database at the new ISP. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
