Exporting the db data into a file returns an error.

  • 14 years ago

    Want to create a back up of the server into a seperate file but get this error.

    Have a good understanding when it comes vb but the sql query and the errors generated here in php have me lost.

    What is wrong with this query? I keep getting access denied and this page when I want to do a back-up/save to a file...

    Thanks

    John

     //*********************************************************************

    [INTERNAL] (v0.643-db42, PHP v4.4.4)
    Server: Apache/1.3.37 (Unix) mod_auth_passthrough/1.8 mod_log_bytes/1.2 mod_bwlimited/1.4 PHP/4.4.4 FrontPage/5.0.2.2635.SR1.2 mod_ssl/2.8.28 OpenSSL/0.9.7a
    SQL server: MySQL 4.1.21-standard
    Referer: http://panchocom.com/legalcase-0.6.4c/legalcase/export_db.php
    Request: GET /legalcase-0.6.4c/legalcase/export_db.php?action=export
    Error: Error in SQL database query.
    SELECT * FROM lcm_app INTO OUTFILE '/home/panchoco/public_html/legalcase-0.6.4c/legalcase/inc/data/db-lcm-20061215-3/lcm_app.csv' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\\' LINES TERMINATED BY ' '
    « Access denied for user 'panchoco_uche40'@'localhost' (using password: YES) »
             lcm_panic("Error in SQL database query.<br />
    SELECT * FROM lcm_app
    				INTO OUTFILE '/home/panchoco/public_html/legalcase-0.6.4c/legalcase/inc/data/db-lcm-20061215-3/lcm_app.csv'
    				FIELDS TERMINATED BY ','
    					OPTIONALLY ENCLOSED BY '&quot;'
    					ESCAPED BY '\\'
    				LINES TERMINATED BY '
    '<br />
    &laquo; Access denied for user 'panchoco_uche40'@'localhost' (using password: YES) &raquo;<br />") # line  108, file: /home/panchoco/public_html/legalcase-0.6.4c/legalcase/inc/inc_db_mysql.php
          lcm_query_db("SELECT * FROM lcm_app
    				INTO OUTFILE '/home/panchoco/public_html/legalcase-0.6.4c/legalcase/inc/data/db-lcm-20061215-3/lcm_app.csv'
    				FIELDS TERMINATED BY ','
    					OPTIONALLY ENCLOSED BY '"'
    					ESCAPED BY '\\'
    				LINES TERMINATED BY '
    '", false) # line  419, file: /home/panchoco/public_html/legalcase-0.6.4c/legalcase/inc/inc_version.php
       lcm_query("SELECT * FROM lcm_app
    				INTO OUTFILE '/home/panchoco/public_html/legalcase-0.6.4c/legalcase/inc/data/db-lcm-20061215-3/lcm_app.csv'
    				FIELDS TERMINATED BY ','
    					OPTIONALLY ENCLOSED BY '"'
    					ESCAPED BY '\\'
    				LINES TERMINATED BY '
    '") # line  179, file: /home/panchoco/public_html/legalcase-0.6.4c/legalcase/export_db.php
    export_database() # line  283, file: /home/panchoco/public_html/legalcase-0.6.4c/legalcase/export_db.php
    



    _          
     
     
     
     
     
     
                                                                                                        

Post a reply

No one has replied yet! Why not be the first?

Sign in or Join us (it's free).

Contribute

Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

“There's no test like production” - Anon