1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

Mysql file on Server , How to execute it ?

Discussion in 'MySQL' started by schandak2001, May 6, 2017.

  1. #1
    I am on Shared server , using cpanel with web hostingpad
    SEMrush
    I have a 97 MB sql file on my server.

    I want to execute that .

    How to do it ?
     
    Solved! View solution.
    schandak2001, May 6, 2017 IP
    SEMrush
  2. #2
    You can't execute an sql file you will need pull it into a MySQL database either through Import section of phpMyAdmin. You could run into problem if your host does now allow uploads as big as 97mb, it is recommended to use SSH:

    Manually upload file to your web space. Login via SSH and run the following command:

    mysql -u username -p database_name <file.sql
    Code (SQL):
    You can contact your host for help with this - if they're decent they should do it for you.
     
    GameO.Over, May 6, 2017 IP