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.
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 ...
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 ...
4
votes
2answers
19k views
How to resolve too many connections and fatal error in mysql running on vps
I am running an application PHPlist on my linode server, simultaneously running 12 php scripts which open mysql connection, now when i access phplist it shows lot of times an error shows:
Fatal ...
4
votes
1answer
160 views
MySQL: Delete a record from all tables in one shot
I have a MySQL database, with one table that has a primary key, f_id that is referenced in multiple table as a foreign key.
I want to delete all records where f_id is a specific value from all ...
4
votes
2answers
4k views
Why can't this mysql user log in with password?
In phpmyadmin I created a user called "edward" with password and all privileges:
Yet when I try to log in via phpmyadmin, it says "Cannot log in to the MySQL Server".
When I try to log in on the ...
4
votes
1answer
698 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
...
3
votes
2answers
609 views
Running SQL Query on all databases
I have one hosting account using cPanel and phpmyadmin.
I have 50 databases under this account, all WordPress.
I need this query modified so that it runs through all databases to update the ...
3
votes
1answer
156 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 ...
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
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 ...
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 ...
2
votes
1answer
295 views
how to retrieve rows of different dates using IN clause
My table structure:
+-----------------+--------------+------+-----+-------------------+----------------+
| Field | Type | Null | Key | Default | Extra |
...
2
votes
2answers
116 views
What is the difference between using varchar(100) and varchar(255)?
I want to know difference between varchar(100) and varchar(255) in terms of memory usage and programming problems of using more memory.
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 ?
2
votes
2answers
37 views
Backing up MySQL database
I have quite large and rather important DB to backup.
First off, whats best way to do it?
Secondly, easiest way I know is to export it through phpmyadmin, but, i'm worried about options, although ...
2
votes
1answer
416 views
Poor MySQL for Drupal on Shared Hosting
My Drupal site is on a shared host where I cannot modify the my.cnf configurations but the database seems to be performing poorly. Here are some of the flagged issues that I can see...
In ...
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
455 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 ...
2
votes
1answer
374 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 ...
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 ...
2
votes
1answer
77 views
phpmyadmin - Login issue, takes me back to the login page after logging in
I'd setup phpmyadmin quite a while ago and it worked well and I got everything setup and working etc... However, I went to login recently and it always just takes me back to the login page. The ...
2
votes
1answer
840 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 ...
2
votes
1answer
170 views
Analysis of MySQL database in real time Amazon RDS similar to phpMyAdmin
I'm using a single Amazon RDS instance (medium) to power several WordPress websites running on a single Amazon EC2 instance.
I used to have my databases on another EC2 instance and installed ...
2
votes
0answers
297 views
SQL set profiling
I'm setting up an automatic database backup for a website. When I try to do a backup it comes up with the error"
MySQL error: The 'SHOW PROFILE' feature is disabled; you need MySQL built with ...
2
votes
1answer
131 views
Change the same field from all the tables from a particular database
Suppose I have a database sitedb and in that I have 20 tables and a primary key(say uid) for one table is used in other tables as dependencies.
uid is of type int with length 10. Lets say that the ...
1
vote
2answers
85 views
What exactly do database passwords protect?
I would like to know what exactly I am password protecting on my server when I set a database password. I am unclear as to what people are referring to when saying to password protect a database. Are ...
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 ...
1
vote
1answer
111 views
MYSQL Triggers syntax
I need some help with my trigger statement, as I would like to only insert the new row if a column value does not already exist, or if it does exist update a corresponding column. Currently I have a ...
1
vote
2answers
129 views
How to partition the table, week-wise?
I have a table with hundreds of thousands of records. How to partition the table, week-wise?
A few million rows insertion will be taking place in my table in a day.So i need to partition it weekly. ...
1
vote
1answer
106 views
Change mysql storage engine from Innodb to MyIsam: Max locks exceeded error
I have about 5 million records in a table which uses Innodb as storage engine. I have about 6000 users who use (do transactions) the same table. It sometimes becomes very slow or hangs. I decided to ...
1
vote
2answers
415 views
Secure method beside phpMyAdmin for remote mysql
Recently, one of my centos linux servers was hacked and the cause of due to phpMyAdmin. It was said due to this problem PhpMyAdmin vulnerability CVE-2011-2505 ...
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 ...
1
vote
1answer
105 views
MySQL user created via command line can't access PHPMyAdmin
I'm trying to create a read-only user with access to one database in PHPMyAdmin. Since I'm a server newbie I followed some instructions line-by-line on setting up my database and PHPMyAdmin. As ...
1
vote
2answers
520 views
How to use 2 auto increment columns in MySQL phpmyadmin
Is it possible to use 2 auto increment values ?
One starting from 0
Another starting from 4000400
Please help me
1
vote
1answer
1k views
Server requested authentication method unknown to the client [mysql_old_password]
Warning: PDO::__construct(): The server requested authentication method unknown to the client [mysql_old_password]
SQLSTATE[HY000] [2054] The server requested authentication method unknown to the ...
1
vote
1answer
163 views
How to restrict MySQL user to not import and export database
I have created a read only MySQL user but this user have an option to export the database through phpmyadmin. How can I disable the options Export and Import?
1
vote
1answer
268 views
How to import big sql file in Phpmyadmin
I am having a big sql file( 16mb) and all i need is to upload it to the Phpmyadmin to work with it in my localhost. I'm a newbie here in Php/MySql and i want to know about the details regarding the ...
1
vote
1answer
82 views
How export a database based in a primary key of a table?
So, I'm trying to export all the DB structure of my MySQL db.
Attached is my DB structure, I have more then this, but I want these tables only.
Basically Tools relate to Factsheets and Factsheets ...
1
vote
1answer
349 views
ON DELETE cascade alternate
I am trying to create a database for 2 Tables like:
Table1 : tb1-id(pk) | tb2-id | other
Table2 : tb2-id(pk) | other
FOREIGN KEY Table2(tb2-id) REFERENCES Table1(tb1-id) ON DELETE ...
1
vote
1answer
217 views
What language and data structures does MYSQL uses as backend?
I am just curious to know what data structures and languages does MYSQL exactly use as back end language? and what does the file format .MYD , .MYI and .frm stand for and how does MYSQL use them?
...
1
vote
1answer
849 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 ...
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 ...
1
vote
1answer
168 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 ...
1
vote
1answer
62 views
BIT columns all “1” after a phpMyAdmin export/import
I have to import data from a MySQL database using phpMyAdmin because that's the only interface my hosting provider supports.
I have exported my database from my local machine using phpMyAdmin. After ...
1
vote
0answers
81 views
PhpMyAdmin: UploadDir & SaveDir
Regarding UploadDir & SaveDir in phpmyadmin, I have them both set to './save' with permissions at 755.
I am the only one using phpmyadmin, but still, could I make this tighter?
Thanks
PHP 5.3.3 ...
1
vote
0answers
89 views
phpMyAdmin slow for small database
I have a small database (<100 KB when dumped) that will hang in phpMyAdmin when I try to sort by various columns.
Sometimes it hangs when I try to edit columns by directly clicking on their ...
1
vote
0answers
109 views
Can't access a specific database from phpMyAdmin
I've installed WAMP on a computer some months ago. Now I'm trying to use it and I was trying to surf the databases using phpMyAdmin. So I went to localhost/phpmyadmin and it showed me the databases.
...
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?
0
votes
1answer
45 views
Making a message system
I have created a messaging system with MySQL structure is as follows
`message_id` int(11) NOT NULL AUTO_INCREMENT,
`message_from` int(11) NOT NULL,
`message_to` int(11) NOT NULL,
...
0
votes
1answer
181 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 ...
