Transferring Hosts

[Surf3rDud3]

When transferring hosts i have no way of recreating the same exact database name... like it was superbes_smf and now its xswatxin_smf... is there a way to still use it so i dont have to lose all my members and posts?

[Illori]

edit the sql backup file you have and change the database name.

[Surf3rDud3]

Whut is recommended to edit it with?

[Illori]

any decent text editor like notepad++, even wordpad could do it, but dont use programs like notepad or word

[Surf3rDud3]

When the backup is opened with Notepad++ its all crazy characters... I guess its suppose to be like this?

[Illori]

what kind of "crazy" characters? the backup should be human readable. given you are opening an sql file that was made with your hosts backup tools and not the backup from the admin panel.

[Surf3rDud3]

Oh umm how do i make a BackUp using something besides the Admin Panel then?

[Illori]

How do I backup my database?

[Surf3rDud3]

Ok i have it wut needs to be edited?

[Illori]

try to upload it to your new host first and see if you have any issues

[Surf3rDud3]

I think iw as to make a database but idk look:

Code Select Expand

Error
SQL query:

--
-- Database: `superbes_smf660`
--
-- --------------------------------------------------------
--
-- Table structure for table `smf_admin_info_files`
--
CREATE TABLE IF NOT EXISTS  `smf_admin_info_files` (

`id_file` TINYINT( 4 ) UNSIGNED NOT NULL AUTO_INCREMENT ,
`filename` VARCHAR( 255 ) NOT NULL DEFAULT  '',
`path` VARCHAR( 255 ) NOT NULL DEFAULT  '',
`parameters` VARCHAR( 255 ) NOT NULL DEFAULT  '',
`data` TEXT NOT NULL ,
`filetype` VARCHAR( 255 ) NOT NULL DEFAULT  '',
PRIMARY KEY (  `id_file` ) ,
KEY  `filename` (  `filename` ( 30 ) )
) ENGINE = MYISAM DEFAULT CHARSET = utf8 AUTO_INCREMENT =8;

MySQL said:

#1046 - No database selected

[Illori]

yes you need to create a new database on your server, then select it in phpmyadmin before you do the import.

[Surf3rDud3]

Ok it uploaded with no problem... whut do i do now lol?

[Illori]

have you read How do I move my SMF forum to a different host? ?

[Surf3rDud3]

Code Select Expand

500 Internal Server Error
The request was not completed. The server met an unexpected condition.

88.198.6.24/~xswatxin/xswatx.info/ (port 80)
Please forward this error screen to 88.198.6.24's WebMaster.

Apache/2.2.17 (Unix) mod_ssl/2.2.17 OpenSSL/0.9.8e-fips-rhel5 mod_jk/1.2.31 mod_bwlimited/1.4 mod_fcgid/2.3.6 Server at 88.198.6.24 Port 80

[Illori]

and where do you get that? i would really suggest you contact your host and ask if they offer transfer services and let them get you setup as it seems you dont know what you are doing.

[Surf3rDud3]

Yea i dont know wut im doing... thats who purpose of support...

[Illori]

i have linked to all the information on what you should do, the other option is doing it for you and i am not going to do that.

[Adish - (F.L.A.M.E.R)]

What Illori suggested is a very long way to do. There is a very easy fix for it.

Once you have the database name as "xswatxin_smf", use the tool "repair_settings.php?" and change the database name from "superbes_smf" to "xswatxin_smf". Also, your user for that database would have changed. So, give it a prefix of xswatxin_ aswell.

You should be done and everything would have been retrieved once the above is done.

Alternatively, you can edit Settings.php and change the database name and user which should do the fix as well.

EDIT:
What is the error which are facing while restoring your database? How do you restore your database? PhpMyAdmin or some other tool?

[Illori]

you would also have to fix any other paths using repair_settings.php, given that your new host does not have the same paths as your old host.