Re: how to transfer a local DB to a DB on Server ?
| From: | Steve Werby | Date: | Wed, 28 Nov 2001 05:43:47 +0000 |
| Subject: | Re: how to transfer a local DB to a DB on Server ? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-75848@lists.php.net to get a copy of this message | ||
"trongduc" <trongduc@tlnet.com.vn> wrote:
> does anyone know ?
> pls help me, thanks...
Very open-ended, do you have some details? What type of database? Is this
really PHP related? The short answer is to use a program to generate SQL
statements for all of the source db's tables and pipe the SQL statements to
the target db to recreate the database. For example, mysqldump and pg_dump
are available for mysql and postgresql respectively. Or if your db supports
it and the source and target machines are similar you may be able to copy
the database files directly from the source machine to the destination
machine using FTP.
--
Steve Werby
President, Befriend Internet Services LLC
http://www.befriend.com/