Hosting Problem

Hi, I just bought a site and a database for a site of mine. I have a reseller and just created a cpanel account. Added my domain to the cpanel.
Now the proble is that the database is to big and the seller asked me to ask my host to enable SSH. What is SSH and why cant I just install using cpanel? The database size is 1GB.
Need help to solve this problem asap. Thanks

 

Can install it for you without SSH as well. PMing you details.

 

Thanks for the superb response via PM. Will keep this in mind. Still waiting of other alternative first though. Rep+
If there are anyone else who can install the database without using SSH PM me your rates too and your payment option. I accept PP and MB but prefer MB more. Let me know

 

Here is my advice for free

phpMyAdmin allows uploads upto 51200 KB via the browser. So, make parts of your 1 GB database dump, which are smaller than or equal to the above size. Then import them in the correct order.

Try it & let me know how it goes.

Ishan

 

I suggest you use

Remote Sql As you can import any DB Size

 

I would say better upload the 1 GB file in a .sql format to your /home/<user>/

where <user> is your account (from your ftp this is the root when you login using cPanel username and password)

Then contact your host asking them to restore the database for you or ask them to provide you SSH access.

The SSH command would be

mysql -u db_username -p db_name < /home/<user>/backupname.sql

Code (markup):

This is the safest method if you (your host) can do it this way.

 

hi
i dont think with normal hosting you be able to do SSH
you need vps/dedicate server to use ssh,
why not telling him use a back up option and then use ftp ur self?

 

I can help out in this without using any SSH.. Let me know if youve not done it yet.

 

Thanks everyone. Really appreciate all of your opinions. Rep+

 

Emm.. how can we split it?

 

If you're unable to get this done via SSH, have you looked into bigdump?

http://www.ozerov.de/bigdump.php

 

You can open it in a text editor & make parts.

You could think of it as making a new file for each paragraph in some text file.


Or you could try the attached script. It comes with instructions on how to use it to upload large dumps.


Or this - http://www.rusiczki.net/blog/blogstuff/SQLDumpSplitter.zip

Let me know if you need any further help.

Ishan

 

Did you manage to get this done yet ?

 

SSH is a command line interface for Linux that allows you to do things directly on the server. You can monitor all the running programs, really, anything you need. Most hosts will nto allow you SSH access on a shared environment (reseller is a shared env.). This is due to security risks. You MAY be able to get jailed SSH, which, essentially, limits you to certain things.

And it would not be a good thing for you to mess with if you don't have any knowledge of it. You can really muck up a server if you do something wrong.