Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

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.

0
votes
0answers
15 views

Select data evry 15 minutes from sqlite [migrated]

Hello so i'm new in sqlite and php and i have a function that i want it to be executed every 15 minutes but i don't know how would i do it. select command from common_commandlog where datetime ...
0
votes
0answers
16 views

how to sync from local database to server database using codeigniter

I created PHP app in working condition, clients want this app without internet working in localhost and with internet automatically connect to the live server,below shown that code,for localhsot ...
1
vote
2answers
19 views

Default phpMyAdmin Login Credentials

I downloaded and installed phpMyAdmin 4.8.5 on my windows. Upon opening it in the browser, it immediately asks for a Username and Password. I tried to submit root for username while leaving the ...
1
vote
1answer
42 views

MySQL Triggers not working from PHP page but work for manual DB updates via phpMyAdmin

I have the following two Triggers in my MySQL DB that fire BEFORE/UPDATE and AFTER/UPDATE on the house_report_details table. The first deletes all records in my scratch table tmp_house_rpt_details and ...
0
votes
0answers
8 views

how to automatic sync mysql database from local to live server using codeigniter [closed]

I am using a CodeIgniter base application on the local server if the internet is available I need the code for database and application automatically connected from local to the live server and ...
0
votes
1answer
19 views

How to use Unicode chars on PHPMyAdmin?

On a WordPress site I want to replace " !" and " ?" by " !" and " ?". The challenge is that the replacement string not uses a common space char but a thin space char (U+2009). PHPMyAdmin is used for ...
0
votes
0answers
7 views

I am trying to import mybb Database through phpmyadmin but failing?

I have made the database through cPanel. Now I am trying to import it in my wamp server. But everytime I try only 22 tables gets imported and others don't. How to fix it? My file isn't that big in ...
0
votes
0answers
22 views

MYSQL #1146 : does it mean the data was lost?

I delete WampServer with all databases and install a new version (AppServ) with php,mysql,apache before I deleted it I copy the wamp64 folder to D:\wamp64 then I just move the folder D:\wamp64\bin\...
0
votes
1answer
17 views

Why does the column content say “Array”?

I got this problem when I'm doing mysql that every time that I post pictures on the blog it will say to the database that I got array on image column. it is supposed to have the image that I inserted
0
votes
1answer
8 views

Can I upload database backup made through cPanel into phpmyadmin?

I have been using mybb forum software. As, I use shared hosting so they had provided me cPanel. Through it I had make a backup which is a .gzip file. Now, my query here is that I want to upload it to ...
1
vote
0answers
12 views

All columns of all views defined as “1” in phpmyadmin export

MySQL 5.7.24, phpmyadmin 4.8.3 phpMyAdmin appears to export corrupted definition on all views of one of my MySQL database. Eg: show create view v_contacts returns CREATE ALGORITHM=UNDEFINED DEFINER=`...
0
votes
0answers
16 views

MySQL (phpmyadmin) update query from one table to another table

I have an issue with my SQL query as I have two tables named Student_Summary and Fees_Master. In Student Summary I have a column named Admission_fees and in fees master we have Fees_Type. For fees ...
0
votes
1answer
23 views

How to remotely manage (with PhpMyAdmin) a MySQL RDS on a load-balanced AWS Elastic Beanstalk setup?

Although there are similar questions and topics, I can't find a solution that currently works. I specifically wrote remotely manage because I'd like to use my home computer's PhpMyAdmin to directly ...
1
vote
1answer
36 views

Handle 4 tables and to show 4 columns as result

i can't figure out how to build the correct query that involves 4 tables and shows these 4 columns: I want to show this 4 rows, each from a different table. EDIT: Each company belongs to a Sector. ...
0
votes
2answers
16 views

How do I export a multi table database with exceptions?

I am working out of phpmyadmin to export data using an sql. I have an 88 table database. I would like to export all data to a .csv from 85 of those tables where I am only keeping the rows in which my ...
-2
votes
1answer
30 views

Error in stored procedure on Phpmyadmin [closed]

I have created this simple StoredProcedure in the Phpmyadmin SQL console but I keep getting syntax errors. I have looked at similar created StoredProcedures but can't seem to figure out what the error ...
0
votes
0answers
21 views

Proper way to fully backup and restore a database including indexes in a low-resource shared web host with ssh access?

I'm rather new to database management and I would like some advice on better practices by using the following experience as an example. Every time I update php software I do a quick export from ...
0
votes
0answers
47 views

Display Dynamic Pivot MySql Table to PHP

i need help on how to display this on html or php. i have this dynamic pivot table code. SET @sql_dynamic:= (SELECT GROUP_CONCAT(DISTINCT CONCAT('if(sum(if(attendance_date = "', ...
-2
votes
1answer
22 views

Where I can see phpMyAdmin release/schedule dates? [closed]

I've tried, but failed to find the source, where I can see the schedule of phpMyAdmin release dates. For example, on official site, it's 4.8.4 version, however, 5.0 version is on github. Where I can ...
0
votes
2answers
41 views

query to replace text with sequential numbers

I have an images database, the default sort is the "name" column, and the "description" column content is the exact same in all files in the table. what I need is to replace certain text in the "...
1
vote
0answers
19 views

Create a table via an INSERT trigger in MariaDB

I'm trying to make a small database I can use to log changes I make to configuration files on various Linux systems. My thought was have a Database named for the system, and then a table called ...
1
vote
0answers
16 views

Weird database icon appears on PHPMyAdmin user interface

On my PHPMyAdmin user interface, I noticed one database which has a strange icon: What does this mean? What causes it? P.S. Note that the database in question functions well (I mean I have no issue ...
-1
votes
1answer
31 views

phpMyAdmin 4.8 vs 5.0 comparison

doc says that since release 5.0, only php 7.1 and later are supported. Can you tell me, where I can viw & compare features among phpMyAdmin versions? why v5.0 is so special that it can't be run on ...
0
votes
1answer
32 views

Auto update “TIMESTAMP” column only when a manual phpmyadmin edit occurs?

I have a column in my MySQL database that uses a "TIMESTAMP" to capture the current time. I have an attribute set to "on update CURRENT_TIMESTAMP" so it auto updates the column whenever and update ...
0
votes
2answers
33 views

Replace some rows in one table with rows of another table

I have two tables and a set of primary key values. I want to replace all rows of the first table whose primary keys are in this set with the corresponding (having the same primary key) rows of the ...
0
votes
1answer
22 views

#1146 table 'db.tablename' doesnt exist

I use AMPPS for localhost server purpose. I was working on one of my client site on localhost. When I start working the other day, it suddenly start giving me such error table does not exist Even ...
1
vote
1answer
31 views

Having troubles creating a specific TRIGGER in MySQL

So I am trying to implement a trigger in MySQL that is triggered once a new user is registered. The relation of my tables are: USER_ACCOUNTS has primary key USER_ID. RACE_TRACKS has primary key ...
1
vote
2answers
61 views

Mysql optimization edit my.cnf

Firstly, I am a beginner. I have a server, which has 32 GB RAM and 16 CPUs. I am working on MySQL optimization, but I have a problem. I am trying to set the InnoDB buffer pool instances = 8. But it'...
-1
votes
1answer
51 views

Inserting data into a 3NF database [closed]

I have 6 tables with ~2-15 attributes each, each one of these 6 tables has an ID which is constrained from another table. This 7th table has its own ID and the 6 other table ID's, as well as a date ...
0
votes
1answer
41 views

Does phpMyAdmin only works with HTTPS?

I have manually setup phpMyAdmin (downloaded from official site) on my site. However, when I enter my User&Pass in login page, i get warning: When i try same page with HTTPS, it logins. Any idea ...
1
vote
1answer
118 views

What is difference between SELECT * FROM table and SELECT * FROM table WHERE 1

What is difference between SELECT * FROM table and SELECT * FROM table WHERE 1 Query 1: SELECT * FROM table Number of records : 103 Load time : 0.0005 sec Query 2: SELECT * FROM table ...
1
vote
1answer
33 views

Fetch ids(Primary Key) from table where ids not available in table within range

I have table named Student. It have primary key student_id which is auto increment and not null. Now Student contains around 5000 records. After passed out from university, we need to delete ...
0
votes
2answers
66 views

Update from PHP 5 to PHP 7.0 - PHPmyAdmin will show two server logins: localhost / localhost:3306

I updated my Linux 14.04 LTS to 18.04 and had to downgrade the PHP 7.2 to 7.0 as I need to run some software which is not capable of the preinstalled PHP 7.2. I used PHP 5 so far. After I got ...
1
vote
0answers
41 views

Simple/basic database design problem (with relationships)

It's been years since I've done anything with SQL databases (and I was never more than a novice). I think I've messed something up and I'm not sure how to fix it. I have 3 tables: services (as in ...
0
votes
2answers
66 views

phpmyadmin/ mysql how to copy a table with all its constraints

I tried to copy a table which is connected to another table through a foreign key using $query = "CREATE TABLE table1 AS SELECT * FROM table 2"; but when I run this query it copies every thing but ...
0
votes
1answer
532 views

Unable to read master log position while setting up MySQL slave

Hi I am trying to setup a data replication server. I am using MariaDB and phpMyAdmin to interface with the 2 DB's I have set up my master with adding the following configuration to my my.ini file ...
1
vote
1answer
155 views

How to open a file in MySQL event scheduler?

I am currently creating my first event in MySQL: CREATE EVENT check_for_uploads ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL 1 MINUTE ON COMPLETION PRESERVE DO // I would like to open a .php file ...
0
votes
1answer
308 views

Update value in table based on condition in other table with trigger

I have 2 tables, first stores the details of all the races 1: and second the users who have joined which races 2: I want to update the race_status to Full and record_status to 2 in race table, if ...
1
vote
1answer
486 views

Can't connect to a remote server using phpMyAdmin

I tried with two different servers, one had no issue but the other gave me this error: MySQL said: Cannot connect: invalid settings. mysqli_real_connect(): The server requested ...
1
vote
1answer
1k views

You do not have privileges to manipulate with the users!

Error message: You do not have privileges to manipulate with the users! Appears in PhpMyAdmin using Mariadb 10.3.7 on MacOs High Sierra installation from Homebrew I'm logged in as root installed ...
1
vote
0answers
55 views

Mysql dump is not full

I have installed fresh ubuntu 16.04 with apache2.4 and php7.0 on it and then installed mariadb. Here is version: mysql Ver 15.1 Distrib 10.0.35-MariaDB, for debian-linux-gnu (x86_64) using readline 5....
0
votes
1answer
493 views

How to execute dependent multiple SQL queries from multiple databases via same PHP web page?

We can connect a single PHP page with more than one databases. But what about executing multiple dependent queries that belong to different databases? mysqli_multi_query(connection,query); does not ...
0
votes
1answer
261 views

Non Super User cannot alter stored procedures and functions

I am running into an issue granted a user access to alter stored procedures and functions within MySQL 5.7.22-0 running on Ubuntu. User has ALL PRIV on the database except GRANT User has SELECT PRIV ...
3
votes
2answers
230 views

Exporting table from MySQL 5.7 to MySQL 5.6 (Error)

While running the following queries on MySQL 5.6.39, DROP TABLE IF EXISTS `sessions`; CREATE TABLE `sessions` ( `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `user_id` int(10) UNSIGNED ...
2
votes
1answer
724 views

Why is ON DUPLICATE KEY not working as expected?

Before I start, I'm not a web developer by trade. I'm self taught using google and StackOverflow. So I recently moved my site from a shared hosting to a VPS. My provider moved my site / files over ...
1
vote
1answer
32 views

Can't set up Unicode support

I am creating a toy website locally with XAMPP and I want it to support Unicode. index.php contains a simple form that I can use to add a new entry (a UTF-8 string) to a table "myTable" in the DB. ...
0
votes
1answer
11 views

php single table language separated autoincrements?

I have 1 table for posts. And my columns are Id | id_language | lang I want to achieve, that there is a second autoincrement id for its language. For example the 80.post is the 5.post written in ...
0
votes
0answers
256 views

Some foreign keys and tables not displaying in phpMyAdmin

I have a small database (9 tables, 17 fields) that I was trying to build using phpMyAdmin. When I go into the designer view for my database, many of the foreign key constraints are missing from the ...
-2
votes
1answer
47 views

I want to make a database where an ID can have multiple records [closed]

I am currently making an inmate information system in which the admin can insert multiple visitations records for a certain prisoner This what my prisoner table looks like Visitations table: I want ...
0
votes
1answer
40 views

Is there any scenario where a exported (.sql) database dump could be bigger in size, than the database itself?

I'm a developer in a local company, and I'm currently working on a project which involves migrating a website to my company's server, from some other hosting provider. For some reason this other ...