HTMLHelp Forums > how to transfer records/data of a single table

Full Version: how to transfer records/data of a single table

HTMLHelp Forums > Programming > Databases

pretty

Sep 19 2008, 12:30 AM

Hi,

To move mysql database from one server to another i have used mysqldump.

QUOTE

1) dump your database from the old server by mysqldump :

mysqldump -h host -u user -p database > dump_file

2) import the sql and data to the database via :

mysql -h host -u user -p database < dump_file

than transfered database successfully.

But my question is if i want to transfer/copy records/data of a single table then how should i do ?

Thanks in Advance...

Brian Chandler

Sep 19 2008, 12:52 AM

You should be able to reload a single table from the dumpfile you've already made of the whole database. sorry, you need to read the manual, really.

Phpmyadmin makes a lot of this stuff easier to do, btw. It has handy import/export functions for a table, which is another way to go.

This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.