|
|
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
Navigation:
[Reply to this message]
|