Re: Best way to take a copy of a Database from Server to server

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" <elias_bachaalany@yahoo.com> wrote in message news:20010807125524.74017.qmail@pb1.pair.com... > 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? > > >