The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Help please!

Discussion in 'General Discussion' started by virtualreality, Feb 10, 2009.

  1. virtualreality

    virtualreality Well-Known Member

    Joined:
    Jan 18, 2008
    Messages:
    76
    Likes Received:
    0
    Trophy Points:
    6
    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
     
  2. adnan.iiui

    adnan.iiui Registered

    Joined:
    May 24, 2009
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    Uploading MySql Database

    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
     
  3. vincentg

    vincentg Well-Known Member

    Joined:
    May 12, 2004
    Messages:
    140
    Likes Received:
    2
    Trophy Points:
    18
    Location:
    new york
    You can import data in shell

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

    You can dump it also using mysqldump

    Hope that helps
     
  4. Spiral

    Spiral BANNED

    Joined:
    Jun 24, 2005
    Messages:
    2,023
    Likes Received:
    7
    Trophy Points:
    0
    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.
     
Loading...

Share This Page