This is actually 2 questions... Background: After using the command line in MySQL for my database introductory classes (very enjoyable), I had been required to use a DBA tool and downloaded XAMPP as identified below. The transition to a GUI would be ok if I understood the interface for creating database tables... Q1.I have searched the ...
Hi, Problems:- Whenever I try to select all tables in a database the connection is just lost and unknown error is given by the server to the browser and the browser just reloads with its own error page stating that the server gave unknown error. (This is in phpmyadmin) I tried to solve this by adding max_allowed_packet to my.cnf first ...
Hi, I have Ubuntu, and installed the phpMyAdmin package (currently 4:3.3.2-1). Every 30 minutes, it asks me to enter my username and password, for inactive session timeout. In earlier version of phpMyAdmin, setting a user/pass would entirely skip this login form and keep the session open indefinitely. This installation is on a dev machin...
I installed the lampp sever on my local in linux OS, but its giving error while opening phpmyadmin. #2002 - The server is not responding (or the local MySQL server's socket is not correctly configured) ...
i'm trying to track down a bug that's deleting rows in a mysql table. for the life of me i can't track it down in my php code, so i'd like to work backwards by finding the actual mysql query that's removing the rows. i logged in to phpmyadmin, but can't find a way to view the history of past sql operations. is there a way to view t...
I am very new to PHP and SQL. I have table that needs to be updated whenever a record is inseted into another table. My query works great when I run it directly in the database but I want to include it in a php form so that it will run whenever the user enters a new record. I investigated the use of a trigger but apparently the trigge...
I have these lines at the top of a MySQL .sql file (dumped with phpMyAdmin): /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; But they all seem to be comment...
Hi all, I have undertaken a small project which already evolved a current database. The application was written in php and the database was mysql. I am rewriting the application, yet I still need to maintain the database's structure as well as data. I have received an sql dump file. When I try running it in sql server management studi...
I need to delete duplicate record from table in mysql. So i have a table name "employee" fields are empid, empname, empssn for getting duplicate record i have written a query SELECT COUNT(empssn), empssn FROM employee GROUP BY empssn HAVING COUNT(empssn)>1 Now i want to delete duplicate records. for that i have wr...
On a webserver, I have a php script that parses a .sql file (which is stored directly on the server), and executes the queries on a mysql database. I have a lot of french characters that doesn't insert well: é becomes é. When I open the sql file with notepad++, I see that the encoding is "uft-8 without BOM". My script looks like thi...
I have a MySQL table where I store text entered in any kind of language. The text is displayed correctly on the website, example but when I export the data to Excel I get garbled text. I tried exporting the data via PHPMyAdmin and even just doing something from the command line like mysql -user -p db < query.sql > export.tsv and I get...
I dropped all tables from a database then restore(import) a backup. and getting this error. Should i repeat the process. or something else? Why this error is coming? ...
Is it possible to restore the previous state of a mysql database through phpmyadmin? I have one column in 4 of the tables that have the auto increment. And my problem is how to begin again in the count of number 1 when I try to add a data. I tried deleting all the records then add a record but it doesn't start with 1. How do I do this w...
I use a local Apache server for many things, but I never really had a use for MySql. I recently decided to keep a local copy of Wordpress, so I installed MySql. I tried to install PHPMYADMIN, but every time I tried to log on I got a blank screen. I tried with good and bad credentials and even the CONFIG mode. I even did the same thing w...
I am not sure why I am getting this error #1062 - Duplicate entry '1' for key 1 cany any one help explain what it means. Thanks ...
I am making a mySQL table which lists ~70 products and information on whether they are compatible or not. For the sake of simplifying the question, I will pretend there were only four products. Product1 Product2 Compatible? A A Yes A B No A C Maybe A D ...
I have 2 queries which display 2 different values but the results from one query are unexpected. Query1: SELECT SUM(T.amount_reward_user) AS total_grouping FROM fem_user_cards UC LEFT JOIN fem_transactions T USING(card_number) LEFT JOIN fem_company_login FCL ON T.fem_company_login_id=FCL.fem_co...
I'm trying to import data into SQL from a CSV in PHP My Admin so it may be a PHP My Admin problem. The problem i'm having is that some of the columns use special characters for instance: "Adán, Antonio" Ends up as just "Ad". The column structure is as follows: CREATE TABLE IF NOT EXISTS `players` ( `player_name` varchar(255) COLLA...
hi all, i've been writing apps for about 8 months and have recently gotten interested in updating a database via myphpadmin and then retrieving the data to my application. more specifically, i developed a website that updates student attendance records, updated daily by the "teacher". i want the "parents" to be able to download my app...
Possible Duplicate: What is the best IDE for PHP ? Hello again everybody, I finish my work placement next week and have over a month off before I start my studies again. Being the super cool party animal that I am I have decided to use the time getting a firmer grip on PHP. I recently bought the highly recommended book 'PHP ...