How do i go about exporting a local database?
sqlite dump or postgres dump might help you. Look up these command and google it
The local database is stored in the root of your project in a temp folder, (/.tmp/data.db) (at least mine is running Strapi SQLite/Postgres), once you have that, you can use a command like @Bibek_Gupta mentioned, or alternatively if you prefer a free GUI approach, try DB Browser for SQL Lite. From there you can perform the export and much more