I am not an sql engineer by any means and I have an issue with my host. It appears that one of their servers has loads of traffic and it is causing timeouts on our site as we are on a shared platform.
I have a need to migrate my DB to another server, however, I cant name it the same as the platform wont let me. The myphp admin only allows file import f up to 2048k and when i do a dump of the db in mysql workbench i am not knowledgable enough to get it to strip the database name off so when i try and reimport it wont let me.
We need this done asap as the site is unusable and are happy to pay if anyone can help