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.
1
vote
1answer
856 views
Why do my ON UPDATE/ON DELETE rules disappear?
I'm trying to connect a couple of Mysql tables with foreign keys and ON UPDATE/DELETE rules. My rules are working on all tables except the last one (OrderContains). Why aren't my rules working?
I am ...
2
votes
2answers
67 views
Delete all highscores from a certain country
I have two tables:
tbl_players
tbl_highscores
I need to delete all highscores that are registered from a certain country. My problem is that the language are set per player, rather than by ...
1
vote
1answer
181 views
How to get a unique highscore per user
I have the following tables: users, highscores
I would like to get the top ten best results in highscore. The scores should be unique, meaning one score per user. I tried using INNER JOIN and GROUP ...
0
votes
1answer
184 views
Look for software that can convert sql (mysql) to erd
I would like to have an ER Diagarm in phpmyadmin, however, its graph is not up to my expectation, the graph has no relationship indicator (1-1) (1-m) etc at all.
So i am wondering whether there is a ...
2
votes
3answers
6k views
How to display database structure in phpMyAdmin?
Is there any way to generate a report of my database structure using phpMyAdmin? What I would like is a table format like the following, and an Entity Relationship table.
Table name: List
...
2
votes
1answer
457 views
How to export mysql database based on a where condition
I need to export the data and structure of a table but the data must have a specific condition (WHERE status=0 and id>20).
How to export mysql database based on a where condition from phpMyAdmin or ...
-1
votes
1answer
96 views
Which database is better comapre to all platforms in performance,security,cost point of view? [closed]
Which Database is better compare to all platforms in performance,security,cost point of view?
Can you please tell me which database is better and why that one is good compare to others?
1
vote
1answer
169 views
Can I use the “import” tool on PHPMyAdmin multiple times?
I am moving databases between a couple of shared hosting accounts, and both of them only give access to the MySQL databases through phpmyadmin.
The importing account's upload limit is 50MB. I would ...
2
votes
1answer
375 views
BACKUP and RESTORE MySQL Database
I have very specific question.
I have seen the instructions on how to backup and restore mysql database using SSH but they barely explain the process when backing up on one server and restoring on ...
3
votes
2answers
4k views
How to cache mysql database in server memory
I am having problems with on website with 600MB of mysql database. The website is way too slow and i noticed the bigger the mysql database gets the slower it gets. When it was like 5MB website was ...
3
votes
1answer
158 views
How can I get MySQL to use the value returned by a function as a default?
I have a pre-existing table that has a column to that can hold a UUID.
I'd like to be able to define a default such that new rows coming in (from legacy systems) will still get a UUID defined, via ...
4
votes
6answers
21k views
importing large SQL file phpmyadmin
I am trying to import this SQL file in phpmyadmin and got this message
#1064 - You have an error in your SQL syntax;
check the manual that corresponds to your MySQL server version
for the right ...
3
votes
1answer
276 views
PHPMyAdmin for multiple servers w/ single pma database
We have PHPMyAdmin setup for our various MySQL instances. The annoying part is the current setup is requiring an individual pma database on each instance. Because of this the severs that are slaves ...
1
vote
1answer
227 views
Visually create a join using PHPMyAdmin
I recently started using SQL Server 2008 express and it has a really nice joins interface, whereby you can visually create a join. Is this possible on PHPMyAdmin?
1
vote
2answers
1k views
Is there any way to recover a database after dropping from phpmyadmin?
I was planning to drop all the tables from a test account, but unfortunately, I didn't notice that I was in the production account when I chose to drop all the tables of my db from phpmyadmin ...
2
votes
1answer
845 views
Stuck outside MySQL! XAMPP - help please
I have been using xampp (on windows XP/XAMPP 1.7.4 /PHP 5.3.5) for quite a while now, and last morning I started to get some weird messages when I was developing my website, It happened yesterday and ...
4
votes
1answer
715 views
Is this a normal set of MySQL privileges?
Using phpmyadmin on a local test wamp setup, and well as pretty much the title states, there are 3 users marked as user = ANY, password = NO, such as:
USER | HOST | Password | Global Priv | Grant
...
2
votes
2answers
5k views
MySQL tables do not show up in the phpMyAdmin and MySQLWorkbench
I just setup the phpMyAdmin and I have this problem: When I login, I can't see any tables.
I had tried this with MySQLWorkbench and I got the same result.
Any suggestions ?
1
vote
1answer
173 views
MySQL Database Design Help?
I am going through my database and what I want to do is re-design it because I feel like it's very messy and that I am doing it wrong. This is just for practice; I've never had anyone teach me so I ...
2
votes
1answer
265 views
Lost tables in Drupal site database
I have Drupal site on my local server build using pressflow
I had problems with the xammp 1.7.4 server, so I delete everything except mysql and htdocs folders.
I installed the server again, but the ...
11
votes
1answer
11k views
How can I change the default storage engine in phpmyadmin?
I use InnoDB almost exclusively in my applications. However, if I'm not careful when setting up the table, I forget to change it and phpmyadmin sticks me with MyISAM. Is there a way to change the ...
