Viewing Content Of Blob In phpMyAdmin
Sorry for the Noob Question, but what does the circled button mean, and how can I view the content of a blob? ...
phpmyadmin
How to drop all table in MySQL?
I don't want to drop database, because I'm not hosting the website on my own machine, drop the database will require create it again,and many settings. Is there a command in MySQL that can be used to delete all tables in a specific database? EDIT Everything I can do is within a phpMyAdmin ...
Does this MySQL Query have any hidden gotchas?
Hello, I hope this isn't a terribly obtuse question. I notice that MySQL will let me refer back to the "Mnth" field in my GROUP and ORDER. This is not the case in every db engine I've worked with. Can anyone confim that this is an OK approach? SELECT DATE_FORMAT(FROM_UNIXTIME(`swauditlogs`.`dateline`),'%Y-%m') AS Mnth, Count(`swauditlo...
phpMyAdmin is asking what size a new index should be for a varchar field with 255 characters.
Hi folks - a newbie question, with apologies. I have a table with only 14,500 rows, which is not likely to increase much over time. I'm trying to index one field to enable fulltext searching, and phyMyAdmin is asking me to enter a size for the index. I have no idea what this number should be, or indeed how to look up the answer. Thanks. ...
How to secure files included in www directory
Now I have put a password in mysql, the only security problem that is left is to secure the php files that are in my www directory. ...
Query works fine in phpmyadmin returns 0 rows when ran from php
I'm really stumped by this. Here is the php: Update: I have escaped the inputs (before I did this a different way, but didn't know about mysql_real_escape_string). Also, I replace the double quotes with single quotes, yet the same problem is happening. Below is the updated code: $request = mysql_real_escape_string($_POST['id']); $c...
how to access phpmyadmin with password
how do I access phpmyadmin/Wampserver(interface) if I have assigned it a password, is there any page where you can input the password? ...
can I put password to individual database in mysql?
I'm using phpmyadmin/wampserver. Is it possible to add a password on a database?Because my problem is I cannot access the whole thing(http://localhost/phpmyadmin) in my web browser if I put a password on it. ...
mysql recount column in mysql based on rows in secondary table
Hi, I took over a database with two tables, lets name them entries and comments. The entries table contains a column named comment_count which holds the amount of rows with entry_id in comments corresponding to that row in entries. Lately this connection has become terribly out of sync due to version switching of the codebase. I need he...
phpMyAdmin Import Error
I am trying to import a database using phpMyAdmin. The file is compressed in a .zip. Every time I try the import I get this error: Error in ZIP archive: Compressed size is not equal with the value in header information. I've tried exporting the file again and and used different applications to compress it but I always get the same er...
fill textbox with mysql data
How do I fill an inputbox with mysql data. So that I can update the database? I have this code that will show the table corresponding to the users request. But I don't know the syntax on how I can fill an inputbox with mysql data. $result = mysql_query("SELECT * FROM t2 WHERE STAT='{$_POST["stat1"]}'"); echo "<table border='1'>...
Date and time in PHP pagination script - slight problems
I have an events calendar written in PHP, with the following pagination script that I obtained from a free PHP site. This is the basic script (entitled PmcPagination.php): http://pastebin.com/f7c5a4a90 (linked here for convenience, too lengthy to post in full!) It works to the extent that it shows all events - but the dates do not tall...
How can I edit a view using phpMyAdmin 3.2.4?
I need to simply edit a very complicate view in phpMyAdmin 3.2.4 but I cannot figure how to do that. Any suggestions? Thanks! ...
how to set default-storage-engine=InnoDB in XAMPP for Linux1.7.3a
can any body plz help me...? ...
Import/Exporting databases from one machine to another
I have two PCs, one is Ubuntu 8.10 and the other Ubuntu 9.10. On the Ubuntu 8.10, i have a few databases in phpmyadmin which i would like to copy across to the Ubuntu 9.10 phpmyadmin(which has no databases). I'm not sure if i'm on the right path but here's what i think i should do: Export the databases onto Ubuntu 8.10. And copy those...
Problem while importing mysql backup
Hi, While I'm trying to import mysql backup file i receive such an error, ALTER TABLE `sf_guard_group_permission` ADD CONSTRAINT `sf_guard_group_permission_FK_1` FOREIGN KEY ( `group_id` ) REFERENCES `sf_guard_group` ( `id` ) ON DELETE CASCADE , ADD CONSTRAINT `sf_guard_group_permission_FK_2` FOREIGN KEY ( `permission_id` ) REFERENCE...
I installed Apache and added PHP to it, than installed MySql but PHPMYADMIN isn't working?
I was using XAMP for windows but there were forming a lot of problems with MySql so uninstalled it and installed Apache Web Server. I connected Apache to PHP and it worked fine. I installed MySql again and it worked fine. Now I can not get MySql to work with PHPMyAdmin. I did not test PHP to see if it worked with MySql without PHPMyAdmi...
how to create mysql database backups by using a query in phpmyadmin
Is it possible to create a backup using phpmyadmin and not the mysql console.exe? ...
incrementing data type in phpmyadmin
Is there a certain data type on phpmyadmin that works like in ms access that if you don't specify a primary key, ms access will prompt to create a primary key named 'ID' which will then be incrementing(1,2,3..) as you are adding more records to the database. ...
how to backup mysql database outside phpmyadmin
I'm currently using the export function in phpmyadmin to update mysql database. How do I do it outside phpmyadmin, is there any other application that could do this? ...