Moving phpbb

[ultimatehandyman]

My site is currently being moved from one server to another.

I have been contacted by the new server owners and have been told this-

But we are unable to create .sql file and download the backup for below 2 database as there size seems to more than 2 mb and you present provider 1and1 has some limitations in php.ini I guess so we are unable to get the backup for this database.

I have even tried to create backup from SSH access but your User does not has privileges to access DB folder using SSH access.

I have phpmyadmin in the 1and1 control panel and I thought that you could move to a new server using this and so my reply to them was-



Because the server is a managed root server they will not give anyone full
access to the server.

I was under the impression that you could back up and restore a database by
using phpmyadmin?

If I contact 1and1 and ask them for a backup it will be days old, as they
needed to back up a file before and the one they had was over a week old.

I can download the databases to my pc and they are over 100mb each, but I do
not know which bits are needed and which are not needed.

I don't understand why you can't do anything because the files are larger
than 2mb?

Is this going to be a problem as I would hate for anything to happen to the
data in the databases.

They have just replied and said -

Ok let me explain you..
On every server there is a master php.ini that control the the date download from php application such as phpmyadmin.. in this setting the limit offered by 1and1 is less so when I try to take backup of this forums it download a 0 size file as your Database size is larger than whats specified in there php.ini

Other than that second option for us to transfer the backup was from SSH access but as you dont have root access to the server it gives permission denied to us.. so we are blocked by all means by 1and1.



Does anyone know if this is true or a way to get around this?

Thanks

chez

[HB]

I assume phpMyAdmin is failing because it's trying to dump the entire database in one request; this times out for large databases. You could dump the tables individually or even in chunks, but if you can upload files to your old site, install MySQLDumper. It breaks up the save/restore into small web-friendly chunks (similar to bigdump, but in both directions). You do not need to twiddle the php.ini file. The install is trivial and the user interface is good.

[ultimatehandyman]

[SeO]

It's normal, there is no limitation for downloads, besides your hd size off course, but upload is limited, and it's a good thing because it not the server to decide of the size, would be too easy to overload a server with 1Go POST var sent from a lot of computers at once.

The solutions suggested by HB works well, you'll just need to upload your old db in the ftp, configure the db access for MySQLDumper or bigdump, and start the import.
Works on the first try in most cases, but some issues are possible if the db version are too different. It's generally still possible without too much pain this way though.

As well, if you change mysql version, you may need to change the DB set in config.php in $dbms.

It can be pretty long with big DBs, so make sure you have coffee for the night

[ultimatehandyman]

Thanks SEO,

I'm not doing it myself. I am not capable of doing this type of thing and so the new firm that I have leased the new server from are doing it as part of free migration to their server.

Since sending them the link to the phpdumper that Dan recommended on Wednesday I have not heard anything from them at all, and so I do not even know if they can do it that way or if they still insist that they need shell access or the php.ini file changing

I guess I better chase them up.

[ultimatehandyman]

Well, I would of been better off trying to do it myself!

The new web hosting firm made a right balls up of trying to migrate my site.

The forum, directory and arcade were offline for over 24 hours and in the end I had to get a webmaster to fix it all.

The hosting firm were that incompetent that they said that all the 404 errors on my site were due to the DNS settings not fully changing at all datacentres. The arcade on my server had been connected to the directory database and so would not work and the directory had lots of files missing.

Not happy with the support on the new server, I hope I don't need them contacting ever again!

[SeO]

No luck

[ultimatehandyman]

It is all sorted now, apart from the GYM sitemap does not work anymore, it shows a 404 error. I have posted in the GYM sitemap forum

[dcz]

http://www.phpbb-seo.com/boards/gym-sitemaps/discussions-vt2487.html#16797