RE: [PHP] Transferring MySQL table...
| From: | Juan carlos | Date: | Thu, 31 Aug 2000 12:54:49 +0000 |
| Subject: | RE: [PHP] Transferring MySQL table... | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-14573@lists.php.net to get a copy of this message | ||
> If you don't need PHP to do it, you can either
>
> [1] Dump it with mysqldump from shell on real server:
> mysqldump -a -e --add-locks database > dump.txt
>
> Copy it to the test server from commandline on real server with e.g.
> scp dump.txt testserver:
>
> And then read it with mysql from shell prompt on test server
> mysql database < dump.txt
>
> Replace the 'database' with your database name
>
> If you are able to connect to the 'real' server from the test server,
> you
> can even do
> mysqldump --host=real -a -e --add-locks database | mysql --host=test
> database
Is
mysqldump --host=local_host -a -e --add-locks database |
mysql --host=remote_host database
posible ?