Skip to main content

Questions tagged [phpmyadmin]

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.

Filter by
Sorted by
Tagged with
0 votes
1 answer
440 views

WordPress database error Table './databasename/wep_options' is marked as crashed and should be repaired for query

Please help me my mysql is keep crashing again and again and generating following error i am out of any clue what will be the reason for this issue WordPress database error Table './databasename/...
Shahid Hussain's user avatar
1 vote
0 answers
523 views

mySQL trigger - error when declaring variable

I am using phpMyAdmin and I am trying to declare a variable but it throws an error. Using the following code, it works just fine: IF EXISTS(SELECT * FROM mytable WHERE new.val=old.val) THEN SET ...
treecon's user avatar
  • 131
0 votes
2 answers
2k views

MySQL Import & Replace via CSV

I have a MySQL database table named items with 10,000+ records. Of these records, I would like to export only records where item_isbn IS NULL. SELECT * FROM Items WHERE item_isbn IS NULL produces a ...
jonboy's user avatar
  • 231
1 vote
3 answers
59 views

Will this indexing work as I think it will?

I am a little confused about the indexing I am going to do. First, I am using a 4-column index, like this: Index Name - advanced_query Columns will be used in the index - title, category 1, ...
Dumb Question's user avatar
0 votes
2 answers
407 views

phpMyAdmin how to run an output query? run a batch?

In phpMyAdmin the code below just outputs a list of sql statements for each table: SET @DATABASE_NAME = 'my_db'; SELECT CONCAT('ALTER TABLE `', table_name, '` ENGINE=InnoDB;') AS sql_statements FROM ...
Marc Alexander's user avatar
1 vote
1 answer
32 views

Recreate Scheme SQL [closed]

i need some help i download a script from a website and i want to test it but this script SQL dump file is missing. all i did was upload it to my localhost and install the script however i'm having ...
Anthonyinit's user avatar
1 vote
1 answer
128 views

Select from SQL

I have a database and want to select from mysql a result which could not succeed after one month please help me it would be really appreciated! My Database Table looks like below and Name = Customer ...
sam's user avatar
  • 13
17 votes
1 answer
11k views

Output getting truncated in phpMyAdmin

I am writing a drop statement (in phpMyAdmin) to get rid of some unneeded tables in my database. If I run this query against our live database I am not seeing the full drop statement (it is getting ...
jscar's user avatar
  • 501
1 vote
1 answer
48 views

Can't debug this simple SQL Statement

I'm importing data into a MySQL table using LOAD DATA LOCAL INFILE. I.ve done this on another table without difficulty, and I copied the stmt and just changed the table name and the fields. Here's the ...
John Biddle's user avatar
1 vote
1 answer
2k views

MySQL Stored Procedure - 0 rows affected

I have got two tables i_mast and exp_mast. The structure of both tables are same. +-----------------+ |id INT(5) | |name VARCHAR(30) | |e_date DATE | +-----------------+ When the e_date ...
CodeIt's user avatar
  • 115
0 votes
2 answers
287 views

Is using the rename database feature in PHPMyAdmin safe?

I know the rename database functionality has been taken out of MySQL. My question is, does renaming it in PHPMyAdmin work and is safe? I know they have written functionality to deal with a number of ...
StackOverflowed's user avatar
1 vote
1 answer
4k views

phpMyAdmin Strange permissions #1142 error after deleting a table record with success!

A have a live/production CentOS 6.8 server with Nginx, PHP (multiple versions), MySQL 5.7.18 and latest (when writing this question) phpMyAdmin 4.7.0. This server is running for many years and with ...
Christos Lytras's user avatar
0 votes
1 answer
459 views

Same script produces 'Specified key was too long' on one server and not on another [duplicate]

Senario: I have a CMS with a database .sql file. When I try to load the .sql file on my local phpMyAdmin, its successful, it loads all the tables into phpMyAdmin. When I try to load the same file on ...
Pranoti Buradkar Kokas's user avatar
0 votes
2 answers
1k views

MYSQL Trigger update on a table

Assuming that I have a table, user. How do I calculate the sum of votes and paymentAmt each time they are being updated using trigger? Then, the votes and paymentAmt will be added to the point. I want ...
Synetrix's user avatar
19 votes
5 answers
66k views

How to retrieve the query I used to create a view?

for my company I created a view which is used for exporting. Maybe there is a problem with the query that is used to create this table. So here is my question: Is it possible to get the query I used ...
Opaldes's user avatar
  • 301
1 vote
2 answers
105 views

Optimize Query with Joins + Where

I have a database with 11 tables and a total count of ~120k rows. I do the following query, to get the data of all tables: SELECT SQL_CALC_FOUND_ROWS char.id, char.firstname, char....
Hans Martin's user avatar
3 votes
3 answers
20k views

Foreign Keys and Data Import

I have: a CSV file (5000+ records); an empty item table; am empty favourite table; a number of other empty tables. I would like to populate the item table with the contents of the CSV file. Then I ...
jonboy's user avatar
  • 231
1 vote
1 answer
2k views

phpmyadmin: know the import progress of sql file

Im importing large size of sql file in PHPMyAdmin and it takes to long to import. is there any way to know its progress?. like some kind of loading bar or percent of its progress?. and i'm ...
Vincent Dapiton's user avatar
3 votes
1 answer
684 views

How to store search keyword or browsing history in database [closed]

I'm making my final year project. Which is a website. Things I can't do: Store the browsing history of users between their login and logout session on the site. Or Store the search keywords. But I ...
Shumail ansari's user avatar
1 vote
0 answers
2k views

Database design for a multiple choice question website

So I want to design a database schema for MCQ website in which I have several sections ,Lets say 3. and these section will have many sub-sections each. I want to store the questions, choices and ...
sagar bajpayee's user avatar
-1 votes
1 answer
324 views

Server Problem exporting SRL query from PHPmyadmin with top button

I was trying to export an SQL result in phpmyadmin, and I used the top menu "Export", when I tryied to export as CSV nd than PDF, I had a strange message impossible to create the table "...
antony's user avatar
  • 111
5 votes
1 answer
18k views

DB Restart Taking too long, site is down

I tried to restart MySQL through WHM and now its taking way too long to restart, the progress bar is still showing. What can I do? I can still access the server via SSH but I cannot connect to ...
Hector's user avatar
  • 155
0 votes
1 answer
13k views

Cannot create relationship: Error:Missing index on column(s)

I am trying to make relation on 2 tables in database designer. I am using relationship tool. Below are the steps followed: I clicked on the ID in table lekar. Then I click on lekar column in the ...
Hynek Bernard's user avatar
1 vote
1 answer
9k views

In phpMyAdmin, how can I execute mysqldump query?

I wanted to execute mysqldump -u username -p –all-databases > dump.sql However, I can't see the appropriate field in PHPMYADMIN. Where I can do that? SQL error
T.Todua's user avatar
  • 184
0 votes
2 answers
72 views

Ideal configuration and structure for single db + single table + 20 million static records

I've spent the last few weeks trying to learn SQL the best I can and after doing research and reading many articles, specifically (This SO Thread), I have ran out of luck and was hoping to get some ...
Birdy's user avatar
  • 103
1 vote
2 answers
857 views

file sql.gz give error 1064 when import in phpmyadmin [closed]

I tried to import a .sql.gz file that I exported before another server in phpmyadmin in this new phpmyadmin, the phpmyadmin version is the same, the sql is being imported the same way it was exported (...
Matheus Silva Itep's user avatar
2 votes
2 answers
105 views

MYSQL : many-to-many problem

i'm trying to filter product with their subcategories : for example : if subcategories = (1,3,4) and if this is subcategory_product : how can i get the products with subcategories id=(1,3,4) ??!! ...
Yosri Mekni's user avatar
2 votes
2 answers
15k views

Mysql unable to store emoji in utf8mb4 collation

I can't store emoji characters in mysql datatbase. I searched a lot, but again fails. I have followed this tutorial and changed these variables from Variables tab in phpmyadmin. | Variable_name ...
Vahid Najafi's user avatar
3 votes
3 answers
13k views

Error on re-import: #1231 - Variable 'character_set_client' can't be set to the value of 'NULL'

Using phpMyAdmin, I was getting an error when importing a MySQL dump file to which I'd made a simple global find-and-replace: Error SQL query: /*!40101 SET CHARACTER_SET_CLIENT=@...
Jeremy Carlson's user avatar
1 vote
1 answer
2k views

Limit MySQL server login attempts without fail2ban

I would like to limit login attempts via phpMyAdmin to protect against brute-force attacks. I found solution above, but it is based on fail2ban. [mysqld-iptables] enabled = true filter = mysqld-...
plaidshirt's user avatar
4 votes
2 answers
11k views

"Error creating foreign key (check data types)…" but they do match…

I'm getting the following error trying to create a constraint: Error creating foreign key (check data types) Problem is… those column data types do match. The target is an int(10) unsigned NOT ...
Marshall Banana's user avatar
-1 votes
1 answer
1k views

mysql trigger to trigger only if record doesn't exist

The following trigger : DELIMITER // CREATE TRIGGER auo_mtltp AFTER UPDATE ON master_table_linfomasltp2016 FOR EACH ROW BEGIN IF (NEW.IMHQ_solicitado = 'SI') THEN ...
Max Molina's user avatar
0 votes
1 answer
336 views

How the input entered through the front-end form match with the existing data in database

Am working on an application that helps user to enter symptoms that matches those existing in the database and gets disease(diagnosis). I have the following database table with information about ...
quintumnia's user avatar
0 votes
2 answers
7k views

Table shows id (auto-increment) is 0 in all rows

I am using laravel 5.2 to develop my web application. i recently uploaded the web application from localhost to my hosting account. I also imported MySQL tables from phpmyadmin localhost to my ...
Ian Nato's user avatar
  • 101
1 vote
1 answer
501 views

Increase AUTO_INCREMENT value in phpMyAdmin

So a website that I've inherited had the AUTO_INCREMENT value for a particular table set to a value of 65536. The website is an online store, and this particular table is set for product variations. ...
user avatar
-1 votes
1 answer
3k views

Using value of a column in another table for ENUM/SET values

I have two tables tbl_events with a column location_id. Then I have a table specifically to hold locations and their IDs,the columns in table tbl_locations are location_id and name. I want the ...
Manny265's user avatar
  • 325
0 votes
1 answer
3k views

PHPMyAdmin very slow inserts

I was trying to insert around 70K records to mysql database through phpmyadmin and was shocked of how slow it is. It took around 5 hours to complete! Please find below the details of the table/...
Sami's user avatar
  • 103
1 vote
1 answer
39 views

Database - Remove Everything After

I am pretty new to modifying databases (running phpmyadmin for WooCommerce) and I am currently stuck at a problem. Basically I have around 400 items which have random SKUs (example). JCB-...
Mister K's user avatar
1 vote
0 answers
168 views

Mysql InnoDB relations vanish when exporting/importing to online database

My issue is the following : I have a local database running on EasyPhp server : WEB server : Apache/2.4.7 (Win32) PHP/5.5.8 DB server : 5.6.15-log - MySQL Community Server (GPL) PHPMYADMIN : version ...
Perceval Dev's user avatar
1 vote
1 answer
3k views

1054 - Unknown column in subquery

i have 2 table one store data of relation user other buy user path table +-------------+---------------+-------------+ | ancestor_id | descendant_id | lenght | +-------------+---------------+--...
Vahid Alvandi's user avatar
0 votes
1 answer
3k views

PostgreSQL to MySQL migration to use database for WordPress site - how to's?

I have a complex issue to solve, related to database migration. I have a website full of news to migrate that is currently based on a PostgreSQL database and written in PHP, without a CMS. I have a ...
query_question's user avatar
2 votes
2 answers
7k views

Is it possible to reorder tables in phpMyAdmin?

By default, database tables are ordered in alphabetical order. Can this be reordered? For example: default alphabetical: company, profile, user common User Flow: user, profile, company Maybe the ...
Leo's user avatar
  • 153
0 votes
1 answer
460 views

Why does phpMyAdmin execute all queries with an apostrophe?

For example, if I use the GUI to perform an INSERT, the console will log the following execution: Why does each item have apostrophes (aside from NULL)? I know that I can do a literal INSERT via ...
8protons's user avatar
  • 101
0 votes
1 answer
126 views

What is the significance of phpMyAdmin's configuration storage and what should I know about it?

After initializing phpMyAdmin on my server, I created a test database in the GUI platform. I realized that I had then received a notification in the phpMyAdmin browser that I needed to set up an ...
8protons's user avatar
  • 101
2 votes
1 answer
7k views

Cannot open some tables in phpmyadmin

Recently i get backup of my database from host in that backup i get table in .ibd,.frm,.myd format . I placed this files in xampp->mysql->data->test . Now i can open the tables in php myadmin. ...
Ron's user avatar
  • 123
0 votes
1 answer
2k views

phpmyadmin to SQL Server

I have scripts generated from a MySQL database using phpmyadmin to create database and insert data. The scripts were exported using compatible with MS SQL. Needless to say they are not compatible at ...
user5495269's user avatar
2 votes
2 answers
3k views

MySQL PHPMyAdmin Autocommit Off

I have global autocommits off but I was wondering if it were possible to set autocommit on for PHPMyAdmin during login without doing so manually. Turning off autocommit makes the PHPMyAdmin GUI not ...
Mocking's user avatar
  • 131
4 votes
1 answer
5k views

MySql Workbench Data Import .csv

Hi I am trying to use to MySql Workbench Data Import facility to import a .csv file (thousands of records). However it stops importing the first 5 records. After studying the .csv file I could see ...
jonboy's user avatar
  • 231
1 vote
1 answer
7k views

Fetching data from 3 tables

Wanna fetch data from 3 tables by mysql query to display in feed. But stack. My query is SELECT f.leaderId, f.followerId, c.ccId, c.ccTitle, c.ccCity, c.ccCountry, c.ccFlag, c.uId, c.ccStartingDate, ...
tisuchi's user avatar
  • 11
1 vote
1 answer
1k views

MySQL query taking too long to execute

My MySQL query is taking around 20 minutes to execute which I feel is excessive. SELECT hyp_id,MAX( player_count ) AS MAXPLAYERCOUNT , MAX( viewer_count ) AS MAXVIEWERCOUNT , SUM( player_count ...
ulman's user avatar
  • 11

1
4
5
6 7 8