how to import a database

[amin3d]

Hello every one.
These days i have faced to big problem . it is g database my database. My database type is mysql and it is so big. i want to know how can i import a database except using Phpmyadmin and things that i must say about my condition are my database is on myftp and the extension of it is .gz and my server is Linux and dont access to shell to use its command for importing database. IS there any script or code snippet that i can use?
Thanks

[cahva]

Well you can try to run with exec commands if your host allows. Heres a couple of ways.

ob_start();
passthru('mysqldump -u [user] -p[password] dbname');
$out = ob_get_clean();
$fp = fopen('dump.sql','w');
fwrite($fp,$out);

This should work if safe mode is not set:

exec('mysqldump -u [user] -p[password] dbname> dump.sql');

If those fail, you're almost out of luck. Try with full path to mysqldump also eg. /usr/bin/mysqldump

If you dont succeed, you just have to ask your host to make the dump for you.