phpBB2Refugees.com Logo
Not affiliated with or endorsed by the phpBB Group

Register •  Login 

Continue the legacy...

Welcome to all phpBB2 Refugees!Wave Smilie

This site is intended to continue support for the legacy 2.x line of the phpBB2 bulletin board package. If you are a fan of phpBB2, please, by all means register, post, and help us out by offering your suggestions. We are primarily a community and support network. Our secondary goal is to provide a phpBB2 MOD Author and Styles area.

moving forum hosting

Goto page Previous  1, 2, 3
 
Search this topic... | Search General Support... | Search Box
Register or Login to Post    Index » General Support  Previous TopicPrint TopicNext Topic
Author Message
itconstruct
Board Member



Joined: 31 Mar 2009

Posts: 17
Location: Australia


flag
PostPosted: Sat Jul 25, 2009 9:18 am 
Post subject: Re: moving forum hosting

rapidyellow wrote:
itconstruct wrote:


Change this line : CREATE DATABASE `buxtonra_buxtonforum` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;

to this one :

CREATE DATABASE `buxtonr1_forumdb` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;

Please try that and let us know how you go!


I cant change that as its an error message, and not text in the file bigdump.php


It's in the database backup file you uploaded to the server!

_________________
I.T. Construct
Please contact me via email/im for help at reasonable prices.
USA and Australian Based Webhosting
email: admin@itconstruct.com.au
- Visit http://www.itconstruct.com.au
Back to top
rapidyellow
Board Member



Joined: 30 Mar 2009

Posts: 65
Location: cheshire, UK


flag
PostPosted: Sat Jul 25, 2009 9:31 am 
Post subject: Re: moving forum hosting

I can only access that file [localhost.sql ?] via ftp or file manager via control panel, its 52mb and I cant seem to be able to open it, can i open it on my computer? if so, what with
_________________
struggling
Back to top
itconstruct
Board Member



Joined: 31 Mar 2009

Posts: 17
Location: Australia


flag
PostPosted: Sat Jul 25, 2009 11:11 am 
Post subject: Re: moving forum hosting

rapidyellow wrote:
I can only access that file [localhost.sql ?] via ftp or file manager via control panel, its 52mb and I cant seem to be able to open it, can i open it on my computer? if so, what with


It needs to be opened with Notepad++ . I believe that will be the correct file as it should contain the database as .sql refers to a sql file which is what the extension is when you backup a database from phpmyadmin without compression.

If you open it locally on your machine make sure you re-upload and update the file on the webserver.

If you can edit it via cPanel this may be easier.

Good Luck.

_________________
I.T. Construct
Please contact me via email/im for help at reasonable prices.
USA and Australian Based Webhosting
email: admin@itconstruct.com.au
- Visit http://www.itconstruct.com.au
Back to top
rapidyellow
Board Member



Joined: 30 Mar 2009

Posts: 65
Location: cheshire, UK


flag
PostPosted: Sat Jul 25, 2009 11:53 am 
Post subject: Re: moving forum hosting

ok, I will have a look, on my way out now so it wont be until early sunday
_________________
struggling
Back to top
Jim_UK
Board Member



Joined: 19 Nov 2008

Posts: 538
Location: North West UK


flag
PostPosted: Sat Jul 25, 2009 3:39 pm 
Post subject: Re: moving forum hosting

Jim_UK wrote:
If the database already exists then remove the section from the sql file


The sql file is your database backup file not bigdump.php

Open your backup file in a text editor such as Crimson Editor (free) or Notepad++ (also free) and near the beginning you will find the instruction to create the database. That is the instruction that Bigdump stopped at and reported an error with.
Delete that line and then just click "Save"
If you do not have a blank database ready to accept the tables and data contained in the SQL file (remember that is the backup one) then create one with whatever tool your host provides. Give it the same name as the original database.
Now replace your SQL file on the server with your edited one and run Bigdump again.

Jim
Back to top
rapidyellow
Board Member



Joined: 30 Mar 2009

Posts: 65
Location: cheshire, UK


flag
PostPosted: Sun Jul 26, 2009 6:27 pm 
Post subject: Re: moving forum hosting

downloaded notepad++ and opened the sql file

can you please tell me what number line[s] to delete from the screenshot attached



sql.jpg
 Description:
 Filesize:  58.81 KB
 Viewed:  466 Time(s)

sql.jpg



_________________
struggling
Back to top
Jim_UK
Board Member



Joined: 19 Nov 2008

Posts: 538
Location: North West UK


flag
PostPosted: Sun Jul 26, 2009 8:04 pm 
Post subject: Re: moving forum hosting

Delete lines 21 and 22

Jim
Back to top
rapidyellow
Board Member



Joined: 30 Mar 2009

Posts: 65
Location: cheshire, UK


flag
PostPosted: Sun Jul 26, 2009 8:15 pm 
Post subject: Re: moving forum hosting

thanks jim

have just give it another go, and now got this: [see attachment]



dump1.jpg
 Description:
 Filesize:  67.89 KB
 Viewed:  443 Time(s)

dump1.jpg



_________________
struggling
Back to top
Jim_UK
Board Member



Joined: 19 Nov 2008

Posts: 538
Location: North West UK


flag
PostPosted: Mon Jul 27, 2009 8:27 am 
Post subject: Re: moving forum hosting

The most likely reason for that is that you selected "Extended inserts" when you made the backup sql file.
Bigdump will not work with "extended" inserts.

If you still have access to the original database then you should make the backup again but without the "extended" inserts.

An alternative to Bigdump is to split the sql file into several sections and then upload via the "Import" in phpmyadmin.
PM me your email address and I will send you a file splitter you can use.

Jim
Back to top
rapidyellow
Board Member



Joined: 30 Mar 2009

Posts: 65
Location: cheshire, UK


flag
PostPosted: Mon Jul 27, 2009 9:34 am 
Post subject: Re: moving forum hosting

thanks - have sent email via your profile
_________________
struggling
Back to top
Jim_UK
Board Member



Joined: 19 Nov 2008

Posts: 538
Location: North West UK


flag
PostPosted: Mon Jul 27, 2009 1:00 pm 
Post subject: Re: moving forum hosting

Just got back home.
Have emailed the StefanL file splitter to you.

Jim
Back to top
rapidyellow
Board Member



Joined: 30 Mar 2009

Posts: 65
Location: cheshire, UK


flag
PostPosted: Wed Jul 29, 2009 12:11 pm 
Post subject: Re: moving forum hosting

Solved

Many thanks for everyones help, in particular Jim who went out of his way and above the call of duty to help me out by taking a close look at my database to see why bigdump would not process it, as well as the fact he altered a couple of forum files to install mods.

Many, many thanks.

Nik

_________________
struggling
Back to top
Holger
Board Member



Joined: 19 Jan 2009

Posts: 509
Location: Hanover


flag
PostPosted: Sun Aug 02, 2009 1:46 pm 
Post subject: Re: moving forum hosting

If you are struggling around with such problems: use mysqldumper on the old and the new host and it might work directly.

Great that you solved it though!
Back to top
rapidyellow
Board Member



Joined: 30 Mar 2009

Posts: 65
Location: cheshire, UK


flag
PostPosted: Sun Aug 02, 2009 8:16 pm 
Post subject: Re: moving forum hosting

Holger wrote:
If you are struggling around with such problems: use mysqldumper on the old and the new host and it might work directly.

Great that you solved it though!


thanks for that anyway icon_biggrin.gif

_________________
struggling
Back to top
Sylver Cheetah 53
Board Member



Joined: 17 Dec 2008

Posts: 426
Location: Milky Way


flag
PostPosted: Tue Aug 18, 2009 7:46 pm 
Post subject: Re: moving forum hosting

Yes... Big Dump did not work for me either. Seems to be non functional. icon_confused.gif
_________________
Image link
My Forum || My Blog

phpBB2 forever! icon_smile.gif
Back to top
Display posts from previous:   
Register or Login to Post    Index » General Support  Previous TopicPrint TopicNext Topic
Page 3 of 3 All times are GMT
Goto page Previous  1, 2, 3
 
Jump to:  

Index • About • FAQ • Rules • Privacy • Search •  Register •  Login 
Not affiliated with or endorsed by the phpBB Group
Powered by phpBB2 © phpBB Group
Generated in 0.0236 seconds using 17 queries. (SQL 0.0029 Parse 0.0033 Other 0.0174)
phpBB Customizations by the phpBBDoctor.com
Template Design by DeLFlo and MomentsOfLight.com Moments of Light Logo