Author |
Message |
itconstruct Board Member

Joined: 31 Mar 2009
         Posts: 17 Location: Australia

|
Posted: 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

|
Posted: 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

|
Posted: 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

|
Posted: 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: 541 Location: North West UK

|
Posted: 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

|
Posted: 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
Description: |
|
Filesize: |
58.81 KB |
Viewed: |
479 Time(s) |

|
_________________ struggling |
|
Back to top |
|
 |
Jim_UK Board Member

Joined: 19 Nov 2008
         Posts: 541 Location: North West UK

|
Posted: 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

|
Posted: 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]
Description: |
|
Filesize: |
67.89 KB |
Viewed: |
457 Time(s) |

|
_________________ struggling |
|
Back to top |
|
 |
Jim_UK Board Member

Joined: 19 Nov 2008
         Posts: 541 Location: North West UK

|
Posted: 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

|
Posted: 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: 541 Location: North West UK

|
Posted: 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

|
Posted: 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

|
Posted: 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

|
Posted: 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
_________________ struggling |
|
Back to top |
|
 |
Sylver Cheetah 53 Board Member

Joined: 17 Dec 2008
         Posts: 426 Location: Milky Way

|
Posted: 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.
_________________ Image link
My Forum || My Blog
phpBB2 forever!  |
|
Back to top |
|
 |
|