Re: Moving MySQL databases.

Actually, Mike, a quick way to handle smaller databases is via an SQL dump.
MySQL has a command built in for that - "mysqldump", I believe - which can
make life easy by creating an SQL-formatted ASCII file that can then be read
back into MySQL at another point (or location.)

An easy way to handle this is to use phpMyAdmin, a web-based administrative
interface for MySQL.  You can find it at http://www.phpmyadmin.net/ and
you'll love it if you are new to both PHP and MySQl.  Set it up in your HTML
tree, htpasswd it while you are working, make a couple of changes to the
config entries in config.inc.php and you have yourself a very neat front end
for your database needs...:).

D


----- Original Message -----
From: Mike Taylor
To: hwg-techniques(at)hwg.org
Sent: Sunday, June 23, 2002 3:33 PM
Subject: Moving MySQL databases.


I am currently with a hosting company that provides MySQL databases.  I'm an
ASP/SQL guy who's transitioning some things over to PHP/MySQL on some of my
hobby sites.

My question is how easy is it to move those databases over to another host
should I need to?  Is there a file somewhere that I can download via FTP?
It appears I can only access MySQL databases tables via the shell account or
via PHP scripting on my pages, so I'm not clear on whether or not there's an
actual database file with my tables that I can actually take with me should
I ever need to move to another host.

Can anyone with MySQL experience clarify this point?

Thanks,
Mike

HWG hwg-techniques mailing list archives, maintained by Webmasters @ IWA