SMF Support > SMF 2.0.x Support

trying to rebuild form backup but database names are different -Help!

(1/3) > >>

pwarnaby:
i have had a forum running here www.256clan.co.uk/forum [nofollow] for a couple of years , this was hosted by justhost. When there renewal came through at £280 i decided to get a new hosting with 123reg. I backed up my old forum , installed the new one and tried to import the backup file. I was then read the instructions! it seems teh new database has to have the same name as the old database. Seemed simple enough until i realised that 123reg wont allow me to create a new database with teh required name it will only generate database names.

So it appears im stuck with a backup with one database name and no way of creating a new database of teh same name.

Any ideas on how i can get out of this one ?

all help appreciated

Orangine:
It doesn't. Just create a new database with new hosting and import content of the old one either using phpMyAdmin or similar (not recommended) or with a tool like BigDump(recommended), and then use repair_settings.php and provide new database details.

pwarnaby:
thanks for that ill try again, dont think it allowed me to finish the import though when i used phpmyadmin but ill try again

pwarnaby:
I get this error when trying to import the database in

Error

SQL query:

-- ==========================================================
--
-- Database dump of tables in `clancou1_clancou1`
-- July 31, 2012, 10:16:46 AM
--
-- ==========================================================
--
-- Table structure for table `smf_admin_info_files`
--
DROP TABLE IF EXISTS `smf_admin_info_files` ;

MySQL said: Documentation
#1046 - No database selected

Orangine:
have you created a database on your new server? if so, add the following line as the first line of the .sql dump file:

--- Code: ---USE databasename;
--- End code ---

Navigation

[0] Message Index

[#] Next page