export-example.ts

```ts
import AdmZip from 'adm-zip';
import { NextApiRequest, NextApiResponse } from 'next';

export default async function handler(
  req: NextApiRequest,
  res: NextApiResponse,
) {
  const zip = new AdmZip();

  zip.addFile(
    `db.sql`,
    Buffer.from(`${yourSQLData}`, `utf8`),
    ``,
  );

  res.setHeader(`Content-Type`, `application/zip`);
  res.setHeader(`Content-Disposition`, `attachment; filename=export.zip`);
  res.send(zip.toBuffer());
}
```