SQL Help please

Soldato
Joined
23 Oct 2002
Posts
4,385
Location
North Devon
I think my heads going to explode before long at this rate.
I'm trying to move a forum from one hosting company to another. Sounds easy.
In trying to move the sql database across, I've been following the guide here.
All was going swimmingly until I tried to upload the database to the new host.
The old host, Servage, gives me my own user area and my own sql databases, so when I called the database 3diphp, that was fine.
The NEW host, however, insists on adding my username to the database name, making it username_3diphp.
Didn't think it'd be a massive problem, but when I try to import the old database, it says user 3diphp does not have access.
Servage offers no facility to add/edit users. The new host does, but it seems to just refuse to accept what I tell it.

So, I'm left trying to edit the sql file itself, and I'm totally in over my head.
Any ideas at all?

EDIT:: Nevermind, sorted it out. Thanks for looking.
Thanks
Mads
 
Last edited:
Turns out for one part I had to select all the tables in one section before trying to export them, then when it did that, I had to export it to view, since if I saved it it would throw up errors on uploading.
Once it was open to view, I changed the database name in it and uploaded as a txt file. Went swimmingly... if rather surprisingly.
 
Back
Top Bottom