Uploading huge sql files.

Insert huge data into mysql database. It is very simple to upload the big sql files by accessing and executing through SSH.

INTRODUCTION

It is a common practice for the developers to upload huge sql data at remote server. Sometimes it become a very big problem, when phpmyadmin has max upload size 2MB and also php upload size is set at 2MB. You can do it very easily with SSH.

Upload a file through your ftp account in any directory.

For Example:

backup.sql to /htdocs/sqlcommand/

Now connect through SSH using putty.

Use the following command to upload the database.


mysqldump --opt --user=username --password database < backup.sql


This will upload the data present in your mysql file with in no time.

Parameters Details:

--user=username // Database Username

--password // Database password

database // Database Name

backup.sql // Sql file you want to upload.