0
I have 20 different sets of tables inside the same bank where each of them corresponds to a virtual store. Since my tables are organized by prefix, how can I select all tables of a certain prefix to export it?
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.
1
If you use phpMyAdmin, you can do this easily:
Select the database > Click the export tab > Select the custom option > 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. Do it the way you did it just gets a little more disorganized, because the ideal would be to create a database for each store, but it doesn’t slow down because of this.
Browser other questions tagged php mysql
You are not signed in. Login or sign up in order to post.