mysql - upload large database file to the server -

i have 5gb database needs uploaded phpmyadmin , on shared server cannot access shell.is there solution can take lesser time upload? please me providing steps upload sql file. have searched through internet not find answer.

do not use phpmyadmin.

assuming have shell, upload file , feed directly mysql command.

your shell command like:

cat file.sql | mysql -uuser -ppassword database 

or can gzipped file:

zcat file.sql.gz | mysql -uuser -ppassword database 

prior doing check:

• database connection works (correct database, user , password)
• database empty :)
• mysql max packet size ok
• you have enough diskspace

---

* update *

you said not have shell access.

then have following options -

• upload file , contact support, let you.
• feed remote, cpanel have special menu can remove access, other panels have same ability too.

in case code executed on computer , like:

cat file.sql | mysql -uroot -phipopodil -hwebsite.com 

or windows:

/path/to/mysql -uroot -phipopodil -hwebsite.com < file.sql 

• do "hack" - feed through crontab, at or via php system() command.

---

if choose "hack" option, note following:

• php have max_execution_time - if set zero, there limit "imposed" hosting.
• usually hosts have limited mysql updates per hour.
• there ulimit restrictions.
• if execute feeding of 5 gb on shared server, server slow down , administrator check doing.