phpMyAdmin is an open source tool written in PHP to handle administration of MySQL over the web. It can perform various tasks such as creating, modifying or deleting databases, tables, fields or rows; executing SQL statements; monitor MySQL health status, or managing users and permissions.

learn more… | top users | synonyms

0
votes
1answer
29 views

Duplicate Entry Error with PHP When Trying UPDATE

I am checking if a record exists, creating a new record if it does not already exist, and updating otherwise. The SQL works fine in PHPMyAdmin but not through the PHP page. $check_for_id = ...
0
votes
2answers
46 views

MySQL Code Works in PHPMyAdmin but not in PHP Page

When I run this query in PHPMyAdmin it works fine, but when I run it from the PHP page using the $sql command, I get the error: "You have an error in your SQL syntax.....near ')' at line 2" $sql = ...
0
votes
1answer
37 views

Pulling from Two Tables with Different Number of Records

I have three tables, one for members with 8 records, one for tasks with 1 record, and one for events with 3 records. The tasks table associates the events with members using one-to-many primary to ...
1
vote
1answer
16 views

my phpMyAdmin data is hashed or hexed?

I have a mySQL db setup in MAMP in which I connected mySQL Workbench to administer the design of the database. When I inserted some data today from within myPhpAdmin (localhost:8888), I noticed the ...
1
vote
1answer
32 views

How to store multiple values in a column in database?

I'm trying to make three tables in phpMyAdmin. The main columns here are named Campaign, Program and Asset. Under Campaign, there are different kinds of Programs. And under each Program, there are ...
0
votes
1answer
20 views

Restore a WordPress database from .frm and .idb only

I had a WordPress website running a long while ago. I used WAMP server. Then, I uninstalled WAMP. Today I would like to work again on my website; all that remains of my database is this (I cannot find ...
0
votes
1answer
64 views

phpmyadmin not working after mysql update

i followed this guide to update my mysql form 5.1 to 5.5. After lots and lots of command and headache, i was able to upgrade mysql. i checked the version via terminal. But now there is another ...
3
votes
1answer
35 views

“zip” a mySQL (phpMyAdmin) database [duplicate]

I've created a large database on my local WAMP webserver. I would like to send that database with all tables and table data to another computer. Is this possible? mySQL ver: 5.5.15 PHP ver: ...
1
vote
0answers
35 views

Host is not allowed to connect to MySQL [duplicate]

First of all I'm acknowledging you that I am a completely newbie in this field. The field I'm referring to is the summation of these things: Accessing files on different computers or over the ...
1
vote
0answers
83 views

Recover innodb database from ibdata1 and *.frm files only

I have a problem on my server. I had a hard disk error on my server, and I restarted it. After that, I started wamp server software, but mysql services were not started. I checked all mysql data, ...
0
votes
0answers
30 views

Trying to import an addressbook

I'm trying to import a .sql-file that I got by converting an .dbf-file. The problem is this line: INSERT INTO address values ('', '', 'Dekanat', '', 'Fachhochschule Hildesheim/Holzminden/Göttingen', ...
2
votes
1answer
36 views

Moving data from an old table into a newly created table with different field names / number of fields

I've been handed over management of a database, and I have had very little exposure to MySQL (or databases in general) so far. I would like to do two things, both of which are (I expect) fairly ...
0
votes
0answers
57 views

PHPMy Admin Exporting Importing with Foreign Key Constraints

I have a major issue here, How do I export a MySQL Database from PHPMyAdmin whilst retaining all the table relationships(foreign key constraints) - I have noticed performing a quick export does not ...
0
votes
0answers
99 views

Can't Add Databases through PHPMyAdmin

EDIT (should've mentioned this sooner): I'm using a Mac, running OS X 10.9.2 Being fairly new to PHPMyAdmin, I thought I was removing settings/privileges for one single user through PHPMyAdmin, but ...
0
votes
1answer
51 views

Create previously created MySQL database without .sql file

I had a bad server crash in which I was able to restore my MySQL files, but I was unable to do a dump in order to get the .sql file. In other words, I have each individual part that was saved in the ...
0
votes
1answer
161 views

Trying to recover/import/transfer database from MySQL data dir

I used phpMyAdmin->export to create a backup of my database but I have now discovered it did not export the whole database, some tables was missed/refused. However at the time of doing the export I ...
1
vote
0answers
517 views

Table already exists error when trying to import sql file

I am trying to upload a backup sql file through phpMyAdmin. I create the empty db with the same db name as in my import file in phpMyAdmin then use the import function selected from within this empty ...
0
votes
0answers
116 views

#2002 Cannot log in to the MySQL server / Connection for controluser as defined in your configuration failed

I use PHP/MySQL in Ubuntu 13. To reduce the size of ibdata1, i followed this post What is the best way to reduce the size of ibdata in mysql? and make necessary changes as told in the answer. I did ...
0
votes
0answers
9 views

phpMyAdmin setup directory accessable

Is it bad if the setup directory is accessable for all users? So users who visit my website can access that folder and possible sub-folders like lib? Can they access phpMyAdmin through this? What ...
0
votes
1answer
62 views

mysql - Waiting for table level lock on a table

I have a problem with my website.. The last few days, at random times the website has become very slow. I started to investigate the best I could. I saw that the MySQL process was using 85 - 95% of ...
0
votes
1answer
37 views

SQL File Upload to MySQL Server

I'm fairly new to databases. I want to upload a .sql file to a mysql server. However the database I want to update contains many .frm .myi .myd files. Should I delete those files and replace with the ...
2
votes
1answer
195 views

What is the difference between MySQL and PostgreSQL in terms of writing SQL queries? [closed]

Other than performance and security is there really any difference between MySQL and Postgres like SQL queries, built-in functions, procedures and so on? I'm asking this because I'm familiar with PHP ...
1
vote
2answers
106 views

Questions since MySQL Startup

Have a weird question / (bug?) here. Using PHP My Admin I installed via apt-get on Ubuntu 13.10 Versions are as follows: Server version: 5.5.35-0ubuntu0.13.10.2 - (Ubuntu) Apache/2.4.6 (Ubuntu) ...
0
votes
2answers
231 views

How can I push data from my local MAMP database to my remote database?

I'm developing a site locally using MAMP Pro, and I've created a mysql database locally that have the same structure as the remote server. (username and password are different though) I'm inserting ...
1
vote
0answers
763 views

PHPMyAdmin - Missing value in the form

I'm currently trying to learn MySQL and have a problem that I was unable to solve. I started to use the query window to give certain commands like: CREATE DATABASE ijdb; The problem is that ...
0
votes
0answers
85 views

#1046: No database selected in phpMyAdmin

I have a problem with phpMyAdmin. When I click on any database on the left I get an error like: SELECT tracking_active FROM.`pma_tracking` WHERE db_name = 'information_schema' AND table_name = ...
0
votes
1answer
83 views

importing database backup to phpmyadmin return #1064

When I tried importing mysql database backup to MySQL using phpMyAdmin I got the following error message: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your ...
0
votes
0answers
20 views

How can i update two tables

On my server, after insert on one table, I want to update two other tables. How can I do this using trigger?
0
votes
0answers
68 views

mysql: Access denied for user, unable to grant privilages

I hosted a website in serversfree.com. http://smc.bugs3.com/ However i'm getting this error MySQL error : Access denied for user 'u903638251_ user'@'10.1.2.25' (using password: YES) I tried to grant ...
0
votes
1answer
70 views

Mysql query in Database

How to get all the tables from database with all values in tables using single query.. I tried using $sql = "SHOW TABLES FROM $dbname"; $result = mysql_query($sql); $arrayCount = 0 while ($row = ...
0
votes
1answer
3k views

phpMyAdmin configuration storage is not completely configured message

Today i have updated my PhpMyAdmin to 4.1.2 Now when i log in to PMA i am getting the message: The phpMyAdmin configuration storage is not completely configured, some extended features have been ...
1
vote
0answers
81 views

MySQL Link to PHPMyAdmin/MS Access

I have a mysql database stored on a server via phpmyadmin. I want to link this to MS Access for other users. I often link mysql databases to MS Access which are stored locally, but never DB's stored ...
-3
votes
1answer
103 views

error querying data with apostrophes [closed]

I'm getting empty sets from running the following query permutations: select * from gsapi_articles where article_title = "James Dean On Merilyn: 'This Woman Is A True Marvel'" select * from ...
1
vote
1answer
191 views

wordpress table is crashed and should be repaired

I run a wordprees website and use a managed VPS server with cPanel/WHM. Got bellow error log and check the table. I repaired the table with repair table command from phpmyadmin. But this problem occur ...
0
votes
1answer
36 views

Migrating database with views trough phpMyAdmin causes error in second host

I'm trying to migrate a database which contains some views and I'm doing trough phpMyAdmin export feature. MySQL version on servers are: Server to migrate: Server version: 5.5.34-0ubuntu0.12.04.1 ...
0
votes
1answer
146 views

There is no export as SQL option

As Cms I use Wordpress I want to export a whole category (windows 8) and I run the SQL command : SELECT * FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.ID = ...
0
votes
1answer
120 views

Difference In Phpmyadmin Mysql web client and Terminal client

I got problem (#2006 Mysql server gone away) with mysql while connecting and performing some operations through web browser. Operation Listed below: When Executing big procedure Importing database ...
0
votes
2answers
258 views

MySQL Error: FUNCTION LEVENSHTEIN already exists

I've got an ExpressionEngine database and I exported a couple of tables from it, then dropped those tables. When I try to re-import the tables in PHPMyAdmin, I get this error: SQL query: -- -- ...
1
vote
1answer
107 views

MySQL: records, inserted via phpMyAdmin, do not replicate

As it says on the topic, for some reason records inserted/ modified via PMA do not get replicated to the slave, If I do exactly the same insert/modification on master via mysql command line, or ...
-1
votes
1answer
38 views

Would This Work? [closed]

This is just a basic script for updating my database from form data. I don't have much experience with databases and this might be a bad question but I have read online that you should use UPDATE ...
0
votes
2answers
3k views

MySQL shutdown unexpectedly

2013-09-09 10:21:44 5776 [Note] Plugin 'FEDERATED' is disabled. 2013-09-09 10:21:44 1624 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future ...
0
votes
0answers
92 views

Export from phpMyAdmin and import later from another phpMyAdmin fail

I have a MySQL Server and a phpMyAdmin in a server at office, I exported a database using the phpMyAdmin export feature. I come home and try to import the exported .sql and get this error: -- -- ...
1
vote
0answers
84 views

phpmyadmin Lock Down

I have a client that wants to use myphpadmin to manage his mysql database 5.x on my server. I found this article on how to hide databases from myphpadmin but I don't like this because if I don't ...
2
votes
1answer
74 views

How identify tables with millions of entries

On a debian server with apache and mysql, how can I find out if any one table gets spammed? I have lots of different blogs, wordpress, wikis,... on my server of different customers. It seems like ...
1
vote
1answer
227 views

TokuDB database size unknown in phpmyadmin

In mysql server, I installed the TokuDB storage engine. I converted database engine InnoDB to TokuDB, but my table sizes show unknown in phpmyadmin.
0
votes
3answers
565 views

Importing 40 gb mysql file via phpmyadmin

I have a 40 GB MySQL dump file. Can anyone give me the idea how to import the file via phpmyadmin?
0
votes
0answers
351 views

Illegal mix of collations for operation 'UNION'

i have this database with tables bellow. it was running good , till when i have done this code alter table <some_table> convert to character set utf8 collate utf8_unicode_ci; to change ...
0
votes
1answer
423 views

1062 Duplicate entry but there are no duplicates?

I keep getting this error: failed to INSERT: [1062] Duplicate entry 'Upping Your Type Game-http://jessicahische.is/talkingtype' for key 'PRIMARY'. The problem is, is that there are no duplicate ...
0
votes
1answer
236 views

Event Management System

I'm working on a "Event Management System" Online Software Project where the system requires the following: Viewers can sign up for their user account Events can be created by the admin from the ...
1
vote
1answer
829 views

School database design

I am trying to design a database management system with my PHP and intermediate MySQL knowledge, keeping normalization in mind. These are the assumptions: The school has many students from grade 1 ...