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
0 answers
134 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 ...
Mahmoud Al Nagar's user avatar
0 votes
1 answer
1k 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 ...
GISKeeda's user avatar
0 votes
1 answer
46 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....
Zain Shabir's user avatar
-1 votes
2 answers
334 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 ...
Umer Mansoor's user avatar
0 votes
1 answer
1k 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>/...
JConstantine's user avatar
0 votes
2 answers
169 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 ...
Nishuthan S's user avatar
2 votes
3 answers
5k 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 ...
Pooya Estakhri's user avatar
0 votes
0 answers
434 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 ...
WoodrowShigeru's user avatar
0 votes
1 answer
449 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 ...
S B RAKESH RATH's user avatar
0 votes
2 answers
256 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 ...
Katie's user avatar
  • 1
2 votes
0 answers
68 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 ...
Daniel Tan's user avatar
-1 votes
1 answer
431 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 ...
rad man's user avatar
1 vote
2 answers
3k 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 ...
Marcus Barnet's user avatar
-1 votes
1 answer
264 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 ...
Maximilian Travis's user avatar
0 votes
0 answers
407 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 ...
Okpaka Lucky's user avatar
1 vote
1 answer
3k 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. ...
Nivetha R's user avatar
0 votes
1 answer
272 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 ...
Francesco Marcucci's user avatar
-2 votes
2 answers
7k 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 ...
Francesco Marcucci's user avatar
0 votes
2 answers
851 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 ...
dsonawave's user avatar
0 votes
3 answers
84 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 '...
newbie's user avatar
  • 111
0 votes
1 answer
2k 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`; ...
Minos Framework's user avatar
1 vote
2 answers
1k 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 ...
Jesto .K.J's user avatar
0 votes
0 answers
48 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 ...
TWyPGn's user avatar
  • 1
0 votes
2 answers
19k 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
Emmanuel T.I.'s user avatar
-1 votes
1 answer
609 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 ...
Edgar Poe's user avatar
3 votes
2 answers
2k 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 ...
Kontractor's user avatar
1 vote
1 answer
181 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` ...
Peter VARGA's user avatar
0 votes
0 answers
4k 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
-2 votes
1 answer
81 views

Multiple queries in phpmyadmin - Distance using coordinates, Slope, Intercept, Angle, and few more

I having around 500 excel sheets in .csv format with data captured for my experiment having following columns in place. Now I need to calculate the following parameters using this data. I have done ...
Rupesh Nath's user avatar
1 vote
1 answer
391 views

How to calculate running balance for many accounts?

please help me fix query below to calculate running balance correctly. What I need to do is: Calculate running balance (debit- credit) by account_no Reset the balance when account_no changes Reset ...
Abeer Sul's user avatar
  • 165
2 votes
1 answer
661 views

Display phpmyadmin export templates

phpmyadmin no longer displays the export templates section after an update Do you know how to display this section? Current phpmyadmin version 4.9.5deb2
unloco's user avatar
  • 123
0 votes
1 answer
511 views

What settings to use to export mysql table rows that I'll be importing to another table with data using phpmyadmin

If I'm using phpmyadmin to manage mysql database, what settings should I use to export only two rows of data that I'll be importing to another table with the same name that contains many other rows? ...
mhweb's user avatar
  • 63
1 vote
1 answer
983 views

MySQL server keeps crashing every few minutes

I am having the hardest time tracking down this problem. Every few minutes or so my database server crashes so all 3 WordPress sites on my WHM cPanels all crash at the same time. When it does, I get ...
Okomikeruko's user avatar
0 votes
0 answers
2k views

Group by with Order by DESC not working using PHP MySQL codes

I have three tables, table one name (tbl_brands) with these columns: and second table name (tbl_loader_attachment) with these columns: and the third table name is (tbl_images) with these columns: I ...
Talib's user avatar
  • 23
2 votes
2 answers
2k views

How to create a running balance column based on account number?

I have a stored procedure that returns account statement for one or multiple accounts Here is the part I have issues with: returning a running balance in each record based on account number. My query ...
Abeer Sul's user avatar
  • 165
0 votes
2 answers
995 views

MySQL/PHP - SELECT DISTINCT column based on another column with ORDER and LIMIT

I have a table named messages that is as follows: +-----+-----------+-------------+-----+ | id | sender_id | receiver_id | ... | +-----+-----------+-------------+-----+ | . | . | ...
amatek's user avatar
  • 101
0 votes
1 answer
362 views

Changing storage engine to InnoDb from MyIsam is dropping records from table

Currently our Database all tables are using MyIsam as a storage engine. We tried changing storage engine of our mysql tables from MyISAM to InnoDB from PHPMyAdmin operations tab. However during the ...
SohaIb AhmEd's user avatar
-2 votes
1 answer
295 views

Random ID for database users

I need to create a table with a random generator ID for users including letters and numbers for example: FT128 instead of default auto-increment ID Thank you for any help.
Adam Bodiš's user avatar
0 votes
5 answers
20k views

How to switch from MariaDB to MySQL in WAMP server?

I installed wamp server on my PC and by default wamp server is connected to MariaDB as showed below How can i switch to MySQL? Thank you in advance for your help.
user avatar
-1 votes
1 answer
728 views

MySQL tables_priv corrupted

I have a mysql database and i need to create an user for the login. This user need the privileges to only select on only one table where the login info are. on phpmyadmin when i use the gui i receive ...
user avatar
0 votes
1 answer
126 views

ORDER BY with IF-ELSE statement (DESC doesn't work)

Descending sort type does not work with this syntax, please help. <?php require_once("../connection/conn.php"); $compare = $_GET["sortfield"]; if(isset($_GET["sortfield"])){ if(isset($_GET["...
Ellie Chsya's user avatar
2 votes
1 answer
3k views

Mysql 8 accidentally lost ROOT user all privileges in localhost wampserver 3.2

Mysql 8 root user all privileges lost.I changed some permissions from phpmyadmin. . After that all tables disappeared. I found this answer Lost All Privileges in MYSQL.but did'nt help me. I am using ...
BluezTechz's user avatar
0 votes
1 answer
18 views

MySQL database getting connected with any username and password [duplicate]

We have a website running on an custom Ubuntu server managed and hosted by the client himself, since last two days the website database is getting hacked and someone deletes all the db tables from the ...
Nishant Solanki's user avatar
-1 votes
1 answer
31 views

MySQL Table is Huge Where Only Text Values Are Stored

I am using LAMP Stack...And one of my db table wp_options (Rows: 10,600) is now about 194+ GB in size... Not sure why the size growing so much huge... As far as i am concern most of the records are ...
Sajjad Hossain Sagor's user avatar
-2 votes
2 answers
234 views

i want fetch json data in mysql [closed]

I am using MySQL version 5.6.41-84.1-log, I want to fetch single column of JSON data example: I want to fetch date only id | amount_detail ---------------- 1 | {"1":{"amount":"6000","...
Mini TechNos's user avatar
0 votes
1 answer
273 views

Unable to Join phpMyAdmin Using MySQL Defined User

I can login to mysql via the command line just fine, but when I try to log on to phpMyAdmin with the same password that worked in the cli, it won't allow me to connect and gives me: ...
Llamaa's user avatar
  • 3
1 vote
2 answers
4k views

How to turn off autocommit in phpMyAdmin

I want to practice rolling back commands, savepoints and more on phpMyAdmin but I couldn't find a way to turn off autocommit in phpMyadmin. Currently I use the command SET autocommit = 0;. ...
Ransaka Ravihara's user avatar
0 votes
1 answer
151 views

Local MySQL database check for changes

Me and my friend had a website. Before closing website he dumped MySQL Database from phpmyadmin and stores it locally on his PC. Now he send me sql file. Is there a way to see if he didn't change/add/...
user avatar
1 vote
1 answer
7k views

How to export specific columns from a SQL table

I am cleaning some data bases and was wondering that if there is any proper way to export any single column and all it's entries from a SQL table. Being specific, I am dealing with SQL tables in ...
Zulkifl Agha's user avatar
-3 votes
1 answer
286 views

Transfer Mysql table data to client Server via TCP/IP by using Trigger [closed]

i Have Database on MySQL Server. I have one Table so called "log" in Database. Data has been insert in Database table automatic. I would like to transfer table via TCP/IP to the another Software. ...
Gopal Desai's user avatar

1
2
3 4 5
8