MySQL AI  /  ...  /  Updating a Vector Store

5.6.3 Updating a Vector Store

To keep up with the changes and updates in the documents in your local directory, you must delete and recreate the vector store table. This ensures that the responses generated by GenAI are up-to-date.

The following sections in this topic describe how to update a vector store:

Before You Begin

Complete the steps to set up a vector store.

Deleting and Recreating the Vector Store

To delete and recreate the vector store table and vector embeddings, perform the following steps:

  1. Delete the vector store table:

    mysql> DROP TABLE VectorStoreTableName;

    Replace VectorStoreTableName with the vector store table name.

  2. To create new embeddings for the updated documents, repeat the steps to set up a vector store.