phpmyadmin: how to remove time limit to import big databases
how can I remove the time limit for the import operation in phpmyadmin ? I'm not able to upload a big database because of the limit and I have to login again in the database. Thanks ...
phpmyadmin
mysql: how to perform these 2 tasks
hi, how can I do the following points in mysql (possibly using phpmyadmin): 1) Given an existing column of numeric values (colA), create a new column with text data (colB) and automatically fill this column with "typeA" if colA = 0, and "typeB" if colB > 0 ? 2) Given the following 2 tables Users and Docs: Table Users has the columns ...
Error in phpmyadmin though runs fine in php script
Ok so this one is strange and I'm thinking there must be a problem in my sql query but I don't see anything wrong with it. What is happening is that I have a script that I am running in a php script that retrieves all categories that a user has signed up for as well as how many other people have signed up for the same category. When I ru...
How to subtract the same amounts to all values in a column?
I was wondering if I can subtract the same value (offset) to all values of a specific column in my table. For example I have: Col1 ------ 34 35 36 I want to make it: Col1 ------ 24 25 26 What's the SQL code for doing it ? ...
Link in foreign keys in phpmyadmin
I have foreign keys set in a mysql db. I have backed up my db from one server to a new one. Both the new and the old server use phpmyadmin. On the old server, y used to have a link in the view of a table from the foreign key to the respective register in the other table. An html link that leads me to the register in the other table. But ...
where the heck is this php.ini file anyways?
I'm running php vs. 4.1.14 on yahoo with phpMyAdmin. it says the file is at /usr/lib/php/php4.ini but I can't find this anywhere. Is it in the phpMyAdmin folder? I really need to find this and turn of magic_quotes soon or I'm gonna go postal. Thanks. Okay So i guess It wasn't that clear. I did phpinfo(). I don't know how to find that ...
Question: how to use the current time in a where clause
Hello all, there was a question coming up to my mind. Is there any possibility to use the current timestamp instead of a selected date in the Where Clause? SELECT this, that FROM here WHERE start>='2010-07-01' I thought it would be sth. like: start='now()' or curdate() or curtime(). Anything I found was that they're used in the Selec...
Sql-Query: Hiding letters after space in the output
Hello all, I've got a problem and hope you can help me find a solution. Name Hours title Name1 12 #1 (Text) - text - text Name2 13 #1545 (text) - text - text Name5 19 #33558 (text) - text - text Name6 36 #54123 (text) – text This is an extract from following query: SELECT name AS Name, Sum((Unix_Timestamp(end)-U...
Installing phpMyAdmin on Cent OS 5.5
Sorry guys, I posted it on here by mistake... I have created it over at server fault: http://serverfault.com/questions/167302/installing-phpmyadmin-on-cent-os-5-5 ...
Is it possible to use characters instead of a position in a substring function?
Hello all, is it possible to use characters instead of a position in a substring function? SELECT SUBSTRING(title,2) FROM table puts out every title starting with the second position. Now I want to cut the output after a space. The space positions varies. Is it realiseable? I tried sth. like SUBSTRING(title,2,LOCATE('',title)),but fo...
php page can't load MySQL's database
Hi I'm having some problems while trying to connect a .php with mysql. here's the connection.php code <?php $db_host =$_POST['localhost']; $db_user =$_POST['root']; $db_password = ""; $db_name = "prtcl"; ?> and this is the page where I actually use the connection <? include("connection.php"); ?> ... <?php $db = mysql_connect($db_...
PHP Page forced download IN ERROR
This is a strange problem but it happens enough that I wanted to ask. For some reason, sometimes the browser will force a php page to download to the browser and it always comes up with 0 bytes. Mind you, I'm not trying to force the download and I'm very familiar with headers and forcing files to download intentionally, what I'm talkin...
the value is not inserted in db
i want to store more than 1000 character in database i use mysql database. when i insert 50-100 character the code run successfully.but when i insert 1000 character it not inserted. even it also not give error. when i use similar insert query in myphpAdmin, the query run successfully. this is query first two fields are varchar & last ...
MySQL backup in shared hosting on windows that does not allow remote connection
Hi all, after googling for a long time, I decided to ask this: I've uploaded a site to a shared hosting that does not allow remote DB connection due to security issues (according to them). the Data is very important to me and I'd like to back it up automatically on a daily basis (in addition to the hosts daily backup). I'm writing the ...
how to maintain paragraph?
i have a problem when i insert some articles which includes paragraph to database at the time of retrieval it display article but without paragraph. so it look like dirty writing on the page. so is there any trick or code for save article with paragraph & at time of display it shows as it is. ...
Using phpmyadmin to manage duplicates
Hi! I'm looking for a tool that allows me to easily manage duplicate entries in the MySQL database. In a sense, I don't want to make my columns 'UNIQUE', but I want to review the records that happen to have exactly the same value in a column. It would be nice if I could craft such an SQL query that shows only such records using the us...
Can't connect to database using my recently added user in MySQL
I'm trying to add a new user to a mysql database. The original state of the file looks like this (which works): $dconex=mysql_connect("200.xxx.xxx.xxx","abong1","XXXXXX"); mysql_select_db("abong1",$dconex); I'm trying to add this line in between the mysql_select_db: $dconex=mysql_connect("200.xxx.xxx.xxx","abong1_abongler","XXXXXXXX"...
how to retrieve table name from database in mysql?
i want to retrieve table name from database plz suggest me query. i am using phpmyadmin database. ...
Auto back-end generator
Is there any PHP application that can automatically generate add/edit forms and listing pages by just reading the database. Like PhpMyAdmin but highly customizable through code or configuration files. The main reason is to avoid time spent on development of back-end of web applications. ...
Faster way to import thousands of records from a single txt file into database MySQL?
I have like 50 txt files each with around 8 columns and 80,000 records. I have written a script in Matlab that reads all the files one by one and then puts it into MySQL using a single INSERT statement for each file. However doing so is taking a huge amount of time(even for a single file!). I have also tried using PHPmyAdmin which says t...