How to import *.sql into database?

I just installed "osCAffiliate v2.0" into my server, and the sql file I need to import was only "13 kb", the strange thing is after I uploaded my "affiliate.sql" into my database table "*_affiliate", file size became "0", it's there any way I can check and make sure the files is there?


http://img165.imageshack.us/img165/9296/uxt9.jpg

 

You should probably using phpmyadmin for doing that.

 

yes, I did using phpmyadmin to import my sql file, but I can't see my file after imported.

 

I can help you with that if you would like. PM ME

 

got to

http://yourdomain.com/phpmyadmin
login using the dbusername / dbpassword

and use import feature to load sql file.

if you do not want to do that,

then download 7zip and compress is using gz ext.

 

You can also try to dump your file the easy way with bigdump: www.ozerov.de/bigdump.php

just setup your username and password before uploading the script.

 

PHPmyadmin or drop to command line and upload it like that.

 

I use phpmyadmin Just go to phpmyadmin select the database you want to import to and go to import and import the .sql file

 

If you find the database is too large you can use SSH if you have access like that.

You're going to need to change the obvious though.