A quick way to populate your MySQL database from a raw sql file with SSH access.

This is just useful to have somewhere so I thought I would post it. If you have many tables or records to set up it is the best way. I found this especially useful when I had a table which was over 30mb in size. 

1. Save your sql into a file (example.sql)
2. Upload to your server (/usr/local/home/httpd/vhtdocs/example.sql)
3. Log into your SSH environment
4. Simply type "mysql -h localhost -u user -p  db_name < /usr/local/home/httpd/vhtdocs/example.sql"
5. You will be prompted for the mysql password
6. The sql file will now be run

As simple as that.

Last update : 26-10-2007 08:59

Average user rating

   (0 vote)