How to export a table (hosted server) & import on local pc without SSH

[jezzer300]

Hi,

MysqlAdmin has a limit of 2mb or so for importing data.
I don't have SSH access for backup.
I can't "SELECT ... INTO OUTFILE" as my database is in a location administered by my hosting company, I have no access.

What's the best (easy) way for me to export data (hosted lynux) and import again on another machine (win xp). In other words backup.

Why does mysqladmin allow huge exports in ziped files and only small imports?

Answer's on a postcard!

Thanks.

[coopster]

Actually, that 2M limit you are hitting is probably due to the PHP default setting for upload_max_filesize [php.net].

My preferred way to move MySQL data from a shared host production machine to a local machine is mysqldump [dev.mysql.com] and secure FTP. Faster and easier than a script.

OK, I just read your thread title again. Sorry, didn't realize you didn't have shell access. You could try running a command through the system [php.net] function -- but if your host is that tight with SSH, I hardly believe you are going to have authority to system().

Wow, tight spot ...