Posted by Fabian Hore on 02/28/06 14:19

still using PHP:

1.
You can always dump an OUTFILE and insert elsewere as an INFILE
very fast. but both mysql users will require FILE privileges.

2.
Plus if you can access shell programs via PHP, so you can use the
`mysqldump` and `mysqladmin` programs. without needing command line access.
off the top of my head ... execute a shell command like:
`mysqldump -uxxx -pxxx -hlocalhost mydb > './tmpfile' &&
mysqldump -uzzz -pzzz -hremotehost newdb < './tmpfile' `






"Simon" <spambucket@example.com> wrote in message
news:46ihg9Fba0apU1@individual.net...
> Hi,
>
> I need to export a 200MB database from one domain to another.
> phpMyAdmin timeout after a while and is not ideal.
>
> I don't mind spending money if I have to but this is rather urgent.
>
> I only work on win32 machines but the servers are Unix machines.
> I don't have command line access to the servers.
>
> Do you guys know anything I could use?
>
> Many thanks
>
> Simon
>
>
>

[Back to original message]