Can not import database with phpMyAdmin
langtupt opened this issue · 9 comments
Dear Vortigont,
Could you please help me check the database ,i import pzmysqlstat.sql in phpmyadmin and do not working.
Please help see the picture below can you help me fix?
Thank you very much
http://prntscr.com/gffkte
@langtupt
You should import only pzem_mysql.sql file. it contains all needed db structs.
pzmysqlstat.sql is only reference queries, not used directly anywhere.
Dear Vortigont,
Please see the picture problem below. i import pzem_mysql.sql and do not working.
http://prntscr.com/gldelt
please advice and help me fix.
Thank you very much
I'm not sure what are you trying to do. Your screen shows that you are already attached to DB 'huuxuanc'.
But 'pzem_mysql.sql' tries to create new DB 'pzem', that's why you get this permission error. If you are not allowed to create new DB's - than remove 'CREATE DATABASE...' and "USE pzem;" statements from 'pzem_mysql.sql' and create only tables within your current DB.
Dear Vortigont,
Where I can find detailed instruction of the configuration?
Thanks in Advance
@IgorVinokur so sorry, I was to lazy to write the complete guide. But if you have any questions, pls ask, I'll try to help you.
@vortigont hello, I am not able to get the view of index.php, I have installed cacti as well as smarty template engine. also set the db parameters in the config.php. Still getting 500 error :(
could you please help where I am doing wrong.
Hello @smah1980, pls check your webserver's error log file, it must show what caused the error.
You may also set ini_set('display_errors', 1); in the config.php. But error 500 usually means that cgi execution failed at the early stage, for e.x. missing php module, file access error or something like this.
Thanks @vortigont its working now, it was permission issue, I just fixed that, but now its giving following error,
Notice: Undefined index: devid in /htmlsite/inc/local.php on line 33
Notice: Undefined index: s in /htmlsite/index.php on line 5
Also can you please tell how meter will know on which db it has to send data? how to configure my meter to post data to my db. I believe that need to be setup some how with cacti.