Re: Moving a PHP/MySQL web site ???

Hi, If you are moving to the same type of server with the same mysql version that you could move actually the files that represent your database. Every database is a directory in MYSQL_INSTALL_DIR/var and every table is 3 files in that directory. Make sure that mysql is not running tar.gz the whole directory untar at the other side in the corresponding directory and your database in there. To make sure that every table is good you cad run a myisamchk on every table. If you are moving to another type server than there is the dump utility of mysql. I have actually recreated the database and the tables and used select * int outfile ' ' than load data infile. See mysql documentation if you need it at www.mysql.com ----- Original Message ----- From: "PHP Junkie" <php091565@netscape.net> To: <php-general@lists.php.net> Sent: Friday, July 27, 2001 5:21 PM Subject: [PHP] Moving a PHP/MySQL web site ??? > Hi <?PHPrEAks!?> > > I will be having to face the dubious task of moving my PHP/MySQL-based website to another server. Can anyone out there point me to some "GOOD" documentation on this? The .php files I'm not as concerned about. I've been using the $DOCUMENT_ROOT in all of my includes. I'm more concerned about getting the MySQL databases ( actual files ??? ) moved over correctly. > > I know this isn't a MySQL list, but I thought that enough of you out there work with PHP/MySQL enough to get some good feedback. I'd also like to hear feedback on just your general experience with the process of moving from one web server over to another. > > Thanks all -- -- > > Gene Kelley > BizFlow Data Solutions > http://www.bizflowdata.net/ > > > > __________________________________________________________________ > Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/ > > Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/ > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net