Posted by Simon on 02/28/06 14:52

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

hum, how do you do that?

>
> 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' `
>

Yes, I guess I could always do that.
I also found the MySQL administrator on www.mysql.com.

Both domains seem to have remote access, so I should be ok, (I hope).

A script would have been great, because the problem is that phpmyadmin
timeout after 30s, so a JavaScript type of script would have been nice.

Simon

[Back to original message]