SMF Support > SMF 2.0.x Support

backup/restore via phpMyAdmin

(1/7) > >>

Deprecated:
I want to download my database and then upload it to a different database, then switch my SMF over to the new database.

There is one problem. The name of the database is encoded into the backup. When you try to import it into the new database the name is wrong and pMA squawks, won't upload it.

I've handled that before by just manually editing the name inside the SQL file. But this file is way too big to be edited by any programs I have: 460 MB.

How do I get around this?

ccbtimewiz:
With a database that large, I'd use BigDump.

Deprecated:
But how do you change the database name? The download has the database name encoded inside. If you try to upload it to a different database server it barfs.

riker:

--- Quote from: Deprecated on September 08, 2008, 08:28:55 PM ---But how do you change the database name? The download has the database name encoded inside. If you try to upload it to a different database server it barfs.

--- End quote ---

I had this problem once.  I got around it by creating the name of the DB in a newly created DB and it then imported

Deprecated:
My cPanel won't let me do that. All I pick is 4.0 or 5.0 and it generates the database, user name and password. I have no idea why they won't let me pick my own. I've seen other hosting services where you can.

Navigation

[0] Message Index

[#] Next page