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.
-2
votes
0answers
39 views
how to fix error #1062 duplicate entry [closed]
whats causing this error
SQL query:
DELETE FROM `adminpanel`.`aggrement` WHERE `aggrement`.`id` =3
MySQL said:
#1062 - Duplicate entry '3' for key 'PRIMARY'
this is happening when i try ...
0
votes
0answers
48 views
Unable to import exported Wordpress DB - #2006 - MySQL server has gone away
I'm having a nightmare trying to clone a live Wordpress site into a local dev environment using MAMP Pro and BackupBuddy.
I have no problem with setup. The problem is that there seems to be some ...
2
votes
2answers
31 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 ...
0
votes
1answer
52 views
Zip based search in mysql.
I want to implement a zip based search in mysql database, I am populating the location column in my database based on a drop-down where in I have predefined zip codes, now if a user wants to search ...
1
vote
1answer
49 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
1answer
87 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 ...
0
votes
0answers
75 views
error in creating trigger in phpmyadmin
I have 4 tables:
event:
event_id(p.k) | uid | circle_id(f.k)
activity:
uid | performed_activity_id(f.k->event_id) | activity_type_id
follow:
follower_id | circle_id(f.k)
noiticication:
...
0
votes
1answer
44 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,
...
2
votes
2answers
110 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.
1
vote
3answers
326 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
98 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
1answer
940 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
2answers
79 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
108 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. ...
0
votes
0answers
171 views
What to do to reduce first byte time after removing slow queries?
I've set long_query_time to 1 sec and found only 2 query which took 1 sec to execute at 2 different points of time since yesterday. So I don't suppose such 2 queries cause my first byte time to be 3 ...
0
votes
0answers
46 views
Configure phpmyadmin to run on different hosts
Just created locally a new host pointing to a new Virtual Host.
And added through command line a new user at the new host.
So like 'user1'@'localhost' I now have 'user2'@'local2' .
The problem is I ...
0
votes
1answer
113 views
What to do with alerted variables phpMyAdmin for MySQL databases?
I've noticed the following alerted variables in phpMyAdmin
Variable Value Description
Aborted clients 5 The number of connections that were aborted because the client died without closing the ...
2
votes
1answer
70 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 ...
0
votes
1answer
698 views
MySQL incredibly slow on WAMP and XAMPP
I've installed WAMP on my new Windows 8 machine and for some reason when I use PHPMyAdmin to import an sql file (it's only about 5mb), it takes several minutes before timing out. And then when I check ...
2
votes
1answer
161 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
1answer
255 views
how to retrieve rows of different dates using IN clause
My table structure:
+-----------------+--------------+------+-----+-------------------+----------------+
| Field | Type | Null | Key | Default | Extra |
...
0
votes
0answers
30 views
localsite joomla database tables not accessible
I have a joomla website functioning locally on MAMP but phpmyadmin cannot access database to dump and go to remote server. The database list column at left indicates there are 62 tables with a ...
1
vote
1answer
104 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
0answers
75 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
1answer
155 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
236 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
0answers
86 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 ...
2
votes
0answers
285 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 ...
4
votes
1answer
150 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 ...
0
votes
1answer
342 views
database creation using codeigniter database dbforge class gives “Access denied for user 'username'@'localhost' to database 'database_name' ”
Using codeigniter database dbforge class I have created a database and loaded that database as the current database and created tables in localhost WAMP server. But when I uploaded it to the server I ...
1
vote
2answers
80 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 ...
0
votes
0answers
60 views
With PhPmyadmin how to show points in a pretty way?
This is what I see if I access my database with Phpmyadmin
The type of LatLong is point (yes it's spatial myisam databases)
Well, is there a way to show that LatLong points in "prettily"?
0
votes
0answers
168 views
On Mac OS-X I can connect remotely via mysql command line but not with phpMyAdmin
I am able to successfully login and query a remote database with my command line using the following:
mysql --user=username --password stagingdb -h 10.0.0.2
However, when I try to do the same thing ...
1
vote
0answers
105 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
332 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 ...
0
votes
0answers
73 views
phpMyAdmin, different results between importing .sql file and executing query
When I import this sql file in phpMyAdmin the values (containing special chars) are cropped:
Exploring sql imported table/data:
But when the query (contained in the .sql file) is executed in the ...
3
votes
2answers
18k 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 ...
3
votes
2answers
558 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 ...
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 ...
2
votes
1answer
121 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 ...
2
votes
1answer
406 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 ...
0
votes
1answer
421 views
How to split 32GB .sql file in small parts [closed]
I have a single 32GB .sql file and i have to split files in smaller pieces as i have to extract email address string from .sql file. Since file is so huge and i can't wait for long time. Please ...
1
vote
1answer
212 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?
...
0
votes
0answers
976 views
PhpMyAdmin Missing parameter:
Everything was working fine until this moment I want to create a new database and I'm receiving this error
db_create.php: Missing parameter: new_db (FAQ 2.8)
Also when I was trying to export my ...
0
votes
1answer
802 views
PHPMyAdmin incredibly slow [closed]
Does anyone else's phpmyadmin take an incredibly long time to load? like 68 seconds after i click a table it finally gets there...!
its also very slow when i click the "add data from text file into ...
0
votes
0answers
74 views
Not all the table in mysql show in phpadmin
I recently accidently dropped my whole database for Wordpress, but luckily I had backed it up with Time Machine.
The problem now is when I copy the database file back to the path where I store the ...
1
vote
2answers
401 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
826 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
172 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 ...
