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.
Ideas Centre
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
User avatar
Lumpy Burgertushie
Registered User
Posts: 64839
Joined: Mon May 02, 2005 3:11 am
Contact:

Re: Moving Forum to New Host

Post by Lumpy Burgertushie » Sat Nov 26, 2016 2:36 pm

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 am available for custom work on a donation basis. Please send me a PM with your needs.

Premium phpBB 3.2 Styles by PlanetStyles.net

OK, so what's the speed of dark?

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

Re: Moving Forum to New Host

Post by goss » Sat Nov 26, 2016 2:40 pm

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 » Sat Nov 26, 2016 2:41 pm

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 » Sat Nov 26, 2016 2:49 pm

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 » Sat Nov 26, 2016 3:00 pm

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 » Sat Nov 26, 2016 3:41 pm

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: 172
Joined: Mon Nov 07, 2016 6:54 pm

Re: Moving Forum to New Host

Post by PiperB » Tue Nov 29, 2016 4:36 pm

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”

Who is online

Users browsing this forum: Badhon_raj, Bing [Bot], eastender lee, wads24 and 89 guests