easy, go inside each table, there will be the structure dump function
available. that will allow you to take the data for that table only. this
may give you a smaller size of data.
--
Hidulf
http://www.hidulf.com
"Elias" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Hello.
>
> I have two MySql databases running on different servers. I have no root
> access and only PHP + Mysql and MysqlAdmin.
>
> How can i take a dump of first database (which is about 1MB) and restore
> that dump on the second one?
>
> Actually, I'm doing a structure dump, but the outputed SQL text is very
> big!..I'm not able to paste it all in the second server's sql query
textbox.
>
> Any ideas?
>
>
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
