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
0 answers
20 views

Problems exporting a database with phpmyadmin

I created a database using phpmyadmin, when I try to export it, it gives me an error on export, and later the SQL module stops and it gives me the following error on xampp: I have already tried ...
user avatar
0 votes
0 answers
19 views

Duplicate foreign key selections when trying to select from dropdown list

I imported information in to phpmyadmin database and every foreign key i select from dropdown list i get duplicates of it. Ones that are sorted by alphabet and ones that are sorted from 1 to ... Like ...
user avatar
0 votes
0 answers
8 views

Is there a machine readable interface for phpMyAdmin

I have to maintain a Typ3 web page. It has a phpMyAdmin plugin which is my only access to the MySQL database. To test changes to the system I want to automatically clone the database to a test ...
user avatar
  • 101
1 vote
1 answer
22 views

how to write mysql query for the following problem?

products table table1 which has item names item_cid item_id item_name 8 403 Tequila1 8 404 Tequila2 8 405 Tequila3 8 406 Tequila4 8 407 Tequila5 8 408 Tequila6 2 409 budwiser1 2 5 budwiser2 ...
user avatar
  • 23
2 votes
2 answers
145 views

Does this kind of data/field in this table needs normalization in MYSQL?

I have this uom table in MYSQL: id uom 1 piece 2 dozen 3 set and this products table in MYSQL: id itemNo title uom 1 19421 test1 1:1:10.00,3:1:56.17 2 7878 test2 1:1:24.33 3 123456 test3 2:12:...
user avatar
  • 31
0 votes
0 answers
13 views

phpMyAdmin Export duplicates column name

I have a MYSQL 8.0.28 server as well as phpMyAdmin running in docker containers. Everything seems to work except that when exporting the database to a dump file through phpMyAdmin one of the views has ...
user avatar
0 votes
0 answers
127 views

Phpmyadmin error Notice in ./index.php#305 Undefined index: utf8

I installed PHPMyAdmin and work with MariaDB 10.6. When accessing the main page I receive an alert with the message: Notice in ./index.php#305 Undefined index: utf8 Any idea how I can fix it?
user avatar
  • 9
0 votes
0 answers
18 views

phpmyadmin Triggers

welcome I have three tables in a database and I want to link them videos channels channels2 i have code SET @channel=(Select channelnumber from channels where flag='0' and channelnumber not in (...
user avatar
-2 votes
1 answer
67 views

How to calculate balance from debit and credit columns for mysql

I Have two columns Debit and Credit and want query to calculate balance from debit and credit for individual customer as shown below in the image:
user avatar
0 votes
0 answers
28 views

Can't log in phpmyadmin, also can't acces the database

My website seems to have been "played" with, I was not able to log in wordpress. I entered my phpMyadmin and I edited the administrator password directly in the wp_users table and I managed ...
user avatar
  • 1
0 votes
1 answer
786 views

mysqli_real_connect(): (HY000/1045): Access denied for user 'phpmyadmin'@'localhost' (using password: YES) - phpmyadmin

I have newly installed MySQL 8 and PhpMyAdmin. I did all the installation steps properly. but once i get login to PhpMyAdmin by root user, it always gives an set of errors at the bottom of page saying ...
user avatar
-1 votes
1 answer
349 views

errno: 150 "Foreign key constraint is incorrectly formed

create table Users( id float(6) primary key, username VARCHAR(20), foreign key(id) references Emps(id)); /*inserting records into users table*/ insert into Users (id) select Employee_Id from emps ...
user avatar
0 votes
2 answers
22 views

Show "0" instead of empty with phpmyadmin

When I run this query the result is empty and it doesn't show me anything select pr.idpreorden,p.DescProducto,pr.Id_Producto, pr.pre_preciounitario, pr.pre_cantidad,pr.pre_total from ...
user avatar
  • 119
0 votes
1 answer
44 views

How to get the maxium row value for a similar values

In my table below, I have id and job_id fields with some of the job_id fields being duplicates. I want to get the MAXIMUM value of the id field corresponding to each unique job_id. I have now tried ...
user avatar
0 votes
2 answers
63 views

Does using the export option to backup a MySQL database (12GB size) cause any performance issues or locking on database?

I have a 12GB database. I want to take a compressed backup using the export option via phpmyadmin. Does this cause any performance impact or locking on the database?
user avatar
  • 2,076
-1 votes
1 answer
40 views

How to take a database backup to a binary file in MySQL using phpmyadmin?

I am using phpmyadmin user interface to mysql database. I want to take a full database backup, and if possible then a compressed one. I know that I can export the database into a .sql file. How to ...
user avatar
  • 2,076
0 votes
1 answer
47 views

Is there a MSSQL `copy only` equivalent in MySQL?

In MSSQL, so that a randomly requested full backup does not affect the differential and transaction log backup chains, we have the option to use the copy only mode. Is there an equivalent of this mode ...
user avatar
  • 2,076
0 votes
1 answer
96 views

Error #1064 on DB Import via PHPMyAdmin

I am using: mysql Ver 15.1 Distrib 10.3.31-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2 I have a wordpress db that I am trying to migrate from one dev environment to another, but I am ...
user avatar
0 votes
1 answer
40 views

Column collision in Left join with many columns vs PHPMyAdmin resultset

I have 4 tables (75 columns each table approx) but they share columns with the same name: Table Master_Producto Master_Product.PD_Prof_21 Table Product_Structure Product_Structure.PD_Prof_21 I am ...
user avatar
0 votes
1 answer
38 views

Importing MySQL dumps to multiple MySQL instances in one machine

In case of title is not clear, I would like to explain myself further. I have 6 MySQL instances in my server. Let's call them, M1, M2, .., M6. The reason I have 6 MySQL instances here, I have also ...
user avatar
0 votes
0 answers
36 views

Sql query + wpml in one language only

I'm not a developer, just a normal user, so please don't expect me to be like you :) I'm managing my website in WordPress, Running 4 languages using WPML, (en,de,cz,pl) My concern is, I want to search ...
user avatar
0 votes
1 answer
48 views

How to speed up queries for 2m Datasets in PHP & Mysql

We have a SaaS Application site, where we would have over 2M records in a table. Server version: 8.0.19 - MySQL Community Server - GPL Protocol version: 10 Even with the indexes these queries are ...
user avatar
0 votes
1 answer
21 views

Inserting data from one database to another database in specific columns not working [closed]

I have csv formatted data, i want to put the data to my existing database's table in specific columns. I was trying to do it with LOAD DATA INFILE... and i have even uncomment the mysqli....
user avatar
-1 votes
2 answers
37 views

Creating Tables with the same table names from other databases doesn't have any bad effects?

I have a WordPress website and I cloned it to another website(domain) using a plugin called Duplicator. So in the backend, phpMyAdmin, I've two different databases but all the tables in both databases ...
user avatar
0 votes
1 answer
536 views

Why do I get #2006 MySQL server has gone away and how can I fix this?

What I'm doing is I'm trying to restore MySQL tables from frm and ibd files. Most of the tables have been restored successfully. I do it like this: mysqlfrm --diagnostic "C:/<path_to_frm>/...
user avatar
0 votes
0 answers
102 views

Edited php.ini but still cannot load csv's into MySQL database

Static analysis: 1 errors were found during analysis. Unrecognized statement type. (near "optionally" at position 146) SQL query: -- Load data into FOOD_NAME load data local infile '....
user avatar
0 votes
2 answers
34 views

SQL query for getting Count of distinct items along with Total [closed]

I'm using MySql (hosted locally at xampp) to store sale information I want the output something like this Is there a single query that gets me the output in this format or should I write multiple ...
user avatar
0 votes
0 answers
10 views

Restore MySQL database [duplicate]

I'm using XAMPP on linux. I reinstalled XAMPP, but I didn't know that I need to export/import databases and not copy/paste lampp/var/mysql folder. PhpMyAdmin displays my database but it has no tables. ...
user avatar
2 votes
3 answers
1k views

Export and import a table without a specific column

I'm trying to export a table with an Auto Increment rowid column and then import it in another server. Considering that the column is primary key and can't accept duplicate keys if i import rows after ...
user avatar
0 votes
0 answers
162 views

Force double quotes in phpMyAdmin export dump

I have a varchar column in my table but when I export it in phpMyAdmin (4.6.6deb5ubuntu0.5), the values are quoted with single quotes. How do I force double quotes? I don't see a setting. CREATE TABLE ...
user avatar
0 votes
1 answer
40 views

Why transaction blocking simple insert in MySQL? [closed]

transaction Query mysqli_begin_transaction($conn); $sql = "UPDATE foldertable SET trashed = 1 WHERE serverToken = (SELECT serverToken from servertoken where userToken = ? limit 1) and ...
user avatar
0 votes
2 answers
80 views

I'm trying to create a database for a hotel company with multiple hotels. I'm stuck on how to reserve a room?

I'm using Xampp phpmyadmin for the first time... So I've got the basics of the database. Customers, hotels, rooms etc. The customer can chose a check-in and check-out date. An admin can class a date ...
user avatar
  • 1
2 votes
0 answers
21 views

how to combine like and between?

i got tables like this: data_transaksi tgl_trans ket sim_wajib what i want to do is showing data from certain dates(tgl_trans) and ket values (values = SW,SS and penyesuian nilai tambah) code ...
user avatar
0 votes
1 answer
15 views

Database not showing

I create a database in the terminal linux ubuntu,gave it all privileges,created the table,inserted the rows.When I open phpmyadmin the database isn't showing how do I connect them? I did use mysql -u ...
user avatar
1 vote
2 answers
103 views

SQL - count rows with same value

I would like to group and list all the rows that have the same value (gruppo_muscolare.nome) and count how many values (esercizio.nome) are related to the same value, but if I use GROUP BY then I only ...
user avatar
-1 votes
1 answer
55 views

Can I use a string as an end of line delimiter when importing a .csv to MySQL?

Very basic question but I'm struggling with it. When importing a .csv file to MySQL, is it possible to use any character or string as an end of line delimiter? If so is it possible from the admin ...
user avatar
0 votes
0 answers
63 views

MySqL Select statement not working

Hello guys can someone help me, I create a two table and one of the table contains a foreign key, i have been trying to select the row that contains data in the table but instead MYSQL is give me only ...
user avatar
1 vote
1 answer
1k views

Missing Edit Privileges Option In PhpMyAdmin [closed]

The Action column of the PhpMyAdmin is not displaying the Edit Privileges. I did not get the solution for this problem. I even tried to upgrade and degrade the PhpMyAdmin version, but nothing worked. ...
user avatar
0 votes
1 answer
58 views

Insert mysql query results into database column with corrensponding ids

I'm trying to store some data from a temporary query into a table, but it doesn't work. Suppose we have the following data Table_A Submission_id Salesman Customer name Hobby Carline Fuel ...
user avatar
-2 votes
2 answers
2k views

MySQL Join two tables with comma separated values

I've got two tables as below: CARLINE option_value option_name tipologia_auto_1 Citycar tipologia_auto_2 Berlina tipologia_auto_3 SUV Hobby_1 football Hobby_2 Basket Datimarketing (is the ...
user avatar
0 votes
2 answers
310 views

how to find password for mySQL database server [closed]

How can I find the password for my database on phpMyAdmin? I want to connect mySQL database just by using mysqli_connect and understand that three strings are needed, but I can't seem to find where ...
user avatar
0 votes
3 answers
69 views

How can I make queries secret?

I have a project whose activity I need to keep private, and I'm not the server administrator. If my app updates a value for the user with id 1, it would probably say something like UPDATE 'users' SET '...
user avatar
  • 111
0 votes
1 answer
969 views

phpmyadmin is no longer letting me set auto_increment value

I am following these instructions to reset the value of auto_increment to the last highest value using phpMyAdmin. Example: If I have this table and data: DROP TABLE IF EXISTS `Tbl_Lis_Agencias`; ...
user avatar
1 vote
2 answers
578 views

MYSQL Server shows it is master server in replication. How to turn off this?

I'm using Ubuntu 20.04 version. I have installed MySQL server using apt-get install mysql-server and used mysql_secure_installation for security. Then I have installed phpMyAdmin using apt-get install ...
user avatar
0 votes
0 answers
44 views

Deleted MySQL “root” user in phpMyAdmin through XAMPP local host…how to restore? [duplicate]

I was working in phpMyAdmin (XAMPP localhost) to add a user for a new database I created for a local WordPress website, and came upon the list of users named "root". Since I did not remember ...
user avatar
  • 1
0 votes
2 answers
5k views

Transpose rows data into columns in MYSQL

Please help me with the scrip that can change table1 into table2 given in the post. I wish to change the rows data into columns
user avatar
-1 votes
1 answer
152 views

Problem with mysql/data folder is too big and took the whole place

for the first time I am faced with such a problem that has puzzled everyone. I have all hosting busy (AWS lightsail) 78GB and after a few analyzes I realized that 90% of the memory is occupied in the ...
user avatar
2 votes
2 answers
783 views

#1194 - table 'user' is marked as crashed and should be repaired

I have problems getting into Mysql on phpmyadmin (mysqli_real_connect()(HY000/1130)Host 'localhost'is not allowed to connect to this MariaDB server ) I have found out its a crashed file in mysql ...
user avatar
1 vote
1 answer
116 views

PMA export with all attributes in CREATE TABLE

This is the default PMA output of an export: CREATE TABLE `foo` ( `id` int(11) UNSIGNED NOT NULL, `fk_id` int(11) UNSIGNED NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; ALTER TABLE `foo` ...
user avatar
0 votes
0 answers
2k views

#1932 - Table '' doesn't exist in engine after accidental delete

I forgot to export my main table before deleting and reinstalling xampp. I recovered it from the recycling bin, but I get #1932 - Table '' doesn't exist in engine when I try to open any of the tables. ...
user avatar

1
2 3 4 5
8