Restore large phpbb database to BH host

[mykdd]

Hi all,

I try to search in several page (in this forum) but couldn't find this information... can anyone point this out to me if there are any information about this in the discussion before...

Thanks...

[Believer]

Just curious if you have tried an SQL dump via SSH? It may look something like this (this depends on your comfort level with Unix/Linux):


mysql DataBaseNameToDumpInto -p < ~/home/UserName/DatabaseFileToDump.sql

I believe that syntax is correct, it works well for large dumps when I use it, but I primarily use it on a non-shared server where I also have root access and full access via SUDO. Again, don't try this if you are not familiar with Unix/Linux and if you do, back up first. I don't know how the syntax would vary on Bluehost , maybe someone who has done this here can interject and correct the syntax for others to use as a reference?

~Cheers
:D

** Note, you can do a PWD command from the current directory you are in where the "DatabaseFileToDump.sql" is located to make sure the path is correct "~/home/UserName/DatabaseFileToDump.sql" or something like that. It will probably not show you any status while it is dumping the file either, you'll have to wait until the command prompt returns and then check your databases out to see how well it worked. Depending on how large it is, there may be a restriction by BlueHost (not sure what it is though), you may want to run it on a screen incase the SSH connection times out, your dump will still finish and you can log back in and re-attach to the screen to see when it is done.

[mykdd]

Thanks believer... I will try that.