Help please!

[virtualreality]

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

[adnan.iiui]

Hi....
i av also a problem related to this....
1. i create Mysql databse on Cpanel but my web is not accessing
i gave url as in my local host....
2. my java servlet are also not working on web not only java servlets but also java beans

[vincentg]

You can import data in shell

mysql -hHOSTNAME -uUSERNAME -pPASSWORD DATABASENAME < sql-file.sql

You can dump it also using mysqldump

Hope that helps

[Spiral]

Adding on to what vincentg said, you just FTP the database file to your server
and then login with SSH where you uploaded the file and run the command
that vincentg told you.

(In the example given in the other post, sql-file.sql would be your database)

No limit to the upload filesizes using this method.