Results 1 to 9 of 9

Thread: sql question     submit to reddit submit to twitter

  1. #1
    Fake Numbers
    Join Date
    Jun 2008
    Posts
    80
    BG Level
    2

    sql question

    I'm using blackapplehost.com and I almost have eqdkp uploaded but 2 files won't upload due to permissions. All the other files I can change but these two wont change.

    Command: PASV
    Response: 227 Entering Passive Mode (74,86,223,249,153,100)
    Command: STOR mysql_data.sql
    Response: 227 Entering Passive Mode (74,86,223,249,173,47)
    Command: STOR mysql_structure.sql
    Response: 553 Filetype not allowed. File mysql_data.sql won't be saved.
    Error: Critical error
    Response: 553 Filetype not allowed. File mysql_structure.sql won't be saved.
    Error: Critical error

    How can I get this to work?

  2. #2
    CoP Dynamis
    Join Date
    Feb 2007
    Posts
    257
    BG Level
    4
    FFXI Server
    Unicorn

    Quote Originally Posted by Grandphoenix View Post
    Response: 553 Filetype not allowed.
    Is your host not allowing extensions with .sql? That's what it seems like from the message above. Is this a free host?

  3. #3
    Fake Numbers
    Join Date
    Jun 2008
    Posts
    80
    BG Level
    2

    Quote Originally Posted by virusiidx View Post
    Is your host not allowing extensions with .sql? That's what it seems like from the message above. Is this a free host?
    Hmm it appears it isn't loading any of the 4 .sql i tried to send. I thought it was the attributes being 553 being a problem. I even copied the text over ontPerhaps something I can do in phpmyadmin?

  4. #4
    CoP Dynamis
    Join Date
    Feb 2007
    Posts
    257
    BG Level
    4
    FFXI Server
    Unicorn

    Was there any instructions given? Those files might be database tables to be uploaded via phpbyadmin like you said.

  5. #5
    Fake Numbers
    Join Date
    Jun 2008
    Posts
    80
    BG Level
    2

    Step 5-1:
    Database Host:
    Your MySQL server name. If it resides on the same server as the web server,
    you should enter 'localhost'
    Database Name:
    The name of the database you created for EQdkp, usually 'eqdkp'.
    Database Username:
    The username with permission to access the database. If you didn't
    create the database yourself, your host should have given you this
    information.
    Database Password:
    The password used with the username from above.
    Prefix for EQdkp tables:
    Simply prefixes the name of each table that EQdkp creates and uses.
    The default of 'eqdkp_' should be sufficient for most installations.

    Domain Name:
    Should be detected automatically by the installation script, but if not
    just put the domain name of your server here (ex: mydomain.com, Untitled Document).
    Webserver port:
    Unless the web server is running on a port other than the default (80), just leave
    the setting as-is.
    Script path:
    The path following the domain name where the script is located. Example: If the full
    path to the install script is http://mydomain.com/user/eqdkp/, you would enter
    '/user/eqdkp/', if the full path was http://mydomain.com/eqdkp/', the path would be
    '/eqdkp/'.
    This was the step I was having issues with. Think it might just be the site.

  6. #6
    CoP Dynamis
    Join Date
    Feb 2007
    Posts
    257
    BG Level
    4
    FFXI Server
    Unicorn

    sounds like it's just blocking you from uploading a file with the .sql extension, maybe try uploading them as .php and rename them after? Also, did you already create the databases like it says?

    I just tried installing that eqdkp just to see and it went through just fine.

  7. #7
    Fake Numbers
    Join Date
    Jun 2008
    Posts
    80
    BG Level
    2

    Quote Originally Posted by virusiidx View Post
    sounds like it's just blocking you from uploading a file with the .sql extension, maybe try uploading them as .php and rename them after? Also, did you already create the databases like it says?

    I just tried installing that eqdkp just to see and it went through just fine.
    Yeah I created it. I tried uploading as .php and .txt and renaming but didn't work either. Did you try it on the same host?

  8. #8
    CoP Dynamis
    Join Date
    Feb 2007
    Posts
    257
    BG Level
    4
    FFXI Server
    Unicorn

    No, sorry, I meant on my own host.

  9. #9
    PROM KING OF
    SHOWDOWN HIGH

    Join Date
    Dec 2008
    Posts
    65
    BG Level
    2

    Quote Originally Posted by Grandphoenix View Post
    Hmm it appears it isn't loading any of the 4 .sql i tried to send. I thought it was the attributes being 553 being a problem. I even copied the text over ontPerhaps something I can do in phpmyadmin?
    Phpmyadmin should allow you to import a .sql file to create a new table. Just create a db and then select the "import" tab from the db view to create a new table from a local .sql file.

Similar Threads

  1. Replies: 8
    Last Post: 2007-02-22, 22:43