I have a database with approx 100 tables. I want to write a process that exports this database as a .sql file.
Easy enough right? Well... maybe not. I want some of the tables to export the data inside them, and other tables to export as empty with keys set to 0.
I'm using php but a ssh command would work fine as well.
Thanks in advance for any guidance or suggestions you may be able to provide.