Elxis CMS Forum

Community => Elxis 2008.x Olympus (dev) => Topic started by: momo-i on January 17, 2008, 00:47:32

Title: SQL backup with mysqli
Post by: momo-i on January 17, 2008, 00:47:32
I tried to backup with mysqli. but backup has failed. sql file is empty and it has following mysql log.
Code: [Select]
080117  7:31:27    2011 Connect     elxisjp@localhost on
                   2011 Quit
                   2012 Connect     elxisjp@localhost on elxisjp
                   2012 Init DB     elxisjp
                   2012 Query       SET NAMES utf8
                   2012 Query       SELECT * FROM elx_core_acl_access_lists
                   2012 Query       SELECT template FROM elx_templates_menu WHERE client_id='0' AND menuid='0'
                   ---- more lines ----
                   2012 Query       SELECT COUNT(session_id) FROM elx_session WHERE userid = 0 GROUP BY ip
080117  7:31:28    2013 Connect     apache@localhost as anonymous on
                   2013 Query       EXPLAIN SELECT VERSION()
                   2013 Query       SELECT VERSION()
                   2013 Query       USE elxisjp
                   2013 Init DB     Access denied for user ''@'localhost' to database 'elxisjp'
                   2012 Quit
                   2013 Quit

I also tried to backup with mysql. then, backup is successful.
but, since an error will occur if a database type is set to mysql (php?/adodb? doesn't close database connection), I'm using mysqli.