copying table to another machine

[Harmandip_Singh]

Hi, i have a development server and a live server and my database is mySQL, i need a way to copy the database tables from the live site to the development database. Any suggestions

[Pests]

phpMyAdmin has a export feature you can use. Theres also a mysql command for it, search the mysql site for it.

[superwormy]

mysqldump or PHPMyAdmin

[baddogg]

I've simply been grabbing the related files from the database, 3 files for each table and dumping them into the mysql on the recipient machine, restart the service... and BAM!

[timmymerch]

You can simply copy the files - but i usually use mysqlhotcopy - which will lock the database, flush the tables and copy the whole database to a location you specify. You can then tar and zip that directory and move it to your live server. Just be sure that you set the permissions so that mysql can read the files once you move them.