I have 20 sets of different tables inside the same bank where each one corresponds to a virtual store. Since my tables are organized by prefix, how can I select all the tables in a given prefix to export?
For example if I want to export the table with prefix z12 _ ?
Can the performance of my stores be affected since I have 20 tables within the same bank? The bank currently has 250MB. Thanks for the clarification.
If you use phpMyAdmin, you can easily do this:
Select the database > Click the Export tab > Select the custom > Find the prefix you want to export > Select the first table, then press shift and select the last table > Click Run (at the bottom of the page).
On performance, it will depend on the server you use. Doing it the way it did just gets a bit more disorganized, as it would be ideal to create a database for each store, but do not slow down because of it.
