phpmyadmin

PHP MYSQL timeout problem

I have an SQL query like this. When iam executing it though my php file it gives time out error. But when running the same query thoruhg php myadmin it gives results within seconds. SELECT cake_apartments.id, cake_apartments.Headline, cake_apartments.Description, cake_apartments.photoset_id, cake_apartments.Renta...

SQL DELETE falling over in PHPmyAdmin Cant work out Why, is it because of LEFT OUTER JOIN

SELECT * FROM `User` LEFT OUTER JOIN `freshersdata` ON `User`.`username`=`freshersdata`.`username` WHERE (`freshersdata`.`username` IS null) AND (`User`.`Persistent`!=1) This SQL query is falling over with ( #1064 - You have an error in your SQL syntax; ) message but works perfecly with a SELECT instead of a delete, why is th...

Can you edit all columns in a table using phpMyAdmin?

In phpMyAdmin, like the create table view with a spreadsheet of column settings, can you edit a table's columns with new columns, as a similar spreadsheet? ...

phpmyadmin - list files in directory

Hello, I have apache+mysql+phpmyadmnin under Gentoo. phpmyadmin-3.2.2 It worked fine before, but now, when I'm loading http://localhost/phpmyadmin I get a list of flies in phpmyadmin-directory, and when I chose index.php, I get it's own code. What I did wrong? ...

How do you update the structure of an entire MySQL database?

ok, say you have two dbs. one you use as a master template which goes through various revisions, let’s say we’re now on revision 3. but the second db is a copy of the template as it was at revision 1. because db 2 is in use, you don’t want to drop any tables, but you do need to update the structure of the entire db to the latest version...

Accessing .sqlite db from phpmyadmin? FF cookies

I'm trying to view my firefox cookies db (cookies.sqlite). Since I've never accessed dbs with anything other than phpmyadmin, I'm at a loss as to how to view the content of this sqlite file. There's localhost/sqlitemanager, but I'd rather stick to the phpmyadmin interface that I'm used to. Any ideas how I can open/view this sqlite db th...

mysql length limits

I am changing my db so that certain fields can be longer. Right now they're "varchar(255)" can I just increase that to "varchar(500)" or are there special rules for dealing with this and I should make them "text"? ...

Where is phpmyadmin located in plesk?

I have plesk 8.3.0, with phpmyadmin 2.8.2.4 I tried to look up where the phpmyadmin is located. I couldn't find it in srv/ and i did a find command in the server and not quite sure where it is actually located. What I want to do is to set up a phpmyadmin under /httpdocs so that I dont have to login to plesk and click many times until...

What Sql (PHPmyadmin)Statements would I use to create the following?

I want to create two Tables. Product, Members, and Category. I want the structure of the tables to be like: Category: Two Fields: (Category_ID) (Category_Name) and I would like Category_ID to be the Primary Key Product: Three Fields (Product_ID) (Product_Name) (Product_Price),(Category_ID) and I would like Product_ID to be the Primary ...

Make a Copy of Live MySQL database periodically

Hi Friends, I am stuck with a problem. I am working on a backoffice project which needs to access the live database of our website which is very big and complicated. Now when i connect my backoffice with live Mysql database and run my queries, some slow queries are also there which in turn locks the database for that time period and the...

Why am I receiving an unexpected T_CONSTANT_ENCAPSED_STRING error?

I am getting this error: Parse error: syntax error, unexpected T_CONSTANT_ENCAPSED_STRING in C:\wamp\www\vacation_showcase\admin\participants_edit_list.php on line 17 This is my sql statement: $sql = 'SELECT substring_index(description,' ',100) as preview, name, extra_line, link FROM participants ORDER BY name ASC'; I dont know why...

How to reset to all privilages for root @ phpmyadmin?

I've created new db via phpMyAdmin and while editing db privilages clicked delete localhost privilages for this db (dunno why). Unfotunately all root privilages has gone. I can't see or create any db. Only root has admin rights. Is there any way to fix it? ...

I can not recover my all privileges in PhyMyAdmin

I am using PhpMyadmin. I canceled some structure privileges of the user root this afternoon and I want to recover these privileges. I always log in to PhpMyAdmin with the user identity of "root". But I get an error message when I attempt to recover my all privileges. Error SQL query: Edit GRANT ALL PRIVILEGES ON * . * TO 'root'@'loca...

Exporting database dump via phpMyAdmin to MS SQL

When I use the phpMyAdmin export, it has an option for MS SQL export compatibility. However, the resulting file includes many non-MS SQL compatible items, such as mediumtext and enum datatypes. How do I work around this issue? ...

How to get the auto increment id for two fields in a table

Hi i want to know that how the auto increment id can be get from the mysql db for two fields in a table ...

What do "Internal Relations" do in phpMyAdmin for MyISAM tables?

In phpMyAdmin v2.8.2.4 for MyISAM tables, the "Relation View" appears under the Structure tab. It shows a list of Internal Relations. But what do these do, given that MyISAM does not support foreign key constraints or relational integrity? By phpMyAdmin version 3.2.0.1 this page ("Relation View") no longer appears for MyISAM tables. So ...

connect to external server by using php myAdmin

i have php myAdmin installed on my machine how can make it connect to external server database Thanks in advance ...

Export structure and data (like in PhpMyAdmin)

I want to export data and structure from MySQL database using PHP. I know about SELECT INTO OUTFILE command but I want to have the file like the one which is generated by PhpMyAdmin in Export window, so all the CREATE TABLE and INSERT INTO. HDo you know how PhpMyAdmn generates those files? I was browsing through the code and I've found ...

phpMyAdmin is having a show plugins error on startup

My WAMP phpMyAdmin instance is now throwing a SHOW PLUGINS error on startup. It has never done this in the past, but now does this and will not start. Any ideas how to resolve this issue? I contacted support but haven't gotten a response back yet. ...

phpMyAdmin for SQLite 3

Is there a good PHP client for SQLite 3 databases? I'm looking for something like phpMyAdmin of SQLBuddy that allows me to manage SQLite 3 databases, preferably one that uses the PDO (pdo_sqlite) driver. ...