Moving tables w/ certain prefix to another db
Please note that I have absolutely no idea how to code mySQL - whatsoever. I can, however, plug queries into phpMyAdmin ;)
I may need to move all of my tables starting with prefix abc_, for example, in the future. When it comes time, I'll need to move those tables to a different db (I would have set them up that way; however, I only get 1 mySQL db w/ 1&1 business plan). Is there a query that I can run to do this... or some php script that automatically does it?
Thanks for the help.