> ## Documentation Index
> Fetch the complete documentation index at: https://private-7c7dfe99-home-button.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# Resyncing specific tables

> Resyncing specific tables in a MySQL ClickPipe

There are scenarios where it would be useful to have specific tables of a pipe be re-synced. Some sample use-cases could be major schema changes on MySQL, or maybe some data re-modelling on the ClickHouse.

While resyncing individual tables with a button click is a work-in-progress, this guide will share steps on how you can achieve this today in the MySQL ClickPipe.

<h3 id="removing-table">
  1. Remove the table from the pipe
</h3>

This can be followed by following the [table removal guide](/integrations/clickpipes/mysql/remove-table).

<h3 id="truncate-drop-table">
  2. Truncate or drop the table on ClickHouse
</h3>

This step is to avoid data duplication when we add this table again in the next step. You can do this by heading over to the **SQL Console** tab in ClickHouse Cloud and running a query.
Note that we have validation to block table addition if the table already exists in ClickHouse and isn't empty.

<h3 id="add-table-again">
  3. Add the table to the ClickPipe again
</h3>

This can be followed by following the [table addition guide](/integrations/clickpipes/mysql/add-table).