Yves Soete wrote:
>
> Dear confrators,
>
> I use phpMyAdmin on Mysql servers to exchange data also to different
> platforms, but with large databases, this is not a very good way to transfer
> complete databases, also phpMyAdmin gives somethimes problems on Windows
> platforms, what is the best, fastest way to transfer data between servers,
> is it with myslqdump or mysqlhotcopy ?? Also if i create a database TXT file
> with PHPMYADMIN and try to import it with mysqlimport database
> phpmyadminfilename it gives me an error ?
>
> Thanks for your answer,
>
> Yves soete.
> [EMAIL PROTECTED]
>
Yves:
A lot of this depends on your version of PHPMyAdmin. Transfering databases via
browser might not be the best idea, anyway.
On origin server:
mysqldump dbname > dbname.sql
On target server:
ftp dbname.sql to a local directory on the target;
mysqladmin create dbname
cat dbname.sql | mysql dbname
Regards,
Van
--
=========================================================================
Linux rocks!!! http://www.dedserius.com
=========================================================================
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
