How to import large mysql files to my database?

To import a large mysql file to your database you need to first have SSH enabled on your account. This can be enable by submitting a support ticket requestiong this.

Once SSH is enabled on your account, you will need to place the mysql file into your file directory on your account.

Once this is done run a SSH program like Putty and connect to your account with your user details.

Once login enter the following in the command prompt:

mysql -u Database_USERNAME_here -p DATABASE_name_here < /home/username_here/public_html/mysql_file.sql

Enter the database password and wait until their is a response from the server. It may appear that nothing is happening but please be patient with this.

  • 52 Users Found This Useful
Was this answer helpful?

Related Articles

Put my website on my account?

To be able to put your website on your account you need to be able to access your file manager...

Is SSH on my account?

SSH can be enabled on request for shared hosting accounts. Please submit a support ticket if you...

Is FFmpeg supported?

Unfortunately FFmpeg is not supported on shared hosting.If you wish to uses FFmpeg you will need...

How to add a subdomain to my website?

A subdomain is a domain that is part of a larger domain. i.e. subdomain.relentlesshosting.com.au...

How do I unblock myself from the firewall?

If you have gotten yourself blocked by the firewall on our server you can follow the following...