How to backup only comments in my site

In my website many comme开发者_JAVA百科nts have been added, while I worked on improvements at my localhost. Now I want to transfer the database from my system to the online website.

I want to retain the comments added online. How can I do it?

I would stage this to make sure it works properly, but install Backup and Migrate and create a profile that only backs up the comments table. Run the backup manually on the live host, and restore it on the devel host.

The complication would be any other modules that implement hook_comment and store things elsewhere.

You need to ensure that the comments table in both databases are the same. Doing a mysql dump of the data, and then importing the dump would do this for you.