Hi Friend,

I have a JSP database SQL file that is more than 10 MB size that is on my local computer. I try to import it via phpMyAdmin to a created empty MySQL database, but the phpMyAdmin file import limits to (Max: 51,200 KiB).

Can I do like this: upload the JSP database SQL file via FTP to web server (/public_html/) and then run restoration via SSH? --- What are the commands to run restoration via SSH? And if the database is successfully restored, how can I run it to communicate with the web server??

Or, are there any other, good options to deal with uploading the database SQL file and formally setting up the database?

Thank you very much friend!

David

Assuming your database is MySQL, sure ... upload the file, create the database (any way you wish --- `mkdir /var/lib/mysql/databasename && chown mysql:mysql /var/lib/mysql/databasename` works in a pinch), then simply "mysql databasename < filename" to import it.

I was wondering what he meant by setting up the database. Do you mean as far as loading it, or configuring the tables, etc. ?

Before you can import a database, you have to create it so there's somewhere to import to. He's already taken that step. The rest will be handled by importing the file using the lines I suggested.