OT: MySQL Databases

[Fyron]

It is a copy of the physical database files. EDIT: I can get access to the directory to upload them to, so that is not a problem. Is it a bad idea to do it this way? Should I manually create all of the databases via Cpanel first, then upload the files? Never worked with the actual database files.

Is there some easy way to convert them to SQL statements, without trying to get a working MySQL and web server on my own machine? Or would it be better to try to get them as an exported SQL file from my previous web host?

[Gandalf Parker]

Richards definetly the best choice on the SQL internals.

But I have seen alot of domain movement by CPanel. You might want to set it up in cpanel first in case there are settings appropriate to that site. Then when it creates the empty database in the right place with the right pointers, you can try overwriting it with the saved copy.

If that fails the export/import might be the next thing to try but again best to have an empty of the same name already in place.

As a last resort you could write a SQL script to access each record and "input" it into the new one. Definetly as a last resort but if the file has hundreds of records and not thousands then it wouldnt be too bad.