Author |
Message |
merebel Board Member
Joined: 19 Mar 2009
Posts: 12
|
Posted: Thu Mar 19, 2009 3: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
|
Posted: Thu Mar 19, 2009 9:40 pm 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
|
Posted: Fri Mar 20, 2009 12: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: 628 Location: Spain
|
Posted: Fri Mar 20, 2009 3: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: 656 Location: North West UK
|
Posted: Fri Mar 20, 2009 5: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
Description: |
|
Download |
Filename: |
rebuild_search_2.4.0a.zip |
Filesize: |
59.61 KB |
Downloaded: |
1222 Time(s) |
|
|
Back to top |
|
|
Slackervaara Board Member
Joined: 01 Jan 2009
Posts: 70
|
Posted: Fri Mar 20, 2009 5: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
|
Posted: Fri Mar 20, 2009 6: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: 656 Location: North West UK
|
Posted: Fri Mar 20, 2009 2: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: 18 Nov 2008
Posts: 266
|
Posted: Sun Mar 22, 2009 11:48 am 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
|
Posted: Sun Mar 22, 2009 2: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
|
Posted: Sun Mar 22, 2009 7: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
|
Posted: Wed Mar 25, 2009 7:40 am Post subject: Re: Site Move |
|
|
I've tryed bigdump and did not work for me. About MySQLDumper, I can't say too much because I've never test it... It is hard to install/use?
|
|
Back to top |
|
|
Holger Board Member
Joined: 19 Jan 2009
Posts: 509 Location: Hanover
|
Posted: Wed Mar 25, 2009 7:43 am Post subject: Re: Site Move |
|
|
Give it a try.
It is easy to install.
|
|
Back to top |
|
|
RMcGirr83 Board Member
Joined: 01 Dec 2008
Posts: 53 Location: East Lyme, CT
|
Posted: Tue Mar 31, 2009 9:30 am Post subject: Re: Site Move |
|
|
Red Dog wrote: | I've tryed bigdump and did not work for me. |
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? |
MySQLDumper is used to restore a database.
_________________ Rich McGirr |
|
Back to top |
|
|
Slackervaara Board Member
Joined: 01 Jan 2009
Posts: 70
|
Posted: Tue Mar 31, 2009 9:34 am Post subject: Re: Site Move |
|
|
Bigdump is for restore a database.
MySQLDumper is both for backup and restore.
|
|
Back to top |
|
|
|