SMF Support > Install and Upgrade Help

Do I have to give the same database name when moving host?

(1/3) > >>

Crozz:
Well suppose for some reason I want to move host, and my cPanel username in old host "abc" and in the new host I have it as "pqr".
Obviously while restoring databases the names would differ as in the old host it would abc_smf and in new it would be pqr_smf.
So would this really be a problem, while restoring? If yes, is there a solution?

K@:
You can name the database as whatever you like, within reason.

In Settings.php, you'll see this:


--- Code: ---########## Database Info ##########
$db_server = 'xxxxx';
$db_name = 'xxxxx_xxx';
$db_user = 'xxxxx_xxxxx';
$db_passwd = 'xxxxx';
$db_prefix = 'xxx_';
--- End code ---

As long as that information's correct, you should be OK.

You might find this useful...

http://wiki.simplemachines.org/smf/Repair_settings.php

Crozz:
Ah I've tried that, the data seems to be fine, only the themes wont properly display. It just displayed plain HTML when I used that.
When I read the documentation it said that it should have the same database name, thanks for clarifying it out.

I guess I must have done something wrong, all URL seems to be correct.

K@:
If the database contains the required data, I don't see why they shouldn't work, unless they call the actual name of the database, somewhere? (Which I'd find odd).

Have you got the theme's paths correctly set?

Crozz:

--- Quote from: K@ on August 24, 2012, 06:26:52 AM ---If the database contains the required data, I don't see why they shouldn't work, unless they call the actual name of the database, somewhere? (Which I'd find odd).

Have you got the theme's paths correctly set?

--- End quote ---
Yeah, I'll let the "Help Needed" board to do that I guess. Clearly I'm wrong somewhere lol.

Just quick ques, do I have to set anything like SQL compatibility or anything? In phpmyadmin there is something like that.

Navigation

[0] Message Index

[#] Next page