One of the easiest ways to do this is to use phpMyAdmin's (http://www.phpmyadmin.net/) export function to dump your table structure and data to a text, csv, or xml file and then import this file on your new server. If you haven't installed phpMyAdmin you can play around with a demo here: http://www.phpmyadmin.net/phpMyAdmin/ -----Original Message----- From: thelist-bounces at lists.evolt.org [mailto:thelist-bounces at lists.evolt.org] On Behalf Of Og Sent: Saturday, August 23, 2003 2:02 PM To: thelist at lists.evolt.org Subject: [thelist] Copying mySQL DB's As with the learning of all new technologies, you have people like me who are going to torture everyone else with stupid questions (at least they don't tke long to answe. So here is a nice one. I'm using PHP and mySQL. I'm developing code on my test server (now that you guys helped me set it up), but I wondering if it's possible to copy a mySQL database to a webserver after you've made it on your test server. The lack of a sinlge access type file is what is confusing me a little. Is it as simple as copying over to the web server then pointing to it using the server admin?. Thanks for your help. Cheers Paul J Maguire CEO Ogmatter www.ogmatter.com info at ogmatter.com "Ogmatter In mind" Note : All outgoing emails have been scanned with Norton Anti-Virus -- * * Please support the community that supports you. * * http://evolt.org/help_support_evolt/ For unsubscribe and other options, including the Tip Harvester and archives of thelist go to: http://lists.evolt.org Workers of the Web, evolt !