where can I find mysql logs in phpmyadmin?
where can I find the mysql logs (errors, queries, etc) in the phpmyadmin interface? ...
phpmyadmin
How to grant previleges to mysql user via phpmyadmin
In the past i have granted previlges to users via phpmyadmin by logging as root user. There was one tab called previleges. I dont remember now where is that tab. can anyone tell me how i can get that tab , i need to grant some previleges ...
Encoding problem in phpMyAdmin. Specifically with records containing russian text.
I'm making small module/plugin for my future CMS/Framework. I wanted it from begining to be with multi-language support. I set my new database to utf8_unicode_ci (I read that it is more accurate, then utf8_general_ci) Set my files to UTF-8 without BOM Every page has in head Content-Type: text/html; charset=utf8 When I register new us...
SP problem in PHPMYADMIN
i got this error , When i execute this below sp snippet , DROP PROCEDURE get_DETAIL_STATE// CREATE PROCEDURE get_DETAIL_STATE(IN stateName VARCHAR(255)) BEGIN sELECT cFname,cLname FROM med_patient WHERE cState = stateName; END DELIMITER ; my updated snippet , DELIMITER ; CREATE PROCEDURE get_DETAIL_STATE(IN...
phpMyAdmin and SHOW CREATE TABLE
Is there a shortcut in phpMyAdmin to SHOW CREATE TABLE for a table (i.e. a button I can click to get the full query, not the truncated one)? Also, can I query multiple SHOW CREATE TABLEs simultaneously in phpMyAdmin? If I separate them, only the last one appears. ...
SQL Server / PHP / Web Based Admin Tool - What are some phpmyadmin-like tools for SQL Server?
I'm trying to find a phpmyadmin-like db administration tool for SQL Server for a LAMP environment. I've only been able to find similar tools that exist for a IIS/ASP environment. ...
Inserting a Japanese XML feed in to a MYSQL table via PHP
Hi I've been looking for a solution to this issue and have tried most answers found. But with no luck was I able to insert the Japanese xml feed into the tables which have been created. I tried setting all setting where UTF8 should be used as most answers have suggested - But no luck!! Can someone guide me through. Thanks Sam ...
HOw to send an email from PHPmyadmin DB
Hi All, I want to sent email on DB field changes.....Can any please let me know how can i do it in PHPmyAdmin. Regards, Hemant ...
phpmyadmin Error
I changed the password for MySQL root and now I can't login to phpmyadmin. I've rebooted, followed the directions here http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html and it still won't let me login. What else can I do to fix this? Thanks! ...
'Cannot start session without errors' from phpmyadmin
I have just installed phpmyadmin, but whenever I log in the screen 'Cannot start session without errors...' appears. I can't find anything in the browser errors log or the Apache error log. Is there anywhere else I should look? It mentions a PHP log but I can't find such a thing anywhere. As a (possibly) secondary issue, the login page...
many things in one query. is it possible?
I have three tables menus +--id---ident---+ |--1----menu_1--| menus_data +--id---id_parent---name---------id_lang--+ |--1----1-----------menu_eng------1-------| |--2----1-----------menu_rus------2-------| +--3----1-----------menu_arm------3-------+ languages +--id---name--------+ |--1----english-----| |--2----russian-----| |--3--...
Help required in triggers
Hi All, CREATE TRIGGER membership AFTER INSERT ON jos_config5 FOR EACH ROW BEGIN INSERT INTO jos_config4( identity_guid, UserID, STATUS , original_conf_path, output_file_path, time_of_process, time_of_start, time_of_completion, status_message, Projectname ) VALUES ( '12', '345', '753', '34', '45', 'NA', 'NA', 'NA', 'User has not sta...
After Update trigger in phpmyadmin need to call a php with passing data
Hi, I want to create the Trigger which calls a php script and also passes parameters to php CREATE TRIGGER trigger_test AFTER Update ON table1 where status_message = "done" FOR EACH ROW BEGIN \! echo "php /Email.php" >> /tmp/yourlog.txt END; how can I get data for the row updated. Regards, NewDev ...
MySQL regex replace?
I've got a table with blob text fields. This blob has a lot of html in it. One of the pieces of html is an h2. I would like to find all instances of a word in the h2 tag, and replace it with another word (while leaving other words the same). For example, I would like to replace the h2 "wiggles" with "bumbles" in the following: Before: ...
How to invoke the application Using Mysql Command
Hi All, I am wrting a trigger, in which i need to invoke the external application using the MySQL Can anyone please help Urgent Regards NewDev ...
HOw to send an email from PHPmyadmin DB using the Stored procedure
Hi All, I want to send mail using stored procedure using the My SQL in the PHPmyadmin regards, hemant ...
Learning Management System using php codeigniter?
Is there any open source Learning Management Softwares that is developed using php codeigniter? a Web based software for delivering,tracking and managing training/education that focuses mainly on Class/session scheduling, Class enrollment/registration, Teachers/Trainers,Students and Lessons/Courses/Categories/Evaluation I'm a BSIT stu...
phpmyadmin: data is not importing correctly for varchar(utf8_bin)
I installed latest mysql and phpmyadmin 3.3.2deb1 on ubuntu. When I import already created sql file of data then it store garbage data (for example: 416e746967756120616e642042617262756461) for varchar field but all other fields are successfully imported. When I used same file before latest installation then it was importing data correctl...
CSV import problem; on different servers import throws error or succeeds
Hi folks, We recently migrated a site from Superb.net to MediaTemple. Part of the upkeep of this site is a 60000+ record export (in 3 CSVs) from Raiser's Edge which I import into mySQL. The tables retained the same schema before and after the move. This week when I went to do my import I found that each of the CSVs caused an invalid ...
How To clone an existing wordpress site into a subdirectory on same server?
For example: I have a Wordpress site (blog) on www.xxxxxx.com I want to upgrade some plugins and WP version of site but before it I want to check all things on a mirror version. How to make a mirror backup site of currently running site on same server like www.xxxxxx.com/testing-site/? Whatever I will do on mirror site, should not ef...