SMF Support > SMF 2.0.x Support

backup/restore via phpMyAdmin

<< < (2/7) > >>

babjusi:

--- Quote from: Deprecated on September 08, 2008, 07:07:17 PM ---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?

--- End quote ---

Would the databases be at the same host or the new database would be in a new host?

Deprecated:
Different database name, different user name, different password, and let's just assume the host is "localhost."

But don't assume "localhost" means the same server.

riker:

--- Quote from: Deprecated on September 09, 2008, 12:25:59 PM ---Different database name, different user name, different password, and let's just assume the host is "localhost."

But don't assume "localhost" means the same server.

--- End quote ---

Maybe a silly question but have you tried downloading it from your forum at your existing host ?

Deprecated:
I've got it downloaded. Downloading is not the problem. Uploading is the problem because the database has a different name and it refuses to upload.

babjusi:

--- Quote from: Deprecated on September 09, 2008, 01:25:01 PM ---I've got it downloaded. Downloading is not the problem. Uploading is the problem because the database has a different name and it refuses to upload.

--- End quote ---

What error message do you get. Can you post here the exact error?

It can be restored in a another database with a different name as well. I have done it like 100''s of times. Matter of fact yesterday I duplicated someone''s site here. I created a new database at the cp of her host and transferred there the database of her live forum without a problem what so ever.

Navigation

[0] Message Index

[#] Next page

[*] Previous page