RE: [PHP] transferring mysql database
| From: | Jon Haworth | Date: | Fri, 18 Oct 2002 13:18:54 +0000 |
| Subject: | RE: [PHP] transferring mysql database | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-120503@lists.php.net to get a copy of this message | ||
Hi Doug,
> was wondering if it were possible to transfer a
> mysql database setup on one server to another
> without having to re-setup all the entire
> database. if so, how?
Dump the schema of the database to a file, and then import it on the new
server.
If you use phpMyAdmin, there are built-in features for doing this. I can't
remember offhand what the actual query is to get MySQL to show the schema,
but I'm sure someone on the MySQL list would know (hint, hint)
Cheers
Jon