hi I have little problem of my sql. I want to transfer my website from one server to another server but when I try to importe the database file of my website. I foud there was limit only 50MB db file can be upload. while my db file size is near by 300MB now tell me how can I solve this problem.
Back the database up to a text file (.sql is easiest). Manually chop the file into <50MB pieces. Import them one at a time. (It's only 6-7 files, so that's faster than finding some program that will do it for you.)
edit your php.ini parameters Change those lines: upload_max_filesize, post_max_size. Restart your vps/server and its done. If you are under hosting account contact your hosting provider.
Ask your hosting provider to do this for you. Most provide assistance with transfer. It's usually automated depending on hosting software (in example in WHM interface there's a feature to copy accounts from other servers by providing account credentials). Transfer can usually be done by doing a global backup on old host, transferring directly from server to server (very fast compared to regular home connections) and restoring backup on new host. You can also copy sql file with SSH and WGET http//..url-to-your.sql directly from that server if SSH is enabled, or ask your provider to do that for you.
Changing parms to allow larger uploads is nice, but when he exceeds MySQL's max filesize, none of that will do any good. Cutting the file up will solve it no matter how large the file gets. (If you already have the file on the server but it's too large for MySQL, Big Dump will load it.)