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.

Site Move

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



Joined: 19 Mar 2009

Posts: 12



PostPosted: Thu Mar 19, 2009 7:43 pm 
Post subject: Site Move

Hello,
I need to move our site from one hosting company to another (our board has outgrown a shared account) and My problem is the database.
It is around 150mb in size.

So what is the best way for me to back this up and move it to the new hosting company??


Thanks
Keith
Back to top
Acaria
Board Member



Joined: 20 Feb 2009

Posts: 238



PostPosted: Fri Mar 20, 2009 1:40 am 
Post subject: Re: Site Move

This is more a theory than a knowledge. Maybe a more skilled member should confirm/deny this before you try.


I'd think it'd be as simple as this:

Go to the "Backup Database" section in the ACP and make an exact backup of the database. Get the domain and hosting plan for the new site and go to the MySQL databases section. Create the database with the EXACT same name as the old one, then go to the phpMyAdmin of that database. Just copy all of the info that backup gave you and run it. Now just create a .zip of all the files in your File Manager and upload and unpack it.

If you've done everything right, I think that would work. But like I said, please wait for a more experienced member to either confirm or deny this.
Back to top
Slackervaara
Board Member



Joined: 01 Jan 2009

Posts: 70



PostPosted: Fri Mar 20, 2009 4:35 am 
Post subject: Re: Site Move

On my web host I can't backup a database of 150 MB with phpMyAdmin, due to timeout issues (30 seconds) and thus the backup gets incomplete. I use MySQLDumper for huge backups and restores. It is free of charge also.
http://www.mysqldumper.de/en/
Back to top
dogs and things
Board Member



Joined: 18 Nov 2008

Posts: 621
Location: Spain


flag
PostPosted: Fri Mar 20, 2009 7:03 am 
Post subject: Re: Site Move

Yes, Mysqldumper is a perfect tool for working with databases.

The "Backup Database" section in the ACP isnīt good, it doesn't do complete backups of databases over a few MBs in size.

_________________
phpBB2 will never die, I hope!
Back to top
Jim_UK
Board Member



Joined: 19 Nov 2008

Posts: 541
Location: North West UK


flag
PostPosted: Fri Mar 20, 2009 9:03 am 
Post subject: Re: Site Move

Use phpmyadmin to create your database backup file.
Whilst you can not backup 150MB directly without using Bigdump or the aforementioned bit of software you can if you want split the file with a file splitter and do it a section at a time.
Many empty the 3 search tables (over 1/2 the database) and then rebuild them after.
Jim



rebuild_search_2.4.0a.zip
 Description:

Download
 Filename:  rebuild_search_2.4.0a.zip
 Filesize:  59.61 KB
 Downloaded:  438 Time(s)

Back to top
Slackervaara
Board Member



Joined: 01 Jan 2009

Posts: 70



PostPosted: Fri Mar 20, 2009 9:16 am 
Post subject: Re: Site Move

Be careful with phpMyAdmin for backup of a database of 150 MB, because I got timeout and an incomplete backup. phpMyAdmin does not warn, if the backup is incomplete and one have to view the sql-file to find out that. I know people that made a backup with phpMyAdmin and then erased the database. When restoring the database they discovered it was incomplete.

When backuping huge databases Complete inserts shall be used which improves accuracy on restore, but increases the backup-file in size with at least 100 %.
Back to top
Ram
Board Member



Joined: 23 Dec 2008

Posts: 100
Location: Somewhere over the rainbow


flag
PostPosted: Fri Mar 20, 2009 10:46 am 
Post subject: Re: Site Move

In my opinion you should empty phpbb_search_* tables and rebuild them after because they are really heavy.
Back to top
Jim_UK
Board Member



Joined: 19 Nov 2008

Posts: 541
Location: North West UK


flag
PostPosted: Fri Mar 20, 2009 6:45 pm 
Post subject: Re: Site Move

Empty the search tables (Do not drop) and rebuild later with the mod I linked.
You can split the SQL file into as many parts as you want then to get around the time out limit.
Here is the StefanL file splitter which I have used to good effect.

Personally I always use Bigdump now.

Jim
Back to top
lumpy burgertushie
Board Member



Joined: 19 Nov 2008

Posts: 216


flag
PostPosted: Sun Mar 22, 2009 3:48 pm 
Post subject: Re: Site Move

in the first place, I have never seen phpmyadmin timeout for a backup no matter what the database size and no matter what host.

however, if you empty the search tables as suggested, your database size will be reduced by as much as 2/3, then it will not be a problem


you can not use bigdump to backup a database, it is only for restoring databases.

it is what you use to overcome the php upload limit imposed by the host's settings. there is no downoad limit that I am aware of.

robert
Back to top
Holger
Board Member



Joined: 19 Jan 2009

Posts: 509
Location: Hanover


flag
PostPosted: Sun Mar 22, 2009 6:46 pm 
Post subject: Re: Site Move

I do not use anything else then Mysqldumper anymore. And I have moved around quite a lot in the past years.
You can also use the dumper to make automated backups via Cron.

It is the perfect tool.
Back to top
merebel
Board Member



Joined: 19 Mar 2009

Posts: 12



PostPosted: Sun Mar 22, 2009 11:37 pm 
Post subject: Re: Site Move

Thanks
The mysqldumper looks like it should solve my problem

Keith
Back to top
Red Dog
Board Member



Joined: 06 Mar 2009

Posts: 41


flag
PostPosted: Wed Mar 25, 2009 11:40 am 
Post subject: Re: Site Move

I've tryed bigdump and did not work for me. icon_rolleyes.gif About MySQLDumper, I can't say too much because I've never test it... It is hard to install/use? icon_smile.gif
Back to top
Holger
Board Member



Joined: 19 Jan 2009

Posts: 509
Location: Hanover


flag
PostPosted: Wed Mar 25, 2009 11:43 am 
Post subject: Re: Site Move

Give it a try.
It is easy to install.
Back to top
RMcGirr83
Board Member



Joined: 02 Dec 2008

Posts: 53
Location: East Lyme, CT


flag
PostPosted: Tue Mar 31, 2009 1:30 pm 
Post subject: Re: Site Move

Red Dog wrote:
I've tryed bigdump and did not work for me. icon_rolleyes.gif


Bigdump is used to backup a database. FWIW, bigdump chokes on "extended inserts".

Quote:
About MySQLDumper, I can't say too much because I've never test it... It is hard to install/use? icon_smile.gif


MySQLDumper is used to restore a database.

_________________
Rich McGirr
Back to top
Slackervaara
Board Member



Joined: 01 Jan 2009

Posts: 70



PostPosted: Tue Mar 31, 2009 1:34 pm 
Post subject: Re: Site Move

Bigdump is for restore a database.

MySQLDumper is both for backup and restore.
Back to top
Display posts from previous:   
Register or Login to Post    Index » General Support  Previous TopicPrint TopicNext Topic
Page 1 of 2 All times are GMT
Goto page 1, 2  Next
 
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.0161 seconds using 17 queries. (SQL 0.0026 Parse 0.0028 Other 0.0107)
phpBB Customizations by the phpBBDoctor.com
Template Design by DeLFlo and MomentsOfLight.com Moments of Light Logo