Re: Copying MySQL database.

Maxim, Looks like a mysql question but whatever... mysqldump --add-drop-table -c database_name table_name > tablename_schema.sql and on the new server mysql database_name < tablename_schema.sql Reference the documentation on www.mysql.com for more information. --David Perry On Thu, 31 Aug 2000, Maxim Maletsky wrote: > a simple question: > > How to copy(transfer) a database or even a table would be enoght to another > server. > > I need to test my new script that works with mySQL > > Maxim Maletsky - maxim@j-door.com > <mailto:maxim@j-door.com> > Webmaster, J-Door.com / J@pan Inc. > LINC Media, Inc. > TEL: 03-3499-2175 x 1271 > FAX: 03-3499-3109 > > http://www.j-door.com > <http://www.j-door.com/> > http://www.japaninc.net > <http://www.japaninc.net/> > http://www.lincmedia.co.jp > <http://www.lincmedia.co.jp/>