SSH or not?

[jakaroo]

Is it possible to upload, maintain and backup a large database without the use of SSH?

[Zachery]

Is it possible to upload, maintain and backup a large database without the use of SSH?
Not realisticly.

[Rob-Morgan]

At what sort of size would a database be in theory too big for phpMyAdmin? Just a rough idea.

[KanyeWest]

phpmyadmin the most you can upload is around 2 mb

[Rob-Morgan]

What about download?

[Zachery]

Thats totally relevant to the php/mysql settings/.

[WhiteOx]

Search for a file called bigdump.php it's worked for me. :)

[Blootix.com]

For my phpMyAdmin I could upload 5.5 MB. But that's it, and I already have 4.7 or something even though my forums are about 1-2 weeks old...

So I'd HIGHLY suggest SSH access. Though phpMyAdmin is easier to use, SSH gets you all the SQL.

[Zachery]

Its easier to use SSH and mysql dump, really, you can do quite abit more though the shell.

[stuarttunstall]

Hi

As Zachery knows, I had this very same situation arise recently, my current host does not allow SSH access, which, apart from a spate of "downtime" was one of my reasons for moving. My new host does allow SSH:)

As my site/database is still rather new/small, with a database around 9mb in size , I used the back up feature in vB to back up my database to my PC, as I had no SSH, then used SSH to restore it to my new server, worked perfect as far as I can see. Not sure if the vB back up feature is reliable on large databases? if you use SSH to restore?

Just another "off topic" comment, I would just like to thank Zachery for his help during my move, along with a couple of other members, ;) The support from this site, and the quality of the product, makes it all worth the money, keep up the good work!
Sorry.....off topic;)

Stuart