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
1answer
245 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 ...
1
vote
1answer
29 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 ...
1
vote
1answer
105 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 ...
7
votes
1answer
7k 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 ...
1
vote
1answer
33 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 ...
1
vote
1answer
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 ...
0
votes
2answers
195 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 ...
1
vote
1answer
3k 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 ...
0
votes
1answer
440 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 ...
0
votes
2answers
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 ...
10
votes
5answers
38k 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 ...
1
vote
2answers
83 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....
2
votes
3answers
14k 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 ...
1
vote
1answer
1k 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 ...
2
votes
1answer
246 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 ...
1
vote
0answers
1k 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 ...
-1
votes
1answer
293 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 "...
3
votes
1answer
11k 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 ...
0
votes
1answer
10k 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 ...
1
vote
1answer
5k 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
0
votes
2answers
57 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 ...
1
vote
2answers
702 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 (...
2
votes
2answers
80 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) ??!! ...
2
votes
2answers
11k 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 ...
2
votes
2answers
8k 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=@...
0
votes
0answers
81 views

Replicate Master to Different Slaves

I have a master database which would be the cloud server that consisted of different schools. Now those schools are deployed to their corresponding school location which would be the local server. ...
1
vote
1answer
1k 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-...
2
votes
2answers
5k 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 ...
0
votes
1answer
984 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 ...
0
votes
1answer
194 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 ...
0
votes
2answers
6k 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 ...
1
vote
1answer
282 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. ...
-1
votes
1answer
2k 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 ...
0
votes
1answer
2k 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/...
1
vote
1answer
36 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-...
1
vote
0answers
157 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 ...
1
vote
1answer
2k 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 | +-------------+---------------+--...
0
votes
1answer
2k 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 ...
2
votes
2answers
3k 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 ...
0
votes
1answer
309 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 ...
0
votes
1answer
99 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 ...
1
vote
1answer
4k 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. ...
0
votes
1answer
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 ...
1
vote
2answers
2k 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 ...
4
votes
1answer
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 ...
0
votes
0answers
4k views

Phpmyadmin not displaying table data

I have a table named "log", which basically stores error log for my php application. My application has database running on rds, and recently i had to delete logs from this table, so i downloaded a ...
1
vote
1answer
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, ...
1
vote
1answer
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 ...
1
vote
0answers
2k views

Connecting PhpMyAdmin to two different MySQL instances on the same host

I currently have running two MySQL instances on my machine, production and development - I can connect to each one using the following: mysql --host=127.0.0.1 --port=3306 -u root -p mysql --host=127....
2
votes
4answers
18k views

Deleted MySQL “root” user (using phpMyAdmin)…how to restore?

I'm test-running a Joomla installation (locally, using WAMP) with an MySQL database supporting it...this is in preparation to moving everything online once I have it configured. I was working in ...

1 2 3
4
5
7