how to upload a 87.5mb sql database

I used bigdump.php, but fail. it said my file is too large. please help

 

Have you tried doing it though PHPMA? if you can't do it from your computer you could send the file to your hosting provider and ask them to do it.

 

You can import sql file easily if you have shell access. For reference http://dev.mysql.com/doc/refman/4.1/en/mysql.html

 

Pack it using winRar, split file into few parts, upload, unpack on server.

 

my English is limited, so i could not find my answer there.

 

Do you have shell access?

 

yes, but i don't know how to use it.

 

An SQL Database is just a plain text file. Open the file with a text editor and split it into multiple pieces. Import each piece one at a time. I do this all the time with MySQL Databases that are too large. You can split the database any where so long as it is not in the middle of a command.

 

Install mysqldumper on the server - http://mysqldumper.de/en/

Upload file to the mysqldumper file manager folder with an FTP program - http://filezilla-project.org/

Use mysqldumper to restore database. Mysqldumper can also be used to backup your database.

 

You can execute SQL statements in a file from shell like

shell> mysql db_name < script.sql

Code (markup):

 

i will try this path. it seems workable.

 

Here is some more info, maybe it's easier to understand.
Backing Up & Restoring a MySQL Database using phpMyAdmin / SSH