Moving Forum to New Host

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Scam Warning
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
User avatar
Lumpy Burgertushie
Registered User
Posts: 68304
Joined: Mon May 02, 2005 3:11 am
Contact:

Re: Moving Forum to New Host

Post by Lumpy Burgertushie »

open your sql file in a text editor.
remove the line that says: CREATE DATABASE `ukcbxc` ;
save the file and run the import again.


robert
I'm baaaaaccckkkk. still doing work on donation basis. PM your needs.

Premium phpBB 3.3 Styles by PlanetStyles.net

If nobody is in the forest, does a tree really fall?
goss
Registered User
Posts: 12
Joined: Fri Sep 16, 2016 2:59 pm

Re: Moving Forum to New Host

Post by goss »

UPDATE

Used Bigdump and ftp (all new to me) and managed to upload to site but same error?
goss
Registered User
Posts: 12
Joined: Fri Sep 16, 2016 2:59 pm

Re: Moving Forum to New Host

Post by goss »

Lumpy Burgertushie wrote:open your sql file in a text editor.
remove the line that says: CREATE DATABASE `ukcbxc` ;
save the file and run the import again.


robert
Thanks , will try that now.
goss
Registered User
Posts: 12
Joined: Fri Sep 16, 2016 2:59 pm

Re: Moving Forum to New Host

Post by goss »

now shows Error at the line 15: USE ukcbxc;

Shall i delete this line too and upload?

Regards

Goss
goss
Registered User
Posts: 12
Joined: Fri Sep 16, 2016 2:59 pm

Re: Moving Forum to New Host

Post by goss »

Deleted above and now get this error:

BigDump: Staggered MySQL Dump Importer v0.36b
Processing file: localhost.sql
Starting from line: 1
Error at the line 32: ) TYPE=MyISAM;
Query: CREATE TABLE `phpbb3_acl_groups` (
`group_id` mediumint(8) unsigned NOT NULL default '0',
`forum_id` mediumint(8) unsigned NOT NULL default '0',
`auth_option_id` mediumint(8) unsigned NOT NULL default '0',
`auth_role_id` mediumint(8) unsigned NOT NULL default '0',
`auth_setting` tinyint(2) NOT NULL default '0',
KEY `group_id` (`group_id`),
KEY `auth_opt_id` (`auth_option_id`),
KEY `auth_role_id` (`auth_role_id`)
) TYPE=MyISAM
MySQL: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'TYPE=MyISAM' at line 10
Stopped on error
Start from the beginning (DROP the old tables before restarting)
© 2003-2015 Alexey Ozerov

Regards

Goss
goss
Registered User
Posts: 12
Joined: Fri Sep 16, 2016 2:59 pm

Re: Moving Forum to New Host

Post by goss »

UPDATE:

Changed all "TYPE" to "ENGINE" then it all uploaded and some boxes with status bars showing progress appeared which was looking goos buth no have:

Seemed so close!

BigDump: Staggered MySQL Dump Importer v0.36b
Processing file: localhost.sql
Starting from line: 138001
Error at the line 138551: INSERT INTO `phpbb_search_wordlist` (`word_text`, `word_id`, `word_common`) VALUES('�', 23720, 0);
Query:
MySQL: Duplicate entry '?' for key 'PRIMARY'
Stopped on error

Thanks,

Goss
User avatar
PiperB
Registered User
Posts: 173
Joined: Mon Nov 07, 2016 6:54 pm

Re: Moving Forum to New Host

Post by PiperB »

Contact your web host support and see if they will help you transfer it. I hope you get it fixed.
<!-- IF U_LOVE_NOTEPAD++ -->
[td class=statement]I Notepad++ ![/td]
<!-- ENDNEVER --> <!-- tee hee --> :P
Whoa ooo whoa ooo whoa I'm a Lady!
Locked

Return to “[3.0.x] Support Forum”